If you want to know how to Add more OneDrive storage to Microsoft 365, the process is straightforward and can greatly enhance your productivity. You now have the option to expand, for a price. Microsoft 365 Personal or Family customers can buy more cloud storage: 200 GB, 1 TB, 5 TB or even 10 TB, […]
Looking for the perfect holiday emoji for your document, slide or email? This quick-and-easy list from Office Watch offers a searchable collection of Thanksgiving-themed symbols that work across Windows, macOS, iPhone and Android. These emoji are supported (with different looks) on Windows, iPhone, iPad and Android devices. Unicode value (hex) The Unicode value column lets […]
Planning a Thanksgiving themed email, presentation or document? This article shows how to take full advantage of the image, icon and emoji libraries built into Microsoft 365, Office 2024/2021/2019 to quickly add festive visuals—whether you search for “Thanksgiving”, pumpkins, autumn leaves or turkeys. It also covers using online pictures, AI-generated graphics and even fun Thanksgiving […]
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 […]