Beyond Excel: People Processes & Tools (and XLOOKUP)

/in /by

A lot of times what we face in the real world with data and Excel:
The Excel solution is easy but the situation is complicated

In this video I discuss the importance of People, Processes and Tools. Excel is only a tool. And a tool won’t save a situation if the process is janky (or there is no process, or the person is janky.

In this case, an XLOOKUP needed to be added to modify an existing process. But it took a long time to think through.

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.

#XLOOKUP

 Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

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