Manage Your Data with Excel
Excel’s data management capabilities allow you to import data from external sources, sort and filter data, apply data validation rules, analyze data, and create reports and pivot tables.
Manage Your Data in Excel
- PC and Mac: Overview of Excel Tables Links to an external site.(External resource)
- Mac: Create an Excel Table Links to an external site.(Video 5m 11s)
- Mac: Sort Worksheet Data Links to an external site.(Video 4m 10s)
- Excel: Data Management Live Training Links to an external site. (PSU resource)
Import Data from External Sources
Locating Data in Excel with VLOOKUP
- PC: VLOOKUP Links to an external site. (Video 8m 22s)
- PC: VLOOKUP and XLOOKUP Comparison Links to an external site. (Video 2m 28s)
- PC: Look Up Data Using XLOOKUP(), VLOOKUP(), HLOOKUP(), INDEX(), and MATCH() Links to an external site. (Video 7m 19s)
- PC: Finding Approximate Matches with VLOOKUP and HLOOKUP Links to an external site. (Video 5m 2s)
- PC: Using VLOOKUP to Find Exact Matches and Search Large Tables Links to an external site. (Video 5m 5s)