Excel Intermediate - One Day Course

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

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.

Progress monitoring is informal with continuous assessment throughout the day.

On completion of the Excel Intermediate  Course you can progress onto the Advanced Excel course at The College.

Dates throughout the year:

• Dates during 2024/2025 will be confirmed soon.

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

Awarding Body:
Bournemouth & Poole College

Curriculum Area:
Business, Service Industries and ESOL - Business and Finance