Certified Financial Excel Power Query Expert (Cfepq-Expert) https://FreeCourseWeb.com Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 301.60 MB | Duration: 0h 36m
Learn to use Power Query practical way, for data transformation and automation from multiple different sources
What you'll learn
Identify the characteristics of good and bad data using the principles of data normalization.
Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot.
Transform datasets by grouping or combining data from different tables or even multiple files from the same folder.
Avoid, interpret and fix errors and exceptions that you experience in Power Query.
Requirements
MS Excel software
Fundamental knowledge of MS Excel usage and it's functions
Fundamental knowledge of Finance and Banking