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

### Like this:

Like Loading...

*Related*

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

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.

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

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.

i JUST WANT TO THANK YOU SO MUCH FOR THESE POSTS. I LEARNED EXCEL A LONG TIME AGO AND SINCE I HAVE NOT MADE MUCH USE OF IT I REALLY NEEDED THESE VIDEOS TO REFRESH MY MIND!YOU ARE GREAT THANK YOU AGAIN

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

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

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

I agree. I thought I knew a thing or two about Excel only to find I was off in my thinking.

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!

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

Great job Keep it up

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

Thanx a lot Ben!

This was a great help.

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

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

Thanks Ben…. Great video lessons!!!

great job

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

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.

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

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

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.

simple n more informative guide

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.

Cheers!

Thanks. Fantastic lesson.

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

thnks alot sir you are amazing..

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!

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!

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!

September 19, 2013

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

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

This is world very best site for Learn easly Excel.

Thanks

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!

thank you for such a wonderful webpage.

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

I had no idea how to approach this before-now I’m locked and loaded.

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

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

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

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

Awesome!!!

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.

Hello Paula,

That sounds easy enough. What kind of help do you need?

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

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

GREAT JOB,THANK YOU FOR THIS USEFUL LESSON

It is very good site for leaning excel .

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

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

this videos really gr8

Thank you, Ben. You’re the best!

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

haha thanks

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!

Ben

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

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

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

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

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

This is amazing!! Thank you!

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!

cool . The master work book is dam good

Great Lesson…!! Thanks…!!

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

Thanks Allot…….. :-)

Hi Ben,

I’d like to share this article http://www.bbc.co.uk/news/magazine-22223190

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!

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

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

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

I wish I had those kind of skills, but I actually didn’t do that myself. I had someone who is a graphic designer help me out with it.

Hope you’re enjoying the site!

how to dawnload this vedies

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

thanks a lot, its very useful..

Thank you

Thank you so much for this amazing site!!

WOW!!! YOU ARE AWESOME!!! SOOOOOOO MUCH APPRECIATED!! :) THANK YOU!!!! WELL TAUGHT !

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

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

realy helpfull

This is AMAZING. Seriously.

BEST INTRO … VERY USEFUL.. THANK YOU VERY MUCH. FOR YOUR GREATEST HELP..:)

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.

Incredible… thanks a million :)

You are awesome. God Bless :)

great work, thanks!

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

It was very helpful and nice…thnx

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

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

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.

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, 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 mr.adeel186@gmail.com 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.

Cheers,

Ben

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…

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

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

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

Good work keep it up….

Absolutely great! Thanks!

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

Thank you thank u.

Hi Ben,

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

Tina

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

Thanks Good job!!

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

Thanks, this is EXACTLY what I need right now

This is good! Thank you!

This tutorial is great. Thanks a lot.

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

I hope I learn something.

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

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.

Its really simple, nice and easy to understand vedio.

Great lesson. Well thought out, explained well and helpful

thank you very much it was very useful ….

thank you very much – this information is invaluable

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

ITS VERY USEFULL

excellent.. very well taught

thank u very much….

I would like to learn more about excel 2010

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!

well done brother

Thank you! This is great for new users!

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

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

Well thought out video. Keep up the good work.

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

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

Great work! thanks :)

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

Great work, thank you

I realy learn from video, did not about excel.