Here are the 10 functions that people read about most.
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column. Our 10 most popular functions
Compatibility functions
In Excel 2010 or later, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead. For more information about the new functions, see Statistical functions (reference) and Math and trigonometry functions (reference) .
If you're using Excel 2007, you'll find these functions in the Statistical or Math & Trig categories on the Formulas tab.
Cube functions
Database functions
Date and time functions
Engineering functions
Financial functions
Information functions
Logical functions
Lookup and reference functions
Math and trigonometry functions
Statistical functions
Text functions
User defined functions that are installed with add-ins
If add-ins that you install contain functions, these add-in or automation functions will be available in the User Defined category in the Insert Function dialog box.
Excel 2010 Formulas And Functions Inside Out Pdf
User-defined functions (UDFs) are not available in Excel Online.
Web functions
Web functions are not available in Excel Online.
Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions.
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Basic Excel Spreadsheet Instructions PdfDo you have a specific function question?Help us improve ExcelDo you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice See Also
It’s easy to use Excel for many of your day-to-day number-crunching tasks, like determining your business’s average sale, computing classroom grades, or forecasting college expenses. Use this handy Cheat Sheet to discover great functions and tips to help you get the most out of Excel.
Excel Functions You’re Likely to Use
Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference to the purpose of each Excel function.
Excel Text Functions You’ll Find Helpful
Excel’s text functions are very helpful when you’re working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does:
Excel Order of Operations to Keep in Mind
Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in general mathematics. You can remember this order by memorizing the mnemonic phrase, “Please excuse my dear aunt Sally.”
Excel Cell References Worth Remembering
In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change in the formula it pastes. The formula can either change the references relative to the cell where you’re pasting it (relative reference), or it can always refer to a specific cell.
You can also mix relative and absolute references so that, when you move or copy a formula, the row changes but the column does not, or vice versa.
Preceding the row and/or column designators with a dollar sign ($) specifies an absolute reference in Excel.
Excel Error Messages to Get to Know
If you create a formula in Excel that contains an error or circular reference, Excel lets you know about it with an error message. A handful of errors can appear in a cell when a formula or function in Excel cannot be resolved. Knowing their meaning helps correct the problem.
Microsoft Excel 2010 lets you save your workbook files directly in the PDF (Portable Document Format) or XPS (XML Paper Specification) file format. These formats enable people to open and print your Excel worksheets even if they don’t have Excel installed on their computers.
Follow these steps to save an Excel 2010 workbook in PDF or XPS format:
1Click the File tab and choose Save As.
The Save As dialog box appears.
2In the Navigation pane, select the folder in which you want to save the file.
(Optional) If you want to save the workbook file inside a new subfolder within the folder currently open in the Save As dialog box, you can click the New Folder button on the toolbar and then type the name of the folder and press Enter.
3Type a descriptive name for the file in the File Name box.
You can use the original name if you want so that your original Excel file will appear right next to the PDF or XPS file in an alphabetical list.
4Click the Save as Type arrow and select either PDF or XPS Document.
Excel displays additional options that apply to PDF and XPS files near the bottom of the Save As dialog box.
5Beside the Optimize For heading, select Standard or Minimum Size.
If you want to make the PDF or XPS file as small as possible (because your worksheet is large), select the Minimum Size (Publishing Online) option button.
6(Optional) If you want to change which parts of the workbook are saved in the PDF or XPS file, click the Options button; then make the appropriate selections and click OK.
From the Options dialog box, you can change how much of the worksheet to convert as well as including the document properties in the output.
7Click the Save button.
Excel saves the workbook in the PDF or XPS file format that you selected in Step 4, and automatically opens the file in Adobe Reader or XPS Reader (unless you deselected the Open File After Publishing check box in the Save As dialog box).
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |