Intermediate Excel

Sold out

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


Session information


Mon 24-Apr-2023
09:30 - 16:30
1 day
    • €95.00 incl.
    Event is fullJoin waiting list


    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