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
Microsoft is raising the price of Microsoft 365 across most Business, Enterprise and Non-Profit subscription plans worldwide, a move that affects most business users in 2026. According to Microsoft, the increases reflect the substantial number of new features (especially AI-powered tools and enhanced security) added to Microsoft 365 in recent
Microsoft 365 is introducing a new add-on tier called Microsoft 365 Copilot Business, a lower-cost, small-business friendly version of its AI assistant for organizations from one to 300 users. Copilot Business has the same core AI capabilities found in the standard Copilot license, including smart writing, data analysis, and automation
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
More than ever, users of Outlook (classic) are running into friction — even when they select it. The newest updates from Microsoft cause the email-client designated “Classic Outlook” to start New Outlook for Windows instead. What once was a stable, always-available legacy interface is increasingly disrupted, making the once-familiar Classic
AI models explained for you. Confused by all the buzz around ChatGPT, Microsoft Copilot, Google Gemini, Claude and other AI-branded tools? Who’s building the underlying models, which ones power which services, and how they differ in technology and real-world strengths. They are all part of the same general AI landscape,
Searching in Outlook for Windows (“new” Outlook) might look as simple as typing a keyword into a search bar, but there’s a surprising amount of power under the hood. The search function can comb through email subjects, message bodies, attachments, contacts, and files. To effectively search Outlook for Windows, understanding
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
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)
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
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,
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
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
