Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.

Learn about the fundamentals of Excel Formulas and Functions in 10 minutes. Excel Workbook for download so you can follow along.
Topics:
1. (00:01) Introduction
2. (00:57) Equal Sign Starts all Formulas.
3. (00:57) Create Formula to correctly round and calculate Sales.
4. (01:08) You can use Arrow Keys to put Cell References in Formula, or the Mouse.
5. (01:26) Math Operators +,-,*,?,^ and ()
6. (01:39)Ctrl + Enter Puts Formula in Cell and Keeps Cell Selected.
7. (01:46) Cross Hair or "Angry Rabbit" can Double-Click Fill-Handle to Copy Formula Down a Column.
8. (02:17) Be sure to check the last cell with the F2 Key.
9. (02:29) Cell References, such as C8 are Relative Cell References, and move throughout Copy Action.
10. (02:44) Keyboard for SUM Function is: Alt + =
11. (03:02) You must use ROUND Function when: 1) You are Required To Round (like with $), 2) You have Extraneous Decimals, and 3) You will use Formula Result in a Subsequent Formula.
12. (04:24) Create Formula to correctly round and calculate Tax Amount.
13. (04:40) Excel's Golden Rule: If a Formula Input can change, put it cell with Label and refer to it in the Formula with a Cell Reference.
14. (05:14) Cell References, such as $I$14 are Absolute Cell References, and are locked throughout Copy Action. F4 adds $ Signs to Cell Reference to lock it.
15. (05:57) Create Formula to calculate Net Sales.
16. (06:11) Be careful when using keyboard for SUM Function.
17. (06:23) Number Formatting only formats the surface of the cell. It does not change the Underlying Number. Formulas do not see Number Formatting.
18. (06:57) Number Formula: Use Math Operators or Functions to calculate a number answer. Numbers are aligned to the right by default.
19. (07:00) Text Formula: Use Join Operator, "Text" in quotes or Functions (like DOLLAR Function) to deliver a text answer. Text is aligned to the left by default.
20. (07:20) Join Operator (&) can be used in Formulas to join items.
21. (8:00) Problem with Cross Hair or "Angry Rabbit" for Double-Click Fill-Handle.
22. (08:12) DOLLAR Built-in Function to apply Currency Number Formatting to a number in a text formula.
23. (08:53) Visual Cue to know whether you have a Number or Text.
24. (09:06) Logical Formula: Use a Comparative Operators or Functions to deliver a TRUE or FALSE. TRUE & FALSE are aligned in the Center by default.
25. (09:30) Comparative Operators .
26. (09:50) Test our Formula Model that we built.
27. (10:12) Summary

[msantosh]

Request all viewer to leave your comment after watching this🙏🙏🙏 I believe that youtube will promote our excelisfun channel to other new viewer if they see high number of interaction on this channel this is how the youtube AI has been developed, request you all to do ur bit if u agree vid me.

[arunkhanal]

On your own word, it is just like one-stop shopping. Many different things can be understood in an easy and smooth way, yet maintaining a high standard of presentation. Hats off, Mike!

[FranktheDachshund]

Teaching so much in such a short time, ...thank you!

[excelisfun]

