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.

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)
TFLXPZ5111 06/09/2021 £210.00 £210.00 £210.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, Digital, Leadership & ESOL - Commercial Delivery

Duration 

1 Day

Attendance 

Part-time

Level 

Other Courses

Qualification Name 

College Certificate

Awarding Body 

Bournemouth & Poole College