CLASS 4 Excel

Chapter 4: Data Management

Aim

Learn to manage and organize data in Excel.

Content

Sort and filter data

How to sort data in ascending and descending order.
How to apply filters to display specific data.
Using tables in Excel

How to create and format a table.
Advantages of using tables in Excel.
Introduction to search functions

VLOOKUP: =VLOOKUP(value, range, column, [sorted])
HLOOKUP: =HLOOKUP(value, range, row, [sorted])
Practical exercise

Create and manage a data table.