Make Microsoft Office a Progressive Web App or PWA
Microsoft Office (plus Word, Excel and PowerPoint) can be installed as a standalone web apps or PWA. We’ll explain how Read More
Microsoft Excel
What Office users need to know about the new Windows 10X
Windows 10X is coming and you’ll hear a lot about it in the coming months. Let’s see what Windows 10X Read More
Understand and use Excel’s Standard Error of the mean
Calculating the ‘Standard Error of the mean’ or SEM is simple using Excel’s in-built functions. Understanding ‘Standard Error of the Read More
Standard Deviation is easy to use and understand in Excel
Calculating the Standard Deviation is simple using Excel’s in-built functions. Understanding Standard Deviation isn’t hard either. We’ll explain the five Read More
Arrived! The first Office bug fixes for 2021
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser Read More
Easily compare a series of values with ChiTest() Excel
How to compare one set of numbers with another list of values using ChiTest() in Excel. ChiTest() or ChiSq.Test() sounds Read More
Using Benford's Law magic with Excel
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical Read More
Excel's CONVERT function for metric and more
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can Read More
Nice variations for Stop shape in Word, Excel & PowerPoint
There’s plenty of scope for variations on the basic Not Allowed symbol (red circle with diagonal) using the tools in Read More
Yet more ways to insert the Stop circle and line symbol in Office
Aside from the stop/prohibited shape in Office, there are other options for entering the common sign symbol in Word, Excel, Read More
Customized Don’t / Not Allowed symbols for Word, Excel and PowerPoint
Whether it’s no smoking, talking, eating or whatever you can make your own ‘Prohibited’ or ‘Not Allowed’ symbol for serious Read More
Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint
Here’s the best and most flexible way to make the common ‘Stop’ circle with diagonal line symbol in Word, Excel Read More
8 simple ‘Prohibited’ symbols for smoking, phones, kids and more in Word
There are some other ‘not allowed’ or ‘prohibited’ symbols, they can be used in Word, PowerPoint, Excel or Outlook. The Read More
Pantone 2021 colors in your Word, Excel and PowerPoint
Pantone has announced not one but TWO ‘colors of the year’ for 2021 and, as usual, we’ll explain how to Read More
Lambda() downsides need to be fixed
The new Lambda() feature in Excel 365 is great, in theory. But when you try using it the problems quickly Read More
What's the deal with Excel’s Calendar Creator?
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a mystery. The Read More
World’s ugliest color in Word, Excel and PowerPoint
The world’s ugliest color is a ‘drab dark green’ and it can be used in any Word document, Excel sheet Read More
A better Excel Calendar Creator for Office Watch readers
Here’s a better and more flexible version of the Calendar Creator with both Sunday and Monday start of week. We’ve Read More
Watch Window finally coming to Excel for Mac
An essential Excel testing and debugging tool is finally in Excel 365 for Mac. The Watch Window makes fixing workbooks Read More
New look in Microsoft 365 for Mac coming in early 2021
Microsoft 365 for Mac is getting a revamped look for the Home or Start menu in early 2021. Here’s all Read More
