Make the Most of Office 365’s Latest Updates
One of the perks of being an Office 365 subscriber is Microsoft’s regular unfurling of new features and updates for the software’s constituent apps (Access, Excel, OneNote, Outlook, PowerPoint, Project, Visio and Word).
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.
3 Top Tips to Take Your MS Teams Meetings From 0 – 100%
I want to show you three mind-blowing MS Teams Meeting tips that are now an unconscious standard practice in my working day. It has helped me work in a better way when I use MS Teams to host meetings/training sessions, let’s hope it helps you work better too.
Would You Like Excel to Use AI to Write Formulas For You?
AI is big news at the moment, and it is going to change the way we use software forever. Microsoft is adding Copilot to Microsoft 365, and we’re seeing the first hints of what it can do.
Copilot will offer AI driven help to all parts of Microsoft 365, from helping you manage your email inbox, to refining a report and polishing a PowerPoint presentation and, yes, even write Excel formulas for you!
This type of AI-driven help has been turning up in Microsoft products for some time, especially in Excel. But how does it work? Darren explains more in this blog.
How Asana Can Improve Productivity and Collaboration in Your Team
Asana is a user-friendly work management tool. Using Asana, teams or groups of people can organise their work, keep track of their progress and manage projects easily. In this blog, our IT expert Gill explains why she likes to use Asana for project management, and how Asana can help to improve your team’s productivity and collaboration.
How to Compare Lists of Data and Find Differences in Excel
Do you need to compare information in different lists? For example, you may need to find out which values exist in two lists and highlight differences.
There are several ways to compare two sheets or even workbooks in Excel. You can use functions like EXACT, IF, Lookup or Conditional Formatting to compare lists of data. In this blog, Happy’s trainers Sal and Ebbie will use Conditional Formatting to highlight values in one list that do not appear in another list.
