New Webinar Series on August 16th Presented in Partnership with PASS Excel BI VC - Register Now! - Excel TV
Excel TV
Share The LOVE

New Webinar Series on August 16th Presented in Partnership with PASS Excel BI VC – Register Now!

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.

[button size=”large” url=”″ text=”Register for Jordan’s Webinar” target=”” color=”orange” ]

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.

[button size=”large” url=”″ text=”Register for Rick’s Webinar” target=”” color=”orange” ]

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.

[button size=”large” url=”″ text=”Register for Szilvia’s Webinar” target=”” color=”orange” ]

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.

 [button size=”large” url=”″ text=”Register for Oz’s Webinar” target=”” color=”orange” ]

  • Col Delane says:

    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.

  • >