Excel, Power Query | UNPIVOT, PIVOTI , GRAFICE in Excel
In this video, I show you how to use Power Query in Excel to process and transform data.
We cover the following topics:
0:00 - Introduction
1:42 - Explaining the UNPIVOT function in Power Query
2:35 - Importing data into Power Query from a table or range
3:18 - Processing data in Power Query
3:45 - Unpivoting data/columns in Power Query
4:39 - Changing/renaming a column name in Power Query
4:47 - UNDO function in Power Query
5:34 - Returning to Excel and transposing data from Power Query to Excel 6:10 - Generating a Pivot on the new data structure
6:49 - Graphical representation of category weight in Excel
What kind of calculations are suitable:
Monthly depreciation calculation in Excel
Monthly data evolution calculation in Excel
Table structure calculation in Excel
Monthly sales calculation by agent
Course calendar: https://sky-it.ro/calendar-cursuri/
If you want personalized Excel courses for yourself or your team, don't hesitate to contact me!
Author: Alexandru Pantilie
#Excel, #PowerQuery, #UNPIVOT, #DataProcessing, #DataTransformation, #ExcelTips, #ExcelTutorial, #PivotTable, #ExcelCharts, #DataVisualization