3. Custom Data Formats and Validation - Data Formats, Fill Series, Data Validation

The Advanced Excel Training videos covers the skills you need to have for certification as a Microsoft Office Specialist Expert in Excel 2016. To pass the Microsoft Excel Expert exam you will need to be able to complete the tasks that are demonstrated in this video. 2.1 Apply custom data formats and validation * Create custom data formats * Populate cells using advanced fill series options * Configure data validation