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.
There are currently no dates scheduled for this listing. Add to your wish list to be notified of future dates or message the host to request a new date or private event.
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.
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!
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:
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.
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. :-)
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.
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. :-)
Oz du Soleil
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
As demanded by the students in previous courses, we're bringing you: Pivot Tables & Dashboards