Intermediate Excel


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


Session information


Session 1: Wed 01-Feb-2023
09:30 - 16:30
1 day
    • €95.00 incl.


    This course is for users who have either completed the Beginner course or who have gained sufficient experience to be familiar with the Beginner topics.


    Classroom: 1 day

    Online: 1 day


    • Be comfortable with the content of the Beginner course – revision of this if required
    • Revision of use of absolute and fixed cells references
    • Be able to insert and delete rows and columns
    • Be able to create a chart in a number of different formats
    • Insert, rename, move, copy sheets within and between spreadsheets
    • Be able to link sheets, so that changes in one are automatically updated in another
    • Set up a list, do simple and complex sorting (including multiple levels, by colour and by icon)
    • Use basic If Function
    • Introduction to Conditional Formatting
    • Introduction to VLookup Function
    • Formatting a list as a table – why and when you do it
    • Introduction to Pivot Tables
    • (If time allows) Introduction to Countif/Sumif/Countifs/Sumifs

    This training will be delivered by Claire Commins - Study Focus