There’s plenty of scope for variations on the basic Not Allowed symbol (red circle with diagonal) using the tools in Microsoft Office. See Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint for how to insert the basic ‘Not Allowed’ shape and change to suit your needs.
Pantone has announced not one but TWO ‘colors of the year’ for 2021 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. The colors of 2021 are … Illuminating and Ultimate Grey As usual what’s more amazing than the color is the description
Microsoft has released some ‘sweater’ backgrounds for Christmas, Hannukah or anytime of year. The PNG images are intended as backgrounds for Teams calls but can be used anywhere. A PowerPoint slide, Word background, Zoom call background or whatever. Adding Virtual Background or blurred video to TeamsAdd your own background image
The only specific 2020/2021 calendar template in Microsoft Word is an academic calendar from August 2020 to July 2021, here’s how to use it and make it better. In File | New search for ‘academic calendar’ there are a few options. We’re looking at ‘Academic year calendar’. A few notes
The usual security fixes for Microsoft Office this month include some unexpected patches for Office 2010 which is a pleasant surprise. Office 2010 is now officially out of support (since 13 October 2020) but still works fine. That’s supposed to mean there’s no more patches. Microsoft hasn’t explained their reason
Adding a video as the background of a PowerPoint slide is surprisingly easy. You might expect that it requires special features but it doesn’t. There are some tricks to know if the slide gets muddled up. A true PowerPoint slide background has to be still a solid color, gradient, pattern
Some people have way too much time on their hands …. and this was pre-lockdown! Hunter Hobbs decided to find out how long it takes to scroll down to the very bottom row of Excel. That’s row 1,048,576. It only takes a moment and two keystrokes to get there, but
0Patch is stepping in where Microsoft has left by offering continued security updates for Office 2010 after official support was dropped a few months ago. Newly discovered high risk security bugs in Office 2010 will get micropatches from 0Patch. These unofficial updates change the existing program files to prevent the
The Quick Access Toolbar (QAT) is located on the left side of the Word, Excel, PowerPoint or Outlook title bar. You can add commands, options and even symbols for easy and quick obvious access By default, the QAT only has Save, Undo, Redo and Touch/Mouse commands but you can cut down
A quick way to type a ü tick or check mark character in Word. Another great Autocorrect suggestion from Morris B. ” … the one that I have found the most useful is to replace ‘./’ with a tick (wingdings 252 – or wingdings 254) “ Using the fullstop/period is
One of the eternal questions to Office Watch is about adding characters to an Office document. Symbols and characters not on the keyboard. The most common requests are for adding currency symbols like Pound £ Euro € or Yen/Renminbi ¥ but can also include the @ symbol which can, even
The new Apple iOS 14.2 adds 117 new emoji to use but be careful now you use them because not even all iPhone and iPad can handle them, let alone non-Apple devices. We explain how they work, how the emoji appear on receiving devices and include a full list of
Those ‘award’ logos with the laurel or fern on each side can be made in Word or PowerPoint. The ‘awards’ can be serious or joking. Here’s the thing we mean, you’ll often see them on theatre or movie posters. Format The standard wording for these logos is: Award organization (Academy
Put the Sound Recording Copyright ℗ or Circled P character into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Sound Recording Copyright ℗ symbol (aka Circled P ) is used to mark musical copyright. The ‘P’ stands for ‘Phonogram’ or the modern ‘Phonorecord’
Adding a continent map is easy in Word, Excel or Powerpoint, in fact there’s a few ways to get them for the Americas, Europe, Africa, Asia, Australia and Antarctica. It depends on the quality you need and version of Office. Continental Icons Among the many icons are silhouettes of all
There are 87 different security breaches fixed in this months rollout of Microsoft bug fixes, including an important one for Windows. Also a Critical fix for Outlook and patches for Word, Excel. We’ll start with a very critical Windows bug that’s important to patch right away. Vital Windows 10 bug
Are your Excel worksheets ready for negative interest rates? The world is seeing historically low interest rates. So low that they can drop to zero or even lower rates. Not only can Excel worksheets break with unexpected negative percentages but modelling can accidently move into negative territory. Interest rates might
Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis and handling blank or zero values. Sparklines are in Excel for Windows and Mac. Excel Mobile (iPhone, iPad, Android) shows existing Sparklines made elsewhere but they can’t be changed, only
The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them.
A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Windows or Mac. Mea Culpa – we thought that ‘Sparklines’ was a fancy name made up by Microsoft after a long liquid lunch … Office Watch readers, John F, Nick
Ignore the scary headlines and threats about Office 2010 ‘ending’ early next month. Things are nowhere near dire, desperate or urgent for Office 2010 users. Office 2010 support (security patches, bug fixes and tech support) end on 13 October 2020. That does NOT mean that the software will suddenly stop
Office 2010 ends support on 13 October 2020 and we’ve been receiving questions from readers asking about switching to newer Microsoft Office. We’ll answer questions about when to update, what to replace Office 2010 and important factors to consider. We’re hearing concerns about privacy in modern Office, reliability and the
Common programming tools can be used to make malicious Office workbooks which bypass both online security checks and Microsoft’s own protections in Word, Excel, PowerPoint or Access. We’ll explain what’s happening and what Microsoft could do better. VBA Purging or VBA Stomping are clever tricks to make an Office documents
