No video
Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts
Рет қаралды 401,162
6 жыл бұрын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
@rahulsolanki1050 5 жыл бұрын
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.
@excelisfun 5 жыл бұрын
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 : )
@ndbvlogs5501 6 ай бұрын
I'm 33 years old and just started learning Excel! Thank you for your instructions!
@excelisfun 6 ай бұрын
You are welcome!!!
@shrek8722 2 жыл бұрын
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!!!
@excelisfun 2 жыл бұрын
You are welcome very much!!!
@awilder166 2 жыл бұрын
I found you over 12 years ago and you are STILL my FAVORITE source for help with excel. Thank you!!!
@excelisfun 2 жыл бұрын
You are welcome for SQRT(144) years of fun Excel help : )
@juanarellano1151 2 жыл бұрын
i bought a course and didnt like it.... googled till i found this... now it is actually fun to learn excel! thanks a lot
@excelisfun 2 жыл бұрын
Cool. This is what i have been doing for 14 years at KZfaq: Free and Fun Excel Education for the world : ) I do change Thumbs Ups, though ; )
@robertchisanga9280 10 ай бұрын
Best Excel teacher I have ever met on y-tube My Excel has improved within two days of watching your videos
@excelisfun 10 ай бұрын
I am glad to help : )
@jmc3179 4 жыл бұрын
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.
@excelisfun 4 жыл бұрын
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 : )
@mbahdieudonne1973 2 жыл бұрын
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.
@excelisfun 2 жыл бұрын
I am glad that my free classes can help!
@tocodelray 4 жыл бұрын
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!
@excelisfun 4 жыл бұрын
You are welcome for the non-rambling breathing Excel fun, tocodelray!!!
@Saad-Sadiq Жыл бұрын
Learned so many things in this one amazing video. Thank you so much.
@excelisfun Жыл бұрын
You are welcome so much!!!!!
@t10nio69 Жыл бұрын
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.
@excelisfun Жыл бұрын
You are welcome so much!!!
@Mohammedshafi-Msk 6 жыл бұрын
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
@excelisfun 6 жыл бұрын
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!!!!
@rreell4372 5 жыл бұрын
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.
@excelisfun 5 жыл бұрын
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 : )
@sunilrawat9644 11 ай бұрын
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)
@excelisfun 11 ай бұрын
Thank you for your very kind words and appreciation, Sunil!!!! I am happy to help you : ) : )
@dadachad712 2 жыл бұрын
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.
@tracichristenson9957 5 жыл бұрын
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.)
@wolfpackmre 6 жыл бұрын
Dude, you have the best voice for teaching and are to the point in a clear, concise manner. These videos are perfect.
@excelisfun 6 жыл бұрын
Thank you for your kind words! Thanks also for the support with your comment, Thumbs Up and Sub : )
@JS-ys2uk 6 жыл бұрын
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!
@excelisfun 6 жыл бұрын
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!!!
@asswipe45566 4 жыл бұрын
Thank you so much. This is by far the best Excel training I've ever come across.
@sebastiankong1979 5 жыл бұрын
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.
@alitharwat4436 3 жыл бұрын
you are the best master i ever listen for , god bless you
@victoriamiller2063 2 жыл бұрын
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
@excelisfun 2 жыл бұрын
Glad my videos can help : )
@manjarpurepecha698 2 жыл бұрын
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.
@excelisfun 2 жыл бұрын
You are welcome! I am glad that you found my videos. A thumbs up on each video is the only cost ; )
@beaglestar1 5 жыл бұрын
Very well taught. Thank you very much for the time you put into these videos.
@wutang5200 11 ай бұрын
真的是太神奇了，你的讲解真是令人愉快。感谢你所付出的一切
@mateusz1227 6 жыл бұрын
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!
@excelisfun 6 жыл бұрын
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 : )
@mohamedamin3393 4 жыл бұрын
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
@excelisfun 4 жыл бұрын
Many you are welcomes, Mohamed!!! Thank you for your kind words and thoughts : ) : )
@amandasweet4879 4 жыл бұрын
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!
@excelisfun 4 жыл бұрын
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 : ) : )
@ashleyhake2656 2 жыл бұрын
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.
@excelisfun 2 жыл бұрын
That is why I post : ) Glad the videos help, Ashley!!!
@kzern Жыл бұрын
Revisit today to refresh what I had learned 2 months ago. The lesson is simple and easy to understand. Love it 👍
@excelisfun Жыл бұрын
Glad it helps!
@rc-mp9ys 6 жыл бұрын
I literaly love the small tricks which you incorporate in every video
@excelisfun 6 жыл бұрын
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 : )
@mohdhakimi2901 5 жыл бұрын
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.
@aammar7987 5 жыл бұрын
Man, I learned everything I need at work from your videos, u r amazing
@haohung8701 4 жыл бұрын
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!
@excelisfun 4 жыл бұрын
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 : )
@PB-ts7nz 6 жыл бұрын
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
@excelisfun 5 жыл бұрын
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 : )
@Thecuteguy-hr4rl 6 ай бұрын
another great video, loving so far!
@Nyuklehead 4 жыл бұрын
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!
@excelisfun 4 жыл бұрын
You are absolutely welcome : )
@josephfrancis4977 4 жыл бұрын
The best channel for learning Excel.
@sonialorenzo9223 6 жыл бұрын
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.
@excelisfun 6 жыл бұрын
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 : )
@Lbbcvt 4 жыл бұрын
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.
@excelisfun 4 жыл бұрын
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 : ) : )
@pankajpariharuttarakhandi524 5 жыл бұрын
whichever video of yours I see there is always a lot to learn. thanks a lot
@MonirulIslam-zj3ve 6 жыл бұрын
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.
@excelisfun 6 жыл бұрын
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 KZfaq : )
@KWChamonix 6 жыл бұрын
Thank you so much for these videos. You are a great teacher, so well explained.
@excelisfun 6 жыл бұрын
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 : )
@akshaynagar6433 5 жыл бұрын
Great job sir, you are amazing before watching videos many problem in execl that's be solve one by one.
@leejohnny5724 6 жыл бұрын
Great work again~~ Second tutorial of the day, all about keep learning.
@excelisfun 6 жыл бұрын
Thank you for your support with comment, Thumbs Up and your Sub : )
@yingyiouyang215 2 жыл бұрын
soooooooooo helpful and sooooooooo easy to understand I! Love! you!
@mounikamallela5881 3 ай бұрын
Thank you so much for the Amazing Explanation
@vaniarhea9056 3 жыл бұрын
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!
@excelisfun 3 жыл бұрын
Glad to help, vania : )
@muhammed-aldulaimi 6 жыл бұрын
Another fantastic tutorial. Much appreciated Mr. Grivin.
@excelisfun 6 жыл бұрын
You are welcome, Miles!!! Thanks for your support : )
@deidretubbs4380 6 жыл бұрын
Thank you for being so thorough in your teaching.
@excelisfun 6 жыл бұрын
You are welcome! Thanks for the support, Deidre, with your comment, Thumbs Up and Sub : )
@okraj13 4 жыл бұрын
I saw a reference of your channel in under other excel videos on KZfaq. Hands down best channel regarding this subject, PERIOD
@excelisfun 4 жыл бұрын
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: kzfaq.info/get/bejne/opddZMSHzKzYmGg.html
@jeongimkim6099 3 жыл бұрын
Great lesson! I have got to focus well and it is very well explained , detailed,right speed... It was really helpful. Thanks a million!
@excelisfun 3 жыл бұрын
You are welcome a million : )
@raizaking5289 3 жыл бұрын
Thank your lessons! It's so thorough and fun to follow.
@excelisfun 3 жыл бұрын
I am glad that you enjoy the lessons!
@classicalbusinessinformati1615 3 жыл бұрын
Good explanations ,Sir .Thank you so much .
@natraj7037 2 жыл бұрын
This is an awesome tutorial, thanks for making learning fun and pleasurable.
@excelisfun 2 жыл бұрын
You are welcome! Thanks for the support with your comment and thumbs up : )
@juliaomeara6741 4 жыл бұрын
Thank you for these videos. They have been extremely helpful!
@excelisfun 4 жыл бұрын
You are welcome, Julia!!!
@lilyzhanca 5 жыл бұрын
Thank you very much! This helped me a lot, very well taught!
@excelisfun 5 жыл бұрын
Glad you like it, Lily! Thanks for your support with your comment, Thumbs Up and Sub : )
@chessytales 4 жыл бұрын
The best excel teacher for all time, I'm glad to take your courses Thanks a lot
@excelisfun 4 жыл бұрын
You are welcome, Youssef!!! Thanks for your best support of all time with your comments and thumbs ups on each video that you watch : )
@chuckhamdan1283 6 жыл бұрын
Always amazed about your clear explanation. Excellent clip!
@excelisfun 6 жыл бұрын
You are welcome! Thanks for the kind words and for your support with comment, Thumbs Up and your Sub : )
@sahilsukhija6354 8 ай бұрын
Great videos sir. People are getting full benefit.
@thomasdavis4938 6 жыл бұрын
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!
@excelisfun 6 жыл бұрын
Yes!!! I am glad that the cure is learning more fun and power with Excel!!!
@barbaragiles9575 5 жыл бұрын
Thank you. Learned a lot!.
@ibrahimmmar 5 жыл бұрын
thank you for this great efforts
@ZsoltPal23092011 6 жыл бұрын
Extremely useful video, just as all the others. Thank you very much for taking the time to create them!
@excelisfun 6 жыл бұрын
You are welcome for the time and video!! Thank you for the support with your comment, Thumbs Up and Sub : )
@vDuzz Жыл бұрын
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.
@excelisfun Жыл бұрын
You're very welcome!
@inkling00 6 ай бұрын
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!
@excelisfun 6 ай бұрын
You are welcome so much : )
@simoiyahector-morales9521 6 жыл бұрын
excellent excellent tutorial, you are the bossssssssss of excel. Continue the wonderful works, may God bless you Sir.
@excelisfun 6 жыл бұрын
I will continue making videos for people to learn from : ) Thank you for the support with your comment, Thumbs Up and Sub : )
@jjk2259 3 жыл бұрын
You are awesome!! Great work!! Helping me a lot! I have subscribed.
@excelisfun 3 жыл бұрын
Glad to help you a lot, JJ K!!!!
@mjtaylor100 5 жыл бұрын
I appreciate this so much. Thank you!
@excelisfun 5 жыл бұрын
You are welcome so much, Matthew!!! Thank you for your support with your comment, Thumbs Up and Sub : )
@alexish9043 6 жыл бұрын
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.
@havinmamo5823 6 жыл бұрын
many and many valuable points and notes in one flexible example,,,,,, very simple but smart explain. Very much appreciated.
@excelisfun 6 жыл бұрын
You are welcome! Thanks for helping this channel with your comment, Thumbs Up and Subscription : )
@syed599 3 жыл бұрын
I have been learning Excel through your channel
@excelisfun 3 жыл бұрын
I aglad that my videos can help : )
@SyedUsman 3 жыл бұрын
Pls also see my channel related to excel It has some great and time saving tips Would love your feedback on it.
@ismailismaili0071 6 жыл бұрын
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
@excelisfun 6 жыл бұрын
You are welcome for the useful info! Thank you for helping with your support of comment, Thumbs Up and Sub : )
@ismailismaili0071 6 жыл бұрын
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
@excelisfun 6 жыл бұрын
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 KZfaq 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 : )
@ismailismaili0071 6 жыл бұрын
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
@Whyvardhann 6 жыл бұрын
Completed your second class and man do I love your videos.
@excelisfun 6 жыл бұрын
I am glad that you love the vids! Thank you very much for the support with your comments, Thumbs Ups and Sub : )
@coofzilla 5 жыл бұрын
This youtube channel has made me a god at work lol, thank you so much.
@excelisfun 5 жыл бұрын
You are welcome for that help at work, hawaiisurf614!!!! Thanks for your support on each video : )
@sawaimalhi8439 Жыл бұрын
i have no words for you sir great great with good hearts
@excelisfun Жыл бұрын
Your words are good : ) I am glad you like the class, Sawai!!
@mujtabamail9235 2 жыл бұрын
thanks for the useful content, and i really enjoy your explanation.
@excelisfun 2 жыл бұрын
You are welcome!
@henriklarsen2276 4 жыл бұрын
Just so great videos, thx ExcelIsFun 👍🙏
@excelisfun 4 жыл бұрын
You are welcome, Henrik!!!!
@bosstrucker8333 4 жыл бұрын
Thank you. I like your style of teaching. the best!
@excelisfun 4 жыл бұрын
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 : )
@jt2317 4 жыл бұрын
Wonderful course clear, detail, very helpful, excellent. I will continue!
@excelisfun 4 жыл бұрын
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: kzfaq.info/get/bejne/bdh8hr2KzuCboXk.html See ya in the comments : )
@mrbb2768 4 жыл бұрын
These vids now make me a excell pro. Keep teaching. Good work.
@excelisfun 4 жыл бұрын
You are welcome, New Excel Pro Balfour!!!! Thanks for your support with your comment, thumbs up and of course your Sub : )
@guymagen1944 3 жыл бұрын
Perfect!
@fishalehadera56 2 жыл бұрын
Wonderful great teacher .
@nabilnabil1824 3 жыл бұрын
Thanks again hehe Your lesson is great and easy for me to understand
@excelisfun 3 жыл бұрын
You are welcome : )
@Introverted.Bookworm 5 ай бұрын
Another good video, thank you.
@excelisfun 5 ай бұрын
You are welcome!!!
@sagheergic Жыл бұрын
Great lecture and unique of its kind. 👍
@SyedMuzammilMahasanShahi 6 жыл бұрын
Wow. Thank you Mike.
@excelisfun 6 жыл бұрын
You are welcome. Thanks for all of your support : )
@alyssamcwhorter7905 6 жыл бұрын
Wonderful! Thank you!
@excelisfun 6 жыл бұрын
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
@anurakmemutti8791 4 жыл бұрын
Thank you so much for these videos.
@excelisfun 4 жыл бұрын
You are welcome for these videos, Anurak!!!
@kavimani5020 4 жыл бұрын
Loving it.Thank you so much
@excelisfun 4 жыл бұрын
You are welcome, kavimani!!!
@Zak7 4 жыл бұрын
Your vids are sooo helpful!
@excelisfun3903 4 жыл бұрын
I am glad that they are helpful, Zaki!!!
@shivakant4698 2 жыл бұрын
Thanks sir very good , Your skill amazing.
@josea1957 6 жыл бұрын
Great video! Thank you!
@excelisfun 6 жыл бұрын
You are welcome, jose!!!! Thanks for the support with your comment, Thumbs Up and Subscription : )
@barttitulaerexcelbart9400 6 жыл бұрын
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...
@excelisfun 6 жыл бұрын
Thank you for your always insightful and helpful comments, Fellow Teammate : )
@excelisfun 6 жыл бұрын
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 kzfaq.info/get/bejne/eZyIoK-Br-Ddhmg.html
@johnpoe3791 6 жыл бұрын
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/
@daanishnaveen2082 3 жыл бұрын
Thank you for give us a very clear information :)
@excelisfun 3 жыл бұрын
You are welcome for the fun clarity, Daanish!!!
@DaveDalton-sd3jj 10 ай бұрын
Bless you! 🙂
@chiengmaluthkota4905 4 жыл бұрын
That is a great piece of video, Am really confident it will change my knowledge on how to use excel
@excelisfun 4 жыл бұрын
I am so glad to hear that this will help you, chieng!!!! Thanks for your support with your comment, thumbs up and Sub : )
@mdshibli1009 2 жыл бұрын
Thank you Sir And love YOU
@yohananlevi8539 4 жыл бұрын
Loved it 👊
@suchitrakulkarni4559 4 жыл бұрын
Thank you for your efforts on these detailed videos. You have indeed made learning excel fun. :)
@excelisfun 4 жыл бұрын
I am glad to help you with learning Excel, Suchitra!!!
@suchitrakulkarni4559 4 жыл бұрын
@@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!
excelisfun
Рет қаралды 239 М.
excelisfun
Рет қаралды 1,5 МЛН
excelisfun
Рет қаралды 191 М.
Excel Campus - Jon
Рет қаралды 14 МЛН
excelisfun
Рет қаралды 251 М.
excelisfun
Рет қаралды 81 М.