Event Details


Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.


The purpose of this 2 half-days Excel Intermediate online course is to teach delegates some more advanced features of Excel such as - Using If statements, Financial Functions, Lookups, Named Ranges, Sorting Data and Charting are all covered.

Versions ; This course is available for Excel 2007 ,2010, 2016 365

You will learn about the following areas

  • Enter and edit information in a Worksheet
  • Navigate Worksheets and Workbooks
  • Create basic Formulas - Addition, Subtraction, Division, Multiplication
  • Use Basic Functions – SUM, AVERAGE, MAX, MIN
  • Use the AutoFill feature (Fill Handle)
  • Insert/Delete columns and rows
  • Understand Relative References
  • Understand Absolute References
  • Format figures to Text
  • Merge and Centre Cells
  • Merge and Centre Cells
  • Set Currency Style
  • Add Borders and Fill Colour
  • Insert New Worksheets
  • Change Page Orientation from Portrait to Landscape
  • Set Page Margins
  • Create a Header and Footer
  • Insert & Remove Page Breaks
  • Set a Print Title
  • Print Worksheets
  • Freeze Rows and Columns

9:30am - 12:30pm

Tuesday 16th July 2024


Wednesday 17th July 2024


Discover and connect with other attendees.