Seminar Curriculum

Operations & Financial Management

Accounting is Not Math: General Financial Knowledge

This two hour seminar is geared toward existing and aspiring General Managers / Executive Directors and Board Members to help ground them in the technical skills required to support financial responsibilities. It will include an introduction to the two essential financial statements: the Balance Sheet and the Income Statement. It will also introduce participants to the concept and mechanics of double entry bookkeeping, the process that yields the financial statements required for sound decision making. Participants will work with the session leaders on developing a case study, walking through the start up year of a small not-for-profit, examining transactions and the need for statements and reports. Along the way we will consider matters such as: revenue generation from earned, fundraised, and government sources, dealing with expenses (cash vs. credit and the contracts/leases that govern multiple transactions); the importance of documentation; and the role of authorization (e.g. who signs cheques and contracts). The goal of the seminar is to assist participants in building on common sense and practical not-for-profit experience as the grounds for discussing technical aspects of accounting and thereby integrating the ‘hard skills’ into daily practice and financial management.

Organizational Cashflow

Hands-on work supported by individual coaching is at the heart of this 2-hour workshop. We begin with a presentation on cashflow principles and techniques, including: the financial contents; timing issues involved in working with last year, this year and next year items; essential control and reconciliation features; and a discussion of how much detail is desirable. We walk through a paper example, and then participants take it away to build their own cashflow based on the model, incorporating various formatting ideas, formulas and functions (including SUM, IF, and ROUND). Participants can use this opportunity (and our coaching resources) to develop their company’s budget, or they can work with our sample data. Bring your laptop and roll up your sleeves! Participants should be comfortable with Excel basics and the functions mentioned in this description.

Operating Budget

“It’s clearly a budget. It’s got a lot of numbers in it.” — George W. Bush. Ever feel that way about your budget? This seminar is for you! We’ll help you bush-whack through the thickets of designing appropriate line items, planning, estimating, formatting, revising/rethinking, tracking actuals and more.

Operational Cashflow

In this seminar we define the difference between budget and cashflow, and explore various sources and uses of cash. We will also look at how to forecast cashflow, and examine a useful spreadsheet template.

CADAC Financial Reporting

Arts organizations that receive operating grant funding from arts councils and other major funders will be familiar with the CADAC financial form. This seminar simplifies the process of budgeting and reporting.


Excel Courses

Excel Basics for Beginners (PC & MAC)

Whether you’re new to Excel or feel like you aren’t using it to its full potential, this seminar is for you! Learn your way around Excel during this introductory course split into two sessions.

Budgeting in Excel

This workshop, focused on hands-on work supported by individual coaching, begins with a presentation on planning and reporting principles and a review of budgeting templates from simple to complex, leading to the creation of a detailed budget document incorporating Excel formatting techniques, multiple periods of data, formulas and functions (financial ratios, SUM, ROUND and more) and linked worksheets (reasonability calculations, detail and summary presentations). Alternative: participants can use coaching resources to develop their company’s budget.

Cashflow in Excel

Hands-on work supported by individual coaching is at the heart of this 2-hour workshop. We will begin with a presentation on cashflow principles and techniques, including the financial contents, timing issues involved in working with last year, this year and next year items, essential control and reconciliation features and a discussion of how much detail is desirable.

Excel Functions 1 – functions with 0-2 arguments

Functions are preset formulas or instructions that allow you to complete tasks rapidly. During this 2-hour introductory workshop, we will look at simple functions that perform core calculations and manage data effectively including SUM, AVERAGE, COUNT and ROUND.

Excel Functions II – conditional functions

Using the CADAC operating grant reporting form and a selection of reporting and data management scenarios, this 2-hour workshop explores the logic and various applications for IF, SUMIF and COUNTIF, including the use of nested arguments.

Budget Bootcamp

This 2-part workshop, focused on hands-on work supported by individual coaching, begins with a presentation on planning and reporting principles and a review of simple and complex budgeting templates, leading to the creation of a detailed budget document incorporating: Excel formatting techniques, multiple periods of data, formulas and functions (financial ratios, SUM, ROUND and more), and linked worksheets (reasonability calculations, detail and summary presentations). Participants can use this opportunity (and our coaching resources) to develop their company’s budget, or they can work with our sample data. Bring your laptop and expect to sink your teeth into spreadsheet creation! Participants should be comfortable with Excel basics and the functions mentioned in this description.

Managing Documents & Creating Templates in Excel I & II

Take your Excel skills to the next level with this 2-part workshop on managing documents. In the first part of the workshop, learn invaluable techniques for managing data inside cells; simultaneously formatting non-adjacent cells; opening multiple workspaces in a single Excel file; creating series’ with numbers, formulas and dates; adding, hiding, revealing and printing comments; controlling the appearance of printed documents, and more. In the second part of the 2-part workshop, learn how to build templates and design in Excel to meet your visual needs. Create stunning reports to share with your staff, board and funders. Format, link and merge information easily into your template and save time and stress when updating your reports. This session will include a guided exercise that will allow you to walk away with the tools you need! A legend will be provided for both PC and Mac shortcuts.

