Team Upskilling Programme

This course covers all topics from the Excel Level 1 course and around 75% of the Level 2 course. It is a full days comprehensive course covering most business needs in using Excel software.

You will learn how to:

• Create and edit standard formulas for basic calculations.
• Understand the sequence of calculations and when to use brackets in formulas.
• Use a range of Excel functions to quickly analyse data for business.
• Fix cell references on a worksheet.
• Enhance the appearance of worksheets to look more professional.
• Filter data on a worksheet.
• Create charts and graphs to analyse trends for business.
• Setup orientation, scaling of data and page breaking to suit business requirements.
• Build linked formulas across worksheets.
• Use conditional functions – IF statements.
• Create and use pivot tables for reporting business data.