Excel Is Fun

Excel 2013 Power Query 03

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

Excel Is Fun

Excel 2013 Power Query 02

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 remove unwanted Product ID data (02:54) Remove column after split [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 01

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 Power Query. Merge tables into the PowerPivot Data Model or [Read More >>>]