### Dueling Excel 92

Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS

### Dueling Excel 71

ROUND to 4 or 2 Formula or Conditional Formatting? DESCRIPTION See Mr Excel and excelisfun round numbers to 2 if the column says “DOLLAR” and 4 if the column says “CRUDE” using the functions ROUND, [Read More >>>]

### Excel Magic Trick 1145

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards [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 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 >>>]

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

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