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-days Excel Intermediate online course is to teach delegates some more advanced features of Excel such as - Using If statements, Financial Functions, Lookups, Named Ranges, Sorting Data and Charting are all covered.
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
9:30am - 12:30pm
Tuesday 16th July 2024
AND
Wednesday 17th July 2024