Using Excel Spreadsheets to Manage a Library Budget - a half day course
2nd March 2007, at Aslib, London
Programme Features:
•The budget cycle
•The different types of figures/terminology
o Requested budget
o Given budget
o Increase on previous year's spend
o Actual spend
o Savings
o Overspend
o Reforecast
o Quotes vs. estimates
o Recording receipt of invoice vs. actual payment
•A practical look at a spreadsheet example
o Percentage formulae
o Recording monthly, periodic and annual payments
o How to record subs with monthly invoices that don't fit in with your same
financial year
o Copying contents of cells to a summary sheet
o Working out the rolling reforecast
o How to work out what is overdue
o 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.
Course Director: Fiona Durrant
Course Fee: £150 plus VAT (Aslib Corporate Members)/ £187.50 plus VAT (Non
Members)
To book your place, please visit: www.aslb.com/training/2/16.html
Regards
Nicole
Nicole Adamides, ASLIB Training
The Holywell Centre, 1 Phipp Street, London, EC2A 4PS
Tel: 020 7613 3031 Fax: 020 7613 5080
www.aslib.com/training Email: [log in to unmask]
_________________________________________________________________
Click Here To Find Your Perfect Match This Valentines!
http://msnuk.match.com/
|