If you haven't already done so, please Sign In or Create an Account to register.

Should you need assistance with your registration, email our Accounting/Registration Specialist, Shobhan Chickarmane.

Sign In

Budgeting 201 Workshop

Budgeting 201 – Post Budget Adoption – Production, Supporting Schedules, Analysis, and Awards

This full-day interactive workshop will focus on budget production by creating supporting schedules, analyzing preliminary June 30th year-end financial information to the 2017-2018 fiscal year budget. We will then focus on the budget awards that can be applied for to give positive publicity for your agency or District.

You will learn how to create and maintain company, departmental, cost center, line item operating budgets. This class will be for all levels of Excel users, and applies to anyone creating budget documents in Excel, Word, and PowerPoint. We will create linked tabs and documents from your company’s budgets online, as well as from my former organization Padre Dam Municipal Water District.  We will create Excel tables, charts, graphs and use Pivot Tables and V-Lookups. Bring any Excel budget files from your agency electronically, and we will discuss and work with them.

This class is for anyone working in the budget process, using Office, or wants to learn more about the details of how budget documents are created.

A laptop with this Office installed will be required. PC version will be used in class.

Prerequisite - Completing Budgeting 101 in the Water Industry is recommended but not required.

DRAFT Outline:


  1. My introduction - qualifications
  2. Attendee Introductions
  3. Discuss the latest budget cycle
  4. Show the Budget for PDMWD
  5. Show some attendees online budgets
  6. Excel - Create 3-year Operating Departmental Schedule
  7. Excel - Create and Analyze Year End Financial Statements


  1. Excel - Update Budget Files with Actual Preliminary Year End Amounts
  2. Word - Create Department Descriptions
  3. Word - Create Supporting Verbiage for Budget Variances to prior year.
  4. PowerPoint - Create Presentations for Management and Board of Directors
  5. Power Point and Excel Files
  6. Power Point and Word Files


  1. CSMFO Award Criteria
  2. GFOA Award Criteria

1:45 - 3:00

  1. Excel - Analyze Budget Variances
  2. Excel - Create Charts and Graphs
  3. Excel - Create Pivot Tables and V-Lookups
  4. Excel - Tips and Tricks

Member $150 / Non-member $250
This workshop is 8:00 am - 3:00 pm
Earn up to 6 contact hours.
Instructor: Len Legotte
7/12/2018 - 7/12/2018
California-Nevada Section, AWWA Frontier Project, First Floor 10435 Ashford Street Rancho Cucamonga, CA 91730

Refund Policy

Requests for refunds must be made in writing and are subject to the following conditions: Full refund of fee paid (minus $50.00 handling fee) will be issued for cancellations received more than two weeks prior to class or event date. All fees are non-refundable thereafter.

Transfer Policy

Requests for transfers must be made in writing.  Transfers are based on availability.  No transfer requests will be authorized within 72 hours prior to the class date.