Workshops & Training

MAAO's Creating Excel PivotTables and Dashboards and Other Excel Tips! November 6, 2023

Sponsored by: Maine Association of Assessing Officers
You must pre-pay to attend this course. Course is limited to 25 participants.
Date: 11/6/2023
Location: Maine Municipal association, 60 Community Drive, Augusta ME 04330
Time: Registration: 8:00-8:30 a.m. / Workshop: 8:30 a.m.-4:00 p.m.
Presenter(s): David Cornell, Certified Microsoft Trainer, Certified Excel Expert, MAI, and CAE
Cost: MAAO Members: $215 | Non-Members: $255

Training for: Workshops & Events, Assessor, Finance, Manager, Tax Collector & Treasurer, MAAO

Certification: Eligible for 6.5 Assessors continuing education hours. Printed certificates are distributed on-site at the conclusion of the workshop.

Course Description: Create live dashboards and rich interactive PivotTables and Pivot charts. This hands-on course starts with foundational exercises of how to create PivotTables and Charts. Once we cover the foundational exercises, we will build interactive dashboards and reports!

This course will cover the following topics:

  • Creating and editing charts
  • Creating PivotTables (they are awesome!)
  • Formatting PivotTables and Charts
  • Creating and working with Tables
  • Using Slicers in reports
  • Using conditional formatting
  • Using data “Best Practices” in Excel
  • Importing data into Excel
  • Refreshing PivotTable Data
  • Creating dropdown lists
  • Building assessing dashboards
  • Other time-saving tips and techniques


  • You must bring a laptop for this course that has Excel version 10 or newer.
  • Class is limited to 25 Participants.
  • Continental breakfast and lunch are included in the registration fee.

ADA Compliance:
It is our practice to conduct workshops only in ADA compliant facilities. Please notify us in advance if you have additional physical or dietary needs, so that we can assure your comfort and full participation.

Consider joining MAAO membership. Call Educational Services at (207) 623-8428 or visit for a membership application.
If there is inclement weather, a decision to postpone will be made by 5:00 pm the day prior to the workshop. MAAO encourages all registrants to check the MMA website at before departing for any MAAO sponsored events to ensure that the event schedule has not changed.

Cancellation notification must be given in writing at least 3 business days before the session begins. Any cancellation received within that 3-day window will be charged the full registration fee. All cancellations are subject to a $10 administrative fee for processing. Please go to to cancel. If you have any questions, please contact the Educational Services Office at (800) 452-8786 or (207) 623-8428.


Click Here To Register

2023 Training Calendar
Download the Training Calendar (pdf)

Notices & Information

Phone: 1-800-452-8786

If pre-registration for a workshop is closed, we will be accepting door registrations on a first come/first served basis. To cancel an existing registration click here.

Policies & Disclaimer

Click here for a complete list of MMA workshop and webinar policies including cancellation, storm, fragrance, smoking & ADA Compliance policies.