The Excel Advanced level covers the following 2 modules.
Module 5 - Advanced Formulas
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
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
Duration: 1 day
Date: Thursday 6th June 2024
Cost: Free to attend for those living or working in Powys
Venue: Welshpool
Course Delivery: This course will be delivered by Pat Jones, PS Training.
Book online using the booking form below, call 01686 628778 or email sam@mwmg.org
If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org
‘This project is funded by the UK government through the UK Shared Prosperity Fund.’