Chandoo speaks at PASS Business Analytics Conference @ Santa Clara, USA - April - 2015 - Preparatory Material

Hi there,

Welcome to PASS Business Analytics Conference 2015. Thank you so much for enrolling in my pre-conference session. I am eager to meet you in Santa Clara this April amp; help you become awesome in your work.

In order to gain the most from this hands-on training, I want you to complete below preparatory course work before attending the class on April 20th.

How much time this prep-course takes?

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

If you have not enrolled in the PASS Business Analytics conference yet, Please click here to enroll.

Material for Advanced & Interactive Charts Training

Please go thru this material.

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.

Please go thru below links to learn about various referencing styles in Excel.

IF formula & its variations [30 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.

Please go thru below links to learn about IF formulas:

VLOOKUP formula [30 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.

Learn how to use VLOOKUP formula.

[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.

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 Santa Clara.