Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 09

April 9, 2015 0

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

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 Is Fun

Highline Excel 2013 Class Video 18

February 17, 2015 0

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your […]

Excel Is Fun

Highline Excel 2013 Class Video 16

February 15, 2015 0

DESCRIPTION Topics in this video: (00:09) ROUND function so Invoices and Payroll spreadsheets are accurate. (03:49) ROUND to the penny, dollar or thousands position. (04:28) ROUND, ROUNDUP, ROUNDDOWN functions round to a digit or position. […]