|
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 and Filters
Using
complex criteria in filters
Working
with dates, months, weeks, and days of the week.
Naming
Ranges
Using
Functions with data
Finding
the average, largest, number of items, rank, and count
Absolute
and relative references in formulas
Looking
up information in tables
Using
named ranges in formulas
Looking
up data to use in calculations
Combining
text and numbers
|
Pivot Tables
What
are pivot tables used for?
Setting
up a pivot table
Summarizing
data using a pivot table
Looking
at data in different views using a pivot table
Understanding
the different cursor icons in pivot tables
Selecting
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?
Additional
examples
What-if
Analysis
Setting
up a spreadsheet for data analysis
Review
of functions and business formulas
Performing
what-if where 1 item varies
Money
over time problems
Setting
up a what-if table where 2 items vary
|
