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.

Who is this course for?

This course is best suited to anyone with limited experience / knowledge of excel

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