Advanced Excel, Dashboards & Power Pivot Masterclass in USA – 2014

Hello folks,

I have a super exciting news to share with you all. I will be conducting Masterclasses on Advanced Dashboards & Excel in Houston, Texas (USA) this September. So if you live in (or nearby) lone star state and want to one up your dashboard skills, you know what to do next.

What is in this Masterclass & Who should attend?

This masterclass is conducted only in Houston, Texas. It has 2 programs.

• Advanced Excel & Dashboards – 15 & 16 September (Monday & Tuesday), 2014
• Power Pivot, Power Query & Data Analytics – 17 & 18 September (Wednesday & Thursday), 2014

This 4 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Data Analytics, Advanced Excel, Dashboard reporting

Advanced Excel & Dashboards Masterclass:

In this masterclass we will be learning,

• Day1: Our first dashboard in Excel
  • Excel formulas for dashboards
  • Applying advanced conditional formatting & sparklines for dashboards
  • Building our first dashboard – hands-on exercise
• Day 2: Advanced dashboard skills
  • Selecting right charts for any situation
  • Enhancing dashboards with Excel 2010 & 2013 – sparklines, slicers, timelines
  • Customizing Excel charts – top 5 problems
  • Building our second dashboard – hands-on exercise
  • Q&A

Power Pivot, Power Query & Data Analytics Masterclass:

• Day1: Data analysis with Pivot & PowerPivot features
  
  • Introduction to PowerPivot & Case study
  • Using Slicers & Pivot Tables
  • Using DAX to analyze data
  • Understanding Important DAX functions
    • Simple measures
    • CALCULATE()
    • ALL()
    • Disconnected Tables & FILTER()
    • DATE Intelligence formulas
• Day 2: Advanced Analysis thru PowerPivot
  
  • Power Query, let your data pains be gone
  • Selecting right charts for any situation
  • Building PowerPivot Dashboard
  • Dashboard Best Practices & Ideas
  • Q&A

For complete details about the masterclass, please download our brochure.

Benefits of this Masterclass – what you will get?

These are the benefits of the of our Masterclass:

1. Learn the process to create robust, easy-to-maintain Excel Dashboards
2. Build better & error-free Excel reports
3. Know how to choose right charts based on your need
4. Understand design principles that make your work stand out
5. Discover some of the less commonly-known Excel features

And you will get this by enrolling:

• Two (or 4) full days of tuition by me
• Lunch and refreshments
• USB stick with Example workbooks, PDF guides & videos
• Access to selected videos & material on Chandoo.org
• Email support for Excel questions for 3 months following the course by Chandoo.org

When is it?

The venues and dates of the masterclass are,

• Advanced Excel & Dashboards – 15 & 16 September, Houston, Texas
• Data Analytics, Power Pivot & Power Query – 17 & 18 September, Houston, Texas

Where is it?

The location of the masterclass is,

11490 Westheimer Road
Suite 900
Houston, Texas 77077

Masterclass fees & Enrollment

This masterclass is US $1,400 per participant per program.

Early bird price per delegate (applicable until 31st of August, 2014):

This masterclass is US $1,200 per participant per program.

If you join both classes (Advanced Excel & Power Pivot), you get $200 discount. The total fee would be – $2,200.

 

Enrolling for the Masterclass

Thanks for your interest in this class. We are sold out.

If you want to learn these concepts, I suggest enrolling in our Power Pivot + Excel School online training program.

Please visit Online Training Programs page to know more.

Thank you

I am really excited about my trip to Houston. I am so thankful to you for supporting Chandoo.org all along & making this happen. 🙂