Complex Lookup: Find Header

Find Header based on Lookup Criteria in Matrix  In this tutorial I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample data was changed for the video) - The question

Quick Gantt Chart

Create a Gantt Chart now in Excel with this step-by-step guide. Quick Gantt Chart A Gantt Chart is great for visualizing and presenting your project plan. But let's say, you just setup a preliminary project plan in Excel. You did that

Stacked Column With Connectors

How do you create this chart in Excel? In this video you'll learn how to add series lines to stacked column charts. Instead of series lines, you might want to add a shaded background to each of the stacked sets. We can do that

3 Steps To Make Great Excel Charts

Are you unsure how to improve the charts and tables in your Excel reports? How to visualize your data for a clear message? Not sure what is easy, effective, or even possible in Excel? An effective chart clearly communicates the intended message to the

Excel Reverse Matrix Lookup

Are you familiar with INDEX MATCH? If you're familiar with Index and Match you know how to solve a matrix lookup problem. You want to find a value inside the matrix by looking up the row and column headers. What happens though when it's

Excel Table Design

Use data tables when you want the reader to look up individual values and do exact one-to-one comparisons. Data tables are ideal for effectively presenting different types of data - such as costs, quantities, ratios, etc. - all in one place.   Let’s look at

Pivot Slicers for Dynamic Charts

Pivot slicers can be used for pivot charts as well and they are an easy way to create interactivity in your Excel reports. In this example I cover two topics: How to get Weekday name from a given date How to create a Pivot

Conditional Formatting Symbols

How to use Own Symbols in Excel and Conditionally Format Them You'd like to use symbols in your reports to bring attention to certain tasks or results? You find the icons available in Excel's Conditional Formatting limited? You'd like something different to make your

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data