POSTPONED - One Day Workshop on Data Analytics (Physical)
This workshop is postponed. New date will inform shortly.
Venue : ITT Lab, ICAI Bhawan, Bibwewadi, Pune
Title: Automating data preparation tasks in Excel without VBA
Speaker/Trainer :- CA. Abhay Gadiya
Topics covered:
• Introduction to Power Query
• How to get data inside power query
• Importing data in Excel using power query - excel, csv, text, etc.
• Excel files -
○ Single sheet or table
○ Multiple sheets or table from single file
• Multiple files - excel or csv
• In built formulas in ribbon - text, date, math, etc.
• Merge multiple datasets
• GST reconciliation
• Case studies
○ Payroll Data
○ Financial Data
○ Stacked datasets
• Fraud tests
○ Check Duplicates
○ Check missing
○ Fuzzy matching
Pre-requisite:
1. Excel 2016 or later
2. Should know about SUMIF, VLOOKUP, Pivot Table in Excel.
Topics covered:
• Introduction to Power Query
• How to get data inside power query
• Importing data in Excel using power query - excel, csv, text, etc.
• Excel files -
○ Single sheet or table
○ Multiple sheets or table from single file
• Multiple files - excel or csv
• In built formulas in ribbon - text, date, math, etc.
• Merge multiple datasets
• GST reconciliation
• Case studies
○ Payroll Data
○ Financial Data
○ Stacked datasets
• Fraud tests
○ Check Duplicates
○ Check missing
○ Fuzzy matching
Pre-requisite:
1. Excel 2016 or later
2. Should know about SUMIF, VLOOKUP, Pivot Table in Excel.
Event Information
| Event Date | 19-12-2021 10:00 am |
| Event End Date | 19-12-2021 5:00 pm |
| Cut off date | 19-12-2021 8:00 am |
| Individual Price | Rs.1500/- Plus GST |
| CPE Credit Hrs | 6 Hrs. |
