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.

New Features Added to Office 365 in April 2020

New features are regularly added to Microsoft Office 365’s assorted apps to improve user experience. The updates are so frequent that even regular 365 users won’t necessarily be up to date with all the new additions.

In April 2020, new features included the ability to drag relevant emails into a group mailbox. Find out more about this and the other newly added features in this blog.

Five Good News Stories From the Past 12 Months

It’s been a tough 12 months. In 2019, the UK has had a lot of change — Brexit, a change of Prime Minister and then a general election. In winter, the UK suffered from severe flooding, and now, in spring, we are currently on lockdown due to Coronavirus (COVID-19).

However, there is hope in this dark time. In this blog, Billy looks at five good news stories from the past 12 months that you may have missed.

How to Use Flash Fill in Excel

Flash Fill is one of the best tools in Excel – but not many people know about it! This feature is available from Excel 2013 onwards.

Learn how it works in this two-minute video.

How to Maintain Resilience in a Time of Crisis

The Coronavirus (COVID-19) outbreak will affect all of us for months to come and combating it requires cooperation on a mass scale. If you’re feeling overwhelmed, don’t be hard on yourself. We’re experiencing something genuinely unprecedented. But we can take certain actions to avoid a mental health deterioration equivalent to the current biological and economic woes.

In this blog, Billy outlines four ways that you can maintain your resilience during this stressful period.