Advanced Microsoft Office Skills

 

In this course on Microsoft Office Advanced skills you will learn how to get even more from your packages, going into the more advanced functions and concepts.  You will need a good existing knowledge – so ideally you will need to have already completed our Office Intermediate course.

 

This course is designed for any school staff who would like to know more about Microsoft Office and utilise more the advanced functions.

​

The sessions are delivered live over the internet –4 x 1 hour sessions over successive weeks. Each session has accompanying notes and an assignment to complete.  Attendees can ask questions and interact with the trainer.   We also offer the course as a pre-recorded online training option, where users can login at ANY TIME to follow the course. Notes, assignments and videos are provided on the online platform.  A printed certificate will be issued on successful completion of all assignments.

 

Because not everyone will want to go into PowerPoint and/or Outlook in such detail we do have some options here – you can swap in a Windows 10 session, a Microsoft Publisher session, or can do a further session in Word and/or Excel – so you pick the 4 session that suit you best.

​

Session 1 : Microsoft Word – Productivity tools – autotext, quick parts, Objects. Macros, Toolbars, Page options & Forms.  Sharing documents.

 

Session 2 : Excel – Advanced text & other formatting, BODMAS, Absolute & relative cell references, IF/AND/OR, Advanced Charts, Views, What If

 

Session 3 : PowerPoint – Enhancing images, Advanced animation and transitions – motion paths, animating individual elements, Media & Action buttons, Saving & Sharing presentations, Themes. work with.

 

Session 4 : Choose from Even More Word – Macros, Toolbars and Visual Basic.  Even More Excel – Macros, buttons, toolbars & VBA.  Microsoft Publisher- Publication Layout & Structure, Adding and Formatting Text. Editing Publication Text, Working with Graphic Objects, Finishing a Publication or Windows 10

​

​

The whole 4 session course costs £99 per school and multiple staff can use the course for this price.   

​