Course curriculum
-
1
Welcome to the course!
- Here's what you'll be learning...
- Course Exercises
-
2
Module 1 - Goal Seek
- Goal Seek
-
3
Module 2 - Using Scenarios
- Scenarios
-
4
Module 3 - Consolidation
- Consolidate - Part 1
- Consolidate - Part 2
-
5
Module 4 - Advanced Filtering
- Advanced Filtering
-
6
Module 5 - Working with Tables
- Working with Tables - Part 1
- Working with Tables - Part 2
- Working with Tables - Bonus Tip
-
7
Module 6 - Validation
- Validation - Drop Down Lists
- Validation - Date Ranges
-
8
Module 7 - Protection
- Protection - Protect Sheet
- Protection - Protect Workbook - Bonus Tip
- Protection - Protect File
-
9
Module 8 - Pivot Tables
- Introduction to Pivot Tables
- Pivot Tables - Analysing Data
- Pivot Tables - Grouping
- Pivot Tables - Slicers
- Pivot Tables - Pivot Charts
-
10
Module 9 - Macros
- Introduction to Macros
- Recording Macros
- Assigning Macros
- Recording Global Macros
-
11
Test your learning
- End of Course Quiz
-
12
Course Survey
- Before you go, we'd love to hear your feedback on the Excel Advanced course please...
Course Instructor
-
Microsoft Office and Office365 Trainer
Simon Lambourne-Wills
I’ve been an IT trainer for over 10 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it’s important to enjoy attending training courses. Therefore, engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.