Extract Data

7 lessons in order

Learn how to pull data from multiple Excel worksheets into one using Power Query, VBA code, or the built-in Consolidate feature.

Learn multiple ways to extract data from a table in Excel using FILTER, SUMIFS, XLOOKUP, Power Query, and advanced formulas.

Learn how to extract month and day from a date in Excel using functions like MONTH, DAY, TEXT, CHOOSE, SWITCH, and Power Query.

Discover how to pull data from another sheet in Excel using VLOOKUP, INDEX & MATCH, FILTER, XLOOKUP, and Power Query based on criteria.

Learn how to extract the year from a date in Excel using YEAR, TEXT functions, cell formatting, and the Text to Columns feature.

Learn how to get data from another sheet in Excel using INDEX/MATCH, VLOOKUP, INDIRECT, HLOOKUP, and Advanced Filter methods.

Learn how to pull the same cell from multiple sheets into a master column in Excel using INDIRECT, Consolidate, and 3D references.