Related Courses
Excel : Data Tools and Data Management
£299.00
Course Curriculum
| Basic Excel Data Tools and Data Management | |||
| Introduction | 00:03:00 | ||
| Project Files | 00:00:00 | ||
| Data Validation Rules to Prevent Bad Data Entry | 00:09:00 | ||
| Drop Down Lists for Easy Data Entry | 00:06:00 | ||
| Custom Validation Messages and Alerts | 00:06:00 | ||
| Splitting Data into Different Columns by Delimiter | 00:04:00 | ||
| Splitting Data of a Fixed Width | 00:03:00 | ||
| Easily Remove Duplicate Rows from a List | 00:04:00 | ||
| The Incredible Flash Fill Tool | 00:08:00 | ||
| Goal Seek – How to Reach the Result you Want | 00:06:00 | ||
| Data Tables – Test Multiple Values Impact on a Formula Result | 00:07:00 | ||
| The New Rich Data Types in Excel | 00:06:00 | ||
