This course has been developed for those who have basic knowledge of Microsoft Excel and wish to become familiar with its more advanced features.

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 06/09/2021 £185.00 £185.00 £185.00

* Please note fees are subject to change.

Costs 

Dates throughout the year:

  • Dates during 2021  will be confirmed soon.

£185,00 per delegate which includes refreshments during the day.

 

 

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

Duration 

1 Day

Attendance 

Part-time

Level 

Other Courses

Qualification Name 

College Certificate

Awarding Body 

Bournemouth & Poole College