The process of cleaning and transforming data is central to executing various tasks that are performed in excel , be it pivotable creation of a formula, charts, analytics and more. On the next excel workshops, we attempt to look at ways to fix data problems caused by Transfer Errors, Human Errors and Technical errors.
Transforming Data Bundle
This bundle consists of the following modules:
- Module 1: Clean raw data
- Module 2: Transform and load data using Power query Part 1 (Excel 2016 and later)
- Module 3: Transform and load data using Power query Part 2 (Excel 2016 and later)
- Module 4: Tips to prepare data for Charts
- Module 5: Tips to prepare data for Pivotables