Andrew Moss
Excel Aficionado
Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to…
Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are…
If you have a set of dates, you might also want their week numbers. These can be returned using the WEEKNUM or ISOWEEKNUM functions. What is the difference though? Function…
You might refer to the characters in a password or the digits on a padlock as a combination. Strictly speaking, this isn’t true though, as the position of each letter,…
Apple loves to bang on about creating seamless and synergistic experiences. After all, Steve Jobs used to trot out the phrase “It just works” to describe any new product or…
Images have never been something Medium has handled well. I posted about this a year ago in an article called Medium has an Image Problem. Back then, my gripe was…
Introducing RANDUNIQUE — for when you want to return an array of unique random numbers. Three weeks ago, I showed a couple of methods of how to do this with…
Previously, I showed you how to use the SCAN function to calculate the running total with a single formula (). However, given only Office Insiders can access it right now,…
Excel functions like XLOOKUP and MATCH lack the ability to look up values in multiple rows or columns. However, this problem is circumvented with the help of MMULT, which returns…
Yesterday, I covered the new BYCOL function, which allows you to perform calculations on columns in an array. Guess what? There’s also a BYROW function! Predictably, it does the same…
The new BYCOL function is currently only available to Office Insiders, but it promises to make calculating columns easier and more efficient. The Sales by Month table contains monthly sales…
A running total is the summation of the current and previous numbers in a column. It’s a useful way of keeping track of sales figures over a time period or…