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 39 times – 71 MB







Related Articles

Excel Is Fun

Excel Magic Trick 1144

Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month DESCRIPTION See how to: (00:07) Text Function and Custom Number Formatting (01:08) Convert Serial Number Date To [Read More >>>]

Excel Is Fun

Excel Magic Trick 1392

DESCRIPTION See how to perform Case Sensitive Unique Count with Power Query: (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count. (01:34) Case [Read More >>>]

Excel Is Fun

Excel Magic Trick 1284

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that [Read More >>>]

Be the first to comment

Leave a Reply