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 […]
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 […]
