Upskilling YOU
Empowering YOU

MS Excel Intermediate

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: Monday 19th April – 14:30pm-16:00pm – Essential Skills
    • Module 2: Monday 26th April – 14:30pm-16:00pm – Working with Formulas & Functions
    • Module 3: Monday 10th May – 14:30pm-16:00pm – Workling with Lists/Manipulating Text
    • Module 4: Monday 17th May – 14:30pm-16:00pm – Creating & Working with Charts
    • Module 5: Monday 24th May – 14:30pm-16:00pm – Multiple Worksheets/ Data Consolidation

    Iteration 2

    • Module 1: Thursday 9th September – 09:30am-11:00am – Essential Skills
    • Module 2: Thursday 16th September – 09:30am-11:00am – Working with Formulas & Functions
    • Module 3: Thursday 23rd September – 09:30am-11:00am – Workling with Lists/Manipulating Text
    • Module 4: Thursday 30th September – 09:30am-11:00am – Creating & Working with Charts
    • Module 5: Thursday 7th October – 09:30am-11:00am – Multiple Worksheets/ Data Consolidation

    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 first group of webinars covers all Excel essentials through to Intermediate content and will also focus on timesaving tips and tricks for the day to day use of MS Excel.

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

    Schedule Outline  

    EXCEL WEBINAR 1 – ESSENTIAL SKILLS

    • The MS Excel Window/Customising the ‘Quick Access Toolbar’
    • Using Shortcut Keys – Navigating/Selecting/Data Entry/Editing
    • Working with Rows and Columns – Inserting/Deleting/Resizing columns/Hiding and Unhiding
    • Moving and Copying content – Filling/Cut -Copy- Paste/Drag and Drop/The Clipboard Task Pane
    • Filling continued/Custom Lists
    • Formatting – Font/Alignment/Number/Format Painter/Orientation/Wrap Text
    • Preview/Page Setup/Print Options
    • Formatting as a table
    • Conditional Formatting

    EXCEL 2: WORKING WITH FORMULAS AND FUNCTIONS

    • Writing and understanding basic formulas
    • Writing and understanding basic functions
      SUM/MIN/MAX/AVERAGE/COUNT/COUNTA/COUNTBLANK
    • Copying Formulas – Relative vs. Absolute cell addressing
    • Conditional formatting revisited (using formulas)
    • IF Function (The Basics)

    EXCEL 3: WORKING WITH LISTS / MANIPULATING TEXT

    • Freezing Panes/Print Titles
    • Sorting and Filtering a list
    • The Filter Function – Excel 2019/365 only
    • Creating and Working with Excel Tables
      • Changing Formatting
      • Changing display options – Total row etc.
      • Working with Functions
      • Using Slicers in Tables
      • Creating calculated fields
    • Manipulating Text
      • Case of text – UPPER/PROPER/LOWER
      • Text to columns
      • Joining Text (Using ‘&’ and TEXTJOIN)
      • Flash Fill
      • Remove Duplicates

    EXCEL 4: CREATING AND WORKING WITH CHARTS

    • Creating and editing various chart types
      • Column/Bar/Line/Pie
    • Moving/Resizing the chart
    • Adding/Editing chart elements
      • Chart title/Legend/Chart Style/Data Table/Data Labels
      • Switch Row/Column
      • Manually Formatting a chart
      • Change overlap and Gap width
    • Creating a combined chart
    • Displaying data on a secondary axis
    • Adding an additional range to a chart once created
    • Creating and working with Sparklines

    EXCEL 5: MULTIPLE WORKSHEETS/DATA  CONSOLIDATION

    • Inserting new worksheets/Renaming
    • Navigating between sheets – Mouse/Keyboard/Navigation List
    • Moving/Copying sheets
    • Using ‘Group Edit’
    • Linking sheets using Formulae
    • Breaking Links
    • Other sheet options – Tab colour/Hiding and Unhiding sheets.
    • Data Consolidation – Position / Category (Label)

    Who Should Attend?  

    This course is suitable for those who are currently using MS Excel regularly but may not have attended formal training recently or may never have attended the training.

    All participants will be given access to a recording of the webinars by way of an email along with relevant files and user reference guides. The webinars 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.

    Entry Requirements

    This course is suitable for those who are currently using MS Excel regularly but may not have attended formal training recently or may never have attended the training.

    Participants should have a basic working knowledge of Excel before attending this course.

    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 19th April, or 9th September
    Start & Finish Time
    19th April @ 14:30pm-16:00pm / 9th September @ 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