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) |
|---|---|---|---|---|
| TFLXPZ5189 | 06/09/2021 | £185.00 | £185.00 | £185.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, Digital, Leadership & ESOL - Commercial Delivery