Excel Expert Challenge with Wyn Hopkins of @AccessAnalytic : Votes and Data Quality

Another Excel Expert Challenge! This time Wyn Hopkins of @AccessAnalytic stepped up to take on a challenge determining the top 4 color choices that were voted on. In this challenge Wyn had to make decisions about handling votes that didn’t fit the rules, and had quality issues.

These challenges are a way to show how other people think and work. Watch and listen as Wyn makes the decision to change directions with his solution.

You’ll see COUNTIFS, Power Query, Conditional Formatting and lots of other Excel features woven together for a solid solution.

#excelchallenge
#AccessAnalytic #Power Query

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2