Edit a Formula After a formula is complete, you can still easily update what the formula is calculating. Select the cell with the formula you want to edit. Click in the Formula bar and edit the formula as necessary. Tip: You can also double-click a cell to switch to edit mode, then edit the formula right in the cell. Click the Enter button when you’re finished. Shortcut: Press Enter. The formula is updated to reflect the changes. Use a Function In Excel, a function is a preset formula. There are several hundred functions available. Some are simple, such as the Sum function. Others are much more complex and contain several different arguments. Arguments are the data used by the function to make a calculation. They appear within the parentheses in the function. Function Categories Functions that are used to calculate interest, payments, loans, etc. Financial Functions to calculate date and times values. Date & Time Math and trigonometry functions, such as SUM, COS, and TAN. Math & Trig Functions that calculate averages, standard deviations, etc. Statistical Functions that lookup or reference values. Lookup & Reference Functions that lookup or calculate values in a list or database. Database Functions that can be used with text or labels. Text Conditional functions (IF…THEN). Logical Functions that return information about values and the worksheet itself. Information Functions used in engineering calculations. Engineering Functions that extract data from OLAP cubes. Cube
Edit a Formula After a formula is complete, you can still easily update what the formula is calculating. Select the cell with the formula you want to edit. Click in the Formula bar and edit the formula as necessary. Tip: You can also double-click a cell to switch to edit mode, then edit the formula right in the cell. Click the Enter button when you’re finished. Shortcut: Press Enter. The formula is updated to reflect the changes. Use a Function Function Categories Financial Functions that are used to calculate interest, payments, loans, etc. Date & Time Functions to calculate date and times values. Math & Trig Math and trigonometry functions, such as SUM, COS, and TAN. Statistical Functions that calculate averages, standard deviations, etc. Lookup & Reference Functions that lookup or reference values. Database Functions that lookup or calculate values in a list or database. Text Functions that can be used with text or labels. Logical Conditional functions (IF…THEN). Information Functions that return information about values and the worksheet itself. Engineering Functions used in engineering calculations. Cube Functions that extract data from OLAP cubes. In Excel, a function is a preset formula. There are several hundred functions available. Some are simple, such as the Sum function. Others are much more complex and contain several different arguments. Arguments are the data used by the function to make a calculation. They appear within the parentheses in the function.
Excel-2016-pt1.docx