Completed
) Learn How Number Formatting can save a lot of time with Data Entry
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