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.
2016/2019 Working with Data - Bundle
This bundle consists of the following modules:
2016 / 2019 Set up data correctly
2016 / 2019 Clean existing data
2016 / 2019 Transform and load data using Power Query
2016 / 2019 Additional Power Query Features