Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 05

April 5, 2015 0

DESCRIPTION See how to Import 3 Excel Tables from an External Excel Wordbook File, Build Relationships, Build Calculated Column, Build Calculated Field (Measure) using SUMX function, and compared Calculated Columns and calculated Fields. (00:21) See […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 04

April 4, 2015 0

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 03

April 3, 2015 0

DESCRIPTION See how to replace VLOOKUP with Excel 2013 Data Model and Relationships. See how to get two or more tables into a PivotTable Field List: (00:11) Get Two Tables into an Excel 2013 PivotTable […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 02

April 2, 2015 0

DESCRIPTION See how importing large data sets into PowerPivot can dramatically reduce file size. (00:03) 500,000 row non-Normalized Data Set in Excel (01:31) Example of Normalized Data (02:02) Import data from External Excel workbook into […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 01

April 1, 2015 0

DESCRIPTION Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: (00:22) Smartest People with PowerPivot (01:31) Which Versions of Excel 2013 contain […]

Excel Is Fun

Excel Magic Trick 1085

January 9, 2015 0

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a […]