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.
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
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
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
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
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
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
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
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
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
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,
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.
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.
There are many ways to enter the latest date or time into Excel, depending on exactly what you need. A fixed date/time at the moment you type into the cell or a date/time which Excel updates automatically. This works on Excel for Windows or Excel for Mac. There are combinations
Microsoft has released a quick ‘TikTok style’ video which is strange and not that helpful at showing some good Excel and Office features. We’ll explain what the video is trying to show off (Excel Conditional Formatting) and some more Office tricks too! We found it in one of Microsoft 365’s
Find and add the Australian National flag, Aboriginal flag and other Aussie ensigns (Boxing Kangaroo or Eureka flags) into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a
Type the Prescription Take Rx ℞ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Prescription Take Rx ℞ symbol is for a medical prescription. It is commonly seen on doctor’s prescription pads and in pharmacies. How Prescription Take Rx ℞ looks Here’s
Here’s the best and most flexible way to make the common ‘Stop’ circle 🚫 with diagonal line symbol in Word, Excel and PowerPoint. Microsoft Office calls it the Not Allowed symbol. It has many, many names; interdictory circle, prohibited symbol, don’t do it symbol, universal no, banned, no entry, nay, no symbol, ‘do not’
Aside from the stop/prohibited shape in Office, there are other options for entering the common sign symbol in Word, Excel, PowerPoint or Outlook. Use Icons in Microsoft 365, Office 2021, Office 2019 or Emoji symbols from the Unicode list. See Make a ‘Stop’ circle / diagonal symbol in Word, Excel
There are at least five different options inserting a Christian or Latin ✝ Cross symbol into Office documents like Word, Excel, PowerPoint or emails. There are some cross symbols available in the Windows / Office symbol fonts and there’s plenty of nice cross options available online in the flexible SVG format.
2023 is the Year of the Rabbit in the Chinese calendar. There’s plenty of rabbit, bunny and other New Year related images, icons and Chinese character 兔 in Microsoft Office plus advice on the right colors to use for Chinese New Year graphics. Chinese New Year is on 22 January
Excel 365 for Windows is getting more functions only for Data Models with PowerPivot. Data Analysis Expression (DAX) functions are useful for exploring large datasets. There are a few UTC time/date functions we’d like to see made available to all Excel users. A full list of the new DAX functions
Finding out the current UTC / GMT time in Excel is possible with a little VBA magic. We’ve included a full working example. Excel has two functions to give you the current date TODAY() or current date and time NOW() but it’s the local time as set on your computer.
Finding out the computers local time zone offset in Excel is possible with a little VBA magic. We’ve included a full working example of how to get the ‘nn hours from GMT’ setting from Windows into Excel. The need for the current UTC/GMT time and offset is becoming more important
