Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about using the Unpivot feature in Power Query to take four separate columns of numbers with columns headers that are criteria and convert it into a proper data set with a column for the criteria and a column for the numbers, and then build a PivotTable to calculate the Mean and Standard Deviation for average hours worked per week for different categories of teachers: 1) (00:21) What is Unpivoting? 2) (01:36) Where is Power Query in Excel 2016? It is here: Excel 2016 Data Tab, Get & Transform group 3) (02:17) Must Convert the data to an Excel tablwe before we can import it into the Power Query Editor. 4) (02:44) Use Get & Transform to Unpivot data 5) (03:43) Close and load to sheet 6) (04:02) With the proper data set we can sort or filter 7) (04:29) PivotTable to calculate the mean and standard deviation 8) (06:16) Summary Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.