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
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
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
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
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
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
Microsoft has announced a major expansion of its AI assistant capabilities for businesses. There are Copilot features coming to most volume licence plans for no extra charge. A new “Copilot Business” bundle for small businesses. Plans will gain access to advanced features including Agent mode in Word, Excel and PowerPoint,
The latest feature from Microsoft Word — the new Word Agent — transforms how you interact with documents by letting the AI edit content directly within your document. It tackles everything from writing new docs and editing existing ones to reformatting style and structure. Our real-world tests show it’s not
If you’ve ever paused over that little horizontal line in a document and wondered whether you should use a hyphen, en-dash or em-dash, you’re not alone. In Microsoft Word there are nine distinct dash or hyphen-like characters, each with its own typographic role and keyboard shortcut. From the standard hyphen
Microsoft’s recent update to Microsoft Word introduces a bold change: new documents are now default-saved to the cloud (via OneDrive or SharePoint) with AutoSave enabled and different file naming. This shift removes the familiar local save location as the default — raising concerns around privacy, offline access and user control.
Microsoft Excel is bringing the familiar #SPILL! error to PivotTables in Microsoft 365, making it easier for users to identify blocked table areas directly within their worksheets. This update replaces traditional alerts with a dynamic #SPILL indicator whenever a PivotTable can’t expand due to filled cells, helping users troubleshoot layout
Microsoft’s new Excel Agent—part of the Copilot AI suite—is already available in Excel on the web, even before its full rollout to Windows and Mac in December 2025. This step-by-step guide explains exactly how to find and enable Excel Agent through Excel Labs, so you can start automating formulas, managing
Microsoft’s new Excel Agent brings powerful AI-driven automation to spreadsheet creation and data analysis. We’ve explored how Excel Agent helps you generate budgets, sample data, and insightful reports with simple text prompts, saving time while expanding what’s possible inside Excel. Discover where it shines (or falls short) in real-world tasks.
If you’re working in Microsoft Excel and need to test formulas, dashboards or data‐driven workflows, real data can often get in the way. Fortunately, you don’t have to wait for live data sets or scrub proprietary information—this article shows you two powerful techniques to create fake data lists quickly and
Excel users, beware, comparing text in formulas doesn’t always behave as you’d expect. While most programming languages treat text strings with upper/lower case as different, Excel doesn’t. By default, it compares text without case sensitivity, leading to potential errors in formulas and automation. Learn how to correctly use functions like
If you’ve ever wondered how to replicate the distinctive “school bus yellow” shade in your documents or slides, you’ll find the answer here. It’s the standard hue for North American school buses, chosen for visibility and impact. You can apply this same shade in Microsoft Word, Microsoft PowerPoint or any
Microsoft Word is officially retiring its “Send to Kindle” feature, ending the convenient way users could send documents straight from Word to their Kindle libraries. This marks the end of a short-lived integration but you can still put Word documents on a Kindle in other ways. Starting February 9, 2026,
Microsoft Australia is issuing refunds to some Microsoft 365 subscribers following court action over its marketing practices. While the refunds currently apply only to Australian customers, the case raises important questions about transparency and accountability for Microsoft 365 users worldwide. The move highlights growing scrutiny over how tech giants advertise
Word documents and Outlook emails can be cluttered with unnecessary emoji. Copilot AI loves adding emoji, like it or not. If you’re tired of seeing smiley faces in your reports or emails, here’s practical ways to clean them out. Learn step-by-step methods to find and remove emoji using font searches
If you’ve ever seen Microsoft Word underline a word with a cryptic “Possible Word Choice” warning, you’re not alone. This subtle feature of Microsoft Editor can confuse even seasoned users. It flags real words that might not fit the sentence’s context, often catching homophones or subtle mix-ups that spell-check misses.
Ever had a heading in Microsoft Word that seemed to wander off from its paragraph like a rebellious teenager? Or a bullet point that ghosted its follow-up text? Enter “Keep with Next” or KWN to its friends, Word’s low-key matchmaker that makes sure certain paragraphs stay together—forever (or at least
Microsoft’s subscription practices are under scrutiny in Australia as the country’s competition regulator takes the tech giant to court. The Australian Competition and Consumer Commission (ACCC) alleges that Microsoft misled approximately 2.7 million Microsoft 365 Personal and Family subscribers over how it communicated a major price increase and subscription change.
A viral post recently accused Microsoft Excel of bias for labeling the shekel as “Hebrew” instead of “Israel.” However, there’s no conspiracy—Excel lists currencies by language, not country, using the same format for all entries. Thanks to Office Watcher, Gary B. from Portland for alerting us to this bit of
Most Word users stop at page numbers and dates in their headers and footers, but Microsoft Word can do much more. From inserting document titles, authors, and file paths to using advanced field codes like StyleRef or NumPages, you can make your headers dynamic, informative, and even interactive. Discover the
