In this module, we will learn how to work with large data sets, including
1. Utilizing filters and autofilters
2. Locking of cells
3. Hiding/unhiding rows/columns
4. Sorting Data
5. Freezing and unfreezing rows/columns
6. Find & replace.
The skills you will learn in this will provide the ability to manipulate and manage large worksheets and tables.
Vocabulary
1. Filter – a feature that displays only the rows that meet the criteria that you specify and hide rows that you do not want to display
2. Autofilter – filter that automatically chooses what to display and/or how to order the rows
3. Lock – to prevent cells from modifying
4. Hiding – to hide from the viewer certain cells (they still exist, just hidden away)
5. Freezing – prevent cells from moving when scrolling through a large excel sheet
6. Find & Replace – tools necessary to find certain keywords and replace them.