Andrew Moss
Technical Writer & Excel Aficionado
Excel has a vast range of keyboard shortcuts, and there have been a few added to the list over the years.New ones introduced include: Open Power Query Editor: Alt +…
Excel’s border styles help us enhance the structure and readability of our worksheets. Thick, thin, dotted and dashed — there are 13 variations to choose from in the Format Cells…
Two weeks ago, the bombshell news about Python integration coming to Excel was greeted with rip-roaring excitement. The secret had been well-kept by tight-lipped Microsoft MVPs, who were finally able…
Sometimes data is perfectly shaped and structured — other times, it’s not. If you’ve used pivot tables, you’ll be familiar with the cross-tabular format, which summarises data based on two…
I’ve long been aware of the practice, but up until a few weeks ago, I didn’t have a scoobies what LinkedIn pods are.You might not either, so here’s a quick…
It’s fair to say the monitor market has been pretty stagnant for a while, but I did snap up a 40″ ultrawide monitor a week or so ago (LG 40WP95CP-W.AEK).…
Dear, oh dear. Looks like hundreds of thousands of Twitter (sorry, X) subscribers need a maths lesson. World of Statistics put out a poll a couple of days ago with…
This time last year, I posted about Microsoft’s plan to reveal a new default font to replace Calibri in Office — now known as Microsoft 365. (https://lnkd.in/eqvJdCUK)After much deliberation in…
What had long been dubbed ‘Spreadsheets in Space’ became a reality last month, as EVE Online went down in history as the first video game to get a Microsoft-backed Excel…
In Excel, it’s common practice to store percentage values as numbers under the General number format; for example, 12, 6, and 16. By only including the percent symbol (%) in…
Is Excel for the web’s calculation engine more advanced than its desktop counterpart?The other day, I identified a gaping problem with the HYPERLINK function (https://lnkd.in/eyqt39qy). After trying to return a…
Happy Summer Solstice! ☀️It’s officially the longest day of the year in the Northern Hemisphere.The UK’s summer solstice occurred at 15:57 BST, marking the point at which the astronomical summer…