Excel Is Fun

Excel 2013 Power Query 13

July 24, 2015 0

Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data DESCRIPTION See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big […]

Excel Is Fun

Excel 2013 Power Query 12

July 17, 2015 0

Find & Replace, Group By 3 Columns, Load With Existing Connections DESCRIPTION See how to: (00:08) Problem Set up. Also Discussion about how sometimes Power Query can be better than Formulas. (01:00) Build Query with […]

Excel Is Fun

Excel 2013 Power Query 11

July 10, 2015 0

Each Row Has 3 Records, Unwind Table into Proper Data Set DESCRIPTION See how to: (00:08) Problem Set up (01:48) Power Query it import table 3 times, each time deleting certain columns, then Append the […]

Excel Is Fun

Excel 2013 Power Query 10

July 3, 2015 0

UnPivot Feature to Create Proper Data Sets (2 Examples) DESCRIPTION See how to: (00:08) Problem Set up (00:49) Use Filter Feature rather than Table Feature to get Table into Power Query (01:30) Unpivot Cross Tabulated […]

Excel Is Fun

Excel 2013 Power Query 09

June 26, 2015 0

Merge Multiple Worksheets in Workbook To New Table using Append Feature DESCRIPTION See how to Merge Multiple Worksheets in Workbook To New Table using Append Feature: (00:08) Problem Setup (00:39) Table Feature for getting Tables […]

Excel Is Fun

Excel 2013 Power Query 08

June 19, 2015 1

Import Multiple Excel Sheets From Multiple Excel Workbooks DESCRIPTION See how to use Power Query to easily import multiple sheets of data from multiple Excel Workbooks and easily have Power Query Add a new column […]

Excel Is Fun

Excel 2013 Power Query 06

June 12, 2015 0

Import Multiple Excel Files From Folder Into One Excel Table or Data Model DESCRIPTION See how to use Power Query to import multiple Excel Files into an Excel Table or Data Model. Then see how […]

Excel Is Fun

Excel 2013 Power Query 05

June 5, 2015 0

Create Dimension Table From Fact Table for PowerPivot During CSV File Import DESCRIPTION See how to Create Dimension Table From Fact Table for PowerPivot During CSV File Import: (00:08) Problem Setup (01:33) Create Dimension Table […]

Excel Is Fun

Excel 2013 Power Query 04

May 29, 2015 1

Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically DESCRIPTION See how to import multiple CSV files from a folder and refresh Query and PivotTable when new files are in folder: (00:11) […]