New Keyboard shortcuts for Office menus
New shortcuts are coming to Microsoft Office 365 for Windows which will help navigate larger pull-down menus with keystrokes. Plus the screen-reader labels are being improved. In short: the Tab key moves between sections/blocks of a pull-down menu.That’s it … so simple and perhaps surprising that it’s not there already. Unfortunately, Microsoft’s description of these […]
Nine easy statistics in Excel
There are at least NINE simple statistics formulas and functions in Excel that can summarize a list of numbers into something easy to understand. Often Excel has lists of numbers or money that makes little sense until you add a summary like this: We have a table called CountbyState and want to know something about […]
Thumbs Up👍emoji in Word, Excel, PowerPoint and Outlook
Insert Thumbs Up or Like👍symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thumbs Up / Like👍emoji is typically used when you ‘like’ something or have approval/agreement. It’s commonly used as a quick response to a comment on Facebook, Twitter and it’s coming to Office Comments too. […]
All 20 Coronation emblems and how to use them in Microsoft Office
All 20 (yes, twenty!) emblems for the Coronation of King Charles III, the exact colours required and how to use them in Microsoft Office like Word documents and PowerPoint slides. Also how to get an SVG/icon version of the emblem, ideal for modern Office apps and show just the parts you want (e.g. no text, […]
Per Thousand / Per Mille sign ‰ in Word, Excel and PowerPoint
How to type the Per Thousand ‰ (or it’s official name ‘Per Mille‘) sign into Microsoft Word, Excel or PowerPoint. Per Thousand / Per Mille ‰ means ‘parts per thousand’ and can be used for values below 1%. It’s not regularly used in English. How Per Thousand ‰ looks in different fonts Per Thousand / […]
Discover the secret powers of a 3D model
3D models have a secret. They let you choose the exact look you want, turn it into a 2D ‘normal’ image that you can do a lot more with. Here’s a 3D model from the Smithsonian collection, a full length but frankly plain view of a famous statue. With a little Microsoft Office trickery, you […]
Goldman Sachs font for a new look in Excel, Word and Office
The (in)famous Goldman Sachs bank has released their own font which anyone can use in their Word, Excel or Powerpoint documents. It’s called Goldman Sans and is available for anyone to download and use. The font is especially useful in Excel workbooks. The company describes the sans-serif typeface as “approachable without being whimsical”. Goldman Sans, […]
Speaking Head in Silhouette 🗣 emoji in Word, Excel, PowerPoint and Outlook
How to insert the Speaking Head in Silhouette 🗣 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Speaking Head in Silhouette 🗣 emoji can be used as a different way to draw attention to a special point or note. Or as an alternative icon for a speaker […]
Siren 🚨 emoji in Word, Excel, PowerPoint and Outlook
Insert the Siren or Police Car Light 🚨 symbol / emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Police Car Light🚨 (aka Siren or Emergency Vehicle Light) symbol can be used any time you want to add warning or alert to a document, slide or sheet. […]
Starting out with 3D models in Microsoft Office
How to insert and use 3D models in Microsoft Office. 3D models let you rotate, pan and zoom all around an object to show it exactly the way you want. Microsoft Office’s 3D models feature has more uses than you might expect. From the Microsoft promotion, it looks like 3D models are only good for […]
Degree Fahrenheit ℉ symbol in Word, Excel, PowerPoint and Outlook
How to insert the Degree Fahrenheit ℉ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Degree Fahrenheit ℉ symbol is used as the unit for the Fahrenheit temperature scale. It’s a single character that’s a combination of the degree symbol and capital F. There’s a matching Degree Celsius […]
Degree Celsius ℃ symbol in Word, Excel, PowerPoint and Outlook
Insert the Degree Celsius / Centigrade ℃ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Degree Celsius ℃ is a single character symbol is used to refer to a specific temperature on the Celsius or Centigrade scale. Centigrade was the original name for the temperature scale before 1948 […]
SketchUp 3D graphics in Office 365
Microsoft has added SketchUp 3D graphics (.skp files) to the models inserted into Word, Excel, PowerPoint, and Outlook. SketchUp is a 3D graphics program where you can create shareable designs such as architectural models and graphics used in industrial design, product design, and civil and mechanical engineering. SketchUp Free is available for everyone. Adding Sketchup’s […]
Use the Smithsonian for great photos and 3D models in PowerPoint and Word
The Smithsonian has millions of images and 3D models available online to add something great and different to Microsoft Office including PowerPoint slides and Word documents. The Smithsonian Institution has been a US cultural, scientific and historical resource for the last 170 years. No visit to Washington DC is complete without going to several of their […]
Microsoft fixes their Quick Access Toolbar changes
Microsoft has reversed course on their proposed changes to the Quick Access Toolbar (QAT) in Microsoft Office 365 apps. The current defaults remain for new installs with ‘below the ribbon’ available as an option. In other words, common sense has prevailed. Microsoft wanted to move the Quick Access Toolbar from its familiar location ‘top left’ […]
Myth Busting about Office document formats
Even after 15 years, there’s still misinformation about the ‘new’ Office document formats .docx .xlsx etc. We’ll explain these myths and how you can easily disprove them yourself. Most of these myths surround the use of ZIP compression to make the document files smaller. Folks have jumped to wrong conclusions after hearing about ZIP. Not […]