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.
(05:48) MROUND, CEILING and FLOOR round to an amount or multiple.
DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]
DESCRIPTION See how to create formulas to calculate Insulin needed with the formula inputs: Total Carbs in grams, Carb Ratio, Blood Glucose Test, Blood Glucose Target, Correction Factor: (00:12) Problem Setup (00:25) Excel’s Golden Rule [Read More >>>]
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 >>>]
Master Excel
Leave a Reply
You must be logged in to post a comment.