Dynamic array functions: excel filter function, the basics (Advanced filter with multiple criteria)
Excel dynamic array functions help to speed up work in excel and this this video we look at the basics of the filter function in excel. Learn an excel advanced filter method with this video. This dynamic and helpful function is available in Microsoft 365 and is an amazing function for easy filtering of data or pulling out data based on parameters. You can filter based on multiple criteria and don't have to mess around with absolute or relative reference. This function is one of the basic building blocks of dynamic Excel dashboards. This easy beginners tutorial will help bring your spreadsheet knowledge up to the next level.
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our playlist on inputting, viewing and managing data: • FREE Excel course for beginners: Week...
Or check out the following videos:
Advanced drop down lists with dynamic array formulas UNIQUE & FILTER: • Advanced drop down lists with dynamic...
Drop down lists: • Excel Basics: EXCEL DROP DOWN LIST - ...
UNIQUE function: • Video
XLOOKUP: • What is XLOOKUP and why is it a good ...
Named ranges: • Naming data in excel and how to use i...
Using named ranges and XLOOKUP together: • XLOOKUP & Named Ranges: use them toge...
