Excel Is Fun

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 Powery Query 1 [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 02

Merge 3 Tables Into One in PowerPivot or Excel Table DESCRIPTION See how to: (00:32) Explain Data and how we will transform it (01:35) Import Excel Table (01:58) Remove unwanted columns (02:10) Split Columns to [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 01

Merge 3 Tables Into One in PowerPivot or Excel Table DESCRIPTION See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using [Read More >>>]