Excel Is Fun

Highline Excel 2016 Class 25

DESCRIPTION In this video learn about: (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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1333

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and [Read More >>>]

Excel Is Fun

Excel Magic Trick 1192

Match Lookup Value to Closest Number in 1st Column of Lookup Table DESCRIPTION What to do if you need to match Lookup Value to Closest Number in 1st Column of Lookup Table: (00:10) Problem Set [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 >>>]