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.

Free Ebook

Latest Tutorials

  • conditional format index match formula result

Conditional Format Index Match Result

Would you like to highlight the result of your lookup formula in the data set? In this tutorial I show you how to conditionally format the result of your Index Match formula (could be

  • How to create a step chart in excel

How to create a Step Chart in Excel

This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step

  • Excel extract unique items for drop-down

Extract unique items for dynamic data validation drop down list

How can you extract unique items from a list that contains multiple instances of each item? There are more "manual" ways you can do this - for example using the Remove duplicates feature or

  • Excel column and stacked chart combination

Excel Clustered Column AND Stacked Combination Chart

How can you create this chart in Excel? At first it seems relatively easy to setup. After all, column charts are one of the most used charts in Excel. But once you start to

  • Reset Weekly Number per month in Excel

Reset Week Number Every Month (start from Week # 1 every new month)

In this video I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to start from 1

Trusted by