Introduction to Power Query
Don't spend countless hours to clean your data before you run reports. Learn the Modern way to automate data cleanup and integration with Power Query.
Power Query is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis
The course also covers Reconciliation techniques using excel functions, pivot tables, power query and new reconciliation tools like the Inquire Addin
Describe the interface for the Power Query tool
Apply Power Query to automate the report update process.
Construct an Advanced and automated reconciliation tool using the Power Query application
“Its been very exciting experience for me. I enjoy the simplicity and practical experience garnered so far. Thank you very much for this”
“Very Knowledgeable And Has Passion For The Course And Profession He Was On Point Throughout The Course ”
“Good Overall, Articulate And Knowledgeable Very Professional And Has Ability To Impact Knowledge Excellent Performance, Well Paced And A Strong Personality ”
Here's what you'll learn...
Introduction to Power Query - Exercise Files & Labs
Discussion
The Reporting Infrastructure
Lab 02 - How Excel Works
Reporting Framework & the 7 Golden Rules of Data
The role of the Control & Report Sheets
How Excel Works
FREE PREVIEWManaging Dates, Validations & Format Styles
Chapter Quiz
Discussion
Get Data with Power Query
Lab 01 - Get Data with Power Query
Getting External Data into Excel
Connect to Excel Files in a Folder
Consolidate Excel Workbooks
FREE PREVIEWTransform Data Types
Loading your Query to Excel
Report update with Power Query
Chapter Quiz
Discussion
Instructions
Before you go...
How to Attach your Certificates to your LinkedIn Profile
10,000+ people are learning on our platform
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”
“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”
“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”
“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”
10,000+ people are learning on our platform
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”
“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”
“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”
“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”