Using Excel Spreadsheets to Manage a Library Budget

In London

Price on request

Description

  • Typology

    Short course

  • Location

    London

Description

What this course intends is to demonstrate how you can use Excel spreadsheets to manage your library budgets.
Suitable for: 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, up to-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.

Facilities

Location

Starts

London
See map
Bonhill House, 1-3 Bonhill Street, London, EC2A 4BX

Starts

On request

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Teachers and trainers (1)

Fiona Fogden

Fiona Fogden

Course Director

Course programme

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)

Additional information

Payment options:

Course Fee: £150 plus VAT Aslib corporate members £187.50 plus VAT Non members PLEASE NOTE: All delegates are expected to bring a laptop with Excel. If you do not have one, we can hire one for you at a cost of £60 plus VAT.

Using Excel Spreadsheets to Manage a Library Budget

Price on request