Finding your way around an Excel workbook is about to get a lot easier with the arrival of Navigation Pane in Excel 365 for Windows. Navigation Pane shows each tab, table and other elements in a nested listing for each worksheet. The Navigation Pane is primarily intended as an accessibility
Microsoft is pushing the Internet Explorer browser over a cliff but there’s a good but hidden reason why IE is worth keeping or get Edge’s IE Mode working. Both Edge and Google Chrome have an annoying feature that adds HTML formatting to the web page downloaded. That’s a problem if
An enigmatic Microsoft tweet about Word Dark Mode set off plenty of talk about changes to the look of Office 365 ,,, but does a single Twitter message mean anything? The response tweets did reveal some interesting tips about Dark Mode. Here’s the tweet that started it all … Nothing
Microsoft has added support for Apple’s iPhone and iPad image formats .HEIC .HEIC and .HIF but there’s a small extra price to pay. After an unsubtle reminder from us, Microsoft has clarified the two extensions needed and the extra to be paid. iPhones and iPads now use a new image
Theta upper case Θ, Theta small upper case θ and Theta lower case ϑ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Theta (uppercase Θ or θ / lowercase ϑ) is the eighth letter of the Greek alphabet. The lowercase symbol represents many things, such as an unknown variable in trigonometry, or
Microsoft has now revealed all the details of their Windows 365 cloud based PC service. Here’s what it will cost, some pricing traps and some hidden ‘features’ to consider. Windows 365 is a ‘PC in the cloud’ service that lets you run a Windows 10/11 machine from any Internet connected
Outlook 365 desktop (Windows/Mac) is getting more Dictation controls for email creation and sending. It’s already possible to dictate (speech to text) an email, after all, the Outlook email editor is Word in disguise and Word 365 has dictation features. Now Outlook Dictation can add receivers (TO, CC or BCC),
Chromebook users are getting unexplained messages when they use some Office apps, leading to rumors about Microsoft Office support of Chromebooks. Microsoft isn’t helping by their silence but the signs are not good for paying Office customers with Chromebooks. It all started when Chromebook users reported getting pop-up messages and
Type the Koppa upper case Ϟ and Koppa lower case ϟ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Koppa (uppercase Ϟ / lowercase ϟ) is a letter used in the earlier forms of the Greek alphabet, it was originally used to
How to insert the Alt key ⎇ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Alt key ⎇ symbol is a modifier key, used in a similar fashion to the Shift key. On a Mac, the same key is called Option.
Insert the Thinking Face 🤔 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thinking Face 🤔 emoji has several other names; Thinker, Throwing Shade, Chin Thumb, puzzled and skeptic. How Thinking Face 🤔 looks in different fonts. Here’s some examples of how Thinking Face 🤔 looks in common Office fonts. Thinking Face 🤔 codes These
Our readers and supporters can now download a free Excel workbook which imports the latest Tokyo Olympics medal tally into Excel. All you need is a recent Excel for Windows with Get & Transform – Excel 365, Excel 2019 or Excel 2016 for Windows. (Alas, not Excel for Mac). There’s
Sound Bible has some useful, free music and sound effects that can jazz up a PowerPoint presentation. There’s a collection of free audio clips (various rights limitations) from here. In WAV or MP3 format, both compatible with PowerPoint. Many of the text labels are deliberatly bland to avoid copyright disputes.
There’s a new way to program or automate actions in Microsoft Office called Office Scripts. We’ll explain what it is, how it’s different from Javascript or VBA and who can get it. Office Scripts is available for some commercial users in Excel but it’ll spread to other Office apps and
Type the Om or Devanagari Om ॐ symbol in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. The Om symbol is a divine sign that denotes the essence of absolute truth, Atman or consciousness. In Hinduism, Buddhism, and Jainism. The syllable is chanted either separately or before a spiritual recitation.
TrimMean() function is a slightly different and useful measure than the regular Excel Average(). It’s still an average/mean but without the high and low, extreme or outlier values in the list. Average() (and its partners AverageA() and AverageIFS() use all the values in the array or list provided. TrimMean() excludes
How does Microsoft Word’s spell check go with the 2021 Words of the Champions list from the US annual spelling bee? Each year the Scripps National Spelling Bee releases a Words of the Champions study list to educators, featuring up to 800 new words. We grabbed a selection of the
Office 365 for Windows is getting a ‘visual refresh’ a changed look to the ribbon and overall appearance of Word, Excel, PowerPoint and Outlook (the other Office apps will change later). This new look is currently in beta testing and may change a little before public release. It’s only fair
Type the Weary / Distraught face 😩 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Weary / Distraught face 😩 emoji is also called Wailing, Frustrated or Sadness. How Weary / Distraught face 😩 looks in different fonts. Here’s some examples of
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab.
Office 2007 and later to Office 365 not only has keyboard shortcuts but in many ways they are better than previous versions of Microsoft Office. For the most part the shortcuts used in Office XP and Office 2003 still work in Office 2007 through 365 also – despite the very
We place all of the “Shortcut of the Week” tips from 2004 in the one convenient place. Tip 1 – Undo The Undo function has become especially important over the years as Microsoft puts more ‘intelligence’ into their products. Sometimes it ‘corrects’ your spelling or re-formats something you were quite
Here’s new suggested backgrounds for Teams, Zoom or other calls, dug out of Microsoft’s not always illustrious past. In other words, they are trying to rewrite the history of Clippy, again. Clippy The new Clippy image is part of Microsoft’s ongoing revisionist history. This campaign seeks to convince people that
While it lasts, there’s a deal available on Microsoft 365 Personal via Amazon US. Reduced prices on the Personal plan are rare so it’s a good chance to save on extending your subscription. Personal for $28 off Use this link to pay $41 instead of $69.99 Stocks are limited so