- Using conditional formatting to showcase data trends
- Adding sparklines
- Understanding Excel formulas and functions
- Performing common calculations
- Subtotaling data values
- Entering formulas
- Troubleshooting formulas
- Working with functions
- Creating and modifying data tables
- Sorting data
- Filtering worksheet data
- Creating PivotTables
- Viewing data instantly with Quick Analysis
A formula can be as simple as =2+2 or as complicated as you can imagine. Excel 2013 gives you all the tools you need, no matter how involved your calculation needs might be. You can type a formula directly in the Formula Bar at the top of the Excel worksheet area or you can type it in the selected cell. Along the way, you can also type or select the function you need and type or drag to select the cells you want to include. See how flexible Excel is when it comes to formulas? And, the program even provides you with on-the-spot error checking (the subject of the next task) to help ensure that your formulas are calculating properly.
Type a formula
Click the cell in which you want to enter the formula.
Type an equal sign (=).
Type the name of the function, followed by a left parenthesis character.
Type the cell addresses that you want to include in the formula.
You can also click the cells or range on the worksheet that you want to include in the formula and Excel will add it for you.
Type a right parenthesis character and press the Enter key or tap outside the cell.