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! :-)

Or check out the following videos:

[MilhouseBS]

Nice tips on making tables when selecting columns. Volume seemed low, I had to turn up my volume.