Calculating a simple percentage increase in Excel seems simple but, as usual, there’s a traps for the unwary. Here’s a smarter and more consistent way to figure out % change. First we’ll go over some basics which you’re welcome to skip … The formula for calculating a percentage change is simple: In other words, find […]
Excel has a slightly different order of calculation to the BODMAS rule taught to us at school. Those variations are important and can give a result you didn’t expect. Ray E from Iowa asked about one of those tricky algebra questions that appear on social media and generate heated arguments -10^2 . Ray wondered how […]
Ignore the clickbait headlines and social media experts, Microsoft Word still has a Thesaurus feature. A slightly related feature has gone but Synonyms is still alive and kicking. Here’s Word’s Thesaurus or “Synonyms” still in Word 365 using Microsoft’s example word. And here’s Synonyms in Word 2024, using a more appropriate example word for this […]
Support for Office 2016 and Office 2019 will end this year. Find out when and how to upgrade to newer Office software or other cheaper options. First and most important, follow the advice of Douglas Adams (much missed) and Don’t Panic. People trying to sell you stuff will use plenty of tricks and misinformation to […]
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 make those totals, using Sum() […]
