Using Conditional Formatting to Detect Fraud In Excel

If you like this video, enroll now to receive UNLIMITED LIFETIME ACCESS to more than 800+ videos, 1,500+ downloadable files, certificate of completion, and unlimited access to ALL future content.

As Microsoft Excel releases new functions and formulas, you will automatically receive access to the videos, so you won't need to purchase multiple courses to get new updates/features.

Harvard asked him to create their course and Microsoft asked him to write their book. In this video, Dr. Winston discusses how to use Excel to detect fraud using Conditional Formatting. The Rules options in Conditional Formatting make it easy to spot duplicate values, suspicious values, and suspicious dates.

If you like this video, it comes from his Excel 2019 book, you can get it here:

Follow us on social media:

To follow along to this video with the file, you can download the file here:

*Some of the links and other products that appear on this video are from companies which we will earn an affiliate commission or referral bonus.

*Dr. Winston created the course for Harvard, but is not affiliated with the university.

#EXCEL #MICROSOFTEXCEL #MICROSOFTOFFICE #EXCEL2019 #OFFICE365 #ANALYTICS #EXCELTIPS #EXCELTRICKS #EXCELHACKS #TOPEXCELTIPS #BI #DATA #BIGDATA #DATAANALYSIS #EXCELTUTORIAL #MICROSOFTEXCELTUTORIAL #TIMESAVINGEXCELTIPS #CONDITIONALFORMATTING #HIGHLIGHTDATA #DATABARS #COLORSCALES #ICONSETS #MICROSOFT_EXCEL #MICROSOFT_OFFICE #EXCEL_2019 #OFFICE_365 #EXCEL_TIPS #EXCEL_TRICKS #EXCEL_HACKS #TOP_EXCEL_TIPS #BIG_DATA #DATA_ANALYSIS #EXCEL_TUTORIAL #MICROSOFT_EXCEL_TUTORIAL #TIME_SAVING_EXCEL_TIPS