Excel Essentials – Thursday 25th & Friday 26th March (2 half day sessions)

Date Location Price / Members Price Places Trainer Book Online or Enquire
25th March 2021 @ 9.30-12.30 Online € 50.00 / € 50.00 6 available Systems & Software Training

Online Workshop – Duration 2 x Half day workshops 9.30-12.30 (both days)

Objectives

Welcome to the world of Excel! This programme will teach delegates the essential features of Excel . Accessing worksheets, entering data, core functions referencing cells, formatting worksheets, headers & footers and printing are all covered and training is delivered by one of the most sought after training provider Systems & Software Training

Versions: This course is available for Excel 2010, 2013, 2016, 365

Pre-requisites

Delegates should have good computer literacy skills and some familiarity with Excel.

Contents

  • 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
  • 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