Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)
Vložit
- čas přidán 2. 07. 2024
- Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start File: Download File: people.highline.edu/mgirvin/Y...
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...
Topics in this video:
1. (00:01) Introduction
2. (00:41) Different kinds of counting and adding
3. (02:28) Function Drop-down and screen tips to learn which function to use
4. (04:05) COUNT Function
5. (05:04) COUNTA Function
6. (06:16) SUM Function
7. (06:55) COUNTIFS Function
8. (10:14) Screen Click Trick to highlight an entire argument in a function.
9. (11:04) Be Careful of Spaces!!!!!
10. (11:48) SUMIFS Functions
11. (15:05) Use Ctrl Key to check your answers
12. (15:53) More Examples
13. (19:14) Homework you can do to practice
14. (20:06) Summary - Conclusion
@7:21 to see how to type Gigi in Sales Rep criteria cell and have row turn yellow? It is an advanced trick. I don't teach it till later in the sequence of classes. It requires mixed cell references, which we have not learned at this point in class. Here is a video about how to do it though: czcams.com/video/XCR3ReuRnTk/video.html
Thsnk so much for coming back and telling this. Really apprecite it.
@@mokisan You are so welcome, HT!!!!
hi, where is the video?
I've been accepted to an MBA program as a psychology undergraduate and these videos are a gift! I'm enjoying my time staring at spreadsheets with these instructions.
Awesome!!!!
Love that your tutorials include homework. Thank you for taking the time to make these!
You are welcome, Christine!!!
These tutorials are the first thing I watch every morning with my coffee lol thank you for making these videos, very entertaining and informative!
Glad to help with the morning coffee!!!
Finally 🎉 I'm so proud of myself 🙌.I did my assignment and I can say that I'm learning from the very very best❤.
I am proud of you too!!!!
Whether you are a beginner or an expert you will hear something you didn't know in these videos. Thank you!
Yes indeed, I try to add something for everyone : ) Really, though, it is by telling a story about a topic that does not have any holes and is told in a logical order that means everyone can find something. The reason is because there are not many stories told about Excel Topics that don't have holes and which make no assumptions. Thanks for stopping by in the comments, James : )
I never thought learning how to use Excel can be so entertaining! You are the best example of a teacher who knows how to make learning fun. Thank you.
You are welcome for the fun and learning, Orsolya!!!! Thanks for your support with your comment, Thumbs Up and Sub : )
The way you expain is very clear sir and i just want to call you as "YOU ARE EXCEL IN EXCEL".
so nice concepts of each count and sum and sumif and countifs etc no any one like you guru of excel world...
Yes sir! I am happy to help you learn the beauty and power of Excel : ) : )
Just watched Videos 1 through 3. your Videos are AMAZING!!! thank you so much!
Glad the videos help!!!!!
Not only am I having an absolute blast with these videos, but after this one I have been shown everything I expected to learn. I can’t wait to see what else is in store! Thanks for your videos!
The is the beauty of Excel: A blast is always had, because there is nothing Excel can't help you do in a fun and efficient way : )
Best video series on excel available on youtube, no doubt !
Glad you like it, AJEET : )
This videos are amazing. I'm learning Excel because I want to work in a Tech company. Kudos 🎉
Glad the videos and files can help!!!!
I really learn a lot. No need for class sessions. Thanks for great job done.
You are welcome!
I am transitioning careers at the present moment. Your videos with reference material is AWESOME! I now have the confidence to make me successful in my new career.
Glad to help, Nia!!!! You can help me with your thumbs up and comment on each video that you learn from : )
You do not know how grateful I am to follow your classes, I have learned a lot. I love Excel Is Fun. I am one of yours followers since 2013. God Bless you.
Thanks for a great introduction to count(ifs) and sum(ifs) - it's also great you included COUNTA. When I give training sessions, everyone knows COUNT but many don't know about COUNTA.
Yes, I so agree!! On many Statistic projects where we get survey data I use COUNTA much more often than COUNT!!!
Manifesting that I will become a data analyst. I am applying tomorrow, I hope I'll get a job!! Thank you so much. I learned a lot from you!
You are welcome! Good luck : )
Loved the video & the homework. Thank you Professor Girvin.
You are welcome!
It's amazing that you are teaching all these in free🙏🙏🙏.
Top notch tutorials. For some reason you have the ability to teach me about excel whilst also entertaining me.
Great teaching process and you really break down everything in detail so I can understand fully.
Thanks Michael.
You are welcome, Jamie! Thank you for your kind words : ) : ) Thanks also for the support with your comment, Thumbs Up and Sub!
Love everything about the way you explain things! Your great tutorials are so helpful and appreciated! THANK YOU SIR!
You are welcome, TSV E! Glad you love the material that I post : ) Thank you for helping me with your comments and thumbs up on each video that you learn from, and of course your Sub : )
You are a simply an excel Guru. I have quite a basic knowledge when it comes to excel. However, you made it so simple. Thank you.
Thanks so much Mr./Professor Girvin! I am so glad I found your tutorials! I feel so much more competent with Office! I have given a thumbs up to every video lol!
Glad that help to build competence!!! Thank you for your support on each video : ) : )
Your videos are sublime. I just chanced upon them and have learned so much! You are a master excel teacher.
Thank you for the kind words!!! Thanks also for the support with your comment, Thumbs Up and Sub : )
Your the best Teacher out There thank you thank you thank you
You are welcome!!!!
The influence of teachers extends beyond the classroom, well into the future.
- F. Sionil Jose
Forever indebted to you sir, you bring out the best in everyone. Thank you is never enough.
Thank you again. Made this screen name when I was like 17. If you had told 17 year old me that when I'm 29 I'd be at home enjoying Excel homework problems he wouldn't have believed you. I'm enjoying the lessons
That is what happens to us when we get older and wiser : ) Excel can REALLY make our life easy : )
@@excelisfun Someone has had to have pointed this out by now but in HW(2) I believe there is a typo. Instructions say that in F6 we should count how many words there are in the B4:B12 range but I think it's supposed to be G5 that we make that formula
@@sittingpsyduck4583 Fixed. Thanks for helping me to edit. This will help the rest of the Team : ) : )
The idea of giving Home Work. was an excellent way of making the learning experience more interactive. Thank you so much for putting your time and effort in creating awesome content.
Glad all of what I post helps you, Aakash!!! homrworkisfun, right?
My boss referred me to your channel. Excellent content. Thank you for making it available for free to all. PS. My boss is an excel expert and his recommending your channel above all else speaks volume. Thank you
You are welcome, Stacey! Thanks for helping to support this free resource with your comments, Thumbs Ups and Sub : ) Tell your boss I say hi!
I loved this lesson! The functions all seem incredibly useful and the homework was a great way to put what we've been learning into practice.
Homework makes us awesome : )
You are Great!! How wish I could have found your lectures earlier! Thank you very much!!
You are welcome! If you do all 25 vids, you can be an Excel Master. Here is full playlist: czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
I appreciate all the work you put into these, I look forward to learning everything I can through your videos.
You are welcome!
I find it more fun listening to your voice, explanation are more simple then other people's. Thanks
The work you have done is a masterpiece and thank you so much for it.
Michael Girvin, Your amazing on the training Excel platform, I love your videos, they are very clear and understandable, thanks for all your support and help, appreciated,
You are welcome, kelvin!!!!
More than Fabulous. you are the world champion of Excel professor.
Thank you for the kind words, AbuOmar!!! Thanks for the support with your comment, Thumbs Up and Sub : )
One more great series ..Excel basics ..Love it. You are no doubt a great teacher. God bless you.
Thanks for your kind words, Sayyad : )
Your videos are so much fun to watch and so detailed. Than you do much for sharing!
You are welcome, Tom Jun! Glad that help are fun for you : )
Wow man I am gonna admit no body teach like this, thank you brother for such teaching, its really hard to do what you do ❤
I wish if I know you in person and take some class.... Really a teacher knows how to teach and explains. Just brilliant.
Well even though you are not in my class live, you get it here at CZcams for free : )
Excellent videos, all the steps are clearly explained, thank you so much for making them available free of cost to everybody. Learning a lot through them.
You are welcome! I am glad the material is clear. Thanks for your support with your comment, Thumbs Up and Sub : )
Excellent again, and thanks for the homework in particular. Practice makes perfect!
EXCELlent!!! Glad the video and Homework help !!! Don't forget that part of the Homework is to comment and Thumbs Up on each video, then it is REALLY perfect : )
You make Excel sooooo easy. Thank you so much for the tutorials, they are helping me a lot in my new job.
You are welcome! That is great that they help with your job!! You can help me too, by always clicking that Thumbs Up and leaving a small comment - it really helps to support : )
Thank you so much ! So helpful and clear. And having exercises is even greater
You are welcome!
Clear and concise information, excellently taught
Glad you like it!!!!
Another day another great Excel lesson. Thanks!
You are welcome, day after day, tacodelray!!!
Your videos are very helpful. Thank you so much for all the efforts that you've put in all of your EXCeLlent videos!
You are welcome for the Excellent efforts, Jill Si! Thanks for your support with your comments, thumbs up and Sub : )
This is an amazing course. Thank you so much for taking the time to put it together.
You are so welcome for the course, Big Haole!!!! Thanks for the support with your comment, thumbs up and of course your Sub : )
Best Tutorial I have ever seen, awesome. Thank You ExcellsFun.
You are welcome, Abdul!!!!!
Good day Sir! Your drive to impart your knowledge is commendable! God Bless you!
Glad to help, JESSIE!!!!
the best youtube for excel this man deserve a prize
My prize has always been simple: thumbs ups and comments from viewers like you : )
@@excelisfun your the only person I met that is thia good
@@saeedtheman Just having fun with Excel - just like you are having now, bob : )
@@excelisfun my friend do you have play list for new beginner what start learning the function do you play list plz help me out also do Facebook link can follow you thank you changed my life in excel
@@saeedtheman This Excel Basics class is my beginner class. Functions are only a small part of Excel. So in this Excel Basics class, I teach all of Excel, including functions. I do not have an Excel Facebook site, but here is the full Excel Basics CZcams class: czcams.com/play/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.html
You are real Gem in this world. excellent video, to the point, full of knowledge and clear presentation.
Glad you like the video thanks for your kind words : )
Such good instruction! Thank you for helping us all understand Excel.
You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
Best Microsoft Office teacher ever!
Glad to help, John!!!
This is a well deserved, super positive comment section!
Glad you like the video, Wright's Right!!!!
Amazing Video.Thanks a lot. Can't describe how grateful I am.
You are welcome, Anushervon!!!! Thanks for your support on each video that you watch with your comments, Thumbs Up and a Sub : )
Thank you so much, sir. Your videos are truly amazing and very helpful.
You are welcome, Md. Soaib!!!!
You're such an awesome teacher, I'm so glad i found your channel! Thank you very much
You are welcome very much, Nathalia!!!! Thanks for the support with your comment, thumbs up and of course your Sub : )
Sir you are officially the Excel guru, thumbs up to your knowledge and passion to share. God bless you.
Glad you like the videos! Thank you so much for your support : )
Ur way of explanation will make the person to understand, instate of learning..👍
I am glad you are understanding! Thank you foe the support with your comment, Thumbs Up and Sub : )
Definitely learning a lot from these introductory videos. I have Linkedin Learning but the instructors are pretty "dry." Had to give up and come here. I have to admit I'm learning a LOT more, easily and rapidly. The keyboard shortcuts are great and the way the instructor explains things is great, which is useful for an incredibly boring topic like Excel. You make it seem fun and that's saying a lot.
Professor Girvin you are the best, thanks a million sir. God bless man
You are welcome a million times!! Thank you for the support with your comment, Thumbs Up and Sub : )
I am very grateful for you making this videos. I had gone for an interview but I did not do well in using excel but It definitely opened an opportunity to learn from you. May the Almighty God bless you
You are welcome, Joseph! I am glad that the videos that i make can help you to become better for your future job interviews. Thanks for your support of my efforts to bring free education to the world with your comments and thumbs ups on each video that you learn from, and of course your Sub : )
Brilliant! as always. Love the presentation style - it really works for me.
Glad you like the videos, Adrian !!! Thanks for your support with your comments, Thumbs Ups and your Sub : )
Thanks its the best tutorials I've seen on Excel and a pleasure to learn spreadsheet.
You are welcome, Danie! Thanks for your support with your comment, thumbs up and of course your Sub : )
Thank you Mike for another EXCELlent Video.
You are welcome! Thank you for your continual EXCELlent support : )
Thank you so much for the assignments, looking forward to completing them.
You are welcome!!!
I was watching other videos on youtube about excel, and I did not like them. I thought it was boring and only did it as I wanted to take advantage of the range of opportunity excel gives to people who understand it. I was on Reddit and a lot of people said: "go check out Excelisfun". You even have homework??? Thank you so much, I am actually enjoying excel! Who would have known? I am liking all the videos I am watching, you deserve a lot of recognition.
Excellent, very helpful. Thanks a lot, Professor Girvin
You are welcome a lot, Mohammad!! Thanks for your support with your comment, thumbs up and Sub : )
Excellent, very helpful. Thanks a lot, Professor Girvin for making it available free.
You are welcome! Thank you for the support with your comment, Thumbs Up and Sub : )
You are the best of the best of the best !!!! Thank you so much!
I might be selected to work in a local office in my city. These videos have been so valuable in practicing excel. Thank you again.
You are welcome, Lewis!!! I started posting videos 12 years ago to do exactly that: help people learn Excel so they can get the job, and then be so efficient with Excel that they have extra time for vacation : )
Man, you are awesome. I am so so thankful to you. You cannot guess. ❤️❤️❤️😭
You are so welcome!!!!!
I've recommended your channel to anyone that would listen!
Thanks for the support, Tosan : )
The homework was a lovely addition to the video! Looking forward to the next tutorial!
Great - Practice makes perfect. Really, that is one of the things that makes excelsifun channel at CZcams THE place for free education: you get it all: video, Excel files, free chapter from the book (pdf) and practice problems with solutions : ) Thank you for your support, Miles : )
ExcelIsFun your enthusiasm for teaching shown throughout the video is inspiring, and your teaching method where you highlight important details through your slowed way of speaking showcases your tutoring expertise. I'm grateful for you making all of these resources available for free. Looking forward to the next video!
I am glad that it all works for you : ) Thanks for your kind words!
thanks a lot i am learning so much, right now, your videos are soo easy to understand.
I wish the university I attend had professors like this guy.
Well, if they don't you can just come here to excelisfun at CZcams : ) Glad, you like the videos, Jacob! Thanks for your support : )
You make Excel so easy. Thank you.
You are welcome! Thank you foe the support with your comment, Thumbs Up and Sub : )
Oh my god!!!....I just love you my RESPECTED SIR.... wish I had found you years back...but I have you now :) , so with so much of admiration & respect from a very small town in India, my good Sir ..
You are welcome, Apples Oranges!!! I am glad that the content that I post helps you in a small town in India : ) You can help me too with a comment and thumbs up on every video that you learn from, and of course a Sub too : ) P.S. Love the user name: Apples Oranges : )
@@excelisfun of course...anything for you Sir ..
@@applesoranges559 : ) : )
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.
I am so glad that the teaching helps! Thank you for your support : )
Great video! LOVE the homework!!!!
Glad you like all the posted Excel items!!! Thank you for the support with your comment, Thumbs Up and Sub!!!!
I hope I will learn Excel in just one week
Thanks a lot for efforts sir ☺️
You are welcome!
You are the best. Thank you very much for this great video and information.
I am glad that the video helps! Thank you for the support with your comment, Thumbs Up and Sub : )
It's just OMG when i saw the title of the video i said these functions are known to me but when i insisted to see the video i learned that they can do more and more so impressive thank you Mr. Mike
You are welcome - I am glad that the video helped you to learn some new things : )
Thank u
thank goodness he's in a teaching position. he's born to teach!
I hope the video helped, iiovelouisDTV
Glad you liked the video, LLovelouisDTV!!!!
Hi Professor, Hallelujah Enlightenments for Excel!
I am glad that the videos help! Thank you for your support : )
You are great excel teacher in world
Thanks a lot for such kind of efforts.keep it Up sir
You are welcome!!
hey mike thanks for the video, have to review your last 2 to refresh what I learned. excellent video!
You are welcome for the video!! Yes, you can watch #1 and #2 to review : ) Thanks for your support, Alphaeus!!!
loving these videos...thank you so much
You are welcome so much!!!
thank you so much for the time you took to make these
You are welcome for the time and for the videos, Abed! Thank you for the support with your comment, Thumbs Up and Sub : )
Forget to like and comment on this video, Came back from Lesson4 to like and comment and say thank you, Sir!
Much appreciated! : ) : ) : )
Another excellent video!
Video is 👍!! Love learning)) thx for homework 📚 very helpful
You are welcome! Thanks for your Support, _AnBu_!!!
by the way , i would like to specially thanking you for the idea of home work , really it helps
wishing that you proceed it in all H W files uploaded
You are welcome! There is no other free resource for learning Excel like this. Thanks for your consistent support on every video that you watch with your comments and thumbs up : ) : )
Enjoying, thank you so much.
THIS IS JUST AWESOME!!!
Glad you like it!!!!!
Thank you so much! Great video
Glad you enjoyed it!
AS GOOD AS ITS GETS - THANK U
You are welcome, ndelpurg!!! Thank you for the support on each video with a comment, Thumbs Up and a Sub : )
Amazing work thank you!!
You are welcome, Yesenia!!!