Excel Genius Class 4 : Tables and Data Validation
Excel Genius Class 4 : Tables and Data Validation
Description:
This Class will cover how to build and edit Tables, and how to write structured references that make function writing easier and more flexible. We will also cover data validation and build drop down lists in your spreadsheets.
Skills required:
Be able to Write functions
Understand Absolute vs Relative Cell References
Know how to navigate menu options in Excel
Prerequisites:
Beginner and Intermediate Excel, Excel Genius Class 3
Class Handouts: