Канал: Excel Magic

Access Data from Anywhere with Power Query! #excel #powerbi #powerquery #powerquerytutorial

Access Data from Anywhere with Power Query! #excel #powerbi #powerquery #powerquerytutorial

Transform your Data with Power Query #excel #powerbi #powerquery #powerquerytutorial #advancedexcel

Transform your Data with Power Query #excel #powerbi #powerquery #powerquerytutorial #advancedexcel

Keeping Up with Power Query Updates | #excel #powerbi #powerquery #powerquerytutorial #advancedexcel

Keeping Up with Power Query Updates | #excel #powerbi #powerquery #powerquerytutorial #advancedexcel

7.9- Referencing Another Query in M Code

7.9- Referencing Another Query in M Code

7.8- Add or Expand Rows

7.8- Add or Expand Rows

7.7- Variables | Power Query | Excel

7.7- Variables | Power Query | Excel

7.6- Manage Parameters | Power Query | Excel

7.6- Manage Parameters | Power Query | Excel

7.5- Formula Firewall Errors | Power Query | Excel

7.5- Formula Firewall Errors | Power Query | Excel

7.4- Dynamic File Paths | Power Query | Excel

7.4- Dynamic File Paths | Power Query | Excel

7.3- Dynamic Folder Paths | Power Query | Excel

7.3- Dynamic Folder Paths | Power Query | Excel

7.2- Scrape Data from Multiple Web Pages | Power Query | Excel

7.2- Scrape Data from Multiple Web Pages | Power Query | Excel

7.1- Parameter Tables for Filtering | Power Query | Excel

7.1- Parameter Tables for Filtering | Power Query | Excel

6.10- Conditional Columns | Power Query | Excel

6.10- Conditional Columns | Power Query | Excel

6.9- Replicating IF OR and IF AND in Power Query | Power Query | Excel

6.9- Replicating IF OR and IF AND in Power Query | Power Query | Excel

6.8- if and Nested if Function | Power Query | Excel

6.8- if and Nested if Function | Power Query | Excel

6.7- Error Trapping | Power Query | Excel

6.7- Error Trapping | Power Query | Excel

6.6- Commenting Code | Power Query | Excel

6.6- Commenting Code | Power Query | Excel

6.5- Tips for Writing M | Power Query | Excel

6.5- Tips for Writing M | Power Query | Excel

6.4- Splitting Text | Power Query | Excel

6.4- Splitting Text | Power Query | Excel

6.3- Using a Function to Add a Custom Column | Power Query | Excel

6.3- Using a Function to Add a Custom Column | Power Query | Excel

6.2- Where to Edit and Write M | Power Query | Excel

6.2- Where to Edit and Write M | Power Query | Excel

6.1- Introduction to M | Power Query | Excel

6.1- Introduction to M | Power Query | Excel

5.4- Load Direct to Power Pivot Excel 2010 | Power Query | Excel

5.4- Load Direct to Power Pivot Excel 2010 | Power Query | Excel

6.4- Reading M | Power Query | Excel

6.4- Reading M | Power Query | Excel

6.5- Writing M | Power Query | Excel

6.5- Writing M | Power Query | Excel

6.6- Type System | Power Query | Excel

6.6- Type System | Power Query | Excel

6.7- Lists and Records

6.7- Lists and Records

5.3- Load Settings & Automatic Refresh | Power Query | Excel

5.3- Load Settings & Automatic Refresh | Power Query | Excel

5.2- Loading to Data Model Power Pivot Excel 2013 Onward | Power Query | Excel

5.2- Loading to Data Model Power Pivot Excel 2013 Onward | Power Query | Excel

5.1- Loading to the Workbook Options | Power Query | Excel

5.1- Loading to the Workbook Options | Power Query | Excel

4.22- Data Profiling | Power Query | Excel

4.22- Data Profiling | Power Query | Excel

4.21- Reuse and Share Queries | Power Query | Excel

4.21- Reuse and Share Queries | Power Query | Excel

4.20- Add Column From Examples | Power Query | Excel

