I visit many different Excel blogs. Every once in a while I learn something completely new that really boggles my mind! And in this case the Chess world overlaps the Excel world so it was REALLY amazing (and nerdy)! How do I start to explain how awesome this is? Continue reading
Post Category → Gurus
Video 00161 Extract Matrix Non Blanks Into 1 Column
Have you ever visited excelxor.com ? It’s an amazing blog with a lot of Excel formula challenges. Here’s one challenge: “given the the 6-by-4 array on the left we may wish to create the single-column on the right” Continue reading
Liam Bastick from sumproduct.com
I recently presented at ModelOff’s Global Training Camp in Toronto. One of the many great things about the training camp was that I had the pleasure of meeting Excel guru Liam Bastick. Continue reading
How Many Unique Visitors To Site Each Day?
Such a clear question originating from the classic: “How many unique items per group“? Continue reading
BradEdgar_8 Search Techniques to Find Best Excel Content
We’ve all done it. We’ve wasted time looking for Excel content on the web due to inefficient searches.
Index of Ignorance
I did a quiz on The Guardian’s website called “How well do you really know your country?” The pic I saw after the quiz reminded me of Excel’s INDEX function. Yes, I see Excel function names everywhere I go! Continue reading
IFERROR post from www.MBAexcel.com
If you’ve been working with Excel long enough you’ll notice that some solutions work but can be dangerous and lead to problems. Continue reading
Trump Excel: Get the List of File Names from a Folder in Excel
When you want to get a list of Excel file names from a folder and display it in an Excel sheet most people would think about using VBA (Excel’s programming language). But what if you don’t know VBA? Continue reading
My Favorite Excel Tips From Other Sites Part 2.
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
My Favorite Excel Tips From Other Sites Part 1.
I work full time as a Data Analyst currently specializing in Microsoft Excel and Microsoft Access. To keep up to date I watch a fair amount of YouTube videos and follow several websites. Continue reading