|
Working with a
Database
 How to set up a database in Excel
Sorting
Pulling data from another spreadsheet
Setting up data validation for dates and
values
Subtotals in Excel
Creating queries & filters
Using complex criteria in filters
Working with dates, months, weeks and
days of the week in Excel
Naming Ranges
Using
Functions with Data
Finding the average, largest, number of
items, rank & count
Absolute & relative references in
formulas
Looking up information in tables
Using named ranges in formulas
Looking up data to use in calculations
Combining text & numbers
|
Pivot Tables
What are pivot tables used for?
Setting up a pivot table
Summarizing data using a pivot table
Understanding the different regions of a
pivot table
Understanding the Pivot Panel
Performing calculations on pivot tables
Using different levels of pivot reporting
What happens when data changes?
What-If
Analysis
Setting up a spreadsheet for data
analysis
Review of functions and business formulas
Performing a what-if where 1 item varies
Money over time problems
Setting up a what-if table where 2 items
vary
|
