Excel and Business Math - Number Formatting and When You Must Use Round Function

Excel and Business Math - Number Formatting and When You Must Use Round Function

ExcelIsFun via YouTube Direct link

) Learn How Number Formatting can save a lot of time with Data Entry

4 of 11

4 of 11

) 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. 1 ) Introduction
  2. 2 ) What does Number Formatting do? Learn about Number Formatting as Façade
  3. 3 ) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting.
  4. 4 ) Learn How Number Formatting can save a lot of time with Data Entry
  5. 5 ) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting
  6. 6 ) Example of Error in a Payroll example when we do NOT use the ROUND Function
  7. 7 ) Round Numbers by Hand. Rule for Standard Rounding Rule.
  8. 8 ) Excel’s Built-in ROUND Function. Learn how to use it and When you MUST use it.
  9. 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. 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. 11 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.