Excel 2013 PowerPivot Basics 10

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example [Read More >>>]

Excel 2013 PowerPivot Basics 09

DESCRIPTION See how to create 9 different DAX functions or Calculated Fields (00:08) Overview of Reports we need to create (01:05) Calculated Fields Overview (01:58) Calculated Column For Net Revenue using ROUND and RELATED function [Read More >>>]

Excel 2013 PowerPivot Basics 08

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

Excel 2013 PowerPivot Basics 07

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

Excel 2013 PowerPivot Basics 06

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

Excel 2013 PowerPivot Basics 05

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

Excel 2013 PowerPivot Basics 04

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

Excel 2013 PowerPivot Basics 03

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

Excel 2013 PowerPivot Basics 02

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

Excel 2013 PowerPivot Basics 01

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