Basic Excel Business Analytics #14: Logical Formulas & Conditional Formatting to Visualizing Data

Review how to use Logical Formulas to add Conditional Formatting to Data Sets:
1) (00:11) Introduction
2) (00:33) Built-in Feature: Conditionally Format Budget Data when Actual Exceeds Budgeted Amounts.
3) (02:26) Logical Formula & Mixed Cell References to Format Row: Conditionally Format Budget Data when Actual Exceeds Budgeted Amounts:
4) (05:24) Cell Chart with Data Bars: Conditionally Format Budget Data when Actual Exceeds Budgeted Amounts:
5) (07:29) AND Function and Mixed Cell References to Conditionally Format Records that math two Criteria.

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[rodrigocustodio]

Mike is the best teacher I have seen yet he is so humble, anybody who follows Mike and reads his books or comments can see how talented and humble Mike is, read the preface or introduction to Mike's book mastering excel arrays formulas and you can see how humble he is. Mike even takes time to reply to our comments here in youtube when he is the one giving us the opportunity to become excel pro. Big thanks to you Mike!

[predatorinstincts]

I am becoming an excel pro because of you. And the best part is you are doing a service to us for Free, what is self-less human being.

[shubhampawar]

Sort of great revision of conditional formatting for me ❤️😊👌

[aamerakhan]

camera is too zoomed out.. had trouble getting the content in the cell....