Microsoft Office Tutorials and References
In Depth Information
Section 6: Using formulas and functions
Using formulas and
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
Using named ranges in formulas
Summarizing the values in groups of
Creating formulas that reference cells
in other workbooks
Analyzing data using the Quick Analysis
Summing with subtotals and grand
Exploring the Excel function library
Creating conditional functions
Exploring new functions in Excel 2013
Search JabSto ::

Custom Search