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.
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.
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 www.maineassessors.org 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 https://www.memun.org/Training 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 https://www.memun.org/Training/Cancellations 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