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 Magic Trick 1131

Ageing Accounts Receivable Reports On Multiple Sheets With PivotTable DESCRIPTION TRICK ONLY WORKS IF THERE ARE NO DUPLICATES!!!!! See how to create Ageing Accounts Receivable Reports On Multiple Sheets With PivotTable when there are no [Read More >>>]

Dueling Excel

Dueling Excel 026

Randomize Between 2 Dates DESCRIPTION See Mr Excel and excelisfun create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE. See formulas [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 >>>]

Dueling Excel

Dueling Excel 025

Extract Records NOT Swim or Ski (Filter or Formula?) DESCRIPTION See Mr Excel and excelisfun extract records from database that are NOT Swim or Ski with Filter, Advanced Filter, or Formula using ISNUMBER, LOOKUP and [Read More >>>]

Excel Topics

Recover Workbooks Using Versions

The Versions feature in Excel 2013 is a very useful tool as it can recover previous versions of a workbook if for example any of these situations occur. Your computer crashes. There’s a power cut. [Read More >>>]

Dueling Excel

Dueling Excel 024

VLOOKUP, MAX, Boolean, IF, Which is Best? DESCRIPTION See Mr Excel and excelisfun throw out 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas. Which one do you like? [Read More >>>]