Download Start Excel File:
Download pdf Notes:
Entire Class Web Site:
In this video learn how about the benefits of Number Formatting, How Formulas do NOT “see” Number Formatting, and how to use the ROUND Function to avoid calculations errors.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:39) What does Number Formatting do? Learn about Number Formatting as Façade
3. (03:10) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting.
4. (04:58) Learn How Number Formatting can save a lot of time with Data Entry
5. (06:57) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting
6. (11:18) Example of Error in a Payroll example when we do NOT use the ROUND Function
7. (14:50) Round Numbers by Hand. Rule for Standard Rounding Rule.
8. (18:07) Excel’s Built-in ROUND Function. Learn how to use it and When you MUST use it.
9. (24:55) 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.
10. (28:53) Second example of how to apply our three-step rule for when the ROUND Function is required. This is the Payroll Deduction Example.
11. (31:13) Summary
Next Video: Excel & Business Math 06
