Loading...

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

GET 75% OFF THE COURSE
Free Ebook

Latest Tutorials

  • Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets in Excel

In this tutorial I show you how to lookup values from multiple Excel Sheets or tabs. In Excel it's relatively easy to lookup values in one specific tab. But how do you lookup values

Excel Dependent Drop Down List with Tabular Data

How do you handle dynamic data validation lists that refer to parts of your table only?  In this example we have a tabular data set. On one side we have the Division and the

  • Excel dynamic data validation many words and spaces

Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

A simple approach to create dependent lists Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List This video builds on the methods shown in a previous tutorial

  • Excel Create Better Tables

BMW Corporate Report Makeover in Excel: Better Tables in Reports

Part 3 of our step-by-step guide: Corporate Report Makeover CHAPTER 3: Better Tables in Reports In this last part of the BMW report case study we

  • Alternative for Doughnut (Donut) charts

Corporate Report Makeover: Alternative for Doughnut Charts

Part 2 of our step-by-step guide: Corporate Report Makeover CHAPTER 2: Alternative to Doughnut Charts Doughnut or Bar Chart? In the 2nd part of our corporate

Trusted by