Microsoft has quietly delivered another round of security updates for Office 2016, even thought the software officially ended support two months ago. These patches focus on critical vulnerabilities that could still affect businesses and individuals running this older version of Microsoft Office. Here’s what’s been fixed and how to get
Learn how to create high-quality PDF files from Microsoft Office documents using the two main methods: Save As/Export and Print to PDF. This guide compares both approaches so you can choose the best one for your needs. Whether you want clickable hyperlinks, bookmarks, backgrounds, or a simple fixed layout PDF
Learn how to use Excel’s powerful SWITCH function, the modern alternative to nested IF statements. The SWITCH function evaluates a value against multiple matched outcomes and returns the first corresponding result, plus an optional default if nothing matches. Our guide breaks down the format, best usage patterns and practical examples
Pantone’s color of the year for 2026 is “Cloud Dancer”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the right Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2026 is …
In a move reversing a 2023 policy, the U.S. State Department has officially returned to using Times New Roman font for its communications, ending the brief tenure of Calibri. Why choose one font over another? Times New Roman vs Calibri – the pros and cons of each font. The US
Type the Left arrow ← into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Leftward Arrow” ← but it can be called ‘Left pointing’ ‘Left facing’ or just ‘Left Arrow’ See also Right arrow → symbol in Word, Excel,
If your Microsoft Excel workbook uses dynamic arrays, you might have run into a common frustration: adding a heading or a total below (or above) the spilled list often triggers a #SPILL! error or leaves awkward gaps when the list expands/contracts. It’s easy to “stack” your dynamic array with extra
Users of the new Outlook for Windows are running into a frustrating bug: certain Microsoft Excel attachments simply won’t open — instead, they trigger the vague error message: “Try opening the file again later.”. Here’s how to bypass the bug. Some users are finding themselves locked out of Excel attachments
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)
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
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
Tired of endless nested IF statements in Excel? The CHOOSE function offers a cleaner, smarter way to pick from multiple options using a single, simple formula. Learn how to replace complex conditional logic with CHOOSE(), streamline your spreadsheets, and make your formulas easier to read, maintain, and debug. Choose() an
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
Microsoft’s Copilot is NOT the wildly popular, world class AI product that Microsoft says it is. That’s not just an opinion; there are hard facts to back it up. The recent sharp price drop and ignored user frustration suggest otherwise. From intrusive integration to privacy concerns, Copilot’s rollout has backfired.
Your trusty Office 2016 or 2019 has lost official Microsoft support. There’s a smart, affordable way to keep your ‘vintage’ Office software secure and running smoothly after October 2025. Zero-day micropatching can protect you from new security threats, extend the life of your software and help you avoid costly upgrades.
Microsoft’s new Copilot() function in Excel comes with real risks. When used incorrectly, Copilot() can produce misleading or nonsensical results that could compromise data accuracy and decision-making. Treat this AI feature with caution and Microsoft should add stronger safeguards and clearer warnings against misuse. It all started with this post
Want to show only the year, month, or day from an Excel date? We explain how to use the TEXT(), YEAR(), MONTH(), and DAY() functions or cell formatting to display or calculate date details efficiently. Learn when to use each method, which is fastest, and how your choice affects Excel
Microsoft is testing new Office icons for Word, Excel, and PowerPoint that drop their signature “W,” “E,” and “P” letters. The minimalist redesign, currently seen in iPhone preview apps, aims for simplicity but sacrifices instant visual recognition. Without letters, the icons blend into a sea of app symbols, making it
