Programme overview
Excel is the most commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.
The purpose of this course is the teach delegates the essential features of Excel. Accessing worksheets, entering data, core functions Referencing cells, formatting worksheets, headers & footers and printing are all covered. Extensive hands-on classroom training is provided throughout.
Learning Outcomes
On completion of the training programme, participants will:
- 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
Who Is This Course For?
This course is best suited to anyone with limited experience / knowledge of excel
Modules
- 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
Course runs over 2 days, Tuesday 28th January – Wednesday 29th January from 9.30am to 12.30pm both days