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 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 […]
Determine Quarter For column of Dates: CHOOSE or CEILING function? DESCRIPTION See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See […]
Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]
Master Excel
Leave a Reply
You must be logged in to post a comment.