Advanced MS Excel 2016 Training

Module 4 : Advanced Data Tools (1 Hours)

In this module, you will learn how to work with advanced data tools.This module covers topics on advanced data tools like converting text to columns and data validation. It also discusses how to implement what-if tools. .
● Text to Column
● Data Validation
● What-If Analysis
● Duplicate Removal
● Data Sanitation through excel – Sorting, Filtering