×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

Excel Power Query

Course Reviews

Track :

Computer Softwares

Lessons no : 41

For Free Certificate After Complete The Course

To Register in Course you have to watch at least 30 Second of any lesson

Join The Course Go To Community Download Course Content

What will you learn in this course?
  • Master how to connect and import data sources using Excel Power Query for efficient data analysis
  • Transform and clean raw data with Power Query to prepare datasets for accurate reporting and visualization
  • Combine multiple data sources seamlessly with Power Query to create comprehensive, integrated datasets in Excel
  • Automate data refresh and updates in Power Query to maintain real-time data accuracy in Excel reports
  • Apply advanced filtering, sorting, and grouping techniques within Power Query for targeted data insights
  • Create custom data transformation workflows using Power Query's user-friendly interface and M language
  • Troubleshoot common Power Query errors to ensure smooth data import and transformation processes
  • Optimize data query performance in Excel Power Query for faster analysis and reporting workflows
  • Integrate Power Query with Power Pivot to enhance data modeling and complex analysis capabilities
  • Design reusable Power Query templates for consistent data processing across multiple projects
  • Leverage Power Query to connect Excel with external data sources like databases and web services
  • Implement best practices for data security and privacy when using Power Query in Excel

How to Get The Certificate

  • You must have an account Register
  • Watch All Lessons
  • Watch at least 50% of Lesson Duration
  • you can follow your course progress From Your Profile
  • You can Register With Any Course For Free
  • The Certificate is free !
Lessons | 41
01 Introduction to Excel Power Query Get Transform in Excel
00:06:17

01 Introduction to Excel Power Query Get Transform in Excel
02 Installing the Power Query Add in in Excel 2010 and 2013
00:03:22

02 Installing the Power Query Add in in Excel 2010 and 2013
03 Overview of Query Editor in Power Query
00:06:59

03 Overview of Query Editor in Power Query
04 Import Data from Web in Excel Using Power Query
00:07:07

04 Import Data from Web in Excel Using Power Query
05 Import Data from TEXT Files in Excel using Power Query
00:07:18

05 Import Data from TEXT Files in Excel using Power Query
06 Import Data from CSV Files into Excel using Power Query
00:05:01

06 Import Data from CSV Files into Excel using Power Query
07 Import Data from an Another Excel Workbook using Power Query
00:08:53

07 Import Data from an Another Excel Workbook using Power Query
08 Getting Data from Current Excel Workbook to Power Query
00:05:34

08 Getting Data from Current Excel Workbook to Power Query
09 Combine Excel Tables in the Same Workbooks Using Power Query Append Method
00:08:47

09 Combine Excel Tables in the Same Workbooks Using Power Query Append Method
10 Combine Excel Tables in the Same Workbooks Using Power Query Formula Method
00:09:14

10 Combine Excel Tables in the Same Workbooks Using Power Query Formula Method
11 Merge Tables in Excel using Power Query
00:09:58

11 Merge Tables in Excel using Power Query
12 Combine Tables from Different Workbooks into One Table in Excel Using Power Query
00:07:49

12 Combine Tables from Different Workbooks into One Table in Excel Using Power Query
13 Combine All the Excel Files in a folder Using Power Query
00:10:31

13 Combine All the Excel Files in a folder Using Power Query
14 Combine CSV Files or Text Files in a Folder Using Power Query
00:06:11

14 Combine CSV Files or Text Files in a Folder Using Power Query
15 Get a List of File Names from a Folder in Excel Using Power Query
00:07:14

15 Get a List of File Names from a Folder in Excel Using Power Query
16 Split Columns in Power Query in Excel
00:07:08

16 Split Columns in Power Query in Excel
17 Merge Columns in Power Query in Excel
00:03:04

17 Merge Columns in Power Query in Excel
18 Filter Data in Power Query in Excel
00:06:16

18 Filter Data in Power Query in Excel
19 Sort Data in Power Query in Excel
00:04:00

19 Sort Data in Power Query in Excel
20 Replace Values in Power Query in Excel
00:05:42

20 Replace Values in Power Query in Excel
21 Fill Down in Power Query in Excel
00:02:03

21 Fill Down in Power Query in Excel
22 Transpose in Power Query in Excel
00:02:21

22 Transpose in Power Query in Excel
23 Group Data in Power Query in Excel
00:04:38

23 Group Data in Power Query in Excel
24 Unpivot Data in Excel Using Power Query
00:07:09

24 Unpivot Data in Excel Using Power Query
25 Using Locale to Manage Dates in Power Query
00:03:56

25 Using Locale to Manage Dates in Power Query
26 Columns Operations Rename Move Delete Duplicate in Power Query
00:03:16

26 Columns Operations Rename Move Delete Duplicate in Power Query
27 Adding Date and Time Columns in Power Query
00:07:28

27 Adding Date and Time Columns in Power Query
28 Transform Text with Extract Options in Power Query
00:05:58

28 Transform Text with Extract Options in Power Query
29 Adding an Index Column in Power Query in Excel
00:04:06

29 Adding an Index Column in Power Query in Excel
30 Adding a Custom Column in Power Query in Excel
00:05:28

30 Adding a Custom Column in Power Query in Excel
31 Adding a Conditional Column in Power Query in Excel
00:04:13

31 Adding a Conditional Column in Power Query in Excel
32 Add Column from Examples in Power Query in Excel
00:07:52

32 Add Column from Examples in Power Query in Excel
33 Overview of Power Query Functions
00:13:41

33 Overview of Power Query Functions
34 Useful Text Functions in Power Query
00:09:24

34 Useful Text Functions in Power Query
35 Creating IF OR and IF AND functions in Power Query
00:05:56

35 Creating IF OR and IF AND functions in Power Query
36 Overview of M Formula Language in Power Query
00:11:29

36 Overview of M Formula Language in Power Query
37 Insert Comments in M Code in Power Query
00:04:56

37 Insert Comments in M Code in Power Query
38 Convert Query to a Function in Power Query
00:14:00

38 Convert Query to a Function in Power Query
39 Extract Data from a Table based on User Selection in Excel using Power Query
00:06:11

39 Extract Data from a Table based on User Selection in Excel using Power Query
40 Get Files Names from a Folder Based on User Selection in Excel using Power Query
00:13:36

40 Get Files Names from a Folder Based on User Selection in Excel using Power Query
Show More Lessons

Recommended Courses



Excel Power Query in excel for beginners
64 Lessons

Excel Power Query in excel for beginners

Excel Power query web scraping techniques
3 Lessons

Excel Power query web scraping techniques

Excel Power query for beginners
28 Lessons

Excel Power query for beginners



We Appreciate Your Feedback

Excellent
10 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
4.7
72 Reviews
Habib DIAOU

Interesting Power Query Course 2025-08-18

Muhammad Randy Akbar

Very usefull, minid blowing 2025-07-19

Loai

Precise to the point 2025-07-16

Hassan Halepota

detailed one 2025-06-04

Muhammad Faizan s/o Muhammad Bashir Ahmed

It helped me a lot. 2025-05-09

karthi keyan

Good 2025-04-29

areeba baidar

5 2025-04-07

Jerry

Excellent Course. Each course are very brief and easy to follow. 2025-02-24

MUHAMMAD INAM UL HAQ

Excellent 2025-02-19

العائله الكبيره

AHMED MOHAMED TAHA MOHAMED 2025-01-27

Hamphrey Zawadi

Good Teacher 2025-01-14

O Vivek Balaji

Good platform to learn, however provider less videos for certificate program. 2024-12-05

Show More Reviews

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

Related Courses

Excel Power Query
41 Lessons

Excel Power Query

Excel VBA
36 Lessons

Excel VBA

Excel Dashboard
21 Lessons

Excel Dashboard

Excel Course Basic to Advanced
26 Lessons

Excel Course Basic to Advanced

Excel Functions
66 Lessons

Excel Functions

Excel Charting
18 Lessons

Excel Charting

Microsoft Access
23 Lessons

Microsoft Access

Microsoft PowerPoint
52 Lessons

Microsoft PowerPoint

Microsoft Word
46 Lessons

Microsoft Word

Microsoft Excel
49 Lessons

Microsoft Excel

Digital Media Literacy
15 Lessons

Digital Media Literacy

Google Classroom
5 Lessons

Google Classroom

Google Slides
18 Lessons

Google Slides

Google Sheets Full data
15 Lessons

Google Sheets Full data

Google Docs
34 Lessons

Google Docs

Google Drive
11 Lessons

Google Drive

What is a power query in Excel? Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. ... Power Query is one of three data analysis tools available in Excel: Power Pivot.Is Excel Power Query free? Power Query is an amazing data tool for Excel! ... “Free” add-in for Excel 2010 and 2013 for Windows. Built-in feature for Excel 2016 for Windows (Office 365 Subscription). Click here to learn where to find it.Power Pivot Power Pivot is a feature of Microsoft Excel. It is available as an add-in in Excel 2010, 2013 in separate downloads, and as an add-in included with the Excel 2016 program. Power Pivot extends a local instance of Microsoft Analysis Services Tabular that is embedded directly into an Excel Workbook.