Microsoft Excel Database Analysis and Pivottables Made Easy - Virtual (C69391)

Log In to Register

Cancellation Policy

Please note that this course is from a third-party vendor, The Carroll-Keller Group. If you cancel less than 7 days in advance of the session, fees are nonrefundable. We strongly recommend registering no later than 24 hours before the course begins. Please contact Sue Malan if you do not receive the event logistics via email at least 24 hours before the course begins: [email protected] or 630-495-0505. Thank you.

Date(s):

06/16/2025

Registration Open:

8:45 AM - 9:00 AM

Time:

9:00 AM - 4:30 PM

Facility:

 Online

Meeting Type:

Courses

CPE Credit:

6.50

Field(s) Of Study:

Personal Development (6.50)

Level of Knowledge:

Basic

Price:

Member: $325.00
Nonmember: $345.00

Individual Discounts:

Not Available

Group Discounts:

10+ Registrants - Discount: 5.00%
20+ Registrants - Discount: 10.00%

Overview

How they work, when to use them, and what they can do for YOU!

Lost your way in the data-jungle and trying to understand what your data is telling you? Gain top-insight and more effective understanding of your data with Excel’s powerful data-tools, features, and functionformulas. Learn to effectively manage worksheet data or data from outside sources. Discover how pivot tables can help make the most from your data with its powerful summarization, charting and reporting tools.

During this workshop you will learn to:

  • Procure database-list data from scratch or outside file/data source.
  • Fix/normalize data with special tools and function-formulas. 
  • Sorting by primary, secondary and more – to compare and contrast areas of your data.
  • Perform subtotaling reports on single and grouped data. 
  • Filter data to focus on information that matches criteria you set. 
  • Advanced filters called “slicers” that make it easy to understand what exactly is being displayed (dashboard effect). 
  • Insert pivot-table tool – perform the ultimate in data summarization and formatted reporting. 
  • Pivot-charting based on pivot-tables.

Other Information:

  • The session will be delivered on the Go To Meeting platform so all participants will work from their own workspace and use their own computer. Go To Meeting has video capability but, if the participant’s computer is not equipped with a camera, audio will also work. 
  • To register we will need the name and email address of each participant. 
  • Five (5) days before the date of the session we will send each participant an electronic copy of the course materials. Additionally, we will provide a link of a Meeting ID that when clicked on will allow the participant to enter the training room. For those registering less than 5 days prior, it will be no problem as we will immediately provide the information.
  • Participants should enter the training room 15 minutes (8:45) before the start time.
  • The sessions will be limited to 20 participants to allow for, and ensure, maximum interaction, participation and engagement.

Speaker(s)