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

  • Excel VBA & Excel Macros and WordArt in Excel

Excel VBA: Control WordArt Fill with Macros

How can you get this effect? Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art

  • Excel WordArt with Formula and Excel bar in bar charts to show progress

Dynamic WordArt in Excel with Bar in Bar Chart

Let's get creative with Excel! In this tutorial we're going to combine Word Art together with Excel charts to create an impressive progress bar. This progress bar is a part of the % sign

  • Excel IF function

Excel IF Formula: Simple to Advanced

The IF function is one of Excel's most common Functions The IF formula performs a test and returns a value depending on the outcome of the test. The test it performs can be simple

Simple Excel Dynamic Map Chart with Drop-down

Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI's by geography. This method doesn't use the relatively new Bing map feature, which means it is

  • 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

Trusted by