Upskilling YOU
Empowering YOU

MS Excel Advanced

Thank you
Thank you
for your booking for {{COURSE_NAME}}
commencing on {{STARTING_DATE}}.

Thank you for your booking for {{COURSE_NAME}} commencing on {{STARTING_DATE}}.

We will be in touch a few days before the course starts to confirm details such as venue, start & finish time etc. Please feel free to contact us in the meantime if you have any queries.

Cancellations made in the final 72 hours before a course commences will be charged in full.

As an ongoing quality control measure and to ensure the highest possible standard of training, courses may be inspected from time to time.

Contacting the Cork Chamber Skillnet Team:

Kate Murray, Training Network Executive
Tel: 021-4530142
E-Mail: kate@corkchamber.ie

Garrett O’ Rourke, Training Network Manager
Tel: 021-4530141
E-Mail: garrett@corkchamber.ie

    Course Dates

    Iteration 1

    • Module 1: Friday 30th April – 09:30am – 11:00am – Dates/Protecting Content/Data Validation
    • Module 2: Friday 7th May – 09:30am – 11:00am – More on Functions (Part One)
    • Module 3: Friday 14th May – 09:30am – 11:00am – More on Functions (Part Two)
    • Module 4: Friday 21st May – 09:30am – 11:00am – Pivot Tables & Pivot Charts
    • Module 5: Friday 28th May – 09:30am – 11:00am – Macros

    Iteration 2

    • Module 1: Thursday 21st October – 09:30am-11:00am – Dates/Protecting Content/Data Validation
    • Module 2: Thursday 29th October – 09:30am-11:00am – More on Functions
    • Module 3: Thursday 4th November – 09:30am-11:00am – More on Functions
    • Module 4: Thursday 11th November – 09:30am-11:00am – Pivot Tables & Pivot Charts
    • Module 5: Thursday 18th November – 09:30am-11:00am – Macros

      Overview

      These online webinars have been designed to replace classroom-based training whilst people are required to work from home.

      Participants have the option of either attending the live webinars at the scheduled date and time or alternatively can view a recording of the webinar at a time that suits them.

      Recordings will be available for 6 months after completion and a link to the recording will be sent to all participants following the live webinar along with all relevant course files.  A trainer will be on hand via email to answer any queries or questions that might arise following the training.

      This second group of webinars follows on from ‘Bundle 1’ and covers the more advanced content.  It is recommended to view the ‘Bundle 1’ webinars in advance.

        Each module is CPD Accredited and 1.5 CPD hours can be awarded to each attendee of the live session.

        Schedule Outline  

        EXCEL 6: DATES / PROTECTING CONTENT / DATA VALIDATION

        • Working with Dates
          • Understanding how Excel sees dates
          • Calculating the difference between 2 dates
          • The TODAY Function
          • Calculating Age
          • EOMONTH/ISONUMBER
          • Using the Text Function with dates
          • Text to Columns to convert date format
        • Protecting worksheets, workbooks & restricting input.
          • Data Validation – Text, Numbers, Drop-Down List.
          • Locking cells and enforcing protection
          • Password protecting workbooks

        EXCEL 7: MORE ON FUNCTIONS (PART ONE)

        • Grouping and Outlines
        • Working with the Subtotals
        • SUMIFS/MINIFS/MAXIFS/AVERAGEIFS/COUNTIFS
        • Writing and Understanding the IF Function
          • Writing a basic IF Statement
          • Using IF with AND/OR/IS Functions
          • Created Nested IF Functions.
        • Using the IFS Function

        EXCEL 8: MORE ON FUNCTIONS (PART TWO)

        • Creating and working with named ranges.
        • VLOOKUP Function
        • IF Error function revisited
        • Index and Match
        • XLOOKUP – Excel 2019/365 only
          • Basic XLOOKUP
          • XLOOKUP – [if_not_found] argument
          • Search Mode argument

        EXCEL 9: PIVOT TABLES & PIVOT CHARTS

        • Creating and understanding a basic Pivot Table
        • Filtering Data
        • Refreshing a Pivot Table/Refresh automatically on opening
        • Using the Pivot Table Design Ribbon
        • Resizing columns and preserving column widths
        • Grouping Dates/Grouping Fields
        • Using Slicers with Pivot Tables
        • Creating/Modifying Calculated Fields
        • Creating and Modifying Pivot Charts

        EXCEL 10: MACROS

        • Recording simple macros
        • The VB Editor
        • A brief explanation of VBA code
        • Assigning macros to buttons
        • Building a macro to open a file and copy data
        • Using variables
        • Assigning macros to the Ribbon

        Who Should Attend?  

        • This course is designed to follow-on from MS Excel Level Two (Intermediate).  Having already familiarised yourself with the most efficient way of performing everyday tasks and now that you have mastered the more commonly used Intermediate topics, it is now time to build on that knowledge.  A large proportion of the course is dedicated to managing and manipulating lists of information from working with tables & slicers up to creating and working with Pivot Tables.
        • Useful functions such as IF and VLOOKUP are covered in addition to automating tasks using Macros etc.  It is highly recommended that you first attend the Excel Level Two (Intermediate) course before attending this advanced course if you are not already fully familiar with the Intermediate topics.
        • All participants will be given access recordings of the webinars by way of an email along with copies of files used and User Reference Material. These will be available to participants for 6 months following the course.
        • A Cork Chamber Skillnet / E-Bridge Certificate of Attendance will be awarded to each participant on completion of all courses. A sample copy is attached for your approval.

        Entry Requirements

        Ideally, those attending should have already attended the Excel Intermediate course or have an equivalent skill level.  If you have a very basic knowledge of Excel, it is recommended that you attend the Excel Intermediate course in advance.

        This course can also be run as an in-company programme delivered on-site to meet your specific requirements. For more information on in-company delivery, or if you have any questions regarding this course, please Click Here.

        About this Form

        The purpose of this booking form is to gather profile information about participants on programmes funded by Skillnet Ireland from the National Training Fund through the Department of Education & Skills (DES). Only aggregated participant data will be reported to the DES.

        As an ongoing quality control measure and to ensure the highest possible standard of training, courses may be inspected from time to time.

        Pay Online

        If you would like to pay online, you ca do so now by clicking on the appropriate button for your membership type

        Member

        Non Member

        Start Date
        Duration
        5 X 1.5 Hours, starting 30th April, or 21st October
        Start & Finish Time
        30th April @ 09:30am-11:00am / 21st October @ 09:30am-11:00am
        Trainer
        E-Bridge
        Places
        Location
        Online
        Members Fee
        €150
        Non-Members Fee
        €175
        Skillnet

        Similar Courses

        Empowering You
        Growing your Business
        Company Registration Number - 13918
        In this section