4.20- Add Column From Examples | Power Query | Excel

4.19- Duplicating & Referencing Another Query | Power Query | Excel

4.19- Duplicating & Referencing Another Query | Power Query | Excel

4.18- Transpose | Power Query | Excel

4.18- Transpose | Power Query | Excel

4.17- Unpivot | Power Query | Excel

4.17- Unpivot | Power Query | Excel

4.16- Grouping | Power Query | Excel

4.16- Grouping | Power Query | Excel

4.15- Adding Custom Date & Time Columns | Power Query | Excel

4.15- Adding Custom Date & Time Columns | Power Query | Excel

4.14- Adding Custom Calculated Columns | Power Query | Excel

4.14- Adding Custom Calculated Columns | Power Query | Excel

4.13- Adding Custom & Index Columns | Power Query | Excel

4.13- Adding Custom & Index Columns | Power Query | Excel

4.12- Transforming Dates | Power Query | Excel

4.12- Transforming Dates | Power Query | Excel

4.11- Transforming Text & Numbers | Power Query | Excel

4.11- Transforming Text & Numbers | Power Query | Excel

4.10- Replace & Fill | Power Query | Excel

4.10- Replace & Fill | Power Query | Excel

4.9- Sorting | Power Query | Excel

4.9- Sorting | Power Query | Excel

4.8- Remove Duplicates & Errors | Power Query | Excel

4.8- Remove Duplicates & Errors | Power Query | Excel

4.7- Filtering Rows | Power Query | Excel

4.7- Filtering Rows | Power Query | Excel

4.6- Merging Columns | Power Query | Excel

4.6- Merging Columns | Power Query | Excel

4.5- Splitting Columns | Power Query | Excel

4.5- Splitting Columns | Power Query | Excel

4.4- Columns Move, Remove, Rename & Duplicate | Power Query | Excel

4.4- Columns Move, Remove, Rename & Duplicate | Power Query | Excel

4.3- Fixing Dates with the Locale Setting | Power Query | Excel

4.3- Fixing Dates with the Locale Setting | Power Query | Excel

4.2- Data Types | Power Query | Excel

4.2- Data Types | Power Query | Excel

4.1- Editing Queries | Power Query | Excel

4.1- Editing Queries | Power Query | Excel

3.4- Query Dependencies View | Power Query | Excel

3.4- Query Dependencies View | Power Query | Excel

3.3- Appending Queries | Power Query | Excel

3.3- Appending Queries | Power Query | Excel

3.2- Worksheets Not Correctly Formatted | Power Query | Excel

3.2- Worksheets Not Correctly Formatted | Power Query | Excel

3.1- Multiple Excel Tables or Named Ranges | Power Query | Excel

3.1- Multiple Excel Tables or Named Ranges | Power Query | Excel

2.9- From OneDrive and SharePoint | Power Query | Excel

2.9- From OneDrive and SharePoint | Power Query | Excel

2.8- Data Catalog Search | Power Query | Excel

2.8- Data Catalog Search | Power Query | Excel

2.7- From Other Sources | Power Query | Excel

2.7- From Other Sources | Power Query | Excel

2.6- From Database SQL | Power Query | Excel

2.6- From Database SQL | Power Query | Excel

2.5- From Folder | Power Query | Excel

2.5- From Folder | Power Query | Excel

2.4- From CSV or Text File | Power Query | Excel

2.4- From CSV or Text File | Power Query | Excel

2.3- From Current Workbook | Power Query | Excel

2.3- From Current Workbook | Power Query | Excel

2.2- From Excel File | Power Query | Excel

2.2- From Excel File | Power Query | Excel

2.1- From Web | Power Query | Excel

2.1- From Web | Power Query | Excel

1.3- Interface | Power Query | Excel

1.3- Interface | Power Query | Excel

1.2- Installing Power Query | Power Query | Excel

1.2- Installing Power Query | Power Query | Excel

1.1- What is Power Query ? | Power Query | Excel

1.1- What is Power Query ? | Power Query | Excel