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” (more…)
Such a clear question originating from the classic: “How many unique items per group“? (more…)
We’ve all done it. We’ve wasted time looking for Excel content on the web due to inefficient searches.
If you’ve been working with Excel long enough you’ll notice that some solutions work but can be dangerous and lead to problems. (more…)
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? (more…)
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….” (more…)
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. (more…)