Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Topics in this video:
1. (00:01) Introduction
2. (00:30) Different Types of Formulas
3. (02:07) Formula Elements – what you can out into a formula.
4. (04:55) Formula 01: Goal: Add calls made a service center last week.: =SUM(C23:C29) . Number Formula.
5. (05:53) Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37/12. Number Formula.
6. (06:25) Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2) . Number Formula.
7. (09:31) Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58. Number Formula.
8. (13:17) Formula 05: Goal: Join "Text " and an Item Number into One Cell.: ="Item # "&C70. Text Formula.
9. (17:02) Formula 06: Goal: Join First & Last Names into One Cell.: =C82&", "&B82. Text Formula.
10. (20:43) Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2) . Text Formula.
11. (24:01) Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6) . Text Formula.
12. (26:00) Formula 09: Goal: Determine If Debits = Credits: =B127=C127. Logical Formula.
13. (30:00) Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula.
14. (33:35) Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156). Number Formula.
15. (35:15) Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173 Greater Than B166-C166. Logical Formula.
16. (41:00) Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185) . Number Formula.
17. (42:30) Summary - Conclusion

[tamimsajid]

I am an accountant, it will really help me a lot in my daily accounting calculations. I am really a great admirer of your beautiful videos, they are not less than a treasure for all of us. Thanks and regards.

[wagdyziada]

Easy, smooth jumping from 1 to 12, as usual you are EXCEL MASTER.

[sharonhanany]

I love this teacher's enthusiasm. When you start to properly learn Excel, it really is amazing.

[dudundutta]

As a beginner, this video really helped me to know how excel works. A very very big thank you for creating this content! I really enjoy all your videos

[TurboTeen]

It's absolutely fun doing all these questions

[ZEN]

The way you modulate your voice during the lectures makes the entire thing awesome..You are doing a great service to your viewers!!The coolest part about your videos is that;the more I watch them, the more I get interested to learn something
Thanks man and god bless u!

[MonirulIslam-zjve]

Sir,

Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

[jamesmyrthong]

You are a Great Teacher Mike👍👍. I never skipped your tutorials. It's one of the BEST. Thank You so much.

[sonialorenzo]

This is the best overview of formulas I have come across. I love it.

[michaelmurray]

Thanks for taking the time to do these videos. Once i have finished the basic 1-24 videos. Have you got another series you would recommend? Your a life saver as i haven't touched excel sincr secondry school. Your a brilliant teacher enthusiastic and you go through ever really slowly

[stefanopalliggiano]

Just in case anyone was wondering how to extract the product name instead of the state abbreviation or the 6-digit numeric product code at 24:01 : this is harder to do, because the number of characters depends on the name of the product (eg. Aspen has 5 characters, Carlota has 7 and so on). After playing around with the formula, I found that one way to do it is to use the LEN function, which returns the number of characters of a string, combined with the MID function, which extracts a specified number of characters starting from a specified n-th character. The full formula is MID(B96, 7, LEN(B96)-10). The "-10" is the overall number of characters that make up the state abbreviation, plus comma and space, and the numeric product code.

[SK-bvyd]

You're such an excellent teacher, and I love "homework"!Thank you so much!

[hazemali]

you are the only one in whole world can I not only understand but also love Excel

[manoharchaudhary]

Your videos are very easy to understand. Your videos are great and very helpful. With your videos Excel is really a fun to learn. Thanks for the videos Sir.

[mostafaahmedzein]

Thank you for being such an inspiring teacher, I'll keep commenting and Thumbs Up for each single video I watch! Keep up the good work... really appreciated <3

[omse]

it s very professional tutorial you really spend a lot of time for it thank you very much . LOT OF RESPECT

[northshoreunitarians]

I am so glad you taught me the Join function (using the ampersand) years ago at HCC. I do that ALL THE TIME at work. Such a handy trick!

[hrprk]

I really like the excercises in this video. I was away for 2 weeks, and coming back I needed a refresher. Thanks so much once again.

[trustinwwjd]

Whoa, , , what awesome Excel courses your teaching on YT Mr. Girvin, , , ,
Even with my limited brain-numbers, I can't help but finding your teaching so fun & interesting to keep watching! Also, Im let my friends n relatives know about your ExcelIsFun on YT !
GOD bless for all your good works, , ,

[AbhishekSingh-jutq]

Why you r giving such precious knowlegde for free i am amazed to see that some people in this world give free knowlegde thankyou sir.