Profile cover photo
Profile photo
Bill Jelen
1,253 followers -
MrExcel
MrExcel

1,253 followers
About
Posts

Post has attachment
Free e-Book! Many examples of the new Excel Array Functions. 57-pages. Free this week only. No catch, just download and learn how these functions are a game-changer. https://www.mrexcel.com/download-center/books/2018/ExcelDynamicArraysStraightToThePoint.pdf
Photo
Add a comment...

Post has attachment
Do you create beautiful formatted comments in Excel? Build 1809 will let your co-workers destroy your work in a flash. It does not have to be this way. Here is my song about it: I am a horrible singer, but this new #Excel threaded comment debacle forced me to write a song. #JustSayNo #DoNotConvertComments https://youtu.be/3Pgf5FVNPWs?t=10m33s
Photo
Add a comment...

Post has attachment
I was just about to finish my new Excel 2019 Inside Out book when Microsoft released a brand new Forms feature. This is great for collecting surveys in Excel.
Add a comment...

Post has attachment
Prevent custom sort in #Excel pivot tables (video)
Add a comment...

Post has attachment
Inserting rows with alternating color in #Excel like old #Greenbar paper (video)
Add a comment...

Post has attachment
#Excel - If VLOOKUP fails, move to a backup lookup table (video)
Add a comment...

Post has attachment
Teach #Excel to always insert N decimal places to numbers you type (video)
Add a comment...

Post has attachment
#Excel replace spaces with empty cells (video)
Add a comment...

Post has attachment
Return all VLOOKUP matches, adding rows as needed #Excel #PowerQuery (video)
Add a comment...

Post has attachment
Truncate Date+Time to Date so your pivot tables report by day. #PowerQuery #Excel (video)
Add a comment...
Wait while more posts are being loaded