Premium Only Content

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
-
LIVE
Donald Trump Jr.
2 hours agoFrom Crypto to AI, There's a New American Energy Revival, Interviews with Asher Genoot & Sen McCormick | TRIGGERED Ep.261
17,692 watching -
BonginoReport
2 hours agoEpstein’s ‘Madam’ Maxwell Meets With the DOJ - Nightly Scroll w/ Hayley Caronia (Ep.97)
15.6K9 -
LIVE
The Jimmy Dore Show
1 hour agoBrigitte Macron Names Jimmy in Suit Against Candace Owens! Fox News Pushes PURE Israeli Propaganda!
5,634 watching -
1:50:08
Redacted News
3 hours agoBREAKING! It's starting! DOJ Strike Force Going After Obama / Hillary Criminal Cabal | Redacted
185K66 -
36:41
Stephen Gardner
2 hours ago🔥BREAKING: Trump-Epstein Saga Gets CRAZIER—Must-See New Evidence Revealed!
15.2K27 -
43:25
Michael Franzese
3 hours agoThis Is the Most Important Thing I’ll Ever Say
24.1K22 -
LIVE
Robert Gouveia
2 hours agoCongress HAMMERS Epstein Files! Maxwell APPEAL Decision! Obama Suspects LAWYER UP! 14th Amendment!
1,619 watching -
2:44:28
Barry Cunningham
4 hours agoPRESIDENT TRUMP TOURS JEROME POWELL SCENE OF THE CRIME AT THE FEDERAL RESERVE
30K10 -
1:25:14
Sarah Westall
3 hours agoBlackmail, Power & Corruption: The Currency of the Empire - Epstein & more w/ Joachim Hagopian
20.4K6 -
16:33
Clownfish TV
8 hours agoLate Night TV Has NO FUTURE After Stephen Colbert's Cancellation!
4K8