Microsoft Excel Advanced Level Course
Attendees should have attended, or have knowledge equivalent to the Introductory Level course.
This course is split across two sessions- Thursday 2nd September and Thursday 9th September
Attendees must attend both sessions.
£65
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