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.
As well as helping you to work more efficiently, keyboard shortcuts can be easier than using a mouse or touchscreen, especially to those who have mobility or vision disabilities. And what would you do if your mouse stopped working? In this week's blog, Edmund will introduce you to six keyboard shortcuts that you may not know about in Excel for both Windows and Mac.
Usually we refer to cells in Excel by their range names, such as A1. This can make deciphering formulas difficult, especially when working with spreadsheets that other people have created. In this 2 minute video, Nicky explains how to create Range Names to make your formulas more meaningful.
With Outline view in Microsoft Word and PowerPoint, you can quickly and easily create a short summary of the content of your document — without the need to type it out again. In this blog, Edmund explains the benefits of Outline view and how to do it.
Many of us are familiar with copy and paste (Ctrl + C and Ctrl + V). But how many other keyboard shortcuts do you know? In this week's blog, Fenella explains five Excel shortcuts that you never knew were there, such as the shortcut for the Autosum function and moving around sheets — and which will save you time when working.
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!
Before spring 2020, many of us may not have heard of Microsoft Teams — but it's now become a household name. With Teams, you can keep your files, conversations and video meetings all in one place, making remote working so much simpler. Microsoft has been adding new features to the application throughout the course of the year in order to make the software more immersive, flexible and convenient. In this blog, Billy highlights a range of Teams’ latest innovations, which are designed to both enhance user experience and improve productivity in our 'new normal'.
While those of us who have been working on computers for years could adapt to MS Teams with very little difficulty, we shouldn't neglect our colleagues whose roles previously required little or no IT knowledge. In this blog, Darren looks at how a simple application like Teams is not always so simply explained to newcomers.
If you are creating a Mail Merge, make sure that the first and last names are in different columns in your Excel spreadsheet using this handy tip.
How often do you struggle to find an email that you need in Outlook? In this short 2 minute video, Nicky explains how you can use the search tools in Outlook to speed up finding emails in your inbox. These handy tools search all folders, and allow you to enter in as much information as you remember about the message.
If you use SharePoint at work, you might be missing being able to manage your files using Windows Explorer or the File tab in your applications. In this short video, Rachael explains how you can Sync your SharePoint Libraries so that you can browse, copy and paste your files just like you are used to.