August 3

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.

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.


You may also like

January 31, 2023

The Comprehensive Guide to the Excel Ribbon: Making the Most of Your Data

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead
  • 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.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.