Six ways to put the date and time into Excel
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 to enter either date, time […]
Explaining Microsoft’s “Conditional Formatting” Excel video
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 latest tweets called ‘Impressing your […]
Australian flag and more into Word, Excel or PowerPoint docs
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 different source. Get the Australian […]
Prescription Take Rx ℞ symbol in Word, Excel, PowerPoint and Outlook
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 some examples of how Prescription […]
Make a ‘Stop’ 🚫 circle / diagonal symbol in Word, Excel & PowerPoint
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’ sign or circle-backslash symbol. And that’s […]
Yet more ways to insert the Stop circle and line symbol in Office
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 & PowerPoint for a better […]
More than five Christian ✝ Cross choices in Word, Excel, PPT and emails
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. Office itself is surprisingly secular […]
Year of the Rabbit images and more in Microsoft Office
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 2023, an excuse for fireworks, […]
DAX functions in Excel that everyone should have
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 are below, two of those […]
Easy way to get UTC / GMT current time in Excel
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. Often the worksheet needs either […]
Get the local time zone offset into Excel
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 as Excel improves its external […]
Compass 🧭 symbol in Word, Excel, PowerPoint and Outlook
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 or black. The symbol can […]
Cool Excel Year Planner now available for download
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 progress ‘thermometer’ for the year. […]
Average / Mean options in Excel
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 the overall pattern. And yes, […]
Converting Google Docs to Microsoft Word
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. If the Google Docs File is Open […]
8 simple ‘Prohibited’ symbols for smoking, phones, kids and more in Word
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, Littering, Pedestrians, bicycles plus no […]
