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.
The Curious Case of Teams and Unconscious Competence

As the year draws to a close, thoughts naturally turn to the word of the year. If we narrow our scope to the workplace, “Teams” has to be high on the list.
But 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 those 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.
How to use XLOOKUP in Microsoft Excel

XLOOKUP was introduced in the latest version of Excel, and is a fantastic new upgrade on VLOOKUP.
In this blog, Darren explains why you should use XLOOKUP instead of VLOOKUP, and how to use this new feature.
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.
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.
How to Create a SharePoint System That Will Help You Work Smarter

“My manager just wants one simple library with all the folders from our server just copied across.”
We hear this all the time! So often a manager will hear or read how the competition is making great use of SharePoint and will ask for a library to be set up, without fully understanding its potential.
In this blog, Darren gives five top tips to help you create a SharePoint 365 system that will help your organisation collaborate better, improve processes and work smarter.
The Mystery of the Humongous Excel File

My colleague Rachael sent me an interesting email today. She had tried to send one of our usually svelte Excel exercise files to a trainer, only to find that the file had grown from a perfectly reasonable 108KB to a frankly shocking 30MB!
Five Reasons to Try Live Online Interactive Learning Solutions
I’m sure we all know how important it is to invest in training and developing your people. Without regular investment, you’ll not be realising maximum value from your most expensive asset. It also goes without saying that in these times of austerity and challenge, training budgets are coming under ever more pressure.
So how do you ensure your people get involving, meaningful and work-relevant training that you can afford?
How to Choose the Right Chart in Excel
Why are the right charts in Excel so important?
The wrong Excel chart can not only lead to confusion but may lead to the wrong decisions being made. Which should you use?
Happy’s expert trainer Darren Andrews explains more in this blog.
Assumptions, Guesses and Pivot Tables: From Data to Discovery

How well do you know your business? Do you know how well you’re doing? What your costs are? How happy your customers are? How happy your staff are?