Excel Classes Chicago - Excel Dashboards & Pivot Tables: Seeing Your Data

Excel Dashboards & Pivot Tables: Seeing Your Data

with Oz du Soleil

TOP RATED

5.0 | 6 reviews

21 Have Dabbled

ABOUT THIS EVENT

Event Category

Business & Technology

Event Overview

You've got a massive amount of data in a spreadsheet 1200 rows & 40 columns, and it just keeps growing. But there are just 5 to 10 things you want to know about this information. How are you going to dig it out? Some people give up and just guess.

STOP!

Let's bring together Pivot Tables and Excel functions and build dynamic summaries of the most important details; i.e., a Dashboard.

We'll go over the diagnosis of the data quality, discuss layout of the dashboard, build the dashboard and install internal alerts to ensure that we can trust the dashboard's results.

After the course, students will be emailed a copy of the finished work.

NOTE: The content of this workshop will be solidly intermediate Excel skill level. Beginners are welcome if they'd like to see what's possible.

C'mon and register!

Minimum age

All ages welcome

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 du Soleil is a freelance Data Management consultant who has been working with Excel for more than 15 years. His approach to Excel and Data Management is from a strategic and conceptual perspective because simple tools and a clear strategy can go much further than fancy tools and no strategy.

Oz has taught 2 courses with Dabble:
Excel Beginner/Intermediate Demo
Excel Formulas

As demanded by the students in previous courses, we're bringing you: Pivot Tables & Dashboards

MESSAGE HOST VIEW PROFILE

EXPERIENCE REVIEWS

Nate G.
Reviewed on 04/10/13

Learned some very helpful tips for solving business problems using Excel. The instructor really knows his stuff and engages students to use examples from their situation to teach the class new things.

From Teacher:

Naté, thanks for the feedback. I'm glad you got something from the course. I agree that the venue was a bit loud that night. For a moment it sounded like Karaoke was going on in the other room. That was unusual. I've got 3 more sessions planned at that venue and am actively looking for another location that offers (free) space. NOTE: I do bring a cord with extra outlets with me. You're welcome to plug in where I'm at. But generally, yes, the outlets are very few. Thanks again, be in touch and I hope to see you again soon.

Learned some very helpful tips for solving business problems using Excel. The instructor really knows his stuff and engages students to use examples from their situation to teach the class new things.

From Teacher:

Naté, thanks for the feedback. I'm glad you got something from the course. I agree that the venue was a bit loud that night. For a moment it sounded like Karaoke was going on in the other room. That was unusual. I've got 3 more sessions planned at that venue and am actively looking for another location that offers (free) space. NOTE: I do bring a cord with extra outlets with me. You're welcome to plug in where I'm at. But generally, yes, the outlets are very few. Thanks again, be in touch and I hope to see you again soon.
Eric G.
Reviewed on 02/01/13

Oz had a lot of great things to share, but I learned plenty just watching him use excel.

From Teacher:

Eric, that's a fresh perspective. I hadn't thought about it but I know I've benefitted form just watching others use Excel.

Oz had a lot of great things to share, but I learned plenty just watching him use excel.

From Teacher:

Eric, that's a fresh perspective. I hadn't thought about it but I know I've benefitted form just watching others use Excel.
Ris F.
Reviewed on 01/31/13

Oz du Soleil makes Excel interesting, exciting, amazing and many other positive words that end with "-ing." He also makes the higher functions and capabilities of Excel accessible and understandable for people who know virtually nothing about the program.

The most important thing Oz teaches is how to think about the raw data you already have and what you would like it to do... in plain English.

From Teacher:

Ris, YOU GOT IT! Thinking in plain English about the task is key. Once that's done, the solution can be simple, complex or brutish but you have a good chance of reaching the destination if it's clearly conceptualized. ONWARD! Thanks for the review. :-)

Oz du Soleil makes Excel interesting, exciting, amazing and many other positive words that end with "-ing." He also makes the higher functions and capabilities of Excel accessible and understandable for people who know virtually nothing about the program.

The most important thing Oz teaches is how to think about the raw data you already have and what you would like it to do... in plain English.

From Teacher:

Ris, YOU GOT IT! Thinking in plain English about the task is key. Once that's done, the solution can be simple, complex or brutish but you have a good chance of reaching the destination if it's clearly conceptualized. ONWARD! Thanks for the review. :-)
Gail K.
Reviewed on 01/31/13

Learned a lot - format was open and flexible. Oz did a great job answering questions - even if way off topic.

From Teacher:

Gail, thanks for attending and thanks for your questions during the workshop. This one was fun and intense. Lots of layers, lots of great inquiry from the students. Hope to see you again.

Learned a lot - format was open and flexible. Oz did a great job answering questions - even if way off topic.

From Teacher:

Gail, thanks for attending and thanks for your questions during the workshop. This one was fun and intense. Lots of layers, lots of great inquiry from the students. Hope to see you again.
Lynn S.
Reviewed on 01/31/13

Good information; a lot packed into a short amount of time. Well worth the $20 and time.

From Teacher:

Lynn, thanks for the feedback and for attending. I'm so glad that you found the experience worthwhile. :-)

Good information; a lot packed into a short amount of time. Well worth the $20 and time.

From Teacher:

Lynn, thanks for the feedback and for attending. I'm so glad that you found the experience worthwhile. :-)

{"commenter_avatar":"/assets/fallback/default_user_photo-7844ce7f6060bc35d96b520c91dde332223314399368a367699ab784f5d8e1fa.png","reviewer_name":"Ris F.","created_at":"almost 12 years","title_link":"\u003cstrong\u003eExcel Dashboards \u0026 Pivot Tables: Seeing Your Data\u003c/strong\u003e","positive":true,"review_content":"Oz du Soleil makes Excel interesting, exciting, amazing and many other positive words that end with \"-ing.\" He also makes the higher functions and capabilities of Excel accessible and understandable for people who know virtually nothing about the program.\r\n\r\nThe most important thing Oz teaches is how to think about the raw data you already have and what you would like it to do... in plain English.","teacher_response":"Ris, YOU GOT IT! Thinking in plain English about the task is key. Once that's done, the solution can be simple, complex or brutish but you have a good chance of reaching the destination if it's clearly conceptualized. ONWARD! Thanks for the review. :-)"}

{"commenter_avatar":"/assets/fallback/default_user_photo-7844ce7f6060bc35d96b520c91dde332223314399368a367699ab784f5d8e1fa.png","reviewer_name":"Gail K.","created_at":"almost 12 years","title_link":"\u003cstrong\u003eExcel Dashboards \u0026 Pivot Tables: Seeing Your Data\u003c/strong\u003e","positive":true,"review_content":"Learned a lot - format was open and flexible. Oz did a great job answering questions - even if way off topic.","teacher_response":"Gail, thanks for attending and thanks for your questions during the workshop. This one was fun and intense. Lots of layers, lots of great inquiry from the students. Hope to see you again. "}

{"commenter_avatar":"/assets/fallback/default_user_photo-7844ce7f6060bc35d96b520c91dde332223314399368a367699ab784f5d8e1fa.png","reviewer_name":"Lynn S.","created_at":"almost 12 years","title_link":"\u003cstrong\u003eExcel Dashboards \u0026 Pivot Tables: Seeing Your Data\u003c/strong\u003e","positive":true,"review_content":"Good information; a lot packed into a short amount of time. Well worth the $20 and time.","teacher_response":"Lynn, thanks for the feedback and for attending. I'm so glad that you found the experience worthwhile. :-)"}