
Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.

Building A Solid Data Cleaning Architecture: Guided Walkthrough
How does an Excel pro in 2026 turn messy data into a clean, reporting ready dataset? They design a complete, repeatable system. Modern Excel expertise isn’t just knowing formulas, it’s understanding how Excel works in the real world. Importing messy…

Excel’s New Functions Are Changing How We Work (2026 Guide)
Most of us learned Excel ages ago, and haven’t done much new since then – this goes for businesses and workers. For a very long time, most workplaces used Excel in more or less the same way. SUM formulas, VLOOKUPs,…

REGEXTEST: Checking Your Regex Works In Excel
Regex is one of the most powerful additions to modern Excel, but it has a real learning curve to it! Sometimes you’ll write what looks like the perfect patten, just to realise it isn’t doing what you expected. When you’re…

Online vs Classroom Excel Training – Which Format Should You Choose?
When it comes to improving your spreadsheet skills, the question isn’t just which course to take, but which format to learn in. Excel is at the centre of so many businesses, and selecting the right delivery will make a big…

Using REGEXEXTRACT To Pull The Exact Data You Need
If you’ve used Excel with data exported from a CRM, you’ll know it doesn’t ever come the way you want it to! Order references get mixed up with descriptions, IDs get buried inside notes, and codes sit inside brackets or…

Regex in Excel & REGEXREPLACE
Microsoft has quietly been adding regular expression support to Excel, also known as regex. Instead of building up a few different text functions on top of each other, you can now use regex inside Excel formulas to search for patterns,…

Best Excel Course In London (How To Actually Choose One!)
Search for “best Excel course in London” and you will get a dozen providers, all claiming to be the very best. In reality though, there isn’t just one best Excel course in London. When picking a course, you have to…

Excel’s New IMPORT Functions Explained – 2026
Microsoft just added some brand-new IMPORT functions, designed to make bringing external data into Excel easier! Instead of digging through menus or writing your own queries, you can now just use these new formulas, IMPORTTEXT and IMPORTCSV. Importing data is…

Acuity Training vs Happy – Best Excel Training Provider in 2025
This guide compares Acuity Training and Happy’s Excel courses in London, reviewing accreditation, trainer quality, course structure, pricing and support to help professionals choose the best provider for 2025. How To Choose A Training Provider For You Or Your Team…

A Buyers Guide To Excel Courses In London
London is a great city – especially for people looking to learn something new. Excel is no different, but there are so many great courses here! That’s why we made this breakdown of the best Excel courses in London, to…

Building A Decision Model In Excel
We all know that Excel is an amazing tool to organise, calculate, analyse and visualise data. Experiences users know you can combine all these features to help make decisions! It can help you compare between different options, test assumptions you…

Excel Training for Beginners – Where to Start
Learning Excel can feel intimidating at first: endless rows, formulas, ribbons, and features everywhere. But here’s the good news: anyone can master Excel with the right structure and teaching. Whether you’re completely new to spreadsheets or just looking to get…
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/