Excel & Business Math 05: Number Formatting & When You MUST Use ROUND Function скачать в хорошем качестве

Excel & Business Math 05: Number Formatting & When You MUST Use ROUND Function

Download Start Excel File: https://people.highline.edu/mgirvin/A... Download pdf Notes: https://people.highline.edu/mgirvin/A... Entire Class Web Site: https://people.highline.edu/mgirvin/A... 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