Advanced Word and Excel

Course Key
Hands holding a tablet computer with the word skills plus icons and a New tag

Circle with the letters IA Initial Assessment

Circle with the letter c Concession Available

Circle with the letter B Blended Course

Circle containing a computer icon Online Course

 

Circle containing the letters I and A

Course Fee FREE*

Course Details

This course is designed for individuals with a good understanding of Microsoft Word and Excel packages wishing to learn how to use the advanced capabilities of the software.  Topics covered include:

Microsoft Word

  • Mail merge
  • Macros
  • Using quick parts, contents pages and styles
  • Embedding objects and links
  • Document collaboration using Microsoft 365 Copilot

Microsoft Excel

  • Advanced functions and formula
  • Power Pivot and Pivot charts
  • Data models
  • Creating dashboards and adding slicers to analyse data

Entry Requirments

For this course, you need to have level 2 Digital Skills and English (to support achievement, progression and potential employment.)

Before you can join this course, you will be required to complete an initial interview and assessment to ensure the course is suitable, and identify that you have an adequate level of English and ICT

It is important that learners attend all classes, as not attending reduces their ability to achieve on the course.

Location:

Venue Day Time Start Date End Date Apply/Enrol
Ron Davis Centre, Smethwick Thursday 9:30am - 11:30am 25/09/2025 06/11/2025 Enquire Now

The benefits of this course

This course will develop the digital knowledge and skills needed in most jobs today, giving the learner the advance knowledge of computer systems, which will enable them to perform complex tasks quickly and efficiently.

Teaching

All the classes are run by a qualified and experienced tutor. Learners will attend one set class each week and experience a variety of learning activities.

How will progress be monitored and assessed?

Learning targets will be agreed with the tutor at the beginning of the course, and targets will be set for each class attended. Regular feedback will be provided by the tutor, with all work submitted being marked with written feedback.

Qualification

Learners will receive an in-house certificate upon completion of the course.

Next Steps

The Tutor will discuss next steps towards the end of the course and suggest further courses/qualifications that may be appropriate. We also have I.A.G qualified staff who could advise learners on progression and other opportunities. 

Equipment Required?

A note pad and pen/pencil would be useful. Any materials needed for the course are provided by us.

 

*Your course fees are paid for through the West Midlands Combined Authority, which is government funding.