This hands-on course is intended to teach employees advanced features of Excel, including the following topics. Completion of Excel: Introduction or similar familiarity with Excel is strongly encouraged.
Learn list and table design techniques, as well as procedures to sort, filter, and validate data. You will also learn to use formulas in lists and tables, remove duplicate records, and use the subtotal and outline features.
- What Is a List?
- What Is a Table?
- Designing List and Table Data
- Formatting a Range of Cells as a Table
- Working with Table Styles
- Freezing Panes
- Expanding a Table
- Keyboard Shortcuts to Select Table Data
- Using Formulas in Tables
- Sorting Data
- Filtering Data
- Removing Duplicate Records.
- Validating Data
- Converting a Table to a List
- Subtotaling Data in a List