This course is ideal for learners who already have some experience using Microsoft Excel and would like to improve their confidence in using formulas and functions. You will learn how to perform calculations more efficiently, work accurately with data and make better use of spreadsheets for everyday and workplace tasks.
What You Will Learn
By the end of the course, you will be able to:
- Use common functions such as SUM, AVERAGE, MIN, MAX and COUNT
- Create formulas using point-and-click techniques
- Use Relative and Absolute Cell References correctly
- Apply nested functions
- Build more complex formulas using the correct order of operations
- Edit, troubleshoot and update formulas confidently
These practical skills can help you save time, reduce errors and improve productivity.
Before You Apply
To benefit fully from this course, you should be comfortable using Microsoft Excel, including entering data, navigating worksheets and saving files. Good keyboarding skills are also recommended.
As part of the enrolment process, you will be invited to attend an informal interview and complete a short skills check. This helps us ensure that the course is suitable for your current skill level and learning goals.
This is a non-accredited course and no formal assessment is required before joining.
Progression Opportunities
After completing this course, you may wish to progress to:
- Creating Charts in Excel
- Other intermediate Excel workshops
- PowerPoint: The Basics
- Enhancing a Presentation
The skills developed on this course are valuable in a wide range of sectors, including administration, finance, retail and other office-based roles. They can also help you manage personal budgets, records and other everyday tasks more effectively.
What You Will Need
Please bring a USB memory stick so that you can save your work and continue practising outside of class.
Prosp Content