Mastering Power Query by CA Saran Kumar U
Learn with Saran Kumar U
24 modules
English
Lifetime access
Transform Your Data Analysis Game with Power Query Mastery
Overview
This course is designed to help you become proficient in Power Query, a powerful data transformation tool in Microsoft Excel and Microsoft Power BI. You will learn how to clean, transform, and merge data from multiple sources with ease. Get ready to take your data analysis skills to the next level with Power Query!
Key Highlights
Learn advanced data transformation techniques
Master the art of cleaning and merging data
Boost your Excel data analysis skills
What you will learn
Enhanced Data Transformation Skills
Master advanced techniques for transforming data in Excel using Power Query.
Efficient Data Cleaning and Merging
Learn how to clean and merge data from various sources seamlessly.
Advanced Data Analysis Techniques
Take your data analysis skills to the next level by leveraging the power of Power Query.
Modules
Session 1 - Learning Path - Introduction to PQ
Session 2 - More in-depth and first query
Session 3 - In and Out of Query
Session 4 - Around M Functions
Session 5 - Analysis of M Functions, Excel.CurrentWorkbookFn
Session 6 - Deepdive into Excel.CurrentWorkbook Fn
Session 7 - Deepdive into Excel.Workbook Fn
Session 8 - In-depth into List, Custom Functions etc
Session 9 - Dyanmic Path, Files, Column Names etc.
Session 10 - Append Multiple Folders, Sub Folders files
Session 11 - Merge Queries in PQ, All Types of Join
Session 12 - Fuzzy Matching, Merge with More Keys
Session 13 - Pivot, Unpivot, Split, GroupBy
Session 14 - Relative Size Factor, Merge within Query
Session 15 - Case Study leveraging VBA, GPT and PQ
Session 16 - Custom Functions in Excel and Power Query
Session 17 - Connect Web Data and Google Form Data
Session 18 - Case Study - Dealing with Consistent Headers
Session 19 - Reconciliation of 2 Datasets - Leveraging AI for Comments
Session 20 - Deep Dive into Custom Functions - Web Data Automation
Session 21 - Automation of Currency Rate Extraction from Web
Session 22 - Deep Dive into Pdf Data Import, Transform and Analysis
Session 23 - Deep Dive into Meta and Connect to Mail Exchange
Session 24 - Deep Dive into Connecting Tally to PQ
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with Saran Kumar U
Rate this Course
₹ 7500.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
