BMW Corporate Report Makeover in Excel: Better Tables in Reports

How could BMW improve the presentation of their tables in their 2015 annual report? Take a look at some suggestions for better presenting data in tables in this tutorial.

Corporate Report Makeover: Alternative for Excel Doughnut Charts

Doughnut charts get a bad reputation, but they are still used in corporate reports. In this tutorial, we offer a better alternative. A bar chart with automatic sorting will tell the story in one glance. Learn, how to set it up.

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

In this case study we take a look at the 2015 Annual Report from BMW and look at ways we could improve on some of the tables and graphs used in the report. When comparing sales volume difference year over year, a cleverly formatted bar chart will be much more effective in telling the story than a simple table.

Excel – Use Symbols in Pivot Slicers

Learn how you can use symbols instead of text in your Pivot slicers to create visually effective Excel dashboard reports.

Excel Solver – Example and Step-by-Step Explanation

Quickly find out where you can find Excel’s Solver tool and how you can use it to solve for the optimal solution to your problem. It’s sometimes seen as an Advanced Goal Seek.

Excel Goal Seek Explained in Simple Steps

Goal Seek is part of the What-If Analysis tools, which you’ll find in Excel’s Data tab. It allows you to find the values necessary to achieve a target. Learn all about it in this tutorial.

How to Change Theme Colors in Excel

Learn how to customize the Excel theme and make it the default by saving it the Excel Start folder.

Skip Dates in Excel Charts

Learn a simple method to deal with gaps in your data, specifically missing dates. You don’t want to display them in a chart, but Excel treats a date axis as continuous and will try to connect the line.

Excel Complex Lookup: Find Header

In this tutorial we tackle a complex lookup problem – how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

Smart Uses of Custom Formatting in Excel

Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. Learn how to use it, how to add color-coded up/down errors and percentage deviations.

Smart Uses of Custom Formatting in Excel – Part 2

Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. In part 2, learn how to add any symbol to custom number format, how to use up/down arrows for percentage variances, and how custom formatting works with thresholds and icons.

INDEX MATCH Multiple Criteria in Rows or Columns

Learn how to perform a matrix lookup, i.e. when you need to return the value based on the header row and the category column, in a scenario where you have more than one header. The powerful INDEX/MATCH combo is capable of handling that a couple of ways.

Previous
1 25 26 27 28 29 31
Next

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill