Video Lesson: Beginner’s Introduction to Excel

One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works.  I’ve created this lesson in an attempt to introduce the most basic information about what Excel is and go over some examples of what it could be used for.

Disclaimer: If you’re pretty familiar with Excel, this video may be extremely boring.  You have been warned!

Throughout the lesson, I explain the following information and questions in great detail:

– What am I looking at when I open Excel for the first time?

– Explanation of Column / Rows and how referencing works.

– Navigating Excel, knowing where you are in the spreadsheet, and the ‘name box’.

– Overview of sheets including adding, deleting, and renaming.

– Explanation of hard-coded values vs. formulas/functions, and Excel default cell formats.

– Formatting options including bold/underline, alignment (e.g. centering), and creating borders.

– Information about the formula bar, and how to use the ‘Insert Function’ feature.

– Example of creating a simple personal finance tracker and how to input information into Excel.

– Introduction to the Master Workbook, including the function listing and previews of examples from other lessons.

Feel free to show this lesson to anyone who wants to learn Excel but doesn’t know the first thing about getting started!

Now if you’re following the Lesson Guide, you should move on to Learning Basic Formatting Techniques.

191 thoughts on “Video Lesson: Beginner’s Introduction to Excel

  1. Thank you for this video. I’m going to follow your lesson plan and complete this course. You teach well and are concise in your explanations.

  2. I am using Excel every single day but still good to know more and more, just want to say thank you for sharing your knowledge to all of us. God bless you.

  3. What a wonderful thing you have done for the community at large. To find such detailed, clearly communicated lessons about Excel is a joy. Thank you very much for your hardwork and time on this. It is a real gift to other Excel curious people!

    Hope you have a wonderful life!

  4. Cheers, bruv!! I really admire and appreciate this upper echelon work of yours and how you freely distribute it. Your humble and patient approach is a gift many formal “teachers” do not possess, and I am sure you have manifested greatness in your life. Good life to you, mate!

  5. Thank you so much for providing such useful information for free! This is a life-saver. You speak in an organized and pleasant manner, too… so many other how-to videos are full of painful rambling, but you’re easy to listen to and extremely informative.

  6. Thank you for the video. I am registered for an excel class. I feel confident knowing I have a general idea of what to expect.

  7. please am new here…I missed the first video and am pleading with any one here to help me get it now. ..thanks so much in advance.

  8. Hello! Very helpful. Great work, Ben! Thank you so much. 🙂
    Now, if I wish to give these to my colleagues, do you suggest of any way to track their progress, so that I can make them do it on a schedule? :Thinking:

    • I am more of a book in front of my nose and then using this knowledge onto the computer. Would you kindly tell me which book I need to do the Excel for Beginners

  9. Hello!
    Thank you so much for taking time out of your busy life to help those of us that are seeking help regarding Excel for career advancement or for whatever reason at absolutely NO cost to us. It is much needed and appreciated.

    Lastly, the video sessions in addition to the cheat sheet/guide is clear and thoroughly articulated.

    God Bless You,

  10. I’m really happy to write the comments here. While I was going through the video, I felt like I’m gaining something out of it. Thank you so much for such a detailed explanation.

  11. I can’t thank you enough for Excel Exposure. You have a clear, concise teaching style, which is very easy to understand. I’ll recommend your site to anyone who’d like to learn more about Excel.

    I’ve used Excel since it first came out but, since I’ve only needed it for a few functions, I have several gaps in my knowledge. Even in your first video, I learned about End Mode, a feature I didn’t know about until now. I’m sure I’ll find many useful gems like this as I go through your lessons.

    Btw, I’m glad to see they’ve expanded the cell limit so much. That was a serious problem early on.

    Thank you again for all your work.

  12. Hello Sir,
    The video is very easy to understand and the way you explain stuff is also great. I love the detailing that you’ve done in each video. Thank you so much for coming up with this. I really needed this.

  13. Awesome, this is just what I’ve looking for for years, at last I’m able to understand how Excel spreadsheets work, as the tutorials that came with the Excel I bought was rubbish & you explain it perfectly & in a way one can follow it precisely to the letter. Thank you, and I’m going to follow the whole course. Amazing! You’ve just made my year. Again, THANK YOU.

  14. Thank you so much for the video. I have used Excel for simple projects in the past but needed a refresher to prepare for new position that requires heavy use of Excel. I have avoided positions requiring Excel in the past but decided to face my fears and go for it . As a senior (59 years) I find it difficult to focus sometimes but I was able to follow along and understand your instructions. This was very helpful!!

  15. You are just amazing. Thanks a ton for all the help. people like you just more often exist. Also, through these videos, I am not just learning how to excel better but great deal of stuff about how to document.

    Thanks again

  16. Awesome awesome awesome. I really enjoyed this short introductory video. As an absolute novice, I used it to do my budget. Thank you soooo much.

    • thank you so much for this wonderful video, very useful and may god bless you for setting this up. i am 65 yrs old and i found it to be very useful. thanks again

  17. Thank you so much, the way you explain everything makes it easier for me, I just started and I look forward to continue! Thanks in advanced, this is going to help me succeed and find a job.

    Highly appreciated.

  18. This was sooooo informative! I did it in college but its been over 5 years since I had to do it and I didnt want to buy a how to guide. thank you so much! very practical and slow enough to get

  19. I agree with every positive comment mentioned. Older woman needing to remain in the workforce, lacking these skills that are so essential in most office environments today. Very grateful, thank you

  20. Thank you Ben for the work you put into these lessons they are well done but of no use to me (I Am deaf) I will UNsubscribe To save you any more work on my participation. Keep up the Good work Ben your efforts are badly needed.

  21. Thank you for this video!! I don’t know excel, which is horrible. Now I will start with your lesson and hopefully learn all about it! Thank you thank you thank you!

  22. Thank you for taking the time to create these videos as well as the Master Workbook. Very good info, I’m taking the class from the beginning. I’m not a beginner using excel but I’m glad I started in the basics first because I still learned somethings I didn’t know.

  23. Thank you for this excellent tutorial. Although I’ve been coding for 40 years I have always struggled with excel as it seems so clumsy. Today I discovered my issue. Clicking and dragging in Windows Explorer is a big No-No as you can so easily destroy your disk and file integrity. So I’ve always been careful to never do so in Excel. But early in the lesson that’s exactly what you did, although you didn’t exactly SAY that’s what you were doing. At 7:41 you said “highlight the area”. It would have helped if you had explained that simple step (with the words – “click and drag”) – I guess it is second nature to you and you assumed that everyone knew that’s what you were doing. So that has been my roadblock. Then, later you showed that you start typing a formula and then you click on a cell and magically the cell address gets typed in. This was interspersed with the word “plus” which apparently you were typing as you clicked on the individual cells. I sensed that this was possible but I had never been able to figure out how to do it. Suddenly a lot came clear and I see that this really is a lot easier to setup that I thought. I am looking forward to following the entire course.

    My comment is not meant as a criticism but just to show you a couple of points that weren’t immediately obvious, to me, in the lesson

    Thank you again. This is a turning point for me.


  25. only one video I’ve watched so far and I’ve learned so much already. What a blessing to stumble upon your website. You’re a wonderful, excellent teacher and I’d like to thank you for all your efforts, patience and dedication you put in to help people like me. Thank you again, Sir!!! Blessings to you and always!!!!

  26. I about to inherit responsibility at work for pricing multi million dollar contracts with many moving parts. Although I am already a basic user, I still picked up some tips from the intro lesson and am going to get stuck into the other lessons pronto. Ben – thank you for taking the time to help us all out with learning about this very powerful tool!

  27. This was so helpful, i am so excited to learn more 🙂

    Thank you so much for sharing your knowledge, this is going to make a massive difference in my life 🙂

  28. Thank you so much for your effort. These lessons are well paced, comprehensive, and very useful for us excel beginners!

  29. Wow oh wow . This is the real thing. The guy takes his time and explains everything in detail. So well composed the tone of voice and examples. Great Job Guy. Thumbs up to you man. Only thing is that you did not say the name of your site you just said go to your website

  30. This is the first video I watched and I really look forward to watching other videos too! If I had to name top5 sites I’ve visited this year, this site seems like it’s gonna be on the the list.

  31. Excellent work. Ive been looking for courses online and looked no further once i tumbled across your website!Learning excel now. Keep up the good work.

  32. Thanks for these helpful tips! I never really had time to learn about excel although I know some couple things. Anyway it’s not what professors teach you in my major. I’m excited to watch your videos because not only this is helpful but you make it entertaining despite anything. Keep up the good work!

  33. I’m really excited about watching all of your videos. It’s really wonderful that you are so generous with your work and helping people to educated themselves with the tools you provide them for free. Thank you so much!

  34. Many, many thanks, Ben, not only for providing this helpful and well explained video, but also to make it available free of charge! It took me about a 1/2 hour to watch it all because I was practicing as you taught 🙂 Blessings to you!

  35. Hi, I’ve only watched one video so far but I’ve already learned quite a bit I wasn’t aware of. Your style of teaching is very exact yet clear. I appreciate the work you’ve put into this and am looking forward to future lessons. 🙂

    One thing I noticed that may or may not be an option for you is to maybe add some sort of captioning? I’ve been watching the videos on my laptop and don’t tend to use headphones so something I could read would be helpful as I don’t want to disturb anyone around me. Also I imagine it’d be great for deaf / hard-of-hearing users to have better accessibility to your site.

    Thank you very much for your effort in creating these tutorials!

    – Charlie

  36. Thank You, I have been trying to figure out Excel. Your simple and easy to understand video was EXCELLENT!! I have been on a waitlist for my Community College for 2 yrs. I know can just go to the site every morning and learn!

  37. Ben Thanks! This is excellent and will help tremendously as I pursue a career in educational leadership!!!


  38. Ben, I really want to learn all I can about Excel and so far your program has been great. But I really need help on how to set up my payroll for my business. I am very much a beginner. With very little time to learn. My husband and I own our own business “Popcorn Paradise” and also work a 10 hours a day 6 days a week. I have been watching your videos in the car on the 3 hour trip from Detroit to Grand Haven.

  39. Ben, this is amazing. i have just started a new job where excel is very important and i need to be more into this. just checked the first video, its brilliant. The way you explain it, it makes sense and so easy to follow!!! Great job and i will deffo check out every video there is on this site!!

    great work and thank you 🙂

    • Hey Robert,

      If you click on the ‘Vimeo’ logo in the bottom right corner for any of the videos, it will bring you to the Vimeo page for that video. Underneath, one of the options has ‘download’. If you click that it should work.

      Hope that helps!


  40. This website is AWESOME. Thank you SO much. May you reap the benefits in an abundance of happiness 🙂

  41. Excellent, mastered excel and other microsoft office stuff back in school but haven’t opened it in atleast 6 years. Its true what they say, ‘if you dont use it you lose it’. Great videos gonna watch the whole series to get it back, thanks!

  42. Really your data is of great help thanx for providing us the teaching lesson of your videos!

    Thanks Allot…….. 🙂

  43. Thank you so much for posting this free education course! I was fired from my job today (due to a large miscommunication) but with your free course I’m confident I’m sure to improve my life and earning power! Thanks again


  44. Thanks when I grow up I want to be just like you. I’m 45 now. (lol). Seriously great job. may God’s blessing precede you in all you attempt to do that is right and good.

  45. I have only took the first lesson, but will definitely continue tomorrow. I love your way of explaining the work. Thank you so much

  46. Thank you soooooo much, this video helped me big time to understand excel basics. Intend to go more into it, again thank you so very much.

  47. I alway wanted to learn this but everyone just confuse. This seem to be very direct, hopefully I can follow along since that’s my weak area. I was thinking I have to pay for a class and was very excited to find this
    Thanks Jean

    • Hi Adeel,

      I’m really sorry to hear about how difficult your work situation is.

      My website is only related to Excel 2010, but has over 5 hours of video lessons to help you learn how to use it. The site is completely 100% free.

      If you look at the Lesson Guide, it has all the videos in the order you should watch them if you want to become a master at Excel.

      Hope that helps.



  48. I was going to actually pay for a course and I cannot believe my luck stumbling across this site. I am very very grateful for this free tuition and your calm, clear and concise directions through the course have made it all seem so simple. even though I have perceived excel to be incredibly complicated.

    Thanks so much and I wish you the best for the future…

  49. Hello Ben, I just wanna let you know that your tutorial is awesome, clear and with detailed explanation! I’ve decided to learn and master Excel myself and certainly your great work and effort put in this project will allow me to do that. Please be proud of yourself and keep it up! Cheers from Brazil. 🙂

  50. Nice introduction video.Even though I use Excel daily I want to make sure I don’t overlook one area. Believe it or not I learned the today function. I had to laugh that I had never used that. I’ll be going over more of these as time permits

  51. So happy someone told me about this site! The narrator is very clear and this lesson, (although I’m somewhat of an Excel user) taught me basic things that I really didn’t know because my learning just came from playing/working in Excel rather than having any type of formal training.

  52. thank you so much. i did the first beginners lesson and it was awesome, functional, informative and just at the right pace for me to think my way through your lessons. am definitely coming back for more!!

  53. thanks so much, your’e doing an invaluable service. i’m a newly single mom and even though i have basic skills on excel i know i am getting passed up a lot on jobs for not knowing how to use it at a more advanced level. i almost signed up for a very basic class for almost 200 bucks which would have been very painful for me at this point, thanks again!

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s