Easily Calculate Body Mass Index in Excel
BMI or Body Mass Index is a ‘rule of thumb’ calculating body fat based on height and weight. It’s easy to calculate in Excel whether you use metric or feet/pounds. BMI can be a polite way of saying how overweight a person is! A BMI over 30 is considered obese and need of work to bring down […]
Automatic worksheet/tabs list in Excel
Make an automatic list of tabs in an Excel workbook a better and more flexible way with options to create clickable links and sort the sheet list. Unlike older methods, it works in Excel for Windows and Mac. We’ve already talked about fitting more tabs on the screen or making a manual list of tabs/worksheets. […]
Explore five (yes FIVE) different Exclamation Mark ! in Word and Office
There’s more possible with the humble ! exclamation mark / point in Microsoft Word or Office. At least five different ! available and that’s before changing color, size and other text effect options. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, icons, symbols and several emoji with infinite variations possible […]
Add the King Charles III monogram to Microsoft Office docs
There’s a new King in Britain (and other countries) which means there’s a new Royal Logo Cypher or Monogram. Here’s how to get the Cypher for Microsoft Office documents or slides. The Royal insignia is usually made from two parts, the Tudor Crown or Scottish Crown above the Royal Cypher. There’s a Royal Cypher below […]
Beware a Microsoft Office 365 – OneDrive outage, what you must to do protect yourself
No cloud service is perfect, no matter what the company says. Here’s what you must do to protect yourself from breakdown of your OneDrive, SharePoint, Teams or Microsoft 365 cloud storage. Microsoft pushes use of OneDrive to store all your documents and images. That suits Microsoft’s strategy but isn’t necessarily a good thing for customers. […]
Exploding Head 🤯 emoji in Word, Excel, PowerPoint and Outlook
Insert the Exploding Head 🤯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Exploding Head 🤯 emoji looks Windows only has Exploding Head 🤯 in the Segoe UI Emoji font, either color or black. To me the black version looks more like a bowl than […]
Three ways to understand part of an Excel formula
Excel has three different ways to see a partial formula result to help you locate and fix a problem or understand how a formula works. Two methods have been in Excel for some time and there’s a new tooltip feature. Evaluate Formula The full Evaluate Formula has been around since at least Excel 2007. It […]
Understand or fix an Excel sheet with Evaluate Formula
Excel has a simple way to understand or fix a complex formula. Evaluate Formula lets you calculate parts of a formula and see interim results that make up the final value that appears in the cell. It’s on the Formulas tab under Formula Auditing. Evaluate Formula isn’t new, just little mentioned despite its usefulness. We […]
Automatic worksheet/tabs list in Excel – the old way
Here’s the ‘old-fashioned’ way to make a list of worksheet tab names. It’s old because the formula uses ” Get.Workbook() ” which is an Excel 4 macro function that’s now blocked in modern Excel for security reasons. See Excel 4 macros are now blocked and about time tooWe’re including this older method for the sake […]
Art Deco font from National Park Posters in Word and Office
The famous Art Deco font used in US National Park posters is available free for Word, Excel or PowerPoint. National Parks Traveller has an interesting article on the history of US National Parks posters. Original posters now sell for four figure prices, not bad for things that were once thrown out as useless pieces of […]
Loudly Crying Face 😭 emoji in Word, PowerPoint and Office
Type Loudly Crying Face 😭 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. In mid-2011 Loudly Crying Face 😭 was the most popular emoji in the world. Alternative names are; Crying, Sobbing, Sad Tears, Bawling, uncontrolled laughter or even overwhelming joy. How Loudly Crying Face 😭 looks […]
Down arrow ↓ symbol in Word, Excel, PowerPoint and Outlook
Insert the Down arrow ↓ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Down arrow ↓ symbol is used for all sorts of things including a bullet symbol. How Down arrow ↓ looks in different fonts. Here’s some examples of how Down arrow ↓ looks in common […]
Rolling on the Floor laughing 🤣 emoji in Word, Outlook, Office
Insert the Rolling on the Floor laughing 🤣 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Rolling on the Floor laughing 🤣 emoji is commonly used, sometimes using the acronym ‘ROFL’ or ‘Hysterical Laughter’ Not to be confused with Face with rolling eyes 🙄 emoji How Rolling […]
How to insert the Beta Lower Case β symbol in Word, Excel, PowerPoint and Outlook
Type the Beta – lower case β into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Beta – lower case β symbol is the 2nd letter of the Greek Alphabet. Within finance, it is used as a measure of investment portfolio risk. Within statistics, it may represent a regression […]
Understand Office VBA code with ChatGPT
If you have Office VBA you’re trying to understand, ChatGPT can help. ChatGPT can take some VBA code and explain it in plain human language. This is very useful for digging into poorly documented or undocumented code. Also for beginners trying to get a handle on how Office VBA works. Office Watch has already explained […]
Five+ heart ❤ symbols in Word, Excel, PowerPoint and Outlook
Insert the Heart ❤ as a symbol, emoji, icon or shape into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Of course, the heart symbol has come to mean love or affection. Less romantically it’s a “plane curve” in geometry called a cardioid. It’s officially called Red Heart […]