Topics:
1. (00:01) Introduction
2. (00:57) Equal Sign Starts all Formulas.
3. (00:57) Create Formula to correctly round and calculate Sales.
4. (01:08) You can use Arrow Keys to put Cell References in Formula, or the Mouse.
5. (01:26) Math Operators +, -, *, ?, ^ and ()
6. (01:39)Ctrl + Enter Puts Formula in Cell and Keeps Cell Selected.
7. (01:46) Cross Hair or "Angry Rabbit" can Double-Click Fill-Handle to Copy Formula Down a Column.
8. (02:17) Be sure to check the last cell with the F2 Key.
9. (02:29) Cell References, such as C8 are Relative Cell References, and move throughout Copy Action.
10. (02:44) Keyboard for SUM Function is: Alt + =
11. (03:02) You must use ROUND Function when: 1) You are Required To Round (like with $), 2) You have Extraneous Decimals, and 3) You will use Formula Result in a Subsequent Formula.
12. (04:24) Create Formula to correctly round and calculate Tax Amount.
13. (04:40) Excel's Golden Rule: If a Formula Input can change, put it cell with Label and refer to it in the Formula with a Cell Reference.
14. (05:14) Cell References, such as $I$14 are Absolute Cell References, and are locked throughout Copy Action. F4 adds $ Signs to Cell Reference to lock it.
15. (05:57) Create Formula to calculate Net Sales.
16. (06:11) Be careful when using keyboard for SUM Function.
17. (06:23) Number Formatting only formats the surface of the cell. It does not change the Underlying Number. Formulas do not see Number Formatting.
18. (06:57) Number Formula: Use Math Operators or Functions to calculate a number answer. Numbers are aligned to the right by default.
19. (07:00) Text Formula: Use Join Operator, "Text" in quotes or Functions (like DOLLAR Function) to deliver a text answer. Text is aligned to the left by default.
20. (07:20) Join Operator (&) can be used in Formulas to join items.
21. (8:00) Problem with Cross Hair or "Angry Rabbit" for Double-Click Fill-Handle.
22. (08:12) DOLLAR Built-in Function to apply Currency Number Formatting to a number in a text formula.
23. (08:53) Visual Cue to know whether you have a Number or Text.
24. (09:06) Logical Formula: Use a Comparative Operators or Functions to deliver a TRUE or FALSE. TRUE & FALSE are aligned in the Center by default.
25. (09:30) Comparative Operators .
26. (09:50) Test our Formula Model that we built.
27. (10:12) Summary

[junaopako]

Mike, you're angel of excel. You have exceptional talent to explain excel on efficient and beautiful simple way. Almost everything I learn about excel, for about 6 years, I learn from you, and that knowledge keeps me safe on my job. God bless you. Greetings from Serbia (Novak Djokovic).

[harismuhammad]

Spending 10 mins to see this video is really a worth for those love to learn excel.This videos is innovative solution of simple formulas in MUCH different way. "Thanks MIKE"

[MrGaurav]

Thanks Mike I have learned a lot from you.
You can also press (cntr + r) to copy the sum formula to the right cell !

[katerina]

The 10 minutes Videos are wonderful, Mike you emphasise so many details, thank you
Have a great New Years Eve Mike

[wayneedmondson]

Hi Mike. An awesome review of formula and function best practices and tips! Thanks and Thumbs up!!

[yulinliu]

Amazing 10 mins of teaching and learning. Thanks Mike and happy 2020.

[briandennehy]

Soooo many great tips and best practice in here, follow Mike and you'll never go wrong 👍

[sovereignruler]

You're making this complex stuff way too easy. Thank you and Happy New Years!

[Ali.Mostafa]

Amazing! Here goes the reward of (best 10 mins Excel tutorial)!

This video really solved a specific problem I face starting Excel with someone who already knows Excel.

With the idea of this video, A quick run through excel will show the weak points of each individual to give him tailored lessons! .. Really amazing! Thank you Mike... An amazing video idea that can be studied and expanded to all teaching fields.. Now you're teaching not only excel but (how to teach)

[methulinkiwane]

I just wanna take this moment and thank you very much you have helped me understand a lot that I could not i will properly thank you in life you are doing such a fantastic job you deserve an OSCAR

[trevormoz]

Thank you so much for your videos. I refer all my coworkers to your channel if they want to learn more about Excel. Happy New Year!

[sachinrv]

With Excel being evolved so much in all these years, it is difficult for anyone to emphasis on each and every small details; but you have covered kind of "all you want to know" it so well. A well rounded video. Thanks :)

[Accountant-pq]

I love your videos. I've learned a lot. love your training skills and the best of all is that it is so easy and fun! thank you so much for sharing your knowledge.

[tajsay]

That was great tricks and quick too..Thanks for the video Mike.

[nsanch]

That was a good video Mike. I didn't know about the dollar function. Hey Mike I'm celebrating a birthday today and had to study one of your videos. When I study your videos,  I learn so much, and when I learn things, I feel like I'm getting better; and getting better is how I want to think about being 1 year older :) Thank you Mike.

[harishpaldhir]

Mike sir

With ur videos U have made excel easy for students like us

Really excel is fun sir

Thanks a lot sir 😈😈😈