You have no graphic design skills. You have no programming skills. You work hard making business charts, dashboards, reports and presentations using Excel and PowerPoint. You want to learn more, you want to make a difference. Welcome to Excel Charts Training Center. This is for you.

Speaking of dashboards: do you know why you should learn how to make a dashboard in Excel? Here are some of the reasons:

  • You’ll have a better, more global understanding of your business;
  • You’ll improve the way you respond to user needs;
  • You’ll improve your data analysis, management, visualization and communication skills;
  • You’ll improve your Excel skills;

These are long-term skills that you’ll keep using even after your promotion :)

Two Dashboard Tutorials for You

I love learning by example. I love to see how a complex object was created, because I learn the “how” but also the “why”. If this is your learning style, you’ll enjoy these video tutorials. They’ll take you from a blank sheet to a fully functional, and somewhat complex Excel dashboard. And you get the actual Excel file and the database.

Both dashboards share the same data set, and I wanted to make them relatively similar, while using very different excel techniques to handle the data.  These videos are for Excel 2007 but I’m planning to add support for Excel 2003 and 2010 soon.

Excel Dashboard VBA Tutorial

Excel Dashboard PopulationVBA? No way! Wait. There are two things that every Excel user should use: pivot tables and recorded macros. I hate it when I see users fighting with SUM() and SUMIF() when they could use a pivot table instead. It’s simpler and safer. So, this tutorial uses several pivot tables, and if you haven’t used them until now you’ll be amazed of how powerful they are.

Problem is, if you use more than one pivot tables, you have to synchronize them. That’s where you’ll use recorded macros. You synchronize the pivot tables once, record your actions and  assign the macro to a button. It’s simple, really. Click here to know more…

Excel Dashboard Lookup Tutorial

Excel Dashboard Population ProjectionsYou should learn more about pivot tables and recorded macros. But if you really don’t want to use them and you prefer lookup functions instead, the Lookup Tutorial is for you. Yes, it uses lookup functions, but that’s not the end of the story. You’ll learn how to aggregate data using SUMPRODUCT() and database functions like DSUM().

I also wanted to play with the design, adding charts (and the map), removing others and make it unrecognizable as an Excel file. If a user starts wondering if this Excel I’ll be very pleased! Click here to know more…

 

Data Visualization for Beginners

A good chart can dramatically improve the way you use and make sense of your data. This course will help you finding better data analysis strategies, show you how to take advantage of human perception and how to select and format the right chart for the right question. Click here to know more…