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

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

[DIGITAL_COOKING]

and when Mike said that round does really matter ..yes!! indeed; I did this mistake before a lot of time
because I didn't know the situations that we must use round function instead of number formatting, and those details are very important
everything we learn in excelisfun is very important...
great video mike as usual !

[jM-qmno]

I have learned very much from you ，thank you🤗

[alirezamogharabi]

Thanks mike, you are the best excel functions teacher in the world!

[MindoverX]

Hey Mike! Long time! Glad you provide these videos for our use! I did really enjoy being in your class in 2011 and enjoyed your presentations. I do sneak in and remind myself for functions as often as I can :)

[johnborg]

I am always glued to my comp even though these are basics. Awesome :)

[rodleaverton]

Fantastic, Mike! Really enjoying the new Business Math series. Incredibly well done ... as always. Hope you are well, my friend.

[SyedMuzammilMahasanShahi]

Thank you Mike for another amazing video.

[prashantrawat]

Very helpful video. I never use round. I am going to use it now

[ismailismaili]

wow thank you so much Mr. Mike it's really useful i appreciate

[barttitulaerexcelbart]

Mike thank you for well explaining the difference between accounting an currency. There is also a button for formatting accounting. Do you know (or someone else) how to change the default currency for that button?

[namasteygermany]

hello sir,
could you please tell me the meaning of this function??
=1/MAbsC(K1:L2, 3) in excel