Mastering Power Query by CA Saran Kumar U
Learn with Saran Kumar U
24 modules
English
Access for 180 days
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
Learn M Formulas as a Pro!!
Automation Assignments
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 2 - More in-depth and first query
1 attachment
Session 2 - Working Files
Session 3 - In and Out of Query
1 attachment
Session 3 - Working Files
Session 4 - Around M Functions
1 attachment
Session 4 - Working Files
Session 5 - Analysis of M Functions, Excel.CurrentWorkbookFn
1 attachment
Session 5 - Working Files
Session 6 - Deepdive into Excel.CurrentWorkbook Fn
1 attachment
Session 6 - Working Files
Session 7 - Deepdive into Excel.Workbook Fn
1 attachment
Session 7 - Working Files
Session 8 - In-depth into List, Custom Functions etc
1 attachment
Session 8 - Working Files
Session 9 - Dyanmic Path, Files, Column Names etc.
1 attachment
Session 9 - Working Files
Session 10 - Append Multiple Folders, Sub Folders files
1 attachment
Session 10 - Working Files
Session 11 - Merge Queries in PQ, All Types of Join
1 attachment
Session 11 - Working Files
Session 12 - Fuzzy Matching, Merge with More Keys
1 attachment
Session 12 - Working Files
Session 13 - Pivot, Unpivot, Split, GroupBy
1 attachment
Session 13 - Working Files
Session 14 - Relative Size Factor, Merge within Query
1 attachment
Session 14 - Working Files
Session 15 - Case Study leveraging VBA, GPT and PQ
1 attachment
Session 15 - Working Files
Session 16 - Custom Functions in Excel and Power Query
1 attachment
Session 16 - Working Files
Session 17 - Connect Web Data and Google Form Data
1 attachment
Session 17 - Working Files
Session 18 - Case Study - Dealing with Consistent Headers
1 attachment
Session 18 - Working Files
Session 19 - Reconciliation of 2 Datasets - Leveraging AI for Comments
1 attachment
Session 19 - Working Files
Session 20 - Deep Dive into Custom Functions - Web Data Automation
1 attachment
Session 20 - Working Files
Session 21 - Automation of Currency Rate Extraction from Web
1 attachment
Session 21 - Working Files
Session 22 - Deep Dive into Pdf Data Import, Transform and Analysis
1 attachment
Session 22 - Working Files
Session 23 - Deep Dive into Meta and Connect to Mail Exchange
1 attachment
Session 23 - Working Files
Session 24 - Deep Dive into Connecting Tally to PQ
1 attachment
Session 24 - Working Files
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.
How long I can access this course?
You can access the course for 6 months from the date of enrollment.
About the creator
Learn with Saran Kumar U
Rate this Course
₹ 6999.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 Access for 180 days. Do you still wish to enroll again?