Using Excel Spreadsheets to Manage a Library Budget

Programme Features:

• The budget cycle
• The different types of figures/terminology
  • Requested budget
  • Given budget
  • Increase on previous year's spend
  • Actual spend
  • Savings
  • Overspend
  • Reforecast
  • Quotes vs. estimates
  • Recording receipt of invoice vs. actual payment
• A practical look at a spreadsheet example
  • Percentage formulae
  • Recording monthly, periodic and annual payments
  • How to record subs with monthly invoices that don't fit in with your same financial year
  • Copying contents of cells to a summary sheet
  • Working out the rolling reforecast
  • How to work out what is overdue
  • How to record credits

Why you should attend:

What this course intends is to demonstrate how you can use Excel spreadsheets to manage your library budgets. To compare what you estimated you would spend which what you actually spent. To enable you to know at a moment's notice where you are at any point in time with your actual and newly predicted spend and not have to spend ages doing a manual reforecast. Common and more complex Excel formulas will be explored to make your professional life easier and to automate as much as possible. It is not intended to be a book-keeping course, but is aimed at the average library manager who is too busy to spend ages on budget management but for whom it is important they can lay their hands on vital, upto-date information without having to have a major trawl through past invoices and catalogue records to try and work out where they are in the spending stakes.

Who should attend:

Anyone who has to manage all or part of a budget, whether this is for work or for a professional association or organization. Only a very basic knowledge of Excel is required, beyond that there is no need to know Excel well.

By the end of the course:

You will have gained more knowledge about how you can use the functionality of Excel to not only record the budget but to keep it as a living, useful document throughout the financial year. There will be a focus on the specific vagaries of library budgets but many of the tips could be applied to other arenas. You will be able to take away some formulae and ideas of how you could use Excel to manage your budget.

Time:
09.45 - 13.00 (am)
13.45 - 17.00 (pm)