School budgeting with Excel

 

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 2 x 1 hour sessions focusing on the functions in Excel that aid with school budgeting.  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 Budgeting.

 

Session 1 – Complex formulae, BODMAS, multi sheet & multibooks, Tracing dependents & precedents, Error checking & arrows, Watch windows,  Budget charts 

 

Session 2 – Inbuilt Functions for budgeting,  Name Manager, What If? Analsysis, Printing large budgets. 

 

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