Microsoft Excel 2013 Plain & Simple

Chapter 6. Using formulas and functions

In this section:

• Understanding formulas and cell references in Excel

• Creating simple cell formulas

• Creating, editing, and deleting named ranges

• Using names in formulas

• Summarizing the values in groups of cells

• Creating formulas that reference cells in other workbooks

• Analyzing data by using the Quick Analysis lens

• Summing with subtotals and grand totals

• Exploring the Excel function library

• Creating conditional functions

• Exploring new functions in Excel 2013

Microsoft Excel 2013 workbooks let you do much more than simply store and organize your data. One important task that you can perform in Excel is to summarize the values in related cells. Whether those cells represent the sales for a day at your store, the returns ...