Microsoft Office Tutorials and References
In Depth Information
Section 6: Using formulas and functions
6
Using formulas and
functions
In this section:
Microsoft Excel 2013 workbooks let you do much more than simply
Understanding formulas and cell
references in Excel
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 from your
personal investments, or your times in bicycle races, you can find the total
or average of the values, identify the minimum or maximum value in a
group, or perform dozens of other calculations on your data. Many times
you can’t access the information that you want without referencing more
than one cell; it’s also often true that you’ll use the data in the same group
of cells in more than one calculation. Excel makes it easy to reference a
number of cells at once, letting you build your calculations quickly.
Creating and editing formulas
Creating, editing, and deleting named
ranges
Using named ranges in formulas
Summarizing the values in groups of
cells
Creating formulas that reference cells
in other workbooks
Analyzing data 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
Search JabSto ::




Custom Search