Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
If you’re working in Microsoft Excel and want a drop-down list from a dynamic array you have to use a workaround because the direct method for fixed arrays doesn’t work for dynamic arrays. Here’s the simple workaround to use a dynamic array function to generate a list of unique values from a data table, and […]
Unleash the full potential of Excel’s GROUPBY() function, the game-changer for summarising data in Microsoft Excel. While GROUPBY() seems simple at first glance, clever combinations with other functions open up advanced capabilities: multi-level grouping with automatic subtotals, creating multiple summaries in one formula, custom headings, and even pulling results into other parts of your workbook […]
Unlock a powerful way to condense and summarise your tables in Microsoft Excel: the GroupBy() function. With just three parameters, what to group, what to summarise and how to combine, you can create dynamic tables that instantly calculate sums, averages, counts, medians and even custom LAMBDA definitions. Both Groupby() and PivotBy() are in Excel 365 […]
Want to make your document look polished by having an image neatly enveloped by text? In this quick tutorial, you’ll learn how to insert a picture into Microsoft Word and apply proper text-wrapping so it can sit on the left, right, center or anywhere – and stay there. Let your text flow around a graphic […]
After a frustrating week of waiting, users of Microsoft 365 finally received relief when the company patched a critical installation bug that had been affecting both home and business clients. The issue, which caused installs to stall or fail entirely, has now, finally, been addressed by Microsoft allowing users to proceed with installations and updates […]
