Istek - School Finance & Admin Training

This course is NOT a free course - if you click FREE TRIAL and access any of the course content when your school has NOT ALREADY  ordered the course, you WILL BE BILLED.

Excel can be a great tool for finance and admin staffs 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 a new online training program consisting of 4 x 1 hour sessions covering different aspects of the more advanced features of Excel. Each session provides a presentation with accompanying notes and a short assignment try the features out. 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