Login

Sign up
MindLuster Logo
Home
Categories
Popular

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

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


We Appreciate Your Feedback

Excellent
24 Reviews
Good
9 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews

4.7

33 Reviews
Suman Rani

It's very useful.. great 2023-09-23

Muhammad akbar

excellent platform for learning 2023-09-21

Root General

Very educative,pragmatic,insightful and very practical career-wise. Great job to the instructor, he is verily and vastly knowledgeable on this course. 2023-09-18

ATIYA

Excellent 2023-09-14

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
23 Lessons

Google Slides

Google Sheets
15 Lessons

Google Sheets

Google Docs
34 Lessons

Google Docs

Google Drive
11 Lessons

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.