Using Microsoft Excel - Data Cleansing and Must know effective techniques

Learn data cleansing and effective techinques of MS-Excel within 2 hours.

Topics to be covered : 

Introduction to MS-Excel

1.Remove Extra Spaces

2.Replace Blank Space with Text

3.Convert Number Stored as Text to Number

4.Remove Duplicates

5.Split Text to Multiple Columns and Combine data from multiple columns to singe column

6. Deep dive with Text Functions

7. Restricting user to select data from List of Values

8. Vlookup and Hlookup Functions with examples

9. Match and Index Functions with examples

10. Pivot Table and Pivot Charts

 

Trainer is a Business Data Analyst with excellent Technical skills along with Communication and Presentation skills.