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

    Overview

    This online course is suitable for those with a busy schedule and is adaptable to the challenges of every lifestyle. Participants can attend the live course at the times outlined below and will have access to the recorded courses for 6 months after completion.

    A trainer will be on hand after each module to answer trainee questions and participants will have access to a dedicated trainer email for queries after the course is completed.

    If you’re unable to attend the live courses, a recorded copy of the course will be provided to you also along with all relevant course files and documents!

    Course Dates

    • Module 1: Wednesday 16th September – 11.30 – 1.00pm – Essential Skills
    • Module 2: Wednesday 23rd September – 11.30 – 1.00pm  – Working with Formulas & Functions
    • Module 3: Wednesday 30th September – 11.30 – 1.00pm – Workling with Lists/ Manipulating Text
    • Module 4: Wednesday 7th October – 11.30 – 1.00pm –  Creating & Working with Charts
    • Module 5: Wednesday 14th October – 11.30 – 1.00pm –  Multiple Worksheets/ Data Consolidation

    Schedule Outline  

    Excel 1: Microsoft Excel Essentials including Formatting & Tips and Tricks

    • Review of Excel Basics concentrating on quick methods of performing commonly used commands/features including an overview of Speed Keys
    Basics
    • Customising the ‘Quick Access Toolbar’
    • Navigating / Selecting / Data Entry / Editing
    • Inserting / Deleting / Resizing columns / Hiding and Unhiding columns
    • Cut / Copy / Paste and Drag and Drop
    • Using the Clipboard Task Pane
    • Filling / Flash Fill Basics / Creating a custom list.
    • Formatting – Font / Alignment / Number / Format Painter
    • Orientation / Wrap Text
    • Formatting as a table
    • Preview and Print
    • Conditional Formatting
    • Overview of Shortcut Keys

    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

    Excel 3: Basic Database Functionality and Manipulating Text

    • Freezing Panes / Print Titles
    • Sorting and Filtering a list
    • Creating and Working with Excel Tables
    • Changing Formatting
    • Changing display options – Total row etc.
    • Working with Functions
    • Using Slicers in Tables
    • Creating calculated fields.

      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

          Excel 5: Working with Multiple Worksheets and 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 – By position and By 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
          Start & Finish Time
          11:30am-1:00pm
          Trainer
          E-Bridge
          Places
          Location
          Online Course
          Members Fee
          €150
          Non-Members Fee
          €175
          Skillnet

          Similar Courses

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