Excel & Business Math 20: Percent Formulas for Part, Rate & Base (8 Example)

In this video learn how to use the three famous percent formulas for Part, Rate and Base. These formulas are universally used and when mastered can transform the way you make calculations and the way you can consume business news.
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:29) Percent Formula and Definition of Terms
3. (07:23) Introduction to 3 Different Versions of Percent Formula, including why they are TRUE and a Great Memorization Trick
4. (11:52) Example 1
5. (15:35) Example 2
6. (17:43) Example 3
7. (20:30) Example 4
8. (23:12) Example 5
9. (25:15) Example 6
10. (27:56) Example 7
11. (29:37) Example 8
12. (31:50) Summary

Next Video: 21 Excel & Business Math

[alexxgalindo]

Thanks sir, I've been learning a lot, you're amazing

[ismailismaili]

it's fun, useful, happiness and the best of all than you made it so easy to understand thank you so much Mr. Mike

[myunghayes]

Thanks again, it was good idea to use hand. SO we shouldn't be so lazy... ✋🏼

[kisslaci]

I would like to ask you for your recommendation. Which of your videos (doesn't have to be 1) is/are the one(s) that you would recommend to watch to get a more superficial feel for Excel, but which covers all (or as much as possible) options within the program? I am not a beginner anymore, mostly thanks to you, but a I am watching your videos for accountants and for many uses of specific formulas I was just wondering if I may have missed videos which are covering bases more as a whole. Thank you in advance, the videos are great and very easy to understand.

[kerryjking]

Nice work Mike. I notice in your first example of using someone's statement to complete a calculationi.e. "this years sales were 110% of last years sales" you only had 1 part of the equation so you could not complete either of the other 2 components(Part or Base). Am I correct or have I missed something?

[heraldstarfire]

There is an error in the Homework assignment #6. Answer sheet you have 3360 as the number of shopper in one day. The number should be 3680. Was double checking you answer with mind and was wonder why it was off.

[aamir]

good morning dear sir,
i need a lookup formula in which the answer should be the some of expenses between two date e.g i have the monthly expenditure for my shop or home and i need to check that how many money i spent from 2nd jan to 11 jan etc

[NoShadowOfDoubt]

The CPAs I know violate not only Excel rules.., .