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 which shows a percentage value that is connected to a
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 of our Word Art. The result is the icon for
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 or complex depending on the problem at hand. It's one
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 works on all Excel versions. The technique shown uses a
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 another lookup formula as well) inside the original data set.
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 Chart is great for visualizing variables that change on an
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 a Pivot Table; But let's say you'd like to use
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 set it up, you realize that in Excel, you can
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 every time we reach the 1st of the next month.
Excel Dynamic Column Chart with Average Line Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combination charts in