Could some Excel training save you £700 million?
Excel use can be optimised so that your team is able to better use Excel or Google Sheets, saving you money in the long run!
5 tips for using Canva effectively
Canva is an online tool for graphic design for people who aren’t graphic designers. It has taken the internet by storm in the last few years, and has expanded from just social media posts to presentations, video, whiteboards, and even spreadsheets. There are so many features within Canva it can be a little overwhelming. Here are our five top tips that you might not know about that will save you time when creating your next design.
How to add up a list of numbers in Excel with Autosum
Did you know that there is a faster way to add up numbers in Excel? One of the best features of Excel is how you can use calculations (or formula) to save time. In this quick two-minute tutorial, Nicky shows you how to add up a list of numbers with just a few clicks using the Autosum formula.
Tips and tricks to transition away from Skype
If you have been using Skype, you’ll have noticed the giant warning at the top of the program, stating that Skype is closing on 5th May 2025.
After this date, which is coming up quickly, you will no longer be able to use any of the Skype features. It’s time to start transitioning to a new platform, especially if you work from home and use Skype.
How to Understand and Use AI to Your Advantage
Everyone is talking about AI at the moment, and it can be daunting. Whether you’re completely new to terms like ‘Large Language Model’ and ‘GPT’, or you just want to ensure that you know how to get the most out of the available tools, Happy is here to help.
You might be thinking “I don’t understand AI” or “I don’t need AI!” and that’s entirely understandable but you might benefit from it far more than you’d think. ChatGPT and similar tools can be great for things like getting writing prompts, summarising documents and e-mails and many other tasks.
In this blog, Ben demystifies some of the riddles of AI and explains how it can be used to help you in your day to day work.
How Power BI Can Help You Create Reports Quickly and Easily
We all want to get the most out of our data – to really dig deep into the numbers so we can make informed business decisions. How do you find new opportunities? How do you know where to divert your resources?
In Excel, this can be a minefield – having to copy and paste data from different sources, then tweak it so it displays correctly, and then running dozens of functions to get the right information. And that’s not counting on the time needed to then create graphs and charts so that you can visualise it and spot trends!
What if there was an easier way? In this blog, Ben explains how Power BI can help you to create these reports quickly and easily.
How to Copy Formulas in Excel Using Absolute Cell References
When copying formulas in Excel, you’ll find that sometimes it works and sometimes it doesn’t. The key to making sure your formulas work every time is Absolute Cell References. This makes sure that your formula uses the same cell reference each time — wherever it is copied to.
Learn how to create an Absolute Cell Reference in this video with Senior Facilitator Gill — understanding how to use Absolute Cell References will allow you to confidently and efficiently expand on your Excel skills!
XLOOKUP Made Easy: Simplifying Complex Data Searches in Excel
XLOOKUP is a new feature in the latest version of Excel. It means you’ll no longer need to use either VLOOKUP or Index and Match, as it’s a much more powerful and accurate tool. It also allows you to use Wildcard characters such as * or ?, which means you can match parts of a string or account for misspellings.
In this two minute video, Gill explains how to use XLOOKUP with an example scenario.
How to Combine Multiple Answers Into One Column With CONCAT
If you had multiple records across different columns, how would you combine them into one? Rather than having to do this manually, you can use the CONCAT function. Find out how it works in this short blog by Happy’s Chief Happiness Officer, Henry Stewart.
