What the course leads to
What courses can I do after this?
On completion of the Advanced Excel One Day Course you will have achieved a proficient standard in using Excel, and can progress onto other courses available at The College.
What do I need to apply
To do this course you should have...
To join this course we recommend that you have either attended the intermediate level course, or an equivalent and have a good working knowledge of Excel.
Course costs
| Course Code | Start Date | Costs 16-18 | Costs 19-23 (with concessions) | Costs 19+ (no concessions) |
|---|---|---|---|---|
| BP01008 | Various | £220.00 | £220.00 | £220.00 |
* Please note fees are subject to change.
Costs
£210.00 which includes handout and refreshments during the day.
Dat4s during 2021 will be confirmed shortly.
Course content
Course Content
The course content will include:
- Protecting data in worksheets and workbooks
- Linking cells, worksheets and workbooks
- Using Logical functions (IF, Nested IFs, AND and OR)
- Using Data validation techniques
- Creating Pivot tables and Pivot charts
- Using What-If Analysis (Scenarios, Goal Seek)
- Creating and using simple Macros
More info
Start Day/Time
This course runs on various dates throughout the year between 9.00am - 4.30 p.m.
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