Charts
Dashboards
Features
Formulas

Charts

  • Excel Create Better Tables

BMW Corporate Report Makeover in Excel: Better Tables in Reports

Part 3 of our step-by-step guide: Corporate Report Makeover CHAPTER 3: Better Tables in Reports In this last part of the BMW report case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve the presentation

  • Alternative for Doughnut (Donut) charts

Corporate Report Makeover: Alternative for Doughnut Charts

Part 2 of our step-by-step guide: Corporate Report Makeover CHAPTER 2: Alternative to Doughnut Charts Doughnut or Bar Chart? In the 2nd part of our corporate report makeover in Excel, I'll show you a better alternative to Doughnut (Donut) charts in Excel. Click here for

  • Graph versus Tables

BMW Corporate Report Makeover in Excel: Graph Versus Table (Part 1)

Part 1 of our step-by-step guide: Corporate Report Makeover CHAPTER 1: Graph Versus Table Excel Table or Chart - Which is Better? In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on

More

Dashboards

Excel Dependent Drop Down List with Tabular Data

How do you handle dynamic data validation lists that refer to parts of your table only?  In this example we have a tabular data set. On one side we have the Division and the next column we have the list of companies that belong to the division. Instead of having the contents of

  • 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

  • How to use symbols in Excel Pivot Slicer

Symbols in Pivot Slicers

A neat pivot slicer trick Symbols in Pivot Slicers Give your report a customized look by replacing text with symbols in your Pivot Slicers. Obviously you can't do that with every Pivot Table filter, but replacing text with symbols whenever it makes sense is actually effective in improving the readability of

More

Features

  • 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

  • excel change default theme color report dashboard

How to Set a Default Theme in Excel

Set your default Excel theme to the theme of your choice. How to Set a Default Theme in Excel When you create a new Excel workbook, you'll notice that it always reverts to the Office theme color by default.   However, in some cases, you might have a set of defined theme colors that you want to use every

More

Formulas

  • Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets in Excel

In this tutorial I show you how to lookup values from multiple Excel Sheets or tabs. In Excel it's relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using just one single formula? In this tutorial I show you different versions of getting this

Complex Lookup: Find Header

Find Header based on Lookup Criteria in Matrix (Unique matrix values) - scroll down for non-unique method  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

Lookup multiple criteria in rows or columns

The Complete Guide to INDEX & MATCH CHAPTER 2: Lookup multiple criteria in rows or columns Some reports involve the need to find a value from a source table using multiple criteria in rows and columns. In this example, we have a table containing both the actual and budget revenues and

More
All Tutorials
Share This