Charts
Dashboards
Features
Formulas

Charts

  • 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 which shows a percentage value that is connected to a cell with a formula. Anytime the cell value is

  • 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 of our Word Art. The result is the icon for this blog post. The thing with Word Art is

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 works on all Excel versions. The technique shown uses a scatter plot first to set up the respective points

More

Dashboards

  • 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 a Pivot Table; But let's say you'd like to use this list in a data validation drop-down and you'd

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need to create a dependent drop down list using a source table. However, while some instances would have the list

  • 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 which showed you how to create an Excel dynamic drop-down data validation list that was dependent on the selection

More

Features

  • 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 another lookup formula as well) inside the original data set. The tricky part is to get the formula required

  • Excel solver examples

Excel Solver example and step-by-step explanation

Handle complex data models and solve for the optimal solution. Excel Solver example and step-by-step explanation Excel’s Solver tool can do complex statistical modeling. There are many ways to benefit from it when you want to manipulate multiple cells to get a certain result. It can be used when solving

Excel Goal Seek Explained in Simple Steps

Find the required numbers to achieve a target value. Excel Goal Seek Explained in Simple Steps In cases where you have a target value that is derived from a formula and you need to find the required numbers to achieve it, Excel’s Goal Seek feature will come in handy.An example of this

More

Formulas

  • 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 or complex depending on the problem at hand. It's one of those formulas that every Excel user should know.

  • 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 every time we reach the 1st of the next month. 2nd case: We reset the week number to 1

  • Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using only one formula? In this tutorial, I'll show you different methods for achieving this. One method uses VLOOKUP

More
All Tutorials
Share This