Profile cover photo
Profile photo
Kevin Lehrbass
66 followers -
https://www.myspreadsheetlab.com/blog/
https://www.myspreadsheetlab.com/blog/

66 followers
About
Posts

Post has attachment
Add a comment...

Post has attachment
Non normalized data disaster. There's a consistent pattern so there's hope!
POST: https://www.myspreadsheetlab.com/data-disaster-non-normalized-data-in-excel/ VIDEO: https://youtu.be/BIfGWM9lauk +excel is fun +Excel On Fire Next is my Get & Transform solution!
Add a comment...

Post has shared content
Excel's Power Query (Get & Transform) and beer!!
Yesterday I was working on a data set, and needed to work out the Top x with Ties in Power Query.  This posed to be a bit more challenging that I first thought it would be. Why did I want Top x With Ties? Let’s take a look at the source data here, on a ……
Add a comment...

Post has attachment
The best post about Excel's custom number formats that I've ever seen! +My Online Training Hub +Mynda Treacy
Add a comment...

Post has attachment
See how to easily create a weighted random data-set.
Add a comment...

Add a comment...

Post has attachment
Are you wasting time endlessly scrolling an Excel data validation list? Here are some solutions https://youtu.be/8-MpnD_MDeM
Add a comment...

Post has attachment
Unstack data challenge with Oz du Soleil and Mike Girvin!
Add a comment...

Post has shared content
Learn Microsoft Excel array formulas!
Blue Cover (3rd Printing) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book at mrexcel.com
Add a comment...

Post has attachment
Fun creating more solutions for Mike Girvin's challenge. https://youtu.be/gL0ony5zpK0
Add a comment...
Wait while more posts are being loaded