Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 08

April 8, 2015 0

DESCRIPTION See how to: (00:08) Overview (01:45) Update Calendar Table in Excel file when we anticipate new transactional data with new dates. (03:35) Update Existing Connections to Source Data Files when File Name or File […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

April 7, 2015 0

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 06

April 6, 2015 0

DESCRIPTION See how to Import, Filter, Edit Data From Access, Excel, Text Files into one Data Model, including importing new tables and columns and deleting tables after an existing connection is established: (00:28) goal of […]

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 […]

Dueling Excel

Dueling Excel 020

March 20, 2015 0

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting […]

Dueling Excel

Dueling Excel 019

March 19, 2015 0

DESCRIPTION See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to […]