Module 5: Working with Data
Sorting, filtering, tables, charts, and conditional formatting.
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Basic Tips for Working with Data
Learn how Excel helps you organize, sort, filter, summarize, and visualize large amounts of information efficiently.
Freezing Panes and View Options
Learn how to freeze rows and columns, split worksheets, and open multiple windows to compare data more effectively.
Sorting Data
Learn how to sort text, numbers, and custom lists in Excel. Master basic sorting, multi-level sorting, and logical ordering using the Sort dialog box.
Filtering Data
Learn how to filter lists and tables to show only the records you need. Use checkbox filters, search, text/number/date filters, and clear filters confidently.
Groups and Subtotals
Learn how to organize large datasets using grouping and automatically summarize data with the Subtotal command.
Conditional Formatting
Automatically highlight patterns, trends, and performance using Conditional Formatting rules, color scales, data bars, and icon sets.