Event Details

*2 HALF DAYS EXCEL TRAINING*

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


Objectives

The purpose of this 2 half day online course is course is the teach delegates the essential features of Excel . Accessing worksheets, entering data, core functions Referencing cells. Extensive hands-on classroom training is provided throughout.

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


Tuesday 16th and Wednesday 17th April

9:30am - 12:30pm

Community

Discover and connect with other attendees.