Excel Classes Chicago - Excel Pivot Tables: You Know You're Curious

Excel Pivot Tables: You Know You're Curious

with Oz du Soleil

TOP RATED

5.0 | 3 reviews

13 Have Dabbled

ABOUT THIS EVENT

Event Category

Business & Technology

Event Overview

"Dude! It took me a whole weekend to do what you just did in 30 seconds!"
This quote came from someone who was desperate to get his business data under control. The business is doing well but he'd like to plan better and stop guessing about inventory levels, customer behavior and product line performance. And all it took was a pivot table.

People who work with Excel hear about Pivot Tables but aren't sure what they are, how they can be useful or when to use them. So, let's spend 2 hours just on Pivot Tables! They can help:

- Get immediate, focused summaries of your data without writing a bunch of formulas
- Assess the size of a project before you jump in
- Check your data quality before you start any analysis

Here is a guest blogpost where I show how to use Pivot Tables to check the quality of a nonprofit’s donor information: Pivot Tables: Your Tool for Exposing Miscreant Data

In the workshop you'll see that Pivot Tables can reduce DAYS of work down to seconds or minutes. The key is in laying out your spreadsheet properly. And well cover that during the session.

We’ll also look at some Excel 2013 features that make Pivot Tables even more powerful.

Sign up! Come out! Learn how you can grab hold of your data like never before.

Minimum age

All ages welcome

Prerequisites

The only prerequisite is that you use Excel on a regular basis.

Cancellation Policy

Location

There are currently no upcoming dates scheduled for this Dabble. Log in to an account message the host or add to your bucket list to be automatically notified when new dates are posted.

MORE ABOUT YOUR HOST

Oz du Soleil

TOP RATED

Oz is a freelancer who builds apps in Excel, and works with companies in cleaning their data. The one thing Oz has observed is that Pivot Tables are used in all of those situations. "We may not always use an IF function or a bar chart, but a Pivot Table always shows up at some point. It's the one thing that a solid Excel user can't do without."

MESSAGE HOST VIEW PROFILE

EXPERIENCE REVIEWS

Elda V.
Reviewed on 09/26/13

I really enjoyed the class and the teacher was awesome.

I really enjoyed the class and the teacher was awesome.
Edie M.
Reviewed on 09/24/13

This class was exactly what I needed. I started putting what I learned into action the very next day.

This class was exactly what I needed. I started putting what I learned into action the very next day.
Lynn Y.
Reviewed on 09/18/13

Course was very well presented. Oz moved at a pace that was comfortable, and related material to participants needs. He was a great instructor and I'm planning to attend more of his classes!

Course was very well presented. Oz moved at a pace that was comfortable, and related material to participants needs. He was a great instructor and I'm planning to attend more of his classes!