Excel and Business Math - Number Formatting and When You Must Use Round Function

This course explains how Excel number formatting changes displayed values without changing underlying numbers, then teaches standard rounding and Excel’s ROUND function to prevent calculation errors in monetary examples.

Syllabus

) Introduction.
) What does Number Formatting do? Learn about Number Formatting as Façade.
) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting..
) Learn How Number Formatting can save a lot of time with Data Entry.
) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting.
) Example of Error in a Payroll example when we do NOT use the ROUND Function.
) Round Numbers by Hand. Rule for Standard Rounding Rule..
) Excel’s Built-in ROUND Function. Learn how to use it and When you MUST use it..
) Examples from Video #3. See an example of how to apply our three-step rule for when the ROUND Function is required. This is the Insurance Discount Example..
) Second example of how to apply our three-step rule for when the ROUND Function is required. This is the Payroll Deduction Example..
) Summary.