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

Dueling Excel

Dueling Excel 018

March 18, 2015 0

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions […]

Dueling Excel

Dueling Excel 017

March 17, 2015 0

DESCRIPTION See Mr Excel and excelisfun Create 5 formulas to count times greater than five minutes. Excel functions COUNTIF and TIME. Different syntaxes for the criteria argument in the COUNTIF function WORKBOOKS