Excel Pivot Tables: You Know You're Curious

Top rated icon TOP RATED

5.0 | 3 reviews

13 Have Dabbled

Carousel iheartss
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.

No upcoming dates. Add to your bucket list to be notified or message host.

BRING IT BACK

MORE ABOUT YOUR HOST

Oz du Soleil

Top rated icon 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."

EXPERIENCE REVIEWS

  • Default user photo
    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.

  • Default user photo
    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.

  • Default user photo
    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!

  • Show more
{"commenter_avatar":"/assets/fallback/default_user_photo-7844ce7f6060bc35d96b520c91dde332223314399368a367699ab784f5d8e1fa.png","reviewer_name":"Lynn Y.","created_at":"over 7 years","title_link":"\u003cstrong\u003eExcel Pivot Tables: You Know You're Curious\u003c/strong\u003e","positive":true,"review_content":"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!","teacher_response":null}

More Events From Oz du Soleil

SIMILAR EXPERIENCES

BROWSE ALL EVENTS