Completed
) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel and Business Math - Number Formatting and When You Must Use Round Function
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What does Number Formatting do? Learn about Number Formatting as Façade
- 3 ) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting.
- 4 ) Learn How Number Formatting can save a lot of time with Data Entry
- 5 ) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting
- 6 ) Example of Error in a Payroll example when we do NOT use the ROUND Function
- 7 ) Round Numbers by Hand. Rule for Standard Rounding Rule.
- 8 ) Excel’s Built-in ROUND Function. Learn how to use it and When you MUST use it.
- 9 ) 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 ) Second example of how to apply our three-step rule for when the ROUND Function is required. This is the Payroll Deduction Example.
- 11 ) Summary
