Here you can find all of Happy’s blog posts, covering our Excel hints and tips, ideas for creating happy workplaces, and ways to be more productive at work — and more.
Microsoft's Office 365 suite includes OneDrive, your individual storage area. Your files are stored securely on the Cloud, so you can access them anywhere. This also means you can easily collaborate and share your files with your colleagues - in this short video, Rachael explains how.
Pivot Tables are a fantastic way to make sense of complex tables of data. In this two-minute video, Nicky explains how your Pivot Tables can show group your data by Month and Year with just a few clicks.
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.
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.
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.
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.
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.
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!
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.
The new XLOOKUP feature in the latest version of Microsoft Excel spells the end of the VLOOKUP function. In this blog, Darren explains why you should use XLOOKUP instead of VLOOKUP, and how to use this new feature.