Course Length: 2-Days
Course Overview
This will course demonstrate the importance of cell references. It will elevate the use of the basic Excel functions by combining them with other functions. Various LOOKUP functions will be explored. The course will show how to handle formulas resulting in errors. Finally, this course will demonstrate how to use functions and formulas to clean and prepare data.
Prerequisites
To ensure success in this course, you should have a basic understanding of Excel.
- Excel Level 1 or equivalent knowledge
- Excel Level 2 or equivalent knowledge
Outline
Understand Cell References
- Relative References
- Absolute References
- Mixed References
- 3D References
Understand Functions
- Mathematical Functions
- Text Functions
- Date and Time Functions
- Logical Functions
- Lookup and Reference Functions
- Statistical Functions
Formula Errors
Error Auditing
- Using Show Formulas Features
- Error Checking
- Tracing Errors
- Evaluating Formulas
You may also be interested in:
Excel Dashboards for Business Intelligence
Excel - Data Analysis and Forecasting
What's Next?
View our Excel Flow Chart