fbpx

Intermediate Excel

9.png

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

Online

Session information

Sessions

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

    Description

    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.

    Duration

    Classroom: 1 day

    Online: 1 day

    Content

    • 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