Course curriculum
-
1
Welcome to the course!
- Here's what you'll be learning...
- Course Exercises
-
2
Module 1 - Manipulating Large Worksheets
- Hiding Rows and Columns
- Freeze Panes
- Group and Outline
-
3
Module 2 - Working with Multiple Files
- Using Arrange All
- Viewing Multiple Sheets
-
4
Module 3 - Linking Data
- Linking
-
5
Module 4 - Paste Special
- Paste Special
-
6
Module 5 - VLookup and HLookup
- Introduction to VLookup and HLookup
- Range Names
- VLookup Syntax
- Using VLookup
- Using HLookup
-
7
Module 6 - IF Statements
- Introduction to IF Statements
- Creating IF Statements
- CountIF
- SumIF
- AverageIF
-
8
Module 7 - Conditional Formatting
- Applying Conditional Formatting
- Top-Bottom Rules
- Text, Duplicate and Formula Rules
-
9
Module 8 - Date and Text Formulas
- TEXT, LOWER, UPPER, PROPER, TRIM
- CONCATENATE
- TODAY, NOW and NETWORKDAYS
- YEARFRAC
-
10
Test your learning
- End of Course Quiz
-
11
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.