Welcome To Our Excel Course
Beginner
Intermediate
Advanced
What will the session include?
- Understanding ribbons
- Terminology
- Formatting
- Introduction to Functions
- Doing maths with Excel
- Filters
- Comments
- Freezing and unfreezing panes
- Create a graph / chart
Session Assessment: Excel Assessment
How long is the session?
3 hours.
The Intermediate Excel Course is split into 2 sessions.
What will the sessions include?
Starter activity: Quiz
Session 1
- Working with Multiple Sheets
- Salary
- Advanced Charts
- Advanced Formulae
- Advanced Functions
Session 2
- Advanced Functions
- Conditional Formatting
- Data Validation
- Pivot Charts
Session Assessment: Excel Assessment
How long are the sessions?
Session1 (Lesson 1) 3 .5 hours
Session2 (Lesson 2) 3 .5 hours
The Advanced Excel Course is split into 2 sessions.
What will the sessions include?
Pre-Course Form
Session 1
- Lookup Functions
- Conditional Functions
- Text Functions
- Array Formulas
- Error Handling Functions
Session 2
- Pivot Tables and Pivot Charts
- What-If Analysis
- Advanced Charting
- Recording Macros, Basics of VBA
Session Assessment: Excel Assessment
How long are the sessions?
Session1 (Lesson 1) 3 .5 hours
Session2 (Lesson 2) 3 .5 hours
