Premium Only Content

Can BMW improve their Report? Graph Vs. Excel Table (Part 1)
Oct 13, 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. Of course I will use Microsoft Excel for this. It's sometimes difficult to decide which visualization to use for which data sets. Specially when it comes to visualizing financial numbers in corporate reports. Sometimes it helps to test different versions - which you can easily do in Excel and then put them side by side. Or give the different versions as handouts to your team and decide which is the easiest and fastest to read.
⯆ Download the workbook here: http://www.xelplus.com/bmw-report-makeover-graph-versus-table/
View Part 2: Alternative to Donut charts https://rumble.com/v2tnky0
View Part 3: Better Excel Tables https://rumble.com/v2tujke
In this video we take a look at a specific table which compares sales volume of 2015 by Mini model with previous year's values. In addition it shows the proportion of sales volume for each Mini Model as compared to the total. There is a lot of information in the table. Could we show this better with a chart? or should we stick to a table?
Link to BMW 2015 Annual report: http://bit.ly/BMWPDF2015
★ 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
-
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
18.8K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $1.26 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
25.8K1 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
78K34 -
37:08
Standpoint with Gabe Groisman
23 hours agoDOGE The UK?! With Liz Truss
41.3K13 -
56:39
SLS - Street League Skateboarding
6 days agoHIGHEST SCORING KNOCKOUT ROUND OF ALL TIME! Felipe Gustavo, Dashawn Jordan, Filipe Mota & more...
30.6K1 -
14:26
Breaking Points
1 day agoWOKE VS BASED?: Saagar And Ryan Play A Game
31.9K6 -
5:29:58
SoundBoardLord
8 hours agoThe Red Dead Journey Continues!!!
29.2K1 -
1:17:31
The Officer Tatum
4 hours agoLIVE: Delta Airlines CRASH BLAMED On Trump, Ashley St. Claire Had Elon's BABY? + More | Ep 63
35.7K37 -
1:38:08
vivafrei
6 hours agoAOC goes Full Criminal Lover? Mehdi Hasan Goes Full Terrorist? Another Plane Crash & MORE! Viva Frei
78.1K37 -
1:52:19
Russell Brand
6 hours agoLIVE FROM MAR A LAGO: US, Russia & China to Negotiate While UK Ramps Up in Ukraine – SF539
150K53