Analyzing Your Excel 2013 Data
- 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
Performing common calculations
Excel 2013 knows that you’ll use some calculations more than others, and for this reason, on the Home tab you have a tool within reach to help you perform some common calculations. Specifically, the Sum tool in the Editing group gives you access to functions you might use often: Sum, Average, Count Numbers, Max, and Min. You can also display additional functions by choosing More Functions in the Sum tool list and use the Subtotal tool on the Data tab to subtotal values on your worksheet.
Do a basic calculation
Click the cell in which you want to create the formula.
Type the equation you want Excel to perform, starting with the equal sign (=).
Press the Enter key.
Excel carries out the math and displays the answer in the cell.
Use the Sum tool for common calculations
Click the cell below the column that you want to summarize.
Click the Home tab.
Click the down arrow adjacent to the Sum button.
The Sum tool list offers the Sum, Average, Count Numbers, Max, and Min functions. You can also open the Insert Function dialog box by choosing More Functions.
Click the function that you want to use.
Press the Enter key or tap outside the cell to accept the suggested formula.