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