Speeding it Up with Advanced Filters in Excel

Financial Modelling Meetup: Speed up your reporting processes with Advanced Filters and VBA

On June 23rd, 2020, I presented to the Financial Modelling meetup group in Sydney, organized by Danielle Stein Fairhurst.

I presented about Advanced Filters in Excel, a tool that will be useful mostly for those who do not have access to Excel For Microsoft 365.

If you’re working with large quantities of data, slicing, dicing, and extracting the information you need for reporting purposes can be a frustrating and time-consuming task. I showed how to reduce the time taken to build a summary report using Advanced Filters in Excel, VBA, and dynamic ranges.

Learn Excel and connect with a community of Excel professionals and enthusiasts: attend for FREE the amazing sessions organized by the MS Excel Toronto Meetup Group – https://www.meetup.com/MSExcelToronto/

Learn how to automate your Excel reports
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists
Check other posts about Power Query and Excel in this Blog,

About the Author: Celia Alves

Celia Alves is an awarded Microsoft MVP and Certified Excel Expert, specializing in building highly complex solutions combining VBA, Power Query, and Power Pivot to automate Excel reporting procedures. By combining her experience as an Excel Consultant and two decades as a Mathematics teacher, Celia created a training program to pass on her knowledge and techniques to those who want to stop wasting time in Excel with repetitive and meaningless tasks. Celia is also the founder and leader of the MS Excel meetup group in Toronto, with over 3,000 members worldwide.