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
Insert a Compass 🧭 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Compass 🧭 uses Segoe UI Emoji In Windows, the Compass 🧭 symbol is in the font: Segoe UI Emoji. Depending on the app and use, it’ll appear in color
A clever and different year planner with a progress thermometer is now available for download as an Excel workbook. The days remaining in the year are visible with weekends shaded and each day of week shown. At the bottom is a clever use of Excel’s Chart features to make a
Excel statistical functions have many Average / Mean options including Average with IF for filtering or mean with extreme values excluded. by David Goodmanson In a world which has more and more data, statistics are really important. They help you distill lots of numbers down so that you can see
Google Docs can be handy for sharing and working on documents with other people, but sometimes you just really need that file in Microsoft Word. No problem – it’s actually really easy to convert them. All you have to do is download the file and save it as a Word doc, Excel sheet or PowerPoint deck.
Some ‘not allowed’ or ‘prohibited’ symbols, they can be used in Word, PowerPoint, Excel or Outlook. No Smoking, No Phone, No Children, No Drinking, No Pedestrians, No Bicycles, Not Drinkable Water or Mute. The Unicode symbol list includes red circle with diagonal to stop, smoking, children under 18, Mobile Phones,
How to bulk convert old documents (.doc .xls .ppt) into the newer Office formats (.docx .xlsx .pptx etc.). Microsoft has never produced a simple bulk conversion tool for the masses, much to the annoyance of users and network administrators. Redmond probably made that choice for their own self-interest but some
Type the Greek letter Omega in upper case Ω or lower case ω in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Omega (uppercase Ω / lowercase ω) is the twenty fourth and final letter of the Greek alphabet. It is used to often
Here are the best ways to get results from Microsoft Forms into an Excel workbook. Sadly they aren’t the elegant and efficient ways available in modern Microsoft Excel 365, 2021 or 2019 for Windows. We’ll explain how to get Microsoft Forms results into Excel for better filtering and analysis. Then
I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for
Microsoft Word’s Sort feature is OK but has its limitations. We humans insist on variations of the simple ‘first and last’ name that confuse a computer. Here’s some name sorting traps and workarounds. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.
