×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

07 Import Data from an Another Excel Workbook using Power Query

Share your inquiries now with community members Click Here
Previous Lesson Next Lesson
Sign Up and Get Free Certificate
Sign up Now

Lessons List | 41 Lesson
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

Comments

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

Join Now

We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews


Related Courses in Computer Softwares
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

Course Description

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.
Trends
Recent
Previous Lesson Next Lesson