Join us on Tuesday August 16th for our upcoming webinar series with Excel TV brought to you by PASS Excel BI VC. Excel TV is partnering with the PASS Excel BI VC to bring you four back-to-back 1-hour webinars live! Learn to create outstanding spreadsheet modules, clean your data, create effective dashboards and understand how Excel Tables can make your life easier.
This webinar series will be taking place on August 16th, starting at 17:00 UTC. Register for each session by following the links below.
Creating Outstanding Spreadsheet Models
Presented by Jordan Goldmeier
Tuesday August 16th, 17:00 UTC
This is an hour-long discussion on creating outstanding spreadsheet models in which I propose three conceptual points to optimize: layout and design, code and formulas, and presentation. I will go through each topic and provide you with directives to build better spreadsheet models. Most importantly, you will develop the tools and confidence necessary to apply these principles across spreadsheet models in all fields.
Making Informed Decisions: Guidelines for Creating an Effective Dashboard
Presented by Rick Grantham
Tuesday August 16th, 18:00 UTC
This session will provide guidelines for developing a dashboard that helps your organization make better-informed decisions. By attending this session, you will:
- determine the best ways to scope your dashboard project, including tips for gathering requirements and eliciting feedback
- see what’s required to build an effective dashboard, from documenting query mockups to creating dashboard prototypes.
I will go through every step of the requirements gathering process and provide the audience with live demonstrations at every step, including real-life examples of how to best scope your dashboard.
After this webinar, you will know when you should (and when you should not) start your KPIs with your company’s annual report. You will be armed with the most efficient process to create the most effective dashboards.
Ten Great Reasons to Use Excel Tables
Presented by Szilvia Juhasz
Tuesday August 16th, 19:00 UTC
This is a must-see overview of why and how Excel Tables matter. With an all-new formula syntax and better “plug and play”-ability with databases and data models, Excel tables offer great benefits for streamlining your daily data management and reporting needs. A must-see for any analyst seeking more confidence navigating this modern era of exponentially larger volumes of data and ever-increasing demands for insights.
Intro to Data Cleansing with Get & Transform (Power Query)
Presented by Oz du Soleil
Tuesday August 16th, 20:00 UTC
More powerful than Text-to-Columns; more flexible than VLOOKUP and INDEX/MATCH. Get & Transform has incredible capacity to cleanse and shape data. And repetitive cleansing tasks can be automated. Oz will show you critical skills that can be done with Get & Transform, from reading in large data sets to fixing critical data inconsistencies, this talk will help you always maintain access to clean, trustworthy data.
- The Comprehensive Guide to the Excel Ribbon: Making the Most of Your Data - January 31, 2023
- 51: Oz du Soleil & the Global Excel Summit 2021 - February 8, 2021
- 50: Randy Austin – Excel for Freelancers - January 22, 2021
Power User Quick Guides:
Hi Szilvia
Great to see someone else debunking the myth that VLOOKUP can’t look left, however, the syntax shown in your guide, viz;
=VLOOKUP(thing_to_find, CHOOSE({1,2}, lookup_col, return_col, 2, FALSE)
is missing the closing parenthesis for the CHOOSE function (immediately after “return_col”).
Keep up the good work.