How Home Working Can Help Your Business to Remain Healthy During the Coronavirus Crisis
If your workplace had to close due to the Coronavirus crisis, would your organisation be prepared? Fortunately, it’s now easier than ever to work remotely using tools in Office 365 and G Suite, such as video conference calls, online apps and Cloud-based file storage.
Reddico’s Journey into a Self-Managing Organisation
Inspired by the Happy Manifesto, Reddico started the move to becoming self-managing in March 2018. In just 18 months it has resulted in happier employees, more satisfied customers, higher revenue and a big increase in profits.
Henry Stewart spoke to Head of Operations Luke Kyte to learn how Reddico achieved this.
5 Tips for a Blissfully Easy Office 365 Roll Out
If you’re reading this, you’re probably involved or soon to be involved in rolling out Office 365 to your organisation. Whether you are setting Office 365 up yourself or liaising between your users and your IT consultants we have a few tips to make the process go as smoothly as possible.
Save Time in Excel with Autofill
Autofill is one of our favourite Excel tools for saving time. In this two-minute video, Nicky explains how you can use Autofill when creating a small budget spreadsheet from scratch so you hardly have to type a thing!
Public Course Dates for Google Sheets Now Live
We have had lots of requests for Google Sheets, as many organisations (particularly charities and public sector) have made the switch to GSuite from Office 365.
How to Make Human Resources More Human
Tracey Waters is focused on improving employee experience at Sky UK. She has implemented two new practices: design thinking and agile methodology. The two processes compliment each other — design thinking is about problem finding, while agile is about problem solving.
In this full-length video from the 2019 Happy Workplaces Conference, Tracey explains how these two methodologies work together.
How to Extract First Names from Full Names in Excel Spreadsheets
If you are creating a Mail Merge using an Excel spreadsheet, this trick may help you. Often when downloading your data from your Client Relationship Management software or similar into a spreadsheet ready for a Mail Merge, you will find that both the first and last name are in the same column. In this blog, Henry explains how you can easily extract this information into two columns. Get in touch 020 7375 7300 Send us a message hello@happy.co.uk I seem to be sending a lot of merged emails lately and the source file for those emails generally contains the full name and the email, but not the first name. This is tricky as it is always nice to be able to say Hi Rosie, rather than just Hi or Hi Rosie Shepherd. And you can, because extracting the first name is fairly easy: Find the first space Step 1 is to find where the first space occurs, as this will normally be the end of the first name. Use the FIND function, which finds a character – or set of characters – in a cell, for this. This example finds the first space in A2: =FIND(“ “,A2) You can use the same technique for extracting first names from email, if the email format consists of firstname.surname@. In that case you search for the first full stop. Use the first space to find the first name You can then use the LEFT function, which takes the left most characters in a cell. Assuming here that the @FIND function has placed the position of the first space in C2. =LEFT(A2,C2-1) It is -1 because you don’t want to include the space itself. You can combine these two into one function like this: =LEFT(A2,FIND(“ “,A2)-1) What if some people have only entered a first name? If there is no space because they have only entered their first name, the above function will result in #VALUE! appearing. This can be fixed using the ISERROR function, which allows you to specify what happens if this function results in an error. We are assuming that the error results from there being only one word (the first name) in the name cell. So: This results in this function: =IF(ISERROR(FIND(” “,A2)),A2,LEFT(A2,FIND(” “,A2)-1)) If looking for a space in A2 results in an error, display A2. If there is a space, take all the characters up to the space. This function will work, as long as nobody has put Mr or Professor or similar in front of their name. And it also relies on the first name coming first, which isn’t true in all cultures.
How Sky UK’s HR Department has Embraced Design Thinking
At Sky UK, they have embraced Design Thinking to tackle common HR issues. Design Thinking is a methodology that provides a solution-based, human approach to problems. It aims to create multiple ideas during brainstorming, which can then be prototyped and tested in a empathetic way that people can easily understand. For Sky, in the final stage, they test people’s reactions and gauge if it ‘wows’.
In this short video from the 2019 Happy Workplaces Conference, Tracey Waters explains how they applied Design Thinking to the question ‘how might we help people at Sky have a fulfilling career?’
The Pursuit of Joy at Work at Happy
Cathy Busani’s goal for the staff at Happy is that they experience joy in at least 80% of their work.
In this video from the the 2019 Happy Workplaces Conference, Cathy explains how she aims to achieve this by focusing on strengths-based working — asking staff to think about what they are great at and seeing how they can incorporate it into their day-to-day working.
What Would Your Team Be Like if Everyone Was Working to Their Strengths?
At Happy, we use the Strengths Finder by Marcus Buckingham to find out what each team member’s strengths are. In each team, everyone shares their strengths and the tasks that they enjoy doing the most to ensure that everyone can work to their strengths as much as possible. What would your team be like if everyone was working to their strengths? How much more productive would they be?
In this short video from the 2019 Happy Workplaces Conference, Cathy Busani, Happy’s Managing Director, explains the benefits of working to your strengths.
