Excel-related articles.
Earlier today, I caught up with the latest episode of Unpivot. Host Wyn Hopkins introduced a new feature called ‘Worth a follow’, and I was delighted to be Mark Proctor‘s choice. He said I’m one of his “favourite social media…
Since IMPORTTEXT and IMPORTCSV were announced earlier this month, I’ve seen a few people asking the same question: What’s the point of these functions when we already have Power Query? I think that question misses something important. Excel isn’t one…
If you ever get disoriented in the worksheet grid, Focus Cell makes it much easier to stay on track. It highlights the active cell’s row and column so you can edit and input with greater assurance you’re in the right…
If you’re stress-testing a worksheet, running a simulation, or building a financial model, generating random numbers is a great way to explore different scenarios. Watch the video Here are three ways: Example 1 Example 2 Example 3
If you’re handling schedules, managing tasks, or reviewing financial data, highlighting today’s date, the current workweek, and the upcoming weekend makes everything easier to track. Assuming your dates are in A2:A31 and today’s date is in C2, carry out the…
Happy birthday to Excel! Check out my video reflecting on its beginnings and the path that led to where it is today. Watch the video Transcript Microsoft Excel is 40! That’s right. It was on 30th September 1985 when the…
End of content
End of content
