Profile cover photo
Profile photo
Excel On Fire (Oz du Soleil)
800 followers -
Mission: rid the world of crap data and the unnecessary misery caused by crap data
Mission: rid the world of crap data and the unnecessary misery caused by crap data

800 followers
About
Posts

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Power Query! Custom Function!
I show how to create a custom function to simplify the small, ongoing, pesky task of converting state abbreviations into state names.

#powerquery #powerquerycustomfunction #excelonfire

https://youtu.be/NYbNeNl6eAk

Post has attachment
Add a comment...

Post has attachment

Post has attachment

Post has attachment
This conversation over VLOOKUP vs. INDEX/MATCH needs to die. Results speak for themselves. Use whatever you can effectively use, and be guided by the people who have to live with the consequences.

https://www.linkedin.com/pulse/giving-damn-more-important-than-vlookup-indexmatch-oz-du-soleil?lipi=urn%3Ali%3Apage%3Ad_flagship3_detail_base%3BG92bxar9T02tR6pZGaN2uw%3D%3D
Add a comment...
Wait while more posts are being loaded