Excel 2013 Power Query 03

Merge 3 Tables Into One in PowerPivot or Excel Table

DESCRIPTION

See how to import three text files (Tab Delimited) that contain Student Grade Data for a 35 year period using the Power Query 1 Step Method, and then make an amazing Pivot Chart with Dynamic Labels:
(00:08) Problem Setup
(02:45) Import multiple Text Files (Tab Delimited) from a single Folder
(06:43) Build 3 PivotTables for 3 Class Grade
(09:22) Chart with Custom Labels
(09:58) Create Labels for chart that are connected to the PivotTable and Cells. Text formulas with TEXT and CHAR functions.

WORKBOOKS

Download “Excel 2013 Power Query Videos 01-06” Excel-2013-Power-Query-Videos-01-06.zip – Downloaded 27 times – 71 MB







Be the first to comment

Leave a Reply