Search improvements in Word, Excel and PowerPoint
Microsoft is again changing the way Search works in Microsoft 365 and also (surprise!) Office 2021 to expand the results beyond the document or Office features. Now you can search for definitions, media and even web results from the top bar of Word, Excel and PowerPoint. The most recent announcement is about Office 365/2021 for […]
Excel formula: get percentage discount
Use Excel to figure out the percentage discount or increase, for example the difference between the original and sale prices. We’ll show you the Excel formula and some practical tricks beyond the official answer. Percentage discount formula The basic formula is: (Original – Sale) – to figure out the difference between old and new amount […]
All the right pointing hand symbols in Word and Office
Word and Office have several right “pointing hand” symbols available in some fonts. Here’s the Unicode options, index, backhand, sideways in white or black, all explained and shown. Want more arrows or pointers? Check out all 200+ Arrow or Hand pointing symbols and more in a searchable list. Index, Backhand or Sideways? The Unicode system […]
Three ways to run an Office macro direct, from the ribbon or toolbar
There are three main ways to run a macro in Microsoft Office (Word, Excel, PowerPoint or Outlook). From the Macros list, from a button on a ribbon or from the Quick Access toolbar. We previously spoke about how to install an Office VBA macro, here’s how a macro can appear on the ribbon or Quick […]
Make the Office ribbon more useful, add your choice of buttons
Any Office ribbon tab can be more useful for you. By trimming some of the buttons you don’t need, making room for the buttons you want. We’ll show you how to remove some of the less needed ribbon sections (likely from the Developer tab) to make more room for your own buttons. Previously we’ve explained […]
Add Chess Piece symbols to Word, PowerPoint and Office
Insert any of the chess piece symbols available in Word, Excel, PowerPoint and other Office apps. King, Queen, Bishop, Knight. Rook and the lowly Pawn all with different looks, depending on the font plus three pieces available in Microsoft Office icons and the single chess piece emoji. Chess Pieces – the full list Here’s the […]
Visio Data Visualizer converts Excel into a diagram
A new Excel add-in converts an Excel 365 worksheet into a Visio diagram. You don’t need to buy Visio to use the Microsoft Visio Data Visualizer in its simple form, just Excel 365 for Windows/Mac or Online. It’s an interesting tool and worth checking out if you make diagrams or flowcharts. The add-in inserts example […]
Easily install an Office VBA macro
Here’s how to easily install VBA code or macro in Microsoft Office. Adding some code you’ve seen on a web site or been given is simple once you know the little tricks. Often people are given some Office VBA code to use with Word, Excel, PowerPoint or Outlook but without instructions for how to install […]
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 […]
