Excel Tables: Use Smart Conditional Formatting for great table layout
Mar 2, 2017 Excel Charts
This is part of my Advanced Online Data Visualization Course: https://courses.xelplus.com/
In this lecture you will learn how you can use conditional formatting smartly to highlight negative and positive differences based on a threshold. The method used here is one of my favorite conditional formatting methods in Excel.
This way you can improve readability of your Excel tables that are used for corporate reporting.
★ 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
-
2:12
Excel Plus Studio
1 year agoTHE AWESOME FEATURES OF CONDITIONAL FORMATTING IN EXCEL
15 -
5:49
The Excel Zone
1 year ago8 AMAZING BENEFITS OF USING EXCEL TABLE
150 -
3:36
Hilarity133
1 year agoExcel Tips: Conditional Formatting in Excel / Enhanced Data Analysis
10 -
2:14:21
Excel For Freelancers
11 months ago $0.02 earnedHow To Transform Boring Excel Tables Into Beautiful Views Like The Pro’s [FREE TEMPLATE]
105 -
1:31
Andrew Magee
1 year agoHow To Automatically Highlight Rows In Excel
81 -
15:42
Dashing Аxe
1 year agoMaking A Smart Table / DIY
2 -
5:24
RahimZulfiqarAli
1 year ago6 Awesome Conditional Formatting Tips & Tricks in Microsoft Excel
2 -
4:47
Nerdalific
1 year agoMS EXCEL Tutorial / Conditional Formatting / Cells That Contain...
-
47:44
RahimZulfiqarAli
1 year agoAdvanced Pivot Table Tips and Tricks in Microsoft Excel
7 -
0:06
MattSahlfeld
1 year agoRegular Handle Table Rows