Excel Is Fun

Excel 2013 Power Query 13

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

Excel Is Fun

Excel 2013 Power Query 12

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

Excel Is Fun

Excel 2013 Power Query 11

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

Excel Is Fun

Excel 2013 Power Query 10

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

Excel Is Fun

Excel 2013 Power Query 09

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

Excel Is Fun

Excel 2013 Power Query 08

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

Excel Is Fun

Excel 2013 Power Query 06

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

Excel Is Fun

Excel 2013 Power Query 05

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

Excel Is Fun

Excel 2013 Power Query 04

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