Канал: Excel Magic

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