25
MAR

Excel Essentials

Date: 25th & 26th March (Two half day sessions)

Time: 09:30 – 12:30 (Both days)

Location: Online

Price: €50.00

Trainer: Systems & Software Training

Book: Wexford Chamber Skillnet

 

Course Content

 

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

  • 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

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