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 […]
Vertical Bar | symbol in Word, Excel, PowerPoint and Outlook
How to insert the Vertical Bar | into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Vertical Bar | symbol (technically a glyph) has many uses in computing, physics, maths and typography. In some programming languages | has a special meaning, for example in PowerShell | is called […]
Excelâs Round () and nine other rounding functionsÂ
Excelâs Round () function rounds a number to a specified number of digits. It might seem like the choice for your rounding needs but there are NINE more rounding functions that might be better and even that’s not enough to cover all rounding needs. Round () basics Round() is pretty simple, give it a value […]
More accurate Excel rounding to the international specification
Hereâs how to round numbers more accurately than Excelâs in-built Round() and other functions. This method uses the internationally recognized standard for rounding (yes, there is one), we’ll show the long formula, how it works plus the Let() and Lambda() versions that can make your worksheet easier to deal with. Rounding ‘Ties to Even’ The […]
Why Excelâs Round() function is wrong
Excelâs Round() function is not totally accurate.  Thereâs a lot more to rounding numbers than we were taught in school and how Microsoftâs Round() function works. What we learned in school and Round() is OK. But if youâre dealing with larger groups of numbers, narrow rounding ranges or should be very, very fair (e.g test […]
Set your own Text Box default settings in Office
Youâre not stuck with the Microsoft Office automatic settings when inserting a new text box. Change the Text Box defaults to whatever you like for faster text box formatting in Office; Word, Excel, PowerPoint or Outlook. There are TWO ways to add a Text Box in Word and Outlook – each with their own ways […]
EVEN() and ODD() are yet more ways to round numbers in ExcelÂ
Excel has two functions that round numbers to either the next Even or Odd numbers â these functions are called ⌠wait for it ⌠Even() and Odd()! Both Odd() and Even() round positive numbers UP to the next odd/even number. Negative numbers are always rounded DOWN to the next lowest odd/even negative number. In […]
All about Ceiling() and Floor()Â Excel rounding optionsÂ
Excelâs Ceiling() and Floor() function rounds a number up or down to the nearest specified multiple. The most common use is to match prices to denominations of coins or notes. Ceiling() is similar to MRound() except that MRound() rounds to the nearest multiple, Ceiling() always rounds UP. The reverse is Floor() which always rounds down.    […]
