Excel Masterclass 

 

Excel can be a great tool for staff in school, but many of us just use the basics day to day as we don’t have the time to explore.

 

To this end we have created an online training program consisting of 4 x 1 hour sessions covering different aspects of the more advanced features of Excel.   Each session provides a recording of our live online presentations with accompanying notes and copies of the Powerpoint slides. 

 

Each session gets a short assignment and on completion of the sessions and assignments, the delegate receives a Certificate in Advanced Excel.

 

Session 1 – Creating a lettings management spreadsheet including Table formatting, Freezing panes, Date formatting, Data validation, Formulae & functions, IF, Filters & Sorting.

 

Session 2  - Invoice template and database including Conditional formatting, Macros, Buttons, Customising Toolbars, Printing – selections / fit to page etc, Protection & Text orientation

 

Session 3 – Resources and other scheduling – how to set up a scheduling system by creating facilities and resources, locating free slots, producing and printing summary reports. It includes Indents, Borders, More conditional formatting, Absolute & relative cell reference, AND / OR functions, GANTT charts, Comments, Views – arranging / viewing / synchro scrolling

 

Session 4 – Budgeting / What-ifs and Projections – using Excel to create what-if scenarios & projections to predict outcomes with differing potential situations.   Includes BODMAS  - Brackets and operator order, Scenario Manager, Scenario Summaries and Pivot Tables, Goal Seek, Solver, Data Tables, Printing – print area and titles

 

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