Pre-requisite: Participants must have good knowledge of intermediate Excel features like functions, conditional formatting, pivot tables etc.
Hardware & Software Requirement : MS Windows 7/8/10, MS Office 2013/2016 Excel with Power Pivot, Power View, Power Map Add-ins (32/64 bits), Min 2 GB RAM,
Duration : 2 days (16 hrs)
What is Power Query & What does it do: Do you work with data that has been exported from a system of record? This could be a general ledger, accounting, ERP, CRM, Salesforce.com, or any reporting system that contains data. If so, you probably spend a lot of time transforming or re-shaping your data to create additional reports, pivot tables, or charts. These data transformations could include tasks like:
| Remove columns, rows, blanks | Split or merge columns |
| Convert data type text,num,date | Sort & filter columns |
| Aggregate or summarize data | Find & replace text |
| Merging worksheets | Vlookup/Hlookup Functions |
| Add calculated columns | Pivot / Unpivot data |
Now these entire boring, repetitive and time consuming task can be automated & done directly using Power Query using Power Pivot and Power View.
Agenda: Clean, Analyze and Visualize large business data using Excel’s Modern Business Intelligence tools… using Power Query, Power Pivot and Power View in Excel
View this Course
Certified
You have 
