Download Start Excel File: http:\/\/ift.tt\/2E2Fiba
\nDownload pdf Notes: http:\/\/ift.tt\/2ERWqBG
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
In this video learn how about the benefits of Number Formatting, How Formulas do NOT \u201csee\u201d Number Formatting, and how to use the ROUND Function to avoid calculations errors.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (00:39) What does Number Formatting do? Learn about Number Formatting as Fa\u00e7ade
\n3. (03:10) Formulas do not \u201csee\u201d Number Format. Learn about how formula results may be misleading because of Number Formatting.
\n4. (04:58) Learn How Number Formatting can save a lot of time with Data Entry
\n5. (06:57) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting
\n6. (11:18) Example of Error in a Payroll example when we do NOT use the ROUND Function
\n7. (14:50) Round Numbers by Hand. Rule for Standard Rounding Rule.
\n8. (18:07) Excel\u2019s Built-in ROUND Function. Learn how to use it and When you MUST use it.
\n9. (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.
\n10. (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.
\n11. (31:13) Summary<\/p>\n
Next Video: Excel & Business Math 04<\/p>\n