Intermediate Excel

Intermediate Excel

18th October 2023
9:00 am


Places remaining: 10
Cost: €45.00 (Plus booking fee)

Terms & Conditions - Click Here

Course Aim:

The aim of this training course is to provide clients with the necessary skills required to produce reports using spreadsheets incorporating various calculations, professional formatting and graphical charts.

Client Profile:

It is important that each client has previous experience and a basic working knowledge of Microsoft Excel. Ideally each client would have access to a computer system where Microsoft Excel is available to maximise learning post training

Basic Working knowledge – Open, Close, Save files, understand the formatting menu i.e. Font, Font size, Text colour and have a knowledge of basic formulas.

Course Outline:

Microsoft Excel Office 365/ 2013 / 2016 / 2019

  • Intermediate MS Excel Command & Functions
  • Open Close, Save File Formats
  • Subtotals
  • Page Setup & Margins
  • Worksheets, Columns & Rows,
  • Borders
  • Editing Cells, Text Orientation, Comments
  • Headers & Footers
  • Spreadsheet layout, Freezing Panes etc
  • Grouping Cells, Audit functions
  • Conditional Formatting
  • Data Filters & Sorting
  • Formulas, Addition, Subtraction, Count, Min, Max
  • Percentages
  • IF Statements
  • Linking Worksheets
  • Adjusting sheets for Printing, Row Column Headers
  • Page Styles
  • Graphs, use chart features/filters
  • Templates
  • Embedded Objects within Excel & MS Word

Javascript is required for this form to work properly

If you are currently employed complete this section


Click to view our Privacy Policy

After clicking "Send your booking" please be patient whilst you are transferred to the next screen to prevent duplicating your reservation