Microsoft 365: Excel Learning Path
Manage Your Data with Excel
Skip To Content
Dashboard
  • Login
  • Dashboard
  • Calendar
  • Inbox
  • History
  • icon-inbox
    Notices
  • Help
Close
  • My Dashboard
  • Microsoft 365: Excel Learning Path
  • Pages
  • Manage Your Data with Excel
2218 - 202122FA
  • Home
  • Modules
  • Library Resources

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

  • PC and Mac: Text Import Wizard Links to an external site. (External resource)
  • PC and Mac: Tutorial: Import Data into Excel, and Create a Data Model Links to an external site.(External resource)
  • PC: Import TXT Data into a New or Existing Workbook Links to an external site. (Video 4m 35s)

 

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)

 

Previous
Next
Requirements Changed
Previous Module:
Create and Store Excel Files
Sort and Filter Your Excel Data