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 See how to create nine DAX Formulas that build a Confidence Interval: (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video (03:34) Formula [Read More >>>]
DESCRIPTION See how to Create Formula to Extract Each Item In List & Display In Every Third Column. Topics: (00:15) Introduction to Problem (01:03) Formula Element Number Incrementor to create pattern like: 1,1,1,2,2,2,3,3,3… See functions [Read More >>>]
DESCRIPTION Formulas for Quarters, Fiscal Quarters & Fiscal Years: (00:07) Quarters using CEILING and MONTH function (02:48) Fiscal Quarter using LOOKUP and MONTH (05:24) Fiscal Quarter using IF, MONTH and CEILING (06:40) Fiscal Year using [Read More >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.
Leave a Reply
You must be logged in to post a comment.