Download Start Excel File: http://ift.tt/2E2Fiba
Download pdf Notes: http://ift.tt/2ERWqBG
Entire Class Web Site: http://ift.tt/2BjafuY
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 04