Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts
ฝัง
- เผยแพร่เมื่อ 16 ต.ค. 2017
- Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Finished File: Download File: people.highline.edu/mgirvin/Y...
Download Full Written Notes: people.highline.edu/mgirvin/Y...
Class web page link: people.highline.edu/mgirvin/A...
Buy excelisfun products:
teespring.com/stores/excelisf...
Topics in this video:
1. (00:01) Introduction
2. (00:25) Goal of video
3. (03:07) Type labels for Net Income Projection Table and Assumption Table
4. (07:18) Add Stylistic Formatting
5. (09:00) Enter Formula Inputs
6. (09:35) Format Cells Dialog Box using Ctrl + 1
7. (13:43) Start Revenue Formula (we are not copying this formula anywhere)
8. (14:12) Revenue Increase Formula (uses Relative and Absolute Cell References):
9. (15:50) Why Percentage Revenue Increase Formula is TRUE
10. (19:26) The Beauty of Excel
11. (20:23) Expense Formula (uses Relative and Absolute Cell References)
12. (22:15) Why Expense Formula is TRUE
13. (22:30) Net Income Formula (uses two Relative Cell References)
14. (24:05) Insert Chart: Column Chart
15. (25:03) Move and Resize Chart
16. (26:12) Format Chart with Green Plus
17. (27:00) Discuss Chart Junk
18. (27:44) Delete Chart Elements
19. (28:22) Open Chart Formatting Task Pane with Ctrl + 1
20. (30:36) Link Chart Title to Cell
21. (32:56) Use Alt Key to Snap Chart to Grid
22. (32:26) Excel’s Golden Rule
23. (32:26) Use Assumption Table (Formula Input Table) to change Formula inputs and watch everything update
24. (34:26) Page Setup
25. (36:56) Summary
![[Watch Party] APL 2024 Bacon Time Vs Hong Kong Attitude ชนะเข้ารอบ](http://i.ytimg.com/vi/ikUfW81sDaw/mqdefault.jpg)
I just wonder how can you be so generous where many are charging for excel tutorials. You truly have a big heart i must say.
Just trying to make the world a better place : ) : ) You can help support with comments and thumbs ups on each video that you watch ... and tell all your friends : )
I'm 33 years old and just started learning Excel! Thank you for your instructions!
You are welcome!!!
Your explanations are so detailed that even though I already know all this, I have watched the entire videos just so I don't miss anything new.
I am glad that the videos and story i tell work for you, Jose!!! Thanks for your support with your comment, thumbs up and Sub : )
i bought a course and didnt like it.... googled till i found this... now it is actually fun to learn excel! thanks a lot
Cool. This is what i have been doing for 14 years at TH-cam: Free and Fun Excel Education for the world : ) I do change Thumbs Ups, though ; )
Best Excel teacher I have ever met on y-tube My Excel has improved within two days of watching your videos
I am glad to help : )
I found you over 12 years ago and you are STILL my FAVORITE source for help with excel. Thank you!!!
You are welcome for SQRT(144) years of fun Excel help : )
I want to learn Excel for employment opportunities...was searching over the internet regarding available resources & one of the answers over Quora suggested your name... believe me I'm very glad I got introduced to your channel...your teaching methodology is very in depth, your slow pace & patience is applaudable. Thank you very much!!!
You are welcome very much!!!
Thank you so much. This is by far the best Excel training I've ever come across.
New Basic series, great! I'll follow this.
Thanks to your other videos I got the job I wanted, passed excel test quite smoothly on the interview!
That is awesome to hear that the videos helped you to get a job : ) Thank you for the continued show of support with your comment and Thumbs Up on each video : )
I'm envious that you can be so passionate about what you're doing AAAAANNNNNND be so good at it too! (I hope you enjoy it...because you are the best Excel Maestro out there...please don't ever leave us.)
Not much but I just wanted to leave a comment and like.. This channel is amazing. I just got started with excel seriously from yesterday and this journey feels amazing. Thank you so much.
You are welcome so much!!!
There were a couple new things I learned from this video: Ctrl + 1 and using the Alt Key to snap a chart to a grid. Also along with the Excel Basics 1 video, this video has taught me how to make page setups look aesthetically pleasing. I promise after every video, I'll comment what new things I've learned.
Very well taught. Thank you very much for the time you put into these videos.
Honestly sir, I have been having plans to go for an excel class but after witching this your video, I decided to practise on my pc and amazingly, everything worked sweetly . Appreciation of the highest esteem.
I am glad that my free classes can help!
Dear Sir,
Although we may not have the chance to meet in person and shake hands, I still wanted to convey my heartfelt gratitude for the incredible videos you have shared. Your content has been immensely enlightening, enabling me to become computer literate without the need for formal classes. Your exceptional abilities and unwavering dedication to teaching are truly admirable. Thank you for infusing your work with such profound love and passion. In a world that greatly benefits from individuals like you, your contributions shine as a beacon of inspiration. May you be blessed abundantly for all that you do.
With utmost respect,
Sunil (India)
Thank you for your very kind words and appreciation, Sunil!!!! I am happy to help you : ) : )
Wow, thank you! The effort put in this is amazing! Even though I don't need them, I noticed you added English subs; so cool of you! The tricks here were so useful and I will definitely be using them in the near future. l will try and share your course for anyone who needs it because I am impressed already. Thanks again
You are welcome, PB!!!!! I am glad you liked all the elements in the video and ancillaries! Thank you for the support with sharing, subbing and all : )
Man, I learned everything I need at work from your videos, u r amazing
Hi Sir, honestly saying you is amazing I don’t have words to say. I have been learning Excel through your channel, whenever I met difficulty with excel I just come to your channel & watch your videos. You help me understood the concept clearly. Thank you sir and wish you all the very best
You are welcome, Sir!!! You don't need the exact words to say thanks - just be sure, on every vid, to click that Thumbs Up and leave a small comment, and be sure to Sub and click the bell so you know when new vids come out. Thanks for your support, mohammed!!!!
I watch a lot of how-to videos on different topics. This channel is one of the best in terms of clarity and effectiveness. No screwing around with long intros, no rambling, just right to the point. This person lives and breathes Excel.
Thanks for all the help!
You are welcome for the non-rambling breathing Excel fun, tocodelray!!!
Seeing how you use absolute cell references for the formulas here was a real eye opener. This is going to save me a ton of time. The chart formatting tips were also incredibly helpful. Thank you for another great video!
You are absolutely welcome : )
you are the best master i ever listen for , god bless you
I literaly love the small tricks which you incorporate in every video
The good news is that if you love Excel tricks, it greatly helps you in your professional career ; ) Thanks for the support, rc, with your comment, Thumbs Up and Sub : )
I have been looking for a while to improve my Excel skills and your videos are bringing all new and smart techniques to the very basics, which is keeping me interested.
Awesome! I am glad that they help with interest and skills!!! Thank you for the support with your comment, Thumbs Up and Sub - it helps me to keep going : )
The way you explain is like we're having a conversation so much engaging that we even lost the track of time and don't want this to be over anytime soon.
This is just one video, when it ends, there are more. I am glad that the content works for you, Rehan! Thanks for your support on each vid that you learn from with your comment, Thumbs Up and a Sub : )
Your video is really helpful for me and I like the way you teach in the video. Keep teaching us through your amazing excel tutorial. Thanks.
Dude, you have the best voice for teaching and are to the point in a clear, concise manner. These videos are perfect.
Thank you for your kind words! Thanks also for the support with your comment, Thumbs Up and Sub : )
You are the most amazing excel teacher on youtube, I tried many channel but only your channel can keep my attention that long. Even for simple thing that experienced excel user may know, you still add some of your own twist and take on it. Appreciate your enthusiasm for Excel!
You are so welcome, Hao Hung!!!!! Thanks for your kind words : ) Thank you also for your support with your comments, thumbs ups on each video that you learn from and of course your Sub : )
Never have seen better person and style to teach Excel. With your videos ´ tematic lists I finally found the point where to start my Excel learning. I appreciate your geniality & monumental effort to share your knowledge.
You are welcome! I am glad that you found my videos. A thumbs up on each video is the only cost ; )
真的是太神奇了，你的讲解真是令人愉快。感谢你所付出的一切
Hi! I'm an Inventory Specialist/Auditor and most of this formulas I really didn't know till my boss told me to level up my excel proficiency and found your tutorial, this really help me from eb01 to eb02 and still following your awesome tutorials.
Another fantastic tutorial. Much appreciated Mr. Grivin.
You are welcome, Miles!!! Thanks for your support : )
another great video, loving so far!
Revisit today to refresh what I had learned 2 months ago. The lesson is simple and easy to understand. Love it 👍
Glad it helps!
Great work again~~ Second tutorial of the day, all about keep learning.
Thank you for your support with comment, Thumbs Up and your Sub : )
The best channel for learning Excel.
I just watched the first video - I cannot believe how much I learned, some of which was just the names for what I had been doing all along, some key stroke short cuts. Looking forward to this video next.
Love to hear that you are learning names, and other useful things from the video, Laurel!!! Thanks for stopping by in the comments and support the cause with your comment and thumbs up : ) : )
Thank you for being so thorough in your teaching.
You are welcome! Thanks for the support, Deidre, with your comment, Thumbs Up and Sub : )
Always amazed about your clear explanation. Excellent clip!
You are welcome! Thanks for the kind words and for your support with comment, Thumbs Up and your Sub : )
Center Across Selection is a tool I didn't know existed even with 10 years Excel experience! I shun merged cells but didn't know the alternative. THANK YOU!
You are welcome!!!! As you know, Merge & Center just cause too much trouble.... I am glad that I know about Center Across Selection too : ) Thanks for your support on each vid!!!
I learned about Excel in school and used it often in my last job, but mainly the basics just entering money and didn't mess with it too much. With my current job I use excel daily and there are some things I don't remember how to do! I am grateful for your videos, they have helped a lot.
That is why I post : ) Glad the videos help, Ashley!!!
Thank you so much for these videos. You are a great teacher, so well explained.
Thank you for your kind words! I am glad that the videos help. Thank you for the support with your comment, Thumbs Up and Sun : )
I wish I could give your tutorials more than 1 thumbs up. So many people think they know Excel, but really only know a handful of useful tips. Your lessons are clear, concise and so informative I have watched them more than once. Thank you so much!
You are welcome so much. And I will be very happy if you click 1 thumbs up and 1 comment on each video that you learn from, Amanda : ) : )
Great job sir, you are amazing before watching videos many problem in execl that's be solve one by one.
whichever video of yours I see there is always a lot to learn. thanks a lot
thank you for this great efforts
The best excel teacher for all time, I'm glad to take your courses
Thanks a lot
You are welcome, Youssef!!! Thanks for your best support of all time with your comments and thumbs ups on each video that you watch : )
it helps sooooo much, thank you very much! I've already watched 10 videos and I already feel myself like a guru of Excel :D
Glad my videos can help : )
excellent excellent tutorial, you are the bossssssssss of excel. Continue the wonderful works, may God bless you Sir.
I will continue making videos for people to learn from : ) Thank you for the support with your comment, Thumbs Up and Sub : )
It is the supreme art of the teacher to awaken joy in creative expression and knowledge.
- Albert Einstein
Sir/Prof Micheal Girvin teaches with passion thus awakens joy in everyone that follows his lessons. Many thanks sir, thank you is understatement. infinite gold thumb
Many you are welcomes, Mohamed!!! Thank you for your kind words and thoughts : ) : )
This is an awesome tutorial, thanks for making learning fun and pleasurable.
You are welcome! Thanks for the support with your comment and thumbs up : )
Completed your second class and man do I love your videos.
I am glad that you love the vids! Thank you very much for the support with your comments, Thumbs Ups and Sub : )
this whole series is so neat, nice and oh God i can't thank you enough for making these videos and putting so much effort. gbu!
Glad to help, vania : )
Thank you very much! This helped me a lot, very well taught!
Glad you like it, Lily! Thanks for your support with your comment, Thumbs Up and Sub : )
Good explanations ,Sir .Thank you so much .
Thank your lessons! It's so thorough and fun to follow.
I am glad that you enjoy the lessons!
Great lesson! I have got to focus well and it is very well explained , detailed,right speed...
It was really helpful. Thanks a million!
You are welcome a million : )
Thank you so much for the Amazing Explanation
Thank you for these videos. They have been extremely helpful!
You are welcome, Julia!!!
many and many valuable points and notes in one flexible example,,,,,, very simple but smart explain. Very much appreciated.
You are welcome! Thanks for helping this channel with your comment, Thumbs Up and Subscription : )
Thank you. Learned a lot!.
I saw a reference of your channel in under other excel videos on TH-cam. Hands down best channel regarding this subject, PERIOD
Glad you like my channel, Franek!!! For 12 years I have been posting over 3000+ free videos and classes. Here is the 2 minute video that shows how to find the video or class that you want: th-cam.com/video/l1-1aVgFth4/w-d-xo.html
Extremely useful video, just as all the others. Thank you very much for taking the time to create them!
You are welcome for the time and video!! Thank you for the support with your comment, Thumbs Up and Sub : )
Great videos sir. People are getting full benefit.
You are just an awesome person what u really love about your videos that you are doing a great perfect job with no confuses thank you for the info it was really useful
You are welcome for the useful info! Thank you for helping with your support of comment, Thumbs Up and Sub : )
I've subscribed you from 2013 I'm a bigger fun of yourself because you make me hit my target in accounting and being the best employee in my company thanks a lot Mr. Mike
Thank you for your support since 2013 : ) You are welcome a lot for helping you at work! Now you can help me to be even better at TH-cam by clicking Thumbs Up and a small comment on each video, and tell all your friends : ) It helps me to continue to bring you and our other Teammates more and more videos : )
yes for sure i will do inform my friends and i love anything about excel so i'm following you video by video thank you so much Mr. Mike
Wonderful course clear, detail, very helpful, excellent. I will continue!
Glad yo hear that you liked the first one, j t!!!! Here is the 2 minute video about the playlist for this class and how to find files and such: th-cam.com/video/7rLSZYiz7qE/w-d-xo.html See ya in the comments : )
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.
You are welcome, Md. Monirul Islam!!! I will continue to make a post fun and informative videos. Thank you very much for the support with your comments, Thumbs Ups and Sub - it really helps the excelisfun channel here at TH-cam : )
Wow. Thank you Mike.
You are welcome. Thanks for all of your support : )
Learned so many things in this one amazing video. Thank you so much.
You are welcome so much!!!!!
I appreciate this so much. Thank you!
You are welcome so much, Matthew!!! Thank you for your support with your comment, Thumbs Up and Sub : )
I have been learning Excel through your channel
I aglad that my videos can help : )
Pls also see my channel related to excel
It has some great and time saving tips
Would love your feedback on it.
Just so great videos, thx ExcelIsFun 👍🙏
You are welcome, Henrik!!!!
Wow I must say this is extremely helpful! Right when I had a q about something you already gave a simple explanation at 22:22! Even on Reddit Excel page they recommend your videos I can see why. Thank you so much!
You are welcome so much : )
These vids now make me a excell pro. Keep teaching. Good work.
You are welcome, New Excel Pro Balfour!!!! Thanks for your support with your comment, thumbs up and of course your Sub : )
Greatttttt as usual.... Was waitinggg for when is next excelisfun video uploading...
Thankkkkkkksssss!
Thank you. I like your style of teaching. the best!
You are welcome, Boss Tucker! I am happy to help! Thanks for your support on each video that you learn from with those comments, thumbs ups, and of course your sub : )
Great lecture and unique of its kind. 👍
Thanks for this video. Learned a lot.
Glad you learned a lot!
This youtube channel has made me a god at work lol, thank you so much.
You are welcome for that help at work, hawaiisurf614!!!! Thanks for your support on each video : )
Wonderful great teacher .
Great videos thank you for making these, I'm excited to go through and learn all I can about Excel. I really like how you go in detail step-by-step, very useful.
You're very welcome!
Wonderful! Thank you!
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
Thanks sir very good , Your skill amazing.
i have no words for you sir great great with good hearts
Your words are good : ) I am glad you like the class, Sawai!!
thanks for the useful content, and i really enjoy your explanation.
You are welcome!
That is a great piece of video, Am really confident it will change my knowledge on how to use excel
I am so glad to hear that this will help you, chieng!!!! Thanks for your support with your comment, thumbs up and Sub : )
soooooooooo helpful and sooooooooo easy to understand I! Love! you!
You are awesome!!
Great work!!
Helping me a lot!
I have subscribed.
Glad to help you a lot, JJ K!!!!
Thank you Sir And love YOU
Thanks again hehe Your lesson is great and easy for me to understand
You are welcome : )
Another good video, thank you.
You are welcome!!!
Loving it.Thank you so much
You are welcome, kavimani!!!
Thank you for your efforts on these detailed videos. You have indeed made learning excel fun. :)
I am glad to help you with learning Excel, Suchitra!!!
@@excelisfun If you could help me on this, it would be really great. So I have a data on closing stock prices for 5 years. I want to extract data from 29 of every month to 3 rd of the next month (Last 2 days of a month + first 3 days of the next month) for all 5 years. Is there a way to do so?
If you already have a video on this, do reply with the link.
Thanks!
Thank you Mike, glad that you update your introduction videos with the latest Excel version. One remark:good that you stongly distinguish between input and output (formulas). In this simple example it is clear that you have a description and right to it the input cel. But in complex models you have intermediate results also with a description. Therefore I use the default "cel styles" input and output,although I dont like these colors. But I do like your green background for formulas in all your other videos. My suggestion is to use this always...
Thank you for your always insightful and helpful comments, Fellow Teammate : )
Like you, I also teach complex model building, but I may take it even one step further, where I require all math formula to be typed out in addition to labels and descriptions, and the an influence diagram too, as in this video:
Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example
th-cam.com/video/C6XmLPJzyV4/w-d-xo.html
If you don't like the formatting for the Input or Output styles, you can change them. You can also merge formats from other spreadsheets. See this page www.ablebits.com/office-addins-blog/2012/01/10/excel-styles-default-custom/
Your vids are sooo helpful!
I am glad that they are helpful, Zaki!!!
Your way of explanation is super cool ..❤️
Pls also see my channel related to excel
It has some great and time saving tips
Would love your feedback on it.
I'm very happy for new series, I am always waiting for new video so please upload video quickly.
I am happy that the videos help! I love to keep making videos when people like you support with comments, Thumbs Up and Sub : )
Amazing and detailed tutorial
Glad it i s amazing fir you, Renatto!!
Excel Basics 2: Done! I've got a sickness and the only prescription is more Excel!! Another Gem, thanks again! I'm gonna blowaway my wife's current family Excel budget layout!
Yes!!! I am glad that the cure is learning more fun and power with Excel!!!
Thank you, now I wont hesitate to apply for jobs that ask for proficient in Excel. I'm still learning,but I really flunked , really bad on a job assesment, She asked me to do a typing test, 54wpm. but then asked me to do a graph, and I had to tell her all I'e done in Excel was input date. BOOH, of course I didn't get the job.
Great video! Thank you!
You are welcome, jose!!!! Thanks for the support with your comment, Thumbs Up and Subscription : )