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.
BOOK
THIS COURSE NOW