Here’s two ways to make a running total column in Excel. The way you were probably taught and a much better and more flexible choice. Running or Accumulative Totals are a very common thing in spreadsheets. Here’s a really simple example in columns C and E. Here’s two ways to
All your choices for deleting or hiding comments in Word documents. An essential step before sending a document out. Comments in a Word document are really great for making side-notes or even discussions between people working on a shared document. It’s also great for adding your own notes to a
Checklist when your version of Microsoft Office will 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
How to prevent Microsoft from pushing a change from classic Outlook for Windows to their new and incomplete Outlook (new). Microsoft is pushing customers to use Outlook (new) even though the software doesn’t have basic features like proper offline support or interactions between mailboxes. New Outlook also has a serious
Microsoft 365 Family and Personal plans are getting Copilot AI integration into their Office apps but it comes with a big price increase and many limits to what people get for the extra cost. Customers in Australia, New Zealand, Malaysia, Singapore, Taiwan, and Thailand have seen massive prices rises in
Microsoft is ending their Publisher desktop publishing product completely. Here’s the vital details you need to know, including how to keep your Publisher software after the end date. Publisher is Microsoft’s desktop publishing software that’s been available since 1991 mostly as part of some Microsoft Office bundles but also sold
Once upon a time there was just one ‘Microsoft Outlook‘ but these days there are at least eleven current programs or services under the ‘Outlook’ name * and two programs called “Outlook for Windows”. That’s before counting past versions that are still supported. You’re totally excused for being confused because
Word field codes let you add automation or automatic content into documents. A simple example is the { DATE } field, which inserts the current date into a letter but there’s a lot more possible. Chances are good that you’ve already used field codes and not realised it. Date, PrintDate,
Microsoft Word’s English dictionaries can be confusing because they don’t always mark incorrect spelling differences between US and UK English (like color/colour). We did some tests with surprising results. English spellings can get screwy as you move between countries and there’s a lot more overlap than many people realize or
Excel 365 is getting new functions that bring the power of Regular Expressions (RegEx) into spreadsheets. It’s HUGE news and a big step forward for Excel. We’ve spent some time trying out the new functions and we’re genuinely excited by the possibilities. Unfortunately, almost six months have passed since the
How and why to remove words from the main Microsoft Word dictionary. The Office Exclusion List ensures a red squiggly underline appears to warn you about an unwanted word. Sometimes the supplied Office dictionary has words you don’t want or you’d like a warning about. Here’s how to put the
The new Outlook for Windows has a safety setting that might stop you seeing images in emails and is another privacy breach by Microsoft to snoop at customers data. It’s buried deep in the software and turned on automatically. Deep in the Settings for Outlook (new) is a way to
The many different Microsoft Outlook versions have a way to block images linked to emails, that includes the so-called ‘spy pixels’ used by many companies. See ‘Spy Pixels’ email epidemic, the good and the bad You can choose to view pictures in an Outlook email by clicking a button at
2025 is a special number, as various social media posts have pointed out. It can be calculated in some interesting ways like (20 + 25)2 = 2025. Naturally we had to convert these into Excel formulas. 2025 is 45 squared, in other words, a ”perfect square”. This last happened in
Let’s take a deeper look at the latest announcement about the change to a new Outlook for Windows “Outlook (new)”. What it says, what Microsoft does NOT say and a close look at the much quoted ‘2029’ date. Here’s a few things that occur to us after carefully noting what’s
Here’s how to find out what type of Microsoft Office licence you have; Subscription, Retail, Volume or OEM and other hidden details of your Office license. For perpetual non-subscription versions of Office like Office 2024, Office 2021 or Office 2019, it’s important to know if your purchase is Retail/Volume or
Outlook (new) for Windows doesn’t support Mail Merge from Word. Just one of the many limitations of that software which is still a work in progress. We’ve heard from a few people that Microsoft has ‘dropped’ mail merge from Word but that’s not true. Word’s Mail Merge has been there for decades
Some last minutes Christmas tips to make personal gift tags, unique for the receiver (especially kids) using avatars or stickers, Plus coloring in pages to keep the littlies occupied. Avatars Put an avatar of the receiver on their Christmas gifts as personal gift cards. Go to the Avatar page on
Microsoft 365 Family and Personal users have a chance to beat the price rise widely expected to come in 2025. You can lock in the current price for up to five years. Why the expected price increase for Microsoft 365? Microsoft has already raised the price of Microsoft 365 in
Excel 365 is getting (at last) a clear warning that some cells have not been recalculated aka a ‘stale cell’ with the addition of a ‘Format Stale Values’ option. This feature only applies if you’re using partial or manual calculation modes. Most of us use the default Automatic mode where
The change from Outlook ‘classic’ to ‘new’ is confusing enough without misinformation about when the change is happening. The current Outlook for Windows is not ‘dying’ in 2026, no matter what you’ve heard. Classic Outlook for Windows does have a “death date” but that’s in 2029 – about five years
If Word doesn’t recognize personal words such as your name, the name of your hometown or the name of your favorite actor, it flags it as a mistake with the familiar red squiggly line. Here’s how to fix that. You can choose to add your words to the app’s custom
Modern Excel lets you make a whole monthly calendar from just one cell formula. We’ll explain how it’s done with a sample workbook for our supporters. At its simplest, Excel can make a single month like this from a formula in cell A6 which fills all the cells with the
Skype has stopped their Skype Credits service which is bad news for Microsoft 365 consumers who took advantage of their monthly 60 minutes of free calls to worldwide phones. Without notice, Microsoft stopped both Skype Credits and Skype Numbers (incoming phone numbers to your Skype account). What’s now appearing at
