Microsoft Excel Advanced Level Course
2 sessions over 2 days - 3hrs per session
Tuesday 1st March & Wednesday 9th March 2022
£65 per delegate (2 sessions)
Please include the version of Excel product used with enquiries. Office 365, 2016 or 2019 preferred.
Attendees should have attended, or have knowledge equivalent to the Introductory Level course.
Module 5 - Advanced Formulas (Session 1)
-Using the Audit Feature to display cells used within Formulas
-Use of the Transpose Feature to switch the display of data
-Understanding Conditional Logic, i.e. IF statements
-Creating formulas using Basic Conditional Logic
-Creating formulas using Nested IF statements
-Creating formulas using Nested AND & OR statements
-Using the =Countif feature to count data meeting specified criteria
-Using the =Sumif feature to total data meeting specified criteria
-Using the =Averageif feature to find the average of data meeting specified criteria
Module 6 - Using the Database Functions (Session 2)
-Apply Conditional Formatting
-Applying Data Validation to ensure the correct information is entered
- Remove Duplicate Values for line of data
-Understanding the Database Functions
-Using AutoFilter to view a specific set of data
-Inserting Automatic Subtotals
-Converting Text Strings to separate columns
-Creation of Pivot Tables to display data in varying formats
-Creation and use of Vlook-up table