Flash Fill Magic in Excel
Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill Read More
Office for Mac
Australian flag and more into Word, Excel or PowerPoint docs
Find and add the Australian National flag, Aboriginal flag and other Aussie ensigns into Office documents, Word, Excel or PowerPoint, Read More
Black ‘Not Allowed’ circle/line symbol
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with a black background and white center graphic. Read More
Eight easy statistics in Excel
There are simple formulas and functions in Excel that can summarize a list of numbers into something easy to understand. Read More
Pi 𝜋 choices in Word, Excel, PowerPoint and Outlook
There are twelve different styles for the Pi symbol 𝜋 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office Read More
Text and formatting tricks for Excel
Entering blocks of text in Excel is quite easy. What’s not obvious are all the options to make the text Read More
Special tricks to add iCloud accounts into Outlook 365 for Mac
iCloud accounts can now be added to the new look Outlook 365 for Mac but there are limitations and it’s Read More
Exclamation Question Mark ⁉ symbol in Word, Excel, PowerPoint and Outlook
How to insert the Exclamation Question Mark ⁉ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows 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
Great UK deal on Microsoft 365 Family – save £30
Amazon UK has a good deal on Microsoft 365 Family (six user). For the next week only save £30 on Read More
Six simple steps for saving on renewals or first purchase of Microsoft 365
Follow these simple, legal, steps to get 12 months of Microsoft 365 Family or Personal for less than what Microsoft Read More
Too many Microsoft Outlook's - we explain them all
Once upon a time there was just one ‘Microsoft Outlook‘ but these days there are at least seven current programs 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
Better ‘Not Allowed’ red circle/line symbol with text
Continuing our series on the ‘Not Allowed’ symbol, let’s make a versions with text instead of a graphic or icon. Read More
Great text & image ‘Not Allowed’ red circle/line symbols
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with text and graphic or icon. Check out 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
Dictate voice commands - the full, searchable list
Here’s the full list of Office 365 Dictate special phrases, in English. Saying any of these phrases converts the words Read More
