| Course |
Excel
2007 Introduction - Formula Building |
| Length |
Three
hours |
| Audience |
Recommended
for anyone who uses Excel 2007 on an introductory level, but needs help
with creating formulas and using functions. Course begins with simple
formulas and develops more complex ones using multiple operations
and functions. Gives participants a solid foundation in spreadsheet
formulas. |
| Prerequisites |
Participants
must have completed the Excel 2007Basics course or have equivalent experience.
|
| Topics
|
Module
1: Building Formulas
- New Formula Tab and Window in 2007
- Basic formulas
to add, subtract, multiply & divide
- More complex
formulas
- Order of
Operations
|
|
|
Module
2: Functions
- The AutoSum
tool
- New Function Wizard in 2007
- New tools
- Understanding
functions
- The SUM,
AVERAGE, MIN, MAX and COUNT functions
|
|
|
Module
3: Cell References in Formulas
- Relative
cell addressing
- Copying data
& formulas
- Moving data
& formulas
- Absolute
cell addressing
|
