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.

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

  1. 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.

  2. 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!

  3. 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!

  4. 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!

  5. 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

  6. 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!

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

    Awesome!!!

  8. 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.

  9. 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!

      Ben

  10. This website is AWESOME. Thank you SO much. May you reap the benefits in an abundance of happiness :-)

  11. 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!

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

    Thanks Allot…….. :-)

  13. 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

    Colby

  14. 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.

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

  16. 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.

  17. 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.

      Cheers,

      Ben

  18. 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…

  19. 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. :-)

  20. 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

  21. 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.

  22. 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!!

  23. 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!

    • Got an excel test tomorrow and know nothing about it, but after watching these videos im going into it feeling confident and ready, cheers ben your a legend

Post any comments, feedback or questions below!

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

WordPress.com Logo

You are commenting using your WordPress.com 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