News & Tips

Sample data alongside GROUPBY analysing it quickly

Excel’s GROUPBY Function: What It Does & When to Use It

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…

Excel’s IMAGE Function: Put Pictures Directly Into Your Cells

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…

Power BI Statistics You Need To See (2026)

Power BI continues to dominate the analytics and business intelligence market. From small businesses, to the biggest conglomerates in the world – Power BI is the go-to software. As a Power BI training company, it’s important we stay on top…

SUMIFS adding up only the data for the IT department

SUMIFS for Budget Reporting: Build A Summary Dashboard Without Pivot Tables

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,…

Higher quality output from a more specific prompt

Copilot In Microsoft Edge – Research Workflows

Most people know Copilot as the amazing assistant inside Excel or Teams. What far fewer people use (or even know exists!) is Copilot built directly into the Edge browser itself. For anyone whose job involves researching information, reading reports, comparing…

Shows all the different data sources Power Query can use

Power Query in Excel for the Web: What’s Changed

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…

Copilot Studio – Building A Useful Meeting Agent

If you’ve been playing around with Copilot in Excel, Outlook, or Teams – you’ll know this: It’s incredible at drafting and summarising… But it doesn’t always do something practical. Copilot Studio and agents is where that all changes. Instead of…

Shows copilot evaluating its own formula

Using Copilot To Generate Formulas In Excel

Writing formulas is one of the most useful – but also the most frustrating – parts of working with data. Even when you know exactly what you need to calculate, it still takes time and knowledge to: Build the logic…

Input Slicer in Power BI – Filter Long Lists Fast!

Filtering large lists in Power BI should not feel like scrolling endlessly through hundreds of dropdown values. The Power BI input slicer makes filtering faster and smarter by allowing users to type or paste values directly into a slicer. Instead…

Power BI Filter Context – How Measures Really Evaluate

Filter context is one of the most important and most misunderstood concepts in Power BI. It is also the reason a single measure can return different values depending on where it appears in a report. This article is written for…

Shows a more complex LET function that does several calculations all in one

Excel’s LET Function: The Secret Juice In Excel

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…

Copilot vs ChatGPT – Which Should You Use at Work?

AI is an incredibly competitive market, with every tool trying to get your attention and business. Copilot vs ChatGPT, which is better, which should you use? But framing the argument like this misses the point and ends up making you…