New Features Added to Office 365 in July 2020

New features are regularly added to Microsoft Office 365’s assorted apps to improve user experience. These updates are so frequent that even regular 365 users won’t necessarily be aware of all the new additions.

In July 2020, this included allowing users to control their PowerPoint presentation using Microsoft’s Surface Earbuds. Find out more about this and the other newly added features in this blog.

How to Use the Quick Analysis Tool in Excel

Quick Analysis is one of the features introduced in Excel 2013. It allows you to visually spot trends and information in your spreadsheets, with just a few clicks. This is a really simple trick that even those of you brand new to Excel will be able to use.

In this video, Nicky will show you how to use Quick Analysis and some of the Formatting tools – and how to clear it if you don’t want to see the information anymore.

6 Easy-to-Use Services That Will Improve Your Work-From-Home Experience

People making the transition into working remotely will be pleased to know the technology for seamless remote working is readily available.

You’re probably familiar with a number of leading services already, as even companies that don’t promote flexible working models have augmented their workspaces with various apps.

In this blog Billy explores 6 easy-to-use services that will improve your remote working experience, that you may not have heard of.

How to Quickly Update All of Your PowerPoint Slides at Once

Master Slides enable you to update all of your PowerPoint slides in a presentation at once. This ensures that all of your slides have the same formatting, making your presentation look more professional and consistent.

In this short video, Nicky explains how to update your Master Slides, including the background, font and text size.

What’s New in Office 365 in June

New features are regularly added to Microsoft Office 365’s assorted apps to improve user experience. The updates are so frequent that even regular 365 users won’t necessarily be up to date with all the new additions.

In June 2020, some of these new features included allowing users to make private annotations on Word files in MS OneDrive and to share links to specific slides in PowerPoint presentations. Learn more about these and other newly added features in this blog.

How to Speed up Using Autosum in Excel

Did you know that there is a shortcut for the Autosum formula in Excel?

In this short video, Nicky shows you how to use this great timesaver, both for simple and more complex spreadsheets. You can even use Autosum on the whole table at once!

How to Turn Off New Email Alerts in Outlook so You Can Focus

Did you know that when you are interrupted, it takes an average of 5 minutes to get back to the same level of concentration you had before? The worst culprit for interruptions are email notifications. We recommend that you only check your email three times a day, or only after you have completed a task.

In this short video, Nicky explains how you can turn off that distracting email alert in Outlook so you can focus better and be more effective.

How to use XLOOKUP in Microsoft Excel

XLOOKUP was introduced in the latest version of Excel, and is a fantastic new upgrade on VLOOKUP.

In this blog, Darren explains why you should use XLOOKUP instead of VLOOKUP, and how to use this new feature.

New Features Added to Office 365 in April 2020

New features are regularly added to Microsoft Office 365’s assorted apps to improve user experience. The updates are so frequent that even regular 365 users won’t necessarily be up to date with all the new additions.

In April 2020, new features included the ability to drag relevant emails into a group mailbox. Find out more about this and the other newly added features in this blog.

How to Use Flash Fill in Excel

Flash Fill is one of the best tools in Excel – but not many people know about it! This feature is available from Excel 2013 onwards.

Learn how it works in this two-minute video.