Complete Introduction to Excel Power Query

سرفصل های دوره

Quickly and effectively learn to load, transfor, cleanse and prepare data for Microsoft Excel using Power Query

1 - Introduction to Excel Power Query

1 -Course Introduction

1 -Course Outline.pdf

1 -Excel Power Query Excel Files.zip

2 -Course Content

3 -Introduction to Power Query

4 -Power Query Benefits

5 -Power Query Version and Compatibility

6 -Navigating the Power Query Interface

7 -Connecting to Data Sources

8 -Excel, Database, and Online Services

2 - Data Transformation Fundamentals

1 -Data Transformation Fundamentals

2 -Sorting Data

3 -Changing Data Types and Formatting

4 -Unpivoting and Pivoting Data

5 -Pivoting Data

3 - Advanced Data Transformation Techniques

1 -Advanced Data Transformation Techniques For Grouping and Aggregating Data

2 -Merging and Appending Queries

3 -Creating and Managing Custom Columns

4 -Loading Data into Excel Tables and Integrating with Pivot Tables

4 - Power Query Functions and Optimization

1 -Introduction to Power Query M Language

2 -Creating Custom Functions and Managing Parameters

3 -Best Practices for Data Transformation and Modeling

4 -Performing Optimizing Tips

5 -Troubleshooting Common Issues

5 - Real-World Scenarios, Case Studies, and Conclusion

1 -Hands-on Examples Showcasing Power Query Applications in Various Industries

2 -Query Applications in Various Industries

3 -Tips and Tricks For Efficient Data Analysis

4 -Resources For Further Learning

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy