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
FreshandFit
9 hours agoShannon Sharpe Fired By ESPN! W or L?
14,273 watching -
2:18:29
Badlands Media
11 hours agoDevolution Power Hour Ep. 376: Optics, Explosions & the War for the Narrative
124K31 -
37:46
Stephen Gardner
9 hours ago🔥Trump NEVER expected THIS WIN as Schumer has EPIC MELTDOWN!
24.1K32 -
2:02:41
Inverted World Live
5 hours agoNASA Engineer Says Trillions of Shape-Shifting, Cloaked Devices are Hidden on Earth| Ep. 83
22.4K8 -
3:12:37
TimcastIRL
6 hours agoGOP Councilman DOUSED IN GAS, Set ON FIRE In Virginia, Suspect In Custody | Timcast IRL
227K80 -
2:32:23
The Quartering
5 hours agoOn To The Big Bosses! Act 2 Of Expedition 33
50.8K4 -
DVR
SpartakusLIVE
7 hours agoTiger Blood RESTOCKED and 30% off w/ code SPARTAKUS30
73.7K -
24:58
Law&Crime
8 hours ago $1.60 earnedSecond Note Leaves Disturbing Clues in New York City Killings
28.3K9 -
1:36:57
Badlands Media
23 hours agoAltered State S3 Ep. 39: Earthquakes, Energy Games & the Fall of the Narrative
62.8K13 -
2:04:07
Due Dissidence
13 hours agoCharlie Kirk's GAZA LIES, Caitlin Clark Stalker, Palantir Goes Hollywood - w/ Kyle Matovcik | TMWS
33.3K8