Managing Multiple Worksheets & Linked Documents in Excel & Word

This 2-hour workshop addresses more complex uses for Excel, particularly developing files with multiple worksheets and linking files (using both Word and Excel) – essential to using the software for more evolved planning and reporting tasks.

Reporting in Excel

This 2-hour workshop will give you plenty of hands-on practice supported by individual coaching as you develop skills in preparing detailed Excel reports.


Database Management

Integrating Database Management into Your Workflow

There are only so many hours in the day, and for most small to mid-sized organizations with limited staffing, working in the database often gets pushed to the bottom of the list until the crunch is on. In this session we explore tips and tricks for doing preliminary work that will make quick work of populating your database, and discuss ways to keep database management in the mix of your regular tasks, seamlessly integrating it into your workflow. Keep your data up-to-date so you always have access to the information you need to more your organization forward. This is an instructional seminar that will include case studies and a take away tip sheet.

Managing Your Data: Making it Work for You and Your Organization

What is a database? What do I want to get out of it? What data is relevant? How can I create consistency? This 2 hour seminar from Young Associates is designed to provide an overview of good database management practices for the arts and cultural sector. The seminar will cover goal setting, policies and procedures, and tips and tricks, and is geared to those working in both a spreadsheet or relational database environment.

Managing Data: Policies and Procedures for Populating Your Database

During this introductory seminar we will explore the basics of adding contact records to your database, and how with a few clicks you can create your own network of supporters that works for you.

Garbage into Gold: Housekeeping for your Database

The information you get out of your database is only as good as the data you put into it. In this seminar we will explore ways to create consistencies in the collection and data entry processes to ensure that your data is telling the true story.Finding lots of duplicate entries? Sinking staff time into maintaining multiple data files with overlapping contents? Losing opportunities because of missing patron information? Not sure if you’ve accurately tracked all your donations? Learn how to identify errors and omissions in your database, and get your data working for you again.

Researching Your Database: Advancing Fundraising With Prospect Research

Learn how to analyze your database for Fundraising purposes to grow your audience and further your mandate. Expand your patron base, target your asks, and meet or exceed your fundraising goals.

Singing from the Same Songbook: Harmonizing Database and Accounting Software

Every organization is likely to have at least two databases: its accounting package and a marketing, membership or fundraising package. Work is greatly streamlined when information is entered only once – but what’s the best way to harmonize the reporting so that both databases tell the same story? This workshop will consider the primary point of data entry, and options for capturing summary information without repeating all the details. In addition, we will explore reporting formats that will help you tell a story about your impact and celebrate your successes, supported by good, quantitative data – both financial and statistical. Case studies will be presented for discussion.

Sumac Basics: Getting Started

Populating your database with good, clean data can be the key to reaching your fundraising and marketing goals, but is often the part of the process we put off doing or give to the interns. Stop putting it off today and learn how to efficiently and effectively populate your database, manually and through data uploads, and get your new and existing data out of spreadsheets and into your database management software. After an instructional section and guided exercises, you’ll leave feeling more confident in your Sumac abilities and able to get your data working for you. Bring your laptop with the sample Sumac database ready to go.

Sumac Basics: Building Contact Records

Populating your database with good, clean data can be the key to reaching your fundraising and marketing goals, but is often the part of the process we put off doing or give to the interns. Stop putting it off today and learn how to efficiently and effectively populate your database, manually and through data uploads, and get your new and existing data out of spreadsheets and into your database management software.

Sumac Basics: Building Donation Records

In this seminar we will explore how donor data is entered into Sumac and how you can use the software to unlock key information about donor trends and the effectiveness of your fundraising campaigns.


Special Topics

Pre-Fringe Seminar: Make it to the end of Fringe before your money runs out!

ABCs of Indie Finances: Artists Balancing their Cash

CADAC Stats

Managing Up, Down and Across: A Peer Exchange about Buy-In on Database Investment, Training and Policies


Feedback

I really enjoyed yesterday’s session. First of all, I was pleased to learn that I knew more than I thought, but many of the nuggets you shared are worth their weight in gold! And your fifty-page handout – Diann always told me that your notes were better than any textbook and now that I’ve seen it, I believe it!
I’m looking forward to my other sessions throughout the summer.

…Excel Basics for Beginners participant

A BIG thank you to you and Heather for hosting such an informative event. It was very much appreciated and thank you for wanting to help us out.

…Fringe Seminar participant

Thank you so much for doing this seminar! I feel like the task of creating a budget for this show is far less daunting now. It was great to have examples of scenarios that come up in Fringe-type scenarios. My experience in university with budgets and cashflows was all for very large companies with operating budgets and a full year of shows to account for. I had no idea how to scale that down to work for this show. It was also great…to have other people there in the same situation to help put me at ease to some of the struggles we all shared. You ladies were an absolute pleasure also and I hope to work with you in the future when I have so much money I can’t handle it myself. ;)

…Fringe Seminar participant


Interested in any of our past seminars? Is there a topic you would like to see covered in a future seminar? Submit a message below.