Using Formulas and Functions in Microsoft Excel 2013
- Creating simple cell formulas
- Assigning names to groups of cells
- Using names in formulas
- Creating a formula that references values in an Excel table
- Creating formulas that reference cells in other workbooks
- Changing links to different workbooks
- Analyzing data by using the Quick Analysis lens
- Summing a group of cells without using a formula
- Creating a summary formula
- Summing with subtotals and grand totals
- Exploring the Excel function library
- Using the IF function
- Checking formula references
- Debugging your formulas
Analyzing data by using the Quick Analysis lens
One of the refinements in Excel 2013 is the Quick Analysis lens, which brings the most commonly used formatting, charting, and summary tools into one convenient location. You have a wide range of tools available to you, including the ability to create an Excel table or PivotTable, insert a chart, or add conditional formatting. You can also add total columns and rows to your data range. For example, you can click Totals and then Running Total for columns, identified by the icon labeled Running Total and the yellow column at the right edge of the button, to add a column that calculates the running total for each row.
Summarize data by using Quick Analysis
Select the cell range that you want to summarize.
Click the Quick Analysis action button to display the Quick Analysis tools available to you.
Click the label representing the category of tools that you want to use.
Click the button representing the summary that you want to create.