Advanced Excel*


1 day, 09:30 AM - 04:30 PM


Session information


Session 1: Tue 14-Feb-2023
09:30 - 16:30
1 day
    • €95.00 incl.


    This course is for highly experienced Excel users who have either completed the Intermediate course or who have sufficient experience to be familiar with the Intermediate topics.


    Classroom: 1 day

    Online: 1 day

    Course Content

    • Revision of basics: basic formulas, using absolute/fixed, basic functions
    • Advanced Worksheet Functions
    • Left, Right, Mid
    • If, And, Or, If Error
    • The Lookup Functions
    • Vlookup: revision of basics/adding extra levels to it
    • Sumif/Sumifs/Countif/Countifs
    • Conditional Formatting – revision of basics
    • Conditional Formatting - beyond the basics
    • Data Entry Validation – creating dropdown lists
    • Working with named ranges
    • Pivot Tables – revision of basics
    • Further Work With Pivot Tables including Show Values As, adding a pivot chart, using the slicer
    • Using Tables
    • Macros and the VBA Project Window
    • Introduction to Dashboards – putting it all together

    This training will be delivered by Clare Commins - Study Focus