Shutterstock are offering two nicely designed PowerPoint templates for free. We’ll explain how to get more from the professional templates with a few clicks. Minimalistic PowerPoint templates comes in two styles: Dawn and Midnight. Dawn Template Evokes a meadow at dawn with a muted color scheme. Midnight Template Midnight template
Metric to Imperial/US conversion or vice-versa can be a little messy in Excel, the new Lambda() feature lets you make an easier and simpler conversion function. It’s a simple and practical example of what’s possible with Lambda(). See Lambda – strange name for a really good extra in Excel Metric
OneDrive’s single file size limit is now 250GB up from a ‘mere’ 100GB. That’s a welcome increase for video editing and other volume users who have to deal with really big files. Word, Excel or PowerPoint users don’t need to worry about their files getting that large <g>. It is
There are two different levels of hidden sheets within Excel, hidden and the less well-known very hidden worksheets. We can easily hide our worksheets by right-clicking the sheet tab and selecting hide. There’s a more extreme option available. Very Hidden means the sheet/tab doesn’t show up at all in regular
It’s been a slow process, but now it’s possible to move a file from Outlook to Teams across both web clients and programs. Users have been asking Microsoft for years to be able to quickly copy an Outlook attachment to a Teams area. Customers had to save the attachment to
Excel for iPad now has Split View, allowing two workbooks to be seen side-by-side. That’s catching up with Word and PowerPoint for iPad which got Split View in mid-2020. iOS 13 is required for Split View on iPad. Get more about Office on iPad and iPhone from Office Watch for
Presenter Coach or Rehearse with Coach is now available in PowerPoint for iPad. You can practice your presentation with Microsoft’s systems ‘listening’ and giving advice on how to improve. Presenter Coach is already in PowerPoint 365 for Windows or PowerPoint Online on the web. See Presenter Coach makes for better
For a short time, Microsoft hinted at an important improvement to Excel. But this promise was quickly removed, leaving Excel customers hanging. The feature is/was ‘Show Changes’ and would let you see a history of changes in an individual cell. Show past values or formula in that cell. “Excel can
Excel users owe thanks to Sumit Gulwani . He’s the guy who turned the Flash Fill feature from a vague dream into something that makes life easier for Excel and other Microsoft customers. Flash Fill is a way to join, split or reformat text in Excel without coding. You type
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with a black background and white center graphic. This isn’t part of the official ISO specification for the symbol but it’s widely used. It’s done by adding a black circle under the main circle/line & graphic (which is
Entering blocks of text in Excel is quite easy. What’s not obvious are all the options to make the text easier to enter and look better. Just typing in a cell will enter text. By default it will extend into any unfilled cells. If there’s something ‘in the way’ the
You may have heard about ‘Project Monarch’, Microsoft’s plan for a single Outlook program for Windows, Mac and maybe other platforms. This is what we know so far about Microsoft’s ‘vision’ for ‘One Outlook’ Project Monarch is an early Progressive Web App (PWA) which will have email, contacts, calendar and
Here’s how to install Outlook as a standalone web app or PWA. This looks like Outlook in a browser but it’s not, it’s Outlook as a standalone Progressive Web App (PWA). It’s available now in Windows 10. It’s not the upcoming Project Monarch but a part-way step in that direction. See
Microsoft Office (plus Word, Excel and PowerPoint) can be installed as a standalone web apps or PWA. We’ll explain how and the current limitations. This looks like the Office.com web page but it’s not, it’s Office as a standalone Progressive Web App (PWA). It’s available now in Windows 10 with
Windows 10X is coming and you’ll hear a lot about it in the coming months. Let’s see what Windows 10X is, how it will run Office (Word, Excel, PowerPoint, OneNote and Outlook) and why most people won’t need to worry about Windows 10X. What is Windows 10X? Windows 10X is
iCloud accounts can now be added to the new look Outlook 365 for Mac but there are limitations and it’s harder than Microsoft’s ‘help’ says. Outlook for Mac has always been able to link with iCloud using IMAP. Now Outlook 365 for Mac with the new interface can automatically setup
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser patches from last week. At first look, it seems there’s only five Office related patches including two each for Word and Excel. It’s important to keep both Office and the
Amazon UK has a good deal on Microsoft 365 Family (six user). For the next week only save £30 on the regular price for new and existing customers. Pay £49.99 for (another) year of Microsoft 365 Family, instead of £79.99 which is what Microsoft charges for automatic renewals. Click here
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical laws that seems to defy common sense but works for most naturally occurring number sets. It says that in most groups of naturally occurring numbers, the leading digit 1 will
Continuing our series on the ‘Not Allowed’ symbol, let’s make a versions with text instead of a graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Text in circle Instead of
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with text and graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Better ‘Not Allowed’ red circle/line symbol with
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better. As usual, we decided
As we mentioned back in October, Office Lens has been dropped from the Microsoft Store but it’s not the end of Lens, far from it. Microsoft announced that the cloud services backing Lens features would be disabled from 1 January 2021. Only Office Lens for Windows 10 and Windows Mobile
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.
