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

Skip Dates in Excel Charts

How do you create gaps on the horizontal axis of a line chart when the data values are empty - i.e. contain blank cells? Excel normally fills the empty dates on the x-axis and

Complex Lookup: Find Header

Find Header based on Lookup Criteria in Matrix (Unique matrix values) - scroll down for non-unique method  In this tutorial I show you the answer to one of the questions that was asked some

  • excel number format formula excel custom number format millions

Smart Uses of Custom Formatting

Use Custom Formatting instead of Conditional Formatting in Excel. Smart Uses of Custom Formatting We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green

Smart Uses of Custom Formatting – Part 2

Smart Uses of Custom Formatting - Part 2 Explore the possibilities of Custom Formatting with Part 2 of our guide. If you missed it, check out Part 1.

Lookup multiple criteria in rows or columns

The Complete Guide to INDEX & MATCH CHAPTER 2: Lookup multiple criteria in rows or columns Some reports involve the need to find a value from a source table using multiple criteria

Trusted by