Intermediate Microsoft Office Skills

 

Micosoft Office is used fairly universally in organisations includings schools, and is an amazing tool for finance and admin staff.  In this course on Microsoft Office Intermediate skills you will learn how to move on beyond the basics with the core Office programmes.  Each session assumes an existing basic knowledge, and introduces features and shortcuts to improve utilisation of packages.

 

The aim of this course, is to provide both additional skills and confidence with the 4 main packages. Delivered over the internet – and consisting of 4 x 1 hour sessions this course provides video presentations with accompanying notes, downloads & assignments. Attendees can email any questions or problems, and can attend all of the sessions or can choose specific ones if preferred.

 

Session 1 : Microsoft Word - Mailmerge, Referencing & reviewing - TOC, index, Templates, headers & footers, Inserting objects into Word.

Session 2 : Excel – Text, number, date & table formatting, Freezing panes, Data validation, IF function, Filters & Sorting, Conditional formatting, Protection, Sort, subtotal & Pivot Tables, Printing

Session 3 : Powerpoint – Templates, design techniques, Inserting other objects, Animation, Packing & creating videos. 

Session 4 : Outlook - Calendar, Hyperlinks, Recall and replace sent messages, Setting up automatic replies and inbox rules, Send and open attachments, BCC, Search , Spam, Distribution lists, Templates and stationery, Voting buttons

 

 

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