Advanced Filtering in Excel

Learn how to use Excel’s Advanced Filtering to filter for otherwise impossible scenarios. Be sure to download the practice file so that you can follow allong. https://student.powerconcepts.ca/resources/view/1783533290538-aa908729e0b902c6

Benefits of tables

When working with many sets of data it is wise to turn them into tables. This video shows how to turn it into a table and then some of benefits including automatically appending columns and rows, auto fill formulas, sorting and filtering in numerous ways. Download the file from here. https://student.powerconcepts.ca/resources/view/1781816653663-88c14a952df93181