Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
Passover images and more in Microsoft Office
Add some Passover images and icons to your documents, slides or emails from right inside Word, PowerPoint, Outlook and Excel. If you know where to look there are images from the Jewish tradition related to Seder, Matzah and Menorah among many, Icons The SVG Icons collection (Insert | Illustrations | Icons) has only one option, […]
Cat Face 🐱 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Cat Face 🐱 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cat Face 🐱 emoji is a variant of the grinning face emoji, usually depicted as yellow on all platforms. How Cat Face 🐱 looks in different fonts. Here’s some examples of how […]
Fast screen shot or clipping in Office
There’s a simple way to copy a screen image into Word, PowerPoint, Excel, Outlook or OneNote. Word, PowerPoint and other Office apps for Windows (Office 2010 and later) has a Screenshot option to paste an image from any open program window into a document or email. Go to the Insert tab of the programs, there’s a Screenshot […]
Word number \# field code formatting explained
All about the \# formatting switch in Word field codes lets you change the look of numbers in many different ways. Many examples plus a guide to the formatting codes. Use these options with Word fields that return a number like SEQ, REF, PAGE, SECTION, SECTIONPAGES, AUTONUM, EDITTIME, FILESIZE and MERGEFIELD . The \# codes […]
Fast stock charting with Excel and StockHistory()
Excel 365 makes it incredibly easy to get past price and volume info for stock, fund and currency exchange data, then convert that into a professional-looking chart. Some may remember the days when stock prices were added manually from a newspaper. Now a single Excel cell formula can grab the history of thousands of traded […]
Dog Face 🐶 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Dog Face 🐶 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Aside from the obvious the Dog Face 🐶 emoji can used as a variant of the Grinning smiley face emoji. How Dog Face 🐶 looks in different fonts. Here’s some examples […]
Caffeine level easy comparison in Excel
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of coffee can have as much […]
Microsoft Journal, the ink notetaking app, grows up
Microsoft’s digital ink notetaking app, Journal, has grown up. It’s no longer ‘Garage’ trial software but part of Redmond’s official software line up. If you like scribbling or notetaking with a digital pen, you can try out Journal. Journal was a Microsoft Garage project which are trials of an app or technologies. Journal seemed like […]
Automatic due date and reminders in Microsoft To Do
Microsoft’s To Do app can now automatically add due dates, reminders and repeat tasks automatically based on what you type. It works quite well but there’s some traps for the unwary. Whatever you type in a new task is analyzed for hints of due dates, reminders and repeat tasks. Here’s Microsoft’s example: Office Watch has […]
A new Outlook coming soon
Had you wondered what’s happening with the Outlook replacement: Project Monarch? Seems we won’t have to wait much longer to see a preview. Project Monarch is a Progressive Web App (PWA) that will run in your browser. It will have email, contacts, calendar and perhaps other ‘Outlook-like’ features. A Progressive Web App looks like a normal […]
Change case using Word’s Replace feature
Changing the case upper/lower for text through all of a Word document is easy because the default Find / Replace settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has peculiar case choices like iPad, […]
Five Change Case choices in Microsoft Word
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE CASE’ or even “cHANGE cASE” […]
Change Picture from clipboard in Word and Office
Replacing images in Word, PowerPoint, Excel and Outlook is a lot easier using the ‘Change Picture’ option, especially now you can change to insert an image on your clipboard. We’ll show you a step by step on how to do it. There might not be one simple keyboard shortcut, but it is a lot better […]
All the \* named format switches for Word field codes
Ever been confused by the \* formatting options in Word field codes? You’re not alone, believe me. Here’s a complete guide with the \* codes and examples of how they appear. In this article we’ll look at the named formatting codes which start with \* like \* Arabic and \* Ordinal and even \* Hex […]
Quick stock price analysis and charts with Excel StockHistory()
StockHistory() is an Excel function that can add historical stock price info, as well as currency exchange rates at monthly, weekly or daily intervals. Date and Closing Price plus optionally Open, High, Low and Volume. All ready to make a chart for stock price analysis. Excel 365 has Stock and Currency data types but they […]
Clipchamp arrives at a high price for too little
Clipchamp video editor has been integrated into Microsoft’s product range but not in the way promised. Instead, it’s selling at a high price for relatively little extra. Though Microsoft has acknowledged part of the problem by upgrading all customers to a decent quality for exporting files, this article has been updated to reflect the late […]
