Microsoft Excel

If you work near Liverpool Street or commute through it, you have more options for Excel training than you might realise, and the differences between them are worth understanding before you book. This guide covers where to find Excel training…

Running Excel training courses across London, Guildford and Manchester means we think about device security differently to most companies. Every week, dozens of learners from different places sit down at our machines across the country and spend the day working…

If you’ve ever built a summary table in Excel by writing five separate SUMIFS formulas – one for each region, product, or department – you’ll appreciate what GROUPBY does. It collapses all of that into a single formula that updates…

Managing a spreadsheet with product images, staff photos, or visual data has always been awkward. You insert a picture, it floats over the cells, refuses to stay where you put it, and the moment anyone resizes a column the whole…

We run Excel workshops in London every month, so we get to spot a lot of trends on how users use Excel at their jobs. There are countless project managers and finance assistants all over the UK building summary dashboards,…

For years, Power Query was one of the main reasons Excel users couldn’t fully move their work to their browsers. You could view query results in Excel for the web, but if you needed to actually build or edit a…

Excel formulas can get complicated quickly. A simple calculation can quickly turn into multiple steps, and pretty soon you’ll be repeating the same logic again and again to get a final result. The LET function allows you to assign names…

When we think about Excel pros, what do we think of? Complicated spreadsheets and complex formulas. But in a professional environment, it’s often the complete opposite. The best spreadsheets rely on clear logic being broken down piece by piece. This…

Whether it’s delegates, trainers, or consultants – I spend a lot of time with Excel users! And to be honest, I see a lot of the exact same habits cropping up again and again. They slow people down, make spreadsheets…

PivotTables are a classic, powerful tool in Excel. They are a great way to show you really understand Excel, and it’s more powerful tools. You can summarise and group data in just a few clicks, but they’re also a little…

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…