Managing Accuracy and Errant Entries with SUMIFS and Conditional Formatting

/in /by

This video pulls together a number of Excel features in order to get an accurate inventory number.

This is based on a real life situation where an organizations data was messy because they weren’t adding numbers properly or managing errant entries.

This video shows how to use SUMIFS, a dropdown list and Excel’s Conditional Formatting to ensure that inputs and outputs are accurate.

#SUMIFS
#ExcelErrors
#ConditionalFormatting

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2