Power Up Your Career with Microsoft Office Training
Power Up Your Career with Microsoft Office Training
Ebook Power Query
Master the Art of Data Transformation and Insightful Analysis with our Power Query eBook
Many professionals find themselves navigating through the complexities of data, often feeling limited by the basic features of Excel.Â
You’re not alone.
This challenge can lead to missed insights and opportunities, as effectively managing and analyzing intricate data sets becomes a daunting task.Â
Embrace ‘Power Query Demystified’ to navigate through the complexities of data transformation with ease, transforming raw data into meaningful insights.
This eBook provides real-world, actionable solutions to elevate your Power Query skills.
Step into the world of efficient data transformation, enhancing your professional growth and decision-making abilities with Power Query.
KEY BENEFITS OF EBOOK COURSE
Our eBook thoroughly covers every aspect of Power Query, from basic operations to advanced data transformation techniques. This means you'll gain an all-encompassing understanding of Power Query, preparing you to tackle diverse data scenarios.
The eBook includes a variety of interactive exercises designed to reinforce your learning of Power Query. This means you'll actively apply the concepts you learn, solidifying your skills through practical experience and ensuring a deeper understanding of the tool.
As Power Query evolves, so does our eBook. You'll receive updates with the latest features and best practices. This means your Power Query skills will remain current and competitive, keeping you at the forefront of data transformation technology.
office tech skill
Hi! I’m Mihir Kamdar, an Power Query enthusiast with over a decade of experience in multiple sectors. My mission is to simplify Power Query, making it accessible and easy for everyone to use.
The knowledge I’ve gained from using Power Query in various professional roles has been poured into this eBook. Here, I share my practical insights and real-life applications, providing you with clear, actionable strategies to master Power Query.
basic to advanced
Explore our comprehensive course curriculum designed to take you step-by-step through the essentials to advanced techniques, ensuring you gain the skills and knowledge for real-world application.
1.1. What is Power Query?
1.2. Why use Power Query?
1.3. History of Power Query
1.4. When to use Power Query vs. VBA vs. Excel for Data Transformation?
1.5. Power Query Versions
2.1. Power Query Editor
2.2. Transform vs. Add Column
2.3. View
2.4. Data Types
2.5. Rename and Delete
2.6. Query Reference vs. Duplicate
2.7. Query Dependencies (Graphic Relation of Queries)
3.1. Table/Range
3.2. Excel File
3.3. Text File
3.4. Access Database
3.5. Webpage
3.6. JSON File
3.7. PDF File
3.8. From Folder
4.1. Column Transformation
4.1.1. Choose Columns
4.1.2. Navigate Columns
4.1.3. Rearrange Columns
4.1.4. Remove Columns
4.2. Row Transformation
4.2.1. Keep Rows
4.2.2. Remove Rows
4.3. Data Type
4.3.1. Manually Selecting Data Type
4.3.2. Auto Detect Data Type
4.4. Promote/Demote Header
4.4.1. Headers as First Row
4.4.2. First Row as Header
4.5. Rename Column
4.6. Replace Values
4.7. Fill Values
4.7.1. Fill Down
4.7.2. Fill Up
5.1. Sort
5.1.1. Single Column Sort
5.1.2. Multi-Level Column Sort
5.2. Filter
5.2.1. Single Column Filter
5.2.2. Multi-Level Column Filter
6.1. Split Column
6.1.1. By Delimiter
6.1.2. By Number of Characters
6.1.3. By Number of Positions
6.2. Format Text Data
6.2.1. Lowercase
6.2.2. Uppercase
6.2.3. Propercase
6.2.4. Trim
6.2.5. Clean
6.2.6. Add Prefix
6.3. Merge Column
6.4. Extract Text Data
6.4.1. Length
6.4.2. First Characters
6.4.3. Last Characters
6.4.4. Range
6.4.5. Text Before Delimiter
6.4.6. Text After Delimiter
6.4.7. Text Between Delimiters
7.1. Statistics
7.1.1. Sum
7.1.2. Minimum
7.1.3. Maximum
7.1.4. Average
7.1.5. Median
7.1.6. Count
7.1.7. Standard Deviation
7.2. Standard Calculation
7.2.1. Add
7.2.2. Multiply
7.2.3. Subtract
7.2.4. Divide
7.3. Rounding
7.3.1. Round Up
7.3.2. Round Down
7.3.3. Round
7.4. Information
8.1. Year
8.2. Month
8.3. Quarter
8.4. Week
8.5. Day
8.6. Age
8.7. Date Only
8.8. Subtract Days
8.9. Hour
8.10. Minute
8.11. Second
8.12. Total Years
8.13. Total Days
8.14. Total Hours
8.15. Total Minutes
10.1. Index
10.2. Duplicate Column
10.3. Conditional Column (If Then Else)
10.4. Custom Column – Conditional Logic based on Multiple Columns or Multiple Criteria
10.4.1. Conditional Logic based on Multiple Criteria
10.4.2. Conditional Logic based on Multiple Columns
10.5. Column from Examples
11.1. Grouping Data by Single Criteria
11.2. Grouping Data by Multiple Criteria
11.3. Grouping and Summarizing Statistics with Multiple Criteria
12.1. Transpose
12.2. Unpivot
12.3. Pivot
13.1. Append Data
13.1.1. Append Queries
13.1.2. Append Queries as New
13.2. Merge Data
13.2.1. Merge Queries
13.2.2. Merge Queries as New
13.3.3. Fuzzy Match Merge
14.1. Intro to M
14.2. Building Block of M Code
14.2.1. Blank Query (M Language UI)
14.2.2. M Expression vs. Let-In Expression
14.2.3. Variable & Sequence
14.2.4. Comment
14.2.5. Characteristics of M Language
14.2.6. Identifiers
14.2.7. Keyword
14.2.8. Operators & Punctuations
14.2.9. Conditional Logic
14.2.10. Each Underscore
14.2.11. Error Handling – Try Otherwise
14.2.12. Combining All-Building Blocks of M Code
14.3. Primitive Value
14.4 Structured Data
14.4.1. List
14.4.2. Table
14.4.3. Record
14.5. Extract Structured Data & Primitive Value
14.5.1. Extract Single List/Column
14.5.2. Extract Multiple Columns
14.5.3. Extract List with Drill Down
14.5.4. Extract Table without Space
14.5.5. Extract Table with Space
14.5.6. Extract Record with Row Index
14.5.7. Extract Record with Row Index 2
14.5.8. Extract Record with Key Match
14.5.9. Extract Primitive Value with Row Index
14.5.10. Extract Primitive Value with Key Match
14.5.11. Extract Primitive Value with Drill Down
14.6. Operators
15.1. Data Source
15.1.1. Power Query Parameter
15.1.2. Excel Cell
15.2. Filtering
15.2.1. Power Query Parameter
15.2.2. Excel Cell
15.3. Conditional Column
15.3.1. Power Query Parameter
15.3.2. Excel Cell
16.1. Function Value
16.2. Invoke Function
16.3. M Functions Library
16.4. Intellisense
16.5. Function Parameter
16.6. Nested Function
16.7. List Function
16.7.1. List.Sum
16.7.2. List.Intersect
16.7.3. List.Union
16.7.4. List.Combine
16.7.5. Table.Index
16.7.6. List.Range
16.7.7. List.Accumulate
16.8. Table Function
16.8.1. Table.AddRankColumn
16.8.2. Table.Max
16.8.3. Table.TransformColumns
16.8.4. Table.Schema
16.8.5. Table.Profile
16.8.6. Extract Next Row Value
16.8.7. Table.ReplaceValue
17.1. M Code Using UI
17.1.1. Historical Currency Criteria
17.1.2. Historical Currency Converter
17.1.3. Function in Action
17.2. M Code from Scratch
17.2.1. Latest Currency Converter
18.1. Close & Load
18.2. Close & Load To
19.1. Manual Refresh
19.1.1. Refresh Single Query
19.1.2. Refresh All Queries
19.1.3. Refresh Single Query via VBA
19.1.4. Refresh Multiple Queries via VBA
19.1.5. Refresh All Queries via VBA
19.2. Automatic Refresh
19.2.1. Refresh Query at Intervals
19.2.2. Refresh Query When Opening File
20.1. Data Source Error
20.2. Expression Error
20.3 Operation Error
20.4. Data Type Error
20.5. Remove Error
20.6. Replace Error
22.1. Comments
22.2. Query Properties
22.3. Group
22.4. Power Query Formatter
22.5. Extract M Code for All Queries
22.6. Extract All Query Names via VBA
22.7. Query Relationships
Are you ready to begin? If so, click on the “Start Now” button below and we’ll get started.
If this is your first time exploring Office Tech Skill, you likely have some questions. Discover our most commonly asked questions here or feel free to contact us via email.
Send us a message or email us at [email protected].
Absolutely! It’s designed to guide you from the very basics to advanced topics.
You’ll start seeing results as soon as you begin applying the concepts. Each chapter is designed to give you quick wins and noticeable improvements in your skills.
Yes, the eBook is formatted to be accessible on various devices, making learning convenient for you.
Unfortunately, there is no refund for this eBook because we are selling it at a discounted price.
No specific prerequisites are needed. The eBook is structured to help readers progress from basic to advanced levels, regardless of their starting point.
Yes, the eBook is packed with practical examples and exercises to help you apply what you learn in real-world scenarios.
Any future updates will be provided free of charge. Registered users will receive notifications and access to download updated versions.
You can reach out to our support team via email or email us at [email protected] for any queries or assistance you may need.
We welcome your feedback! You can submit your review or feedback through email or email us at [email protected].
