This Week’s Tip : Microsoft Excel – The FILTER Function

Microsoft Excel – Working with the FILTER Function

DID YOU KNOW … that using the FILTER Function in Excel automatically updates when your source data changes? If you add, remove, or edit data, the filtered results refresh instantly, no need to reapply filters manually. It’s much more efficient than using the traditional filters or copying filtered data.

Here’s 3 good reasons to use the new Filter Functions in Excel:

1. No clicks, dropdowns, or manual steps
2. Great for dashboards and reports
3. Keeps everything formula-driven and consistent

To learn more, click the play button below to get started.

This lesson is part of our CPD Accredited Excel 365 – Master Course

Our Weekly Tips are delivered via email every Tuesday. Learn something new every week – in Bite Size bites of learning.  To sign up to our Weekly Tip Newsletters – sign up here

Take a look at our Microsoft Office Courses – available within our E-Learning Library and as Virtual Classes.

Spring into Action – with our Microsoft 365 Training Solutions

eLearning Library – Three Month Taster – start anytime

Deliver our SCORM CPD Courses on your own Learning System

Virtual Classes – 3-hours or full days – tailored for your organisation

Copilot Workshops – Full and 1/2 days – delivered virtually on Microsoft Teams

Power BI Workshops – from Intro to Advanced – delivered virtually on Microsoft Teams

Let’s have a conversation to see how we can help.  Get in touch.