Intermediate Microsoft Office Skills

 

Developing more in depth Microsoft Office skills helps the smooth and efficient running of any school. As staff take on more complex tasks — managing data, producing professional documents, coordinating communication, and supporting senior leaders — it is increasingly important that they are confident moving beyond the basics of Microsoft Office.

​

In schools, developing intermediate-level skills improves efficiency, consistency, and professionalism. Staff who understand more advanced features can work faster, reduce duplication, manage information more effectively, and present data clearly and accurately. This course supports school support staff to become more independent, confident users of Microsoft Office, enabling them to better support teaching, learning, and administration across the school.

 

Our Microsoft Office Intermediate Skills course is designed for staff who already have a basic working knowledge of Microsoft Office and want to build on this foundation. The course introduces more advanced features and time-saving techniques that help staff get the most out of the core Office applications.

 

The course consists of four one-hour sessions. Each session includes a video presentation, supporting notes, downloadable resources, and assignments to reinforce learning.

​​

Session 1: Microsoft Word
Mail merge, referencing and reviewing tools, tables of contents and indexes, templates, headers and footers, and inserting objects into Word documents.

​

Session 2: Microsoft Excel
Text, number, date and table formatting, freezing panes, data validation, IF functions, filters and sorting, conditional formatting, protection, subtotals, pivot tables, and printing.

 

Session 3: Microsoft PowerPoint
Using templates, effective design techniques, inserting external objects, animation, and packing presentations and creating videos.

 

Session 4: Microsoft Outlook
Advanced calendar use, hyperlinks, recalling and replacing sent messages, automatic replies and inbox rules, managing attachments, BCC, search, spam management, distribution lists, templates and stationery, and voting buttons.

​

Outcomes - By the end of the course, participants will have developed greater confidence and stronger intermediate skills across the four core Microsoft Office applications, allowing them to work more efficiently and support school