Login

Sign up
Home
Categories
Popular

Excel Power Query Course Online For Free tutorial With Certificate

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

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

الدورة دي هتفيدك
Power BI et Excel
إخفاء
Power BI et Excel
Microsoft Power BI
Microsoft Power BI
Power BI Quick Project
Power BI
Power BI


We Appreciate Your Feedback

Excellent
4 Reviews
Good
2 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews

4.7

6 Reviews
Olaleye Ifeoluwa Janet

The course is very educative. Thanks to the instructor. I had a challenge though. On my certificate the course name was not written on it. The course name was Excel Course from Beginners to Advance. I await your response. Thanks 2022-07-13

Gladstone Eli Atrakpo

A course with all in one...good for beginners... Weldone on your works! 2022-05-17

Moutaz Mansour

Important information 2022-02-22

Mohamed

It's very good and easy 2022-01-04

Show More Reviews

Best Telegram Channels
Join Our Telegram Channels to Get Best Free Courses in your Learning Track

Join Now
Related Courses
Excel Power Query
41 Lesson

Excel Power Query

Excel VBA
36 Lesson

Excel VBA

Excel Dashboard
21 Lesson

Excel Dashboard

Excel Course Basic to Advanced
26 Lesson

Excel Course Basic to Advanced

Excel Functions
66 Lesson

Excel Functions

Excel Charting
18 Lesson

Excel Charting

Microsoft Access
23 Lesson

Microsoft Access

Microsoft PowerPoint
52 Lesson

Microsoft PowerPoint

Microsoft Word
46 Lesson

Microsoft Word

Microsoft Excel
49 Lesson

Microsoft Excel

Digital Media Literacy
15 Lesson

Digital Media Literacy

Google Classroom
5 Lesson

Google Classroom

Google Slides
23 Lesson

Google Slides

Google Sheets
15 Lesson

Google Sheets

Google Docs
37 Lesson

Google Docs

Google Drive
11 Lesson

Google Drive

Free Excel Power Query tutorial, 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.