Excel Advanced - One Day Course
In brief...
This one-day course is intended for anyone who has completed an Excel Intermediate course, or for competent existing users seeking to expand their knowledge of Microsoft Excel.
Who is it for?
If you have completed the Intermediate course at BPC, this is the next logical step to take to expand your knowledge and skills. Or, if you are a competent user of Excel, this will be a perfect way of building up expertise.
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.
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 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
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