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

Highline Excel 2013 Class Video 18

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

Excel Is Fun

Highline Excel 2013 Class Video 16

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