Excel Dashboards & Pivot Tables: Seeing Your Data

21 Have Dabbled
5 | 6 reviews

There currently are no classes scheduled for this course.

Medium excel dashboard wordle1a

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!

Student Reviews

5 | 6 reviews
  • Default user photo
    Nate G.
    Excel Dashboards & Pivot Tables: Seeing Your Data

    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.

  • Default user photo
    Eric G.
    Excel Dashboards & Pivot Tables: Seeing Your Data

    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.

  • Default user photo
    Ris F.
    Excel Dashboards & Pivot Tables: Seeing Your Data

    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. :-)

  • Default user photo
    Gail K.
    Excel Dashboards & Pivot Tables: Seeing Your Data

    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.

  • Default user photo
    Lynn S.
    Excel Dashboards & Pivot Tables: Seeing Your Data

    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. :-)

Show More
{"commenter_avatar":"/assets/fallback/default_user_photo.png","reviewer_name":"Ris F.","created_at":"over 3 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.png","reviewer_name":"Gail K.","created_at":"over 3 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.png","reviewer_name":"Lynn S.","created_at":"over 3 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. :-)"}

Oz du Soleil

Small square oz   s1k   small

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

Other Classes You May Like