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
