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
Office 2003
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
Type Interrobang in Word, Outlook, Excel and PowerPoint
What is an interrobang ‽ and how to use it in Microsoft Word, Excel, Outlook and PowerPoint Interrobang ‽ is Read More
Two ways to find accented letters in Word
How to find words with or without accented characters in Microsoft Word. You might need to find both naïve and Read More
Reader's suggestion for typing a tick in Office
A quick way to type a ü tick or check mark character in Word. Another great Autocorrect suggestion from Morris Read More
Quickly add any special characters in Office
One of the eternal questions to Office Watch is about adding characters to an Office document. Symbols and characters not Read More
The trick to Find or Replace web links in Word
Find or change many web links in Word documents using the Replace command, here’s the trick. For example, you might Read More
What happened with UK COVID tracking and Excel?
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official Read More
Excel - a history of rows and columns
How many rows and columns does Excel have? All the talk about 64-bit versions of Office has raised the issue Read More
WTF? Word's Alphabetical order is different from a dictionary!
Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what Read More
Full CONVERT() measurement list for Excel
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table Read More
Date formatted charts in Excel
The secret to a timeline chart in Excel is the data. Emily writes asking “How can I make an Excel Read More
More Word Find / Search tricks
Following on from our introductionFind pane search secrets in Word here’s some Word Find tricks that you might find useful. Read More
Four Word fixes for stretched out last line
To my horror, I encountered something strange while working on a Word document with “strung out” or ‘stretched’ text on Read More
Microsoft Word tests for the Oxford Comma
Word can warn you about the ‘Oxford’ or serial comma’ whether you prefer to use the extra comma or not. Read More
Degree Celsius ℃ symbol in Word, Excel, PowerPoint and Outlook
Insert the Degree Celsius / Centigrade ℃ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Read More
Gene names changed to stop confusing Excel
The names of genes are being changed just to stop Excel confusing them with dates during the import process. We’ll Read More
Excel’s General problem that messes up what you type
Why does Excel change what people type or import, sometimes in ways they don’t want? It’s the General cell format Read More
