Search

Hi there,

Welcome to my Excelapalooza 2014. Thank you so much for enrolling in my dashboards session. I am eager to meet you in Dallas this September & help you become awesome in your work.

In order to gain the most from this hands-on workshop, I want you to complete below preparatory course work before attending the classes in September (22 or 23).

### How much time this prep-course takes?

It should take no more than 8 hours of your time. Please aspire to finish it all to gain most from the hands-on workshop.

## Material for Dashboards Workshop

Absolute vs. Relative References in Excel [30 mins]

Understanding various reference styles is very important to develop simple, repeatable & useful formulas. And formulas are the engine of any successful dashboard.

IF formula & its variations [45 mins]

IF formulas help us build various real-life conditions & scenarios in Excel. Learning how to use IF formula is critical to building your formula knowledge.

SUMIFS Formula [45 mins]

SUMIFS (along with its cousins – COUNTIFS, SUMIF, AVERAGEIF etc.) plays a vital role in quickly summarizing data and getting answers to our questions.

VLOOKUP formula [60 mins]

VLOOKUP formula helps us answer questions like what is the price of product PR1234-01? by looking up data. Along with other powerful functions like MATCH & INDEX, VLOOKUP helps us do many useful things when building dashboards. Please note that we will be learning about MATCH & INDEX in the Masterclass. So, just brush up on your VLOOKUP for now.

[optional, takes another 60-90 mins] Comprehensive guide to Excel LOOKUP formulas

Excel Tables [30 mins]

Excel Tables help us structure our data & write simpler formulas. They are vital for creating dashboards that have ever-changing data.

Introduction to Excel tables

[Optional, takes another 30 mins] How to use VLOOKUP with Tables

Conditional Formatting [30 mins]

Conditional formatting is a quick & easy way to add wow-factor to your reports, analysis & dashboards. Learn the basics now. We will learn advanced stuff in the Masterclass.

Introduction to Pivot Tables [30 mins]

Pivot tables form the core of Power Pivot. So get a good understanding of what they are and how to use them.

## Thank you and see you at the conference

Thanks again for taking the preparatory course. I am eager to meet you at the conference in Dallas.

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.