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







Related Articles

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 04

DESCRIPTION See how to import multiple CSV files from a folder and refresh Query and PivotTable when new files are in folder: (00:11) Problem Setup (00:52) Power Query Import From Folder (01:15) Edit Query and [Read More >>>]

Dueling Excel

Dueling Excel 044

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and [Read More >>>]

Be the first to comment

Leave a Reply