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:
/ helenrmwall
Helen's LinkedIn Classes:
/ 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:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2