Advanced Microsoft Office 

​

As school systems and administrative demands become more complex, advanced Microsoft Office skills play a vital role in maintaining efficiency, accuracy, and professionalism. Staff who are confident using advanced tools and automation features can significantly reduce time spent on repetitive tasks and manage information more effectively.

​

In schools, advanced Office skills support higher-level administration and leadership support. From producing complex documents and analysing data to automating processes and managing shared information, advanced users help schools operate more smoothly. This course is designed to enable experienced staff to work smarter, increase productivity, and make full use of Microsoft Office across the school environment.

​

Our Microsoft Office Advanced Skills course is aimed at staff with a strong existing knowledge of Microsoft Office. Ideally, participants will have completed our Intermediate course or have equivalent experience. The course explores advanced functions and concepts to help staff get even more value from the core Office applications.

 

Flexible course structure

We recognise that not all staff need the same depth of training in every application. This course therefore offers flexibility: while Word and Excel form the core, Session 4 can be tailored to meet your school’s needs. Options include additional advanced Word or Excel, Microsoft Publisher, Windows 10, or alternative combinations — allowing you to select the four sessions most relevant to your staff.  

​​

Session 1: Microsoft Word
Productivity tools including AutoText and Quick Parts, working with objects, macros, toolbars, page options and forms, and sharing documents.

​

Session 2: Microsoft Excel
Advanced text and formatting techniques, BODMAS, absolute and relative cell references, IF/AND/OR functions, advanced charts, views, and What If analysis.

​

Session 3: Microsoft PowerPoint
Enhancing images, advanced animations and transitions including motion paths, animating individual elements, media and action buttons, themes, and saving and sharing presentations.

​

Session 4: Optional advanced pathway (choose one)

• Even More Word: Macros, toolbars, and Visual Basic

• Even More Excel: Macros, buttons, toolbars, and VBA

• Microsoft Publisher: Publication layout and structure, text, graphic objects, and finishing a publication

• Windows 10

 

Outcomes - By the end of the course, participants will have developed advanced skills and confidence, enabling them to streamline workflows, handle complex tasks, and provide high-level administrative support within the school.