Courses > Computers

Microsoft Excel – Office 365, 2016 & 2019 – Intermediate Level

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

Course Location:

Killarney, Kerry | Macroom | Cork City | Online

Course Available as Daytime Training | Night Classes | One-to-One | Online


Please contact Island Computers & Training for more details


Book your Course