Login

Microsoft Excel: Master Power Query in 120 Minutes

CPD Accredited | Affordable Pricing | No Hidden Charges | 24/7 Tutor Support | Instant Access
4.8
9 Reviews

stds7 Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49. FIND OUT MORE

course-highlight Course Highlights

Experience Microsoft Excel like never before with our comprehensive 120-minute course, Microsoft Excel: Master Power Query in 120 Minutes. Advanced data manipulation techniques are introduced in the first module, which covers the fundamentals of Power Query in Microsoft Excel. The ability to effectively transform data in Microsoft Excel is a crucial skill for every data analyst, and it will be covered in this course. This is a major topic covered in Module 2.

The middle modules, “From Folder” and “From Workbook,” guide you through integrating multiple data sources in Microsoft Excel. This knowledge is crucial for handling real-world data scenarios where information is scattered across different files and formats. Module 05, “Joins,” takes you deeper into Microsoft Excel’s capabilities, teaching you to merge data from various sources seamlessly.

The last module solidifies your understanding of Power Query in Microsoft Excel, enabling you to tackle challenging data projects. By the time this course ends, you will be able to manipulate and analyse data like an expert because of your newfound expertise with Microsoft Excel.

course-benefits Learning outcome

course-why Why should I take this course?

course-why Career Path

course-requirement Requirements

Curriculum

  • play Power Query Intro and Excel version
    play 00:03:00
  • play Excel Power Query – Introduction
    play 00:03:00
  • play Excel Power Query – Query Editor Ribbon
    play 00:09:00
top