Advanced Word and Excel |
Course Type |
|---|---|
|
|
|
Non-Accredited
Access to a Computer/Laptop recommended
Initial Assessment
|
Course Fee |
*FREE |
Duration |
3 x 10 Week Modules |
|---|
Course Details
These courses are 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. There are three programme modules to choose from that explore the advanced features for Microsoft Word and Excel and are designed for those who are already comfortable a level 2. The modules can be completed individually or as part of a longer term programme of learning.
Course Content
| Module 1 - Automation and Formulas | Module 2 - Dynamic Array Formulas | Module 3 - Data Models and Dashboards |
|---|---|---|
|
Word Mail merge Macros Using quick parts, contents pages and styles Embedding objects and links Excel Relative and Absolute cell references Boolean Functions Various IF formulas Nested Functions |
Excel Tables Dymanic Array Functions
Conditional Formatting uising formula |
IntroductionPowerQuery Data Models Power Pivot Dashboards |
|
Additional Module Collaborative Technology |
Additional Module GDPR |
Additional Module CoPilot Functions and IA in Excel |
Locations
| Venue | Module | Day | Time | Start Date | End Date | Enquire |
|---|---|---|---|---|---|---|
| Ron Davis Centre, Smethwick | Module 1 | Thursday | 9:30am - 11:30am | 24/09/2026 | 03/12/2026 | Enquire |
| Tipton College, Tipton | Module 1 | Friday | 9:30am - 11:30am | 25/09/2026 | 04/12/2026 | Enquire |
| Ron Davis Centre, Smethwick | Module 2 | Thursday | 9:30am - 11:30am | 14/01/2027 | 25/03/2027 | Enquire |
| Tipton College, Tipton | Module 2 | Friday | 9:30am - 11:30am | 08/01/2027 | 19/03/2027 | Enquire |
| Ron Davis Centre, Smethwick | Module 3 | Thursday | 9:30am - 11:30am | 22/04/2027 | 30/06/2026 | Enquire |
| Tipton College, Tipton | Module 3 | Friday | 9:30am - 11:30am | 23/04/2026 | 01/07/2026 | Enquire |
Who is the course for?
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 and will enable you to revise and learn new skills away from the stresses of normal family life. You will have a qualified tutor and will have the opportunity to ask questions and improve your skills.
How will I be taught and assessed?
You will need to complete an initial assessment before you join the course, and advice will be given as to the suitability of the course for you. Learning will take place in a supportive environment, where professional teaching will be differentiated for individual learner needs. Your course will be classroom based and you will take part in with one to one, paired and small group work. Full participation will require you to find some time to complete homework, which will be marked and commented on by the tutor with guidance to help you to know how to improve.
How can I progress?
At the end of the course, your tutor will advise you of your progression routes which may include further digital courses or discussions with a Sandwell Careers advisor to guide you to higher education.
Do I need to bring my own equipment/materials?
A pen and paper to make notes. Any aids to learning (glasses, hearing aids, etc.).
Your is funded through the West Midlands Combined Authority, which is government funding.