Excel Expert Live Challenge – Helen Wall – Shifts & Overtime

Next up! Helen Wall (linkedin.com/in/helenrmwall) as the Excel Expert who’s taking on an Excel challenge that she hadn’t seen before I hit the record button.

This time: we have data about scheduled shifts and several questions need to be answered about the data.
– How many distinct people are assigned?
– How much will be paid in regular pay?
– How much in overtime?
– How many hours have specific people been scheduled for?

We get to see how Helen reviews the situation and goes forward to answer the questions. She even shifts directions. Abandoning a formula-driven solution and jumping into Power Query.

Helen Wall at LinkedIn:
https://www.linkedin.com/in/helenrmwall/
Helen’s LinkedIn Classes:
https://www.linkedin.com/learning/instructors/helen-wall
0:00 Intro
5:59 The Challenge
17:13 Changing Directions – Power Query
41:20 Discussion of the solution
42:46 Outro

For a list of my Excel courses at 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