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 | 01/08/2020 | £0.00 | £0.00 | £0.00 |
* Please note fees are subject to change.
Costs
Price includes refreshments throught out the day, buffet lunch and course handouts.
Dates throughout the year:
- Dates for 2019 will be confirmed soon.
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