What the course leads to
What courses can I do after this?
On completion of the Excel Intermediate Course you can progress onto the Advanced Excel course at The College.
What do I need to apply
To do this course you should have...
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.
Course costs
Course Code | Start Date | Costs 16-18 | Costs 19-23 (with concessions) | Costs 19+ (no concessions) |
---|---|---|---|---|
BP01007 | Various | £195.00 | £195.00 | £195.00 |
* Please note fees are subject to change.
Costs
Dates throughout the year:
- Dates during 2021 will be confirmed soon.
£185,00 per delegate which includes refreshments during the day.
Course content
Course Content
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
More info
Start Day/Time
This course runs on various dates throughout the year between 9.00 a.m. - 4.30 p.m. Date of next course to be confirmed soon.
Duration
1 Day
Attendance
Part-time
Level
Other Courses
Qualification Name
College Certificate
Awarding Body
Bournemouth & Poole College
Curriculum Area
Business, Service Industries and ESOL - Business and Finance