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