Excel Advanced Module 5 - Advanced Formulas, 24th May Online delivery via teams,
The Excel Advanced level covers the following module:-
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
Duration: 1pm - 4pm
Date: Wednesday 24th May 2023
Cost: Free to attend
Venue: Online delivery via teams
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