Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 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 PowerQuery and PowerPivot: 1. Using PowerQuery import three data [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 12

DESCRIPTION See how to create Student GPA Grade by Class for each High School, with each report on a new sheet, automatically using a PivotTable and Show Report Filter Pages. This feature is NOT available [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) [Read More >>>]

Excel 2013 PowerPivot Basics

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

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

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

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

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

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

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