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.

This entry was posted in Workbook/Reference Lessons and tagged , , , , , . Bookmark the permalink.

196 Responses to Video Lesson: Beginner’s Introduction to Excel

  1. Gloria says:

    Thank you very much!! Well done job!!

  2. Santhoshi says:

    Excellent and easy to understand.

  3. Kelly Drinkwater says:

    I’m sure your videos are excellent but I can’t get the volume up high enough to hear you without straining.

  4. Brook says:

    Thx for every words.

  5. Anonymous says:

    Hi Ben, Thank you so much. It’s really useful video.

  6. Yashvi says:

    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.

  7. Ahmed Nur says:

    HI !! I have watched the first part and it is really an excellent lesson.

  8. Pedro Sousel says:

    Thank you for the time you took to create these videos.

  9. Jodelyn says:

    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.

  10. Anonymous says:

    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!

  11. Anonymous says:

    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!

  12. Sanchita says:

    Thank u so much for providing such valuable information for free God bless you

  13. Rebecca says:

    Wow what a Lesson. Thank you so much, because i could not even understand this lessons better when i was at school…
    Thank you

  14. askntombi says:

    Wow! For the FIRST time in my life I used the excel successfully. I was embarrasingly clueless but the first lesson was such an eye opener. BLESS YOU

  15. Caris says:

    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.

  16. Johnpaul says:

    Hi I am looking for opportunity to learn excel. iam a begenner please I will be grateful.

  17. Anonymous says:

    Awesome Videos and Mentoring. Thank you so much as it helped a lot.

  18. Anonymous says:

    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.

  19. nabeela imran says:

    highly appreciated
    (y) love the way you mentor

  20. harshal says:

    great videos, now i find excel interesting and helpful.
    Thankyou for sharing

  21. yasir says:

    excellent !! May lord reciprocate you for this lovely work

  22. Tordzeagbo foster norkplim says:

    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.

  23. A.S. says:

    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:

  24. Anonymous says:

    I wish you all the best in your life.
    Truly extremely valuable videos that one can hardly gets online!

    Thank You 🙂

  25. larissa says:

    hi, am looking for someone who can help me out with excell functions and formulas. ib

  26. kim says:

    Hi Ben,
    Is there a way to work within the workbook, while watching your video so I can reference back and forth as I go along?

    • Christine Berry says:

      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

  27. Anonymous says:

    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,

  28. Siva says:

    Very useful

  29. Anonymous says:

    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.

  30. Goldenprinz says:

    please I can’t find where to download the video, please can someone help me or you mail me the video….

  31. Goldenprinz says:

    please I can’t find where to download the video, please can someone help me

  32. A. Tyrrell says:

    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.

  33. Thank you , i never paid attention in my school and now i have to used to get to know excel . however, it’s just one single video. do you have serious of videos for the other formulas?

  34. Shreya Majumdar says:

    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.

  35. Anonymous says:

    Awesome!!! Great job 🙂

  36. sravan kumar says:

    Really superb knowledge gainer on excel.

  37. Anonymous says:

    it was very use full for me thanks a lot for you video

  38. Gordon Hopkins says:

    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.

  39. Anonymous says:

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

  40. Anant Saxena says:

    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

  41. Anonymous says:

    thanks for lesson, very useful

  42. KMD says:

    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.

    • mohammad k. darvish says:

      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

  43. Anonymous says:

    you rock

  44. Eliseo says:

    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.

  45. Anonymous says:

    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

  46. Claire says:

    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

  47. Anonymous says:


  48. Judy says:

    What is the cost of this course

  49. Anonymous says:

    thank you so much Ben , This has really helped me , will take all the course .

  50. Mayra Rafferty says:


  51. Candris Outten says:

    Excellent……..Can’t wait to learn more!

  52. So very informative. I took excel twice in College, but literally never paid attention. Now I need to know how to use it, so I am happy to have found this class, that is saving me tons of money! Thank you so very much!

  53. Very useful way of explanation..

  54. Dennis Gore says:

    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.

  55. Shiqi says:

    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!

  56. Tuan Ho says:

    Thank you for taking time to make this video, it is useful for me. I will continue with other sections.

  57. Latoya S. says:

    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.

  58. Rakibul Hasan says:

    It’s an well organized package to learn Excel…. thank you…. Hope i will learn more from your site 🙂

  59. Phil Seakins says:

    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.

  60. Emerson De Lira says:


  61. Oscar says:

    Thanks a million, this is really good; keep it up.

  62. Meriem says:

    So well explained. Thank you so much. I will take all the lessons.

  63. junbug says:

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

  64. Anonymous says:

    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!

  65. Jean says:

    Thanks so much… I am going to take all the courses!

  66. shashi sekhar says:

    Great job Keep it up

  67. Ginnais says:

    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 🙂

  68. Shirna says:

    Thanx a lot Ben!
    This was a great help.

  69. Anonymous says:

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

  70. Steve says:

    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

  71. Jules says:

    Thanks Ben…. Great video lessons!!!

  72. Anonymous says:

    great job

  73. Anonymous says:

    I’m really looking forward to getting stuck into these videos. The first one was very helpful. Thanks!

  74. Juhis says:

    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.

  75. SJ says:

    You made me so happy it’s virtually impossible to get a job without Excel thank you so much

  76. James says:

    You are my hero, thanks so much for these invaluable lessons.

  77. Anonymous says:

    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.

  78. Anonymous says:

    simple n more informative guide

  79. says:

    Hello there, just became alert to your blog through Google,
    and found that it’s really informative. I’m gonna watch out for brussels.

    I will appreciate if you continue this in
    future. A lot of people will be benefited from your writing.

  80. Anonymous says:

    Thanks. Fantastic lesson.

  81. Orlando says:

    Hey pal, thanks for this. You’re a genius. P.s. your voice is a close resemblance to Ryan Gosling’s

  82. Anonymous says:

    thnks alot sir you are amazing..

  83. Excel newb says:

    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!

  84. Anonymous says:

    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!

  85. Claudita says:

    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!

  86. Anonymous says:

    September 19, 2013
    Thanks sooo much for creating these video tutorials! I’m just starting but already feeling empowered! Angie

  87. Charlie says:

    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

  88. Pradeep says:

    This is world very best site for Learn easly Excel.

  89. Laura says:

    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!

  90. shiv says:

    thank you for such a wonderful webpage.

  91. Anonymous says:

    Hi!!!! Just wanted to say THANK YOU! I will definitely be taking all the lessons!!!! 🙂

  92. Anonymous says:

    Thanks so much for the lesson, it was certainly easy to understand!

  93. Anonymous says:

    Thank you so much for this videos, I have learned a lot just from watching the first one. Great Job!

  94. Anonymous says:

    Thanks so much for these videos they have really helped me had forgoten about excel

  95. Josh says:

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


  96. Paula says:

    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.

  97. Bes says:

    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 🙂

  98. Derek Stark says:

    You purposely added a zero to rent to show how versatile functions in Excel are. Sly genius.

  99. CH .NSS. ADITYA says:


  100. Pankaj Tiwari says:

    It is very good site for leaning excel .

  101. Minhaj says:

    This is my wish to learn some computer program but I have no money to admit in an institute

  102. yingyu says:

    Thanks you so much Ben.. it’s really helpful and appreciate indeed! I’ll definitely learn more ˆˆ

  103. Anonymous says:

    this videos really gr8

  104. Anonymous says:

    Thank you, Ben. You’re the best!

  105. Anonymous says:

    This just what I was looking for!! You are so easy to follow. Awesome!!

  106. Robert says:

    Great job! Can these be downloaded?

    • 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!


  107. Anonymous says:

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

  108. ehsaan says:

    thank’s for providing a great knowledge!!!!!!!!

  109. Vivian Eni says:

    This is definitely helpful to me. Thank you so much.

  110. Susan says:

    You have provided an amazing resource! Thank you so very much.

  111. Chandan Singh says:

    this is realy helpfull we are very much thankful to you to provide such a amazing service.

  112. Ana says:

    This is amazing!! Thank you!

  113. Aaron Julian says:

    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!

  114. chaitali says:

    cool . The master work book is dam good

  115. Roy says:

    Great Lesson…!! Thanks…!!

  116. Poonam says:

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

    Thanks Allot…….. 🙂

  117. Elena says:

    Hi Ben,
    I’d like to share this article
    simply to draw the excel users attention on the importance of how careful we should be when dealing with excel in order to provide true and meaningful information.
    Thanks for the useful lessons!

  118. aj says:

    THANK YOU so much! This is such a wonderful, helpful tool, so grateful for your tutorial!

  119. Anonymous says:

    Very informative…easy to understand for a beginner..tankz alot!!

  120. Anonymous says:

    I like the animation on the excel exposure, how did you do that?

  121. manoj patel says:

    how to dawnload this vedies

  122. Christopher says:

    Can we get this dude a round of applause or what?

  123. Neha says:

    thanks a lot, its very useful..

  124. Anonymous says:

    Thank you

  125. Sara says:

    Thank you so much for this amazing site!!

  126. Tara says:


  127. arun sachdev says:

    Hello i want to learn excell from the begining can you please help me in this.

  128. Colby Gallatin says:

    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


  129. Anonymous says:

    realy helpfull

  130. Jasmine says:

    This is AMAZING. Seriously.

  131. Mohamed says:


  132. Isabella Peoples says:

    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.

  133. Adriana Guerrero says:

    Incredible… thanks a million 🙂

  134. Shweta says:

    You are awesome. God Bless 🙂

  135. danny says:

    great work, thanks!

  136. I was knowing nothing abt EXCEL, but after looking at this video, I knowing something abt it now…

  137. Anonymous says:

    It was very helpful and nice…thnx

  138. Anonymous says:

    Thank you very much!!! Very good explanation!!!

  139. Margo says:

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

  140. Anonymous says:

    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.

  141. Ann says:

    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

  142. Anonymous says:

    HI, please guide me i am new in this Excel world, I got a job of document controller now my boss is always shouting because letters are not found i want to figure it out help me at plz plz

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



  143. Eva says:

    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…

  144. Anonymous says:

    thank u very much,,,,,,,,,,,,,,,,,,,,,,,,,it is really usefull

  145. Sally says:

    Thanks so much! I’m dyspraxic and have trouble with numbers but could follow this first lesson no problemo!

  146. Jorin Weber says:

    Ben, thank you very much for posting this for everyone. It is a great tool to refresh and improve my Excel skills

  147. Anonymous says:

    Good work keep it up….

  148. Anonymous says:

    Absolutely great! Thanks!

  149. Anonymous says:

    very good . thank you.. good to learn something on my lunch breaks. thank you very much.

  150. azar says:

    Thank you thank u.

  151. Tina Jolly says:

    Hi Ben,

    Your tutorials are extremely useful & systematic for learning excel !!!


  152. Johnattan Costa says:

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

  153. Anonymous says:

    Thanks Good job!!

  154. Anonymous says:

    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

  155. Anonymous says:

    Thanks, this is EXACTLY what I need right now

  156. IvoovI says:

    This is good! Thank you!

  157. Anonymous says:

    This tutorial is great. Thanks a lot.

  158. lisa says:

    This is wonderful, thank you very much. It was very helpful and we really need people like you. God bless you! Thanks 🙂

  159. Krystal says:

    I hope I learn something.

  160. Gyf says:

    I’m so glad I found this page! This is clear and amazing! I will finally be able to use Excel soon! 🙂

  161. Anonymous says:

    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.

  162. Narpal Chandra says:

    Its really simple, nice and easy to understand vedio.

  163. Anonymous says:

    Great lesson. Well thought out, explained well and helpful

  164. mustajab says:

    thank you very much it was very useful ….

  165. Gina says:

    thank you very much – this information is invaluable

  166. santhilatha says:

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

  167. Anonymous says:


  168. angel says:

    excellent.. very well taught

  169. Anonymous says:

    thank u very much….

  170. Kathleen Harney says:

    I would like to learn more about excel 2010

  171. adisomaddy says:

    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!

  172. mijanur rahman says:

    well done brother

  173. Sara says:

    Thank you! This is great for new users!

  174. Loraine says:

    Thanks for this. it has helped me gain the confidence to improve my excel skills.

  175. kyle says:

    you have a really nice voice, i think it’s sexy (: <3 <3 <3

  176. Well thought out video. Keep up the good work.

  177. Christene says:

    Thank you so so much. I find it extremely useful:)!

  178. very important imformation done very well thanks and keep up the good work.

  179. Hoda says:

    Great work! thanks 🙂

Leave a Reply