Course Overview
This course has been developed for those who have basic knowledge of Microsoft Excel and wish to become familiar with its more advanced features.
The course content will include:
- Work with multiple worksheets and workbooks
- Apply conditional formatting
- Name cells and ranges
- Sort and filter data
- Understand common date functions
- An introduction to the VLOOKUP function – when and how to use it
- An introduction to the IF function, including SUMIF and COUNTIF
- Format and modify charts
To join this course we recommend that you should have a basic knowledge of Excel, i.e. have attended an introductory course or be familiar with and able to use the majority of topics listed in the introductory course contents.
Progress monitoring is informal with continuous assessment throughout the day.
On completion of the Excel Intermediate Course you can progress onto the Advanced Excel course at The College.
Dates throughout the year:
- Dates during 2024/2025 will be confirmed soon.
£195,00 per delegate which includes refreshments during the day.
Awarding Body:
Bournemouth & Poole College
Qualification:
College Certificate
Curriculum Area:
Business, Service Industries and ESOL - Business and Finance
From courses to careers
£34,197.13
Potential Salary
£17,622.00
Entry Level Salary
£20,456.09
Average Salary
5
Annual Openings
£31,368.27
Potential Salary
£17,892.00
Entry Level Salary
£21,568.51
Average Salary
6
Annual Openings