Course |
Excel
Introduction - Formula Building |
Length |
Three
hours |
Audience |
Recommended
for anyone who uses Excel 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 Basics course or have equivalent experience.
|
Topics
|
Module
1: Building Formulas
- Basic formulas
to add, subtract, multiply & divide
- More complex
formulas
- Order of
Operations
|
|
Module
2: Functions
- The AutoSum
tool
- 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
|