A long last, Excel is getting a quick summary of the workbook statistics including the bounds of the sheet, tables, formulas and external connections. Look on Review | Proofing | Workbook Statistics in Excel 365 for Windows or Mac. There are details for the currently selected sheet and the whole
It’s possible to add a virtual background of your choice to a Microsoft Teams video call or just blur the background for a little privacy. Microsoft hastily added some virtual background options to Teams but the whole calling part of Teams is still woefully inadequate. For example, many of the
Transport for London knows some of us are missing our bus and tube journeys so they’ve made some virtual backgrounds you can use on Zoom, Teams or anywhere else that supports it. Or use as a background on a PowerPoint slide. Go to https://londonblog.tfl.gov.uk/2020/05/01/video-conference-backgrounds/ There’s ‘Sit in collection’, pretend you’re
We’ve updated our workbook that imports the latest COVID-19 statistics and combines with population data through Excel 365’s Stock Data Type. No technical changes in the workbook but we’ve added a few more ‘interesting’ or outlier countries. Plus some repeat help tips. Download COVID-19 Global Statistics workbook there’s also a
Adding a moving average line to an Excel Chart is very easy, just a few clicks, with many options. Any chart with a series of values over time will benefit from a trendline like a moving average. What is a moving average? An average / mean is a single value
It was only a matter of time before someone became so bored in the lockdown that they made a song about Microsoft Word. Ghetts, a British ‘rapper‘ (translation: singer/songwriter in the modern styling) has ‘dropped‘ (released) a song and video entitled ‘Microsoft Word’. As a boring white man in his
Section breaks are probably one of the most useful features in Word when you are formatting complicated documents. They allow you to change formatting aspects that would otherwise be the same throughout a document, such as page orientation, margins, columns, headers and footers. Column changes (2, 3 or more columns)
There are two ways to make Microsoft Word open with your preferred font ready to go. Just like with Two Ways to Change Word’s Opening Paper Size there are two ways to change the default or preferred font. Change the base Normal style or open the main Word template and
Nirsoft’s SearchMyFiles has received a major boost. It can now search inside Office documents and PDF’s. SearchMyFiles is the Windows search tool that should be included with Windows. It’s interface might be old-fashioned but all the options are visible, including some not available in Windows. Some of the highlights in
There’s big gap between the response of the Windows and Office parts of Microsoft to the coronavirus troubles. One team has understood the changed needs of customers and adapted; the other part of the same company is carrying on as normal and even taking advantage. Most people think that Windows
Microsoft has changed sentence spacing default setting in Word 365. Now the default is set at a single space at the end of a sentence, not two spaces. You can still choose your own preference or stop the checks completely. Single sentence space vis double spacing is one of those
Word numbered lists can do a lot more than simple 1, 2, 3 so here we’ll show you some better (1st, 2nd) and maybe unusual options (First Level, Second Place etc). All these and more are possible with Microsoft Word’s numbering plus a little knowledge and cunning. Numbering controls are
Format Painter in Office will work to copy formatting between shapes which is very useful for complex Gradients. But they don’t always format copy in the way you’d expect. We’re obliged to Office-Watch.com reader, Lorelei, for pointing out that Format Painter can copy gradient fills in most but not all
A pop-up message to Office 365 / Microsoft 365 says there are ‘more benefits’. Are there extra benefits in Microsoft 365 or is it more Microsoft hype? This dialog appears after an update to Office 365 …. Office 365 is now Microsoft 365 New Name. More benefits. Same price. Microsoft
Word has six shortcuts to make horizontal lines, here’s how they work, change them, color the lines and how to stop lines when they get out of control. All six line shortcuts There are six horizontal line shortcuts. For each one type the same character three times at the start
Microsoft is pushing video backgrounds to PowerPoint slides, but they really are a bad idea and should be banned from slide decks. Designer’s Design Ideas will start with a background video. Microsoft loves showing off these moving backgrounds because they impress people at demonstrations. Moving backgrounds are not a good idea because they distract the
Today (21 April 2020) is that day Office 365 becomes Microsoft 365. What does that mean to you and using Word 365, Excel 365, PowerPoint 365, Outlook 365 etc. A few weeks ago, Microsoft announced that ‘Office 365’ was becoming ‘Microsoft 365’ from today. There’s NO change in the software
Inserting live video into a PowerPoint presentation is possible in different ways. With online meetings and presentations all the rage, it’s natural that people would like to show themselves and their presentation at the same time. Either half and half screen (left) or some variation of video in box (right).
We’ve made a few changes to our COVID-19 tracking workbook for Excel 365. The kind comments from readers are much appreciated. For those of you who asked, it was made by our Editor-in-Chief, Peter Deegan, who is safely locked-down in London. Peter refreshed the COVID-19 statistics (which any Excel 365
Google Slides can be handy for sharing and working on presentations with other people, but sometimes you just really need that file in PowerPoint. No problem – it’s actually really easy to convert them. All you have to do is download the file and save it as a PowerPoint file. If the Google Slides File is Open If you have your
PowerPoint includes quick access to character spacing features that make slide titles stand out. In PowerPoint there are two useful features to make a slide title jump out at the viewer. Character Spacing is quickly changed on the Home tab. More subtle is Kerning. When it comes to Design, and clarity in Design, Space is almost as important
We’ve made a new version of our COVID-19 statistics workbook that’s compatible with Excel 365 for Mac. Keep track of COVID-19 statistics using this Excel spreadsheet that shows the latest cases and deaths for countries you choose and populations also added for you. Excel 365 for Windows has a separate
Some of the features and tricks in our COVID-19 worksheet for Excel 365. We’ve made this workbook as a practical and timely example of some important recent Excel features and how they can be used. Open up the workbook in Excel 365 for Windows and add some countries to see
Keep track of COVID-19 statistics using this automatically updating Excel spreadsheet that shows the latest cases and deaths for selected countries with populations also added for you. We’ve been a little annoyed at media coverage that deals with raw numbers without adjusting for population. We opened up Excel 365 and
