Excel Is Fun

Excel 2013 Power Query 13

DESCRIPTION See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big data by using Power Query and PowerPivot: 1. Using Power Query import [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 12

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 Find & Replace using “Find Values” feature in the Transform Group [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 11

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 3 tables, Sort and Load To Table. (04:57) Test with New [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 10

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 Table into Proper Data Set (03:12) Unpivot Only Two [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 09

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 into Power Query (00:53) Use “From Table” feature in Power Query [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 08

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 that is populated with the Sales Rep Name [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 06

DESCRIPTION See how to use Power Query to import multiple Excel Files into an Excel Table or Data Model. Then see how easy it is to update the Table when new files are dropped into [Read More >>>]

Excel Is Fun

Excel 2013 Power Query 05

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 or Lookup Table from File Name in Fact Table. Use Power Query [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 >>>]