Excel & Business Math 08: Arithmetic Tips for Add, Subtract, Multiply, Divide, Exponents, Rounding

In this video learn many tricks with Excel formulas for basic math operations.
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. (01:13) Whole Numbers, Integers & Decimals Words
3. (03:22) Write Number in English
4. (05:34) Math Operators & Order of Operations
5. (07:55) Adding in Excel – many important tricks for adding
6. (16:53) Subtracting in Excel– a few tricks for subtracting
7. (19:86) Check Work When Subtracting or Adding
8. (21:31) Multiplying in Excel– many important tricks for multiplying
9. (28:91) Money amounts that with be added – Use ROUND
10. (30:21) Dividing in Excel – many important tricks for dividing. See the QUOTIENT and MOD Functions
11. (39:40) Check Work When Multiplying or Dividing
12. (41:20) Exponents – how to calculate and write in Excel
13. (46:84) More ROUND Examples
14. (54:23) Summary

Next Video: Excel & Business Math 09

Thanks you very much for your fantastic teaching. Be healthy and happy.

[georgekakar]

This fantastic and incredible teaching.

[mohamedchakroun]

You are incredible man you teach us even how we succes if we love what we do :-)

[SaurabhAgrawal]

How does it show the formula written in the next cell when you apply any formula. Many thanks for such amazing videos 😊

[mervynjack]

In the Divide tab, the first example answer is actually 422.1428571 and that is what is displayed on my version of the spreadsheet. You have not explained what you have done on your copy of the spreadsheet to only display to 2 digits. I'm wondering what the industry standard would be for that? Great videos by the way, loving the learning.

[rokadebt]

How to subtract 2 or multi digit numbers in separate columns in excel like giving in books of maths in 3rd or 4th standard