Make better Excel tables: BMW report to the test (Part 3)

Oct 26, 2017 #MsExcel
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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.

In this specific video we take a look at presenting data in Excel Tables and how we can better organize the data, headers, distance etc to create tables that are easy to read. We also take a look at using conditional formatting in our report such as data-bars to bring attention to deviations - especially the bigger changes.

An alternative approach is to use custom formatting and use symbols and color to bring attention to the positive and negative deviations.

You'll see some neat tricks here that allow you to better organize your data in tables so that attention is directed to areas that need attention most. This makes the entire report easier to read and digest.

⯆ Download the workbook here: http://www.xelplus.com/report-makeover-excel-better-excel-tables/

Link to BMW 2015 Annual report: http://bit.ly/BMWPDF2015
Link to Video 1 - Table or Chart? https://rumble.com/v2tnkxm
Link to Video 2 - Alternative to Doughnut Charts: https://rumble.com/v2tnky0
More on Custom Formatting: https://rumble.com/v2tnek0

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel