Understanding Standard Deviation isn’t hard, especially with Excel’s help. This quick guide shows the difference between sample and population functions so you can choose the right one and get accurate, informative results every time. Standard Deviation in Excel The standard deviation measures the variation from the average or mean of a
In Excel there are various ways to either protect sheets or cells from access, make a them read-only or totally encrypt the workbook with a strong password. It’s important to understand the difference in Excel between Protect and the stronger Encrypt feature. Excel’s password protection is more complicated than in
How did we make a Word table with a picture background for a recent article – asks an Office Watch friend? She meant this table of Zoom shortcuts for toggling audio and video . There’s a similar table for Teams shortcuts. The quick answer is … we cheated! Word can’t
Create awesome retro, classic or original WordArt in Microsoft Word 365, Word 2024 and earlier version. It’s simple, just follow these steps. At the time, WordArt was a big step for Microsoft Word. It was a quick way to add fancy text, not possible before. Alas, like many Office design
Everyone knows that Word checks your spelling with red underlines but do you know everything that’s possible in the spell check menus. Simply click the underlined word to view suggested corrections. Choose the right option, and Word will replace it instantly. So far, so easy. More choices below the suggestions
The BBC has published a good history of the famous “Keep Calm and Carry On” poster from World War 2 but missed what, to us, is the most important 21st Century innovation. When “Keep Calm and Carry On” first became popular, we saw the opportunity to showcase what Word and
If you’re wondering why a contacts address change in Outlook doesn’t stick, you’re not alone—many Outlook users face this frustrating issue. There are three possible reasons starting with a little known quirk in how Outlook saves email addresses. An Office Watch reader asks why Outlook keeps remembering an old email
Transform how you format Word documents with keyboard shortcuts—going beyond the built‑in ones for Headings 1–3 by adding your own for Heading 4, 5, 6 (and beyond) that Microsoft has forgotten. With these simple tweaks, your document structuring becomes faster and more consistent. Word’s in-built Heading styles come with some shortcut keys, but
Microsoft is retiring the Reuse Slides feature, however you can still copy slides manually—and it’s simple. Whether you’re preparing for a meeting, a lecture, or a project presentation, knowing how to quickly and efficiently move or copy slides between presentations can save you both time and hassle. To get started,
When will your version of Microsoft Office stop getting security bug and software bug fixes, what Microsoft calls the “end of support“. This is important because software updates are necessary for Office apps. Mainly because outdated versions are more vulnerable to hackers, particularly in the case of opening malicious emails,
Down in Australia there’s another example of a mistake when redacting a Word document before public release. Make sure you delete any links to redacted text, such as a Table of Contents or summary. What caught our eye was the latest example of an oversight when redacting a document. Aussie
Transform your next presentation by mastering five powerful ways to add images in PowerPoint. Whether you’re embedding visuals directly from the web, creating photo albums, leveraging SmartArt, or using Copilot enhancements, these expert tips will streamline slide preparation. On a PowerPoint slide with a picture placeholder, just click the image
Add the US National flag “Old Glory” “The red, white and blue” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a different source or our articles about
Still using .doc, .xls, or .ppt files? These outdated Microsoft Office formats are not just relics—they’re major security risks and should be banned. Hackers exploit these older files to spread malware, ransomware, and steal data, as they often bypass modern antivirus protections. After our suggestion to ignore old style Office
RTF files may seem safe, but they can carry hidden risks. Hackers use RTFs to exploit Microsoft Word and even infect systems through email previews. Learn why RTF isn’t as harmless as it looks—and how to stay protected. The confusion is understandable. After all .RTF (Rich Text Format) files aren’t
Struggling with a sea of worksheet tabs at the bottom of your Excel window? Whether you’re managing dozens of tabs or juggling shared workbooks with tight screen space, discover how to fit more visible tabs across your Excel workbook can transform your workflow. In this guide, we walk through both
OneNote offers an electronic equivalent to the ‘sticky note’ or side-note. Most OneNote demos show off the full-size pages with a full range of feature but Quick Notes is the smaller and faster part of OneNote for Windows. Let’s explore how to make a Quick Note, what they can do
Our annual look at the words that challenged the Scripps Spelling Bee champs to see how many are recognized by the spell check in Microsoft Word. Again in 2025 Word was beaten by some very clever 14 year olds. Here’s a selection of the last round words from the 2025
Whether you’re managing schedules, tracking deadlines, or analyzing time-based data, comparing dates in Excel is a critical skill. This guide walks you through how to use the powerful IF function to compare dates—such as determining if one date is before, after, or equal to another. Learn essential Excel formulas that
Be careful comparing text in Excel because it looks easy but there are traps when comparing exact text (including upper/lower case) or not. Whether you’re cleaning data or ensuring accuracy in sensitive fields like usernames or product codes, we’ll help you get the results you need every time. Case-insensitive IF
In Excel there are various options for making sure a text label singular (e.g. person) or plural (people) matches the quantity. There’s the standard answer (IF() functions) or clever cell formatting tricks. For example if the cell has 1 item you want the singular label: 1 cookie But if the
There’s a little trap in Excel when figuring out the number of days between two dates. Excel has one way, but the real world has two others. It’s easy to forget the differences and it can matter when the date calculation is close to some limit, for example in a
Importing text files into Excel can sometimes lead to unexpected data conversions—like turning product codes into dates or trimming leading zeros from IDs. To avoid these issues, Excel’s Get & Transform feature (also known as Power Query) offers a more reliable method for importing text data. You can ensure your
Google offers a great variety of free open-source fonts that can be used in Microsoft Office, Windows or Mac. You just need to know the right trick to access them for Word, Excel or PowerPoint. Over 1,800 Google Font families There are 877 1,816 Google Font families currently available at
