Charts
Dashboards
Features
Formulas

Charts

  • Adding total values to stacked column charts

3 Ways to Improve Readability of Excel Stacked Charts

Add Total Values, Percentages & Dynamic Legends   There is so much potential to improve the standard Excel stacked chart. For one, adding total values outside the last stack would ease comparison between categories. Adding percentages to the stacks would also help identify and compare the stack sizes to one another. One method

  • Excel variance charts - columns, bars error bars and arrows

Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows

Dynamic column and bar charts are great for showing variances. Dynamic arrows also work great here! How can you create this in Excel? In this full series you will find four ways to visualize variances. Method A: Uses a column chart with dynamic coloring of the columns to distinguish between positive and negative

  • free waterfall chart in excel guide

Easiest Waterfall Chart in Excel From Scratch (works with negative cumulative values)

Watch the video to learn how to create a Waterfall or Bridge Chart in Excel. From Scratch! It uses simple but unusual techniques to quickly and easily get a Waterfall Chart that also works with negative cumulative values. If you prefer to read instead of watching, scroll down and follow the steps. Also Scroll down for

More

Dashboards

  • excel chart dashboard

Excel Charts: Special Excel Graphs (InfoCharts) – How to use shapes in charts

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 though). I found the chart informative, visually effective and interesting.

5 Design Tips for Better Excel Dashboards

What results do you want to show in your Excel dashboard? What should readers take away from it? These five design tips will help you showcase your data clearly and directly. Scroll down for the video. Learn how to create this interactive Excel report in the upcoming ‘Visually Effective Excel Dashboards’ Course. 1.

  • Excel Sumifs - SUM different columns based on selection

Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header

How to SUM Different Columns based on Header? Excel's SUMIFS function makes it easy to sum columns based on different criteria. But how can you use the SUMIFS function to not just sum based on criteria, but also sum different columns based on the column header? This video shows you how you can sum

More

Features

  • Excel array formulas

Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

You'll learn a few methods to replace the TRANSPOSE function In Part 3, I show you how you can use the INDIRECT, ROW, ADDRESS and later INDEX functions to avoid the use of TRANSPOSE which requires CSE Make sure you watch PART 1 and PART 2 before you take a peek at Part

  • Excel Array formulas - use MMULT function

Excel Arrays: Count Unique Items with MMULT Function (Part 2/3)

You'll learn all about the Amazing MMULT Function in this Lecture! In Part 2 we will create an Excel Array Formula using SUMPRODUCT and MMULT. In this lecture I will show you how you can use Excel's Matrix Multiplication formula, MMULT function to solve complex problems.  I will use the same example as

  • Learn complex array formulas in excel

8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

You'll learn 3 of them in this video! Learn Excel Array formulas by going through the example While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how I approach complex problems. I hope I managed to

More

Formulas

  • Excel array formulas

Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

You'll learn a few methods to replace the TRANSPOSE function In Part 3, I show you how you can use the INDIRECT, ROW, ADDRESS and later INDEX functions to avoid the use of TRANSPOSE which requires CSE Make sure you watch PART 1 and PART 2 before you take a peek at Part

  • Excel Array formulas - use MMULT function

Excel Arrays: Count Unique Items with MMULT Function (Part 2/3)

You'll learn all about the Amazing MMULT Function in this Lecture! In Part 2 we will create an Excel Array Formula using SUMPRODUCT and MMULT. In this lecture I will show you how you can use Excel's Matrix Multiplication formula, MMULT function to solve complex problems.  I will use the same example as

  • Learn complex array formulas in excel

8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

You'll learn 3 of them in this video! Learn Excel Array formulas by going through the example While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how I approach complex problems. I hope I managed to

More
All Tutorials