| 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