• Attachments
  • Exercises
  • Assignments
    Use assignments to show off a photo or video of what you've learned to the teacher and your fellow students.

Basics of Excel 2010

by Motion Training

0:00 | 9:19
Excel 2010 | The Essentials
Lesson 1 – "Basics of Excel 2010" by Motion Training
  • FAQ

What you'll learn in this course

Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.

Basics of Excel 2010
9 min
Learn More
Interested in learning about Microsoft Excel 2010? This tutorial covers how to use Excel, how to edit and format spreadsheets, and how to create basic charts.
  • Lesson Intro
  • Getting Set Up
  • Exercise - Auto Fill
  • Calculations
  • Exercise - Calculations
  • Formatting
  • Exercise - Centering a Title
  • Exercise - Font Size
  • Currency Symbols
  • Exercise - Decimal Places
  • Creating a Chart
  • Exercise - Totals in Charts
  • Exercise - Benefits of Electronic Spreadsheet
  • Final Assignment
  • 9 step-by-step lessons to master what's important
  • 133 minutes of learning-packed video that isn't sleep-inducing
  • 47 exercises and 9 assignments with personalized teacher feedback
  • 14 attachments so you can learn by actually doing
100% Money Back Guarantee
Mobile Included

Don't take our word for it, ask your future coursemates!

When you take this course you will be joining an active community of 17413 students already learning together. And more are joining every day! Students at Curious love to learn together and help each other out. Meet a few of your virtual coursemates below.

"I think this course is fantastic. I can go back and forth from the spread sheet to the lesson and go along with the lesson. GREAT!"

— Mark V.

"Excel 2010 now belongs to me. Thanks!"

— Gloria W.

"Great to learn 2010 and to know all the shortcuts. My last teacher took the long way home, very time consuming. Nice course."

— Jon I.

"Very grateful for the clear, simple and articulate instructions and sample. The follow up questions to confirm retention are very helpful!"

— Susan H.

"A great find. I work with Excel everyday and have still learned a few new tricks."

— Debbie B.

"I was so nervous about learning Excel, you made it so easy, kudos teach!!"

— Rose M.

Other stuff you might like to know

What is Curious?

Curious is an innovative and engaging marketplace that connects lifelong learners with exceptional teachers from around the world. Curious offers video-based, interactive lessons that help anyone learn about anything on their own time.

Hmm… YouTube is free. Why should I subscribe to Curious+?

While YouTube is awesome (and we admit to spending countless hours watching cat videos), quality, educational content can be challenging to find. At Curious, all lessons are carefully curated and taught by expert instructors. And the instructors actually answer your questions.
Curious+ gives you access to our entire library – that’s over 13,000 lessons and courses covering countless topics from over 1,000 teachers.

How does the free trial work?

The free trial gives you a week of Curious+ at no cost. Enroll in some lessons, browse the collections – try it before you buy it!
At the end of your trial, your membership will automatically continue. You can easily cancel online anytime. And don't worry; there are no cancellation fees.

Wow, so much to learn! How can I watch the lessons? What are the system requirements?

Curious lessons are available by streaming through our iPhone and iPad apps or our website using Chrome, Internet Explorer 9+, Firefox, or Safari. Stay tuned for updates about new devices we support.

How can I cancel my subscription?

We're sorry to see you go! It's easy, just visit our cancellation page. There are no cancellation fees.

Comments on this lesson (898)

Leave a comment (898)

  • Lois W: Kept short, very clear, understandable. Thanks!
  • Arthur M: Very nice. Thank you.
  • Jennifer C: Thank you
  • Sharon B: Thank you, you made it look easy
  • Deborah B: Nice presentation.
  • Rozmina T: This was a great lesson
  • Anshuman K: Awesome, simple, understandable. Well done.
  • Dee D: Very informative. Can't wait to learn more!
  • George G: Awesome!!
  • Tiffany D: Good thx
  • Sue A: Thanks so much! Great things to review.
  • Shamira S: Thank you the lesson was very helpful
  • Francis R: Thank You!
  • Dan T: Great lesson! How can you print from a spreadsheet?
  • Michele K: Thank you for your great tutorial, I thought I knew the basics of Excel but you showed me things I didn't know. This was most informative
  • Joseph C: Thanks for the simple and comprehesive way of teaching.
  • Thoona M: Thank you for your simple and clear explanation
  • Lisa C: So simple and straightforward. Would work even for those who are hesitant with technology.
  • Lucas S: Great tutorial. I've just begun using excel for work and will be turning to you for more how to's.
  • Yolanda G: Thank you, this is a good class!!
  • Sue H: Loved the clarity
  • Marcus B: I recently submitted a request to do an Excel course for work and by good fortune came across this excellent tutorial! ????
  • john h: Great job no money right now mate' definitely next time.
  • Sylvie S: This was very useful
  • Eddy G: Great teacher
  • Liz R: Very nice explanation...
  • Hasan I: I love the teacher on his teaching skills , which are fantastic
  • Magnus S: Thank you very much!
  • Tucson G: Thank you, very helpful basic information
  • Gloria V: Great teaching
  • uday d: sir when you are showing auto sum at the same time you please tell about short cut key like alt = so that we can remember the auto sum as well as short cut key. this will be very helpful for us to remember as well as time saving.
  • salif y: Very comprehensive,concise to the point
  • Jmckc P: Wow! I learned so much very quickly. Thank u for talking slowly and clearly.
  • Cruz P: Thanks for the info. It did help.
  • Beth S: Outstanding
  • Iris N: Thank you!!!!
  • Amparo E: Sorry Sir I'm trying to learn Excel for a job, I will be starting next week. I have no money right now. Sincerely Amparo
  • Miyr L: Great tips!
  • Neha S: Thanks
  • Sandy Z: I can't see anymore????
  • Jigmee L: good work, keep it up
  • SaiCharan K: It's really great. While I understand the point of pricing your videos, they are on the higher side in my opinion.
  • Mohand K: Thanks
  • Tony P: Thanks
  • Malcolm L: Class is for idiots that know nothing, I signed up to learn about pivot tables. That is what it said I would learn.
  • DK K: Ty I learn it
  • Terri H: This was awesome! I am unemployed so cannot send a tip now but this was terrific!!
  • Dasa B: Thank u so much, simply explained I learned a lot , will follow up on ur teaching :)))
  • Temoor A: HAhahHa I seriously enjoyed. It's very interesting and you have made this in such a way that it grabs attention easily. Moreover the questions and comments are very amazing too :p thank you
  • Pat R: I have been using the latest excel a lot, I am amazed at the easier alternative ways you showed. This will save me some time.
  • Dasa B: Great one :)
  • Jackie D: Loved this lesson! Very informative. Easy to follow and learn from. Thank you.
  • Dorothy A: Thanks would like more lessons very informative
  • Diane H: Thanks, I've learned new things!
  • Kathy S: Awesome! Easy to follow!
  • Dorothy A: Thanks
  • Carlos P: Thanks
  • Andy S: Thank you for the info!
  • Lee A: that was not only a really comprehensive lesson but it was also simple, clear cut and i didn't fall asleep. thank you!
  • Jacqueline Z: Love this app
  • Kenneth R: Thanks!
  • Mary E: Thank you for sharing?? I love the way you clearly and carefully explain each step. It's very helpful in the learning process.
  • Chris A: A great lesson! Clear and concise! Thank you!
  • Nancy M: Simple straightforward and well paced beginning instruction.
  • carlos t: Thank you very much great examples
  • Carter J: Awesome app!! 5 stars
  • Bella C: Nice practice!
  • Tina H: I've been using excel for years and never knew how simple it was to create a chart. Thanks!
  • Liliana R: Hola
  • Syema A: Thanks a lot :)
  • Steve B: Very nice demo. Thanks
  • Giancarlo C: Thanks! Very educational and enlightening lesson!
  • Jennie S: Thanks? A really simple basic guide.
  • Yun R: Thank you! So easy to follow .
  • Kelly L: Thanks and easy to understand
  • Hoel S: From a range 0 to ten. The note is 10.
  • Judy W: i can't tell you how helpful this tutorial has been for me!! thank you so much!!
  • Charlotte L: Very clear and concise. Not too wordy thank you.
  • Joe A: Thanks
  • Osmany E: Very good
  • Krystal W: Very simple to understand the presenter. Uses short and easy demonstration enforced by visual cues. Could not make screen larger to see it.
  • Jerry O: Nice job, it was very helpful for me. Thanks!
  • Teisa B: ThNks for the lesson. I am looking to learn how to make spreadsheet making a financial budget. Hope to see an example from you.
  • Dolores E: Very well understood
  • Stephanie G: Thx!
  • Priya K: I'm just a lovely mom of two daughters. But I really love to study. By watching your video I've learnt an important lesson.
  • Anudeep Y: That was easy. Now i cant wait to be an excel sheet expert
  • Margie C: Thanks!
  • Shirlene M: exactly what we wanted to know thank you
  • Linda D: Thank you , very helpful.
  • Marcia E: Verry good
  • Cammy L: I really enjoyed the informative lesson you taught in basics of excel. Please continue giving lessons on excel cause I'd really love to learn more from you as a teacher. Thank you very much for your time and teaching.
  • Phil S: Great class
  • Yanibe d: Thank you. Very nice
  • Phil E: Dear Teacher /Guy??? I have tried the Office 2010 and the Excel lessons today and purchased the Excel as I think it is EXCELLENT As I thought I was in Virtual Computer Land I was quite surprised when on pressing the Tip symbol my account was actually debited that amount Apart from that small surprise I really enjoyed my first day with you
    • Motion Training: Hi Phil. Thanks for enrolling on the course and it's great to hear you are finding it helpful. The 'tip' option is a feature to allow people that have watched the free lessons to make a (optional) small payment if they found it helpful. Obviously you have paid for the course so the 'tip' feature is not relevant! I'll let know that they might consider disabling that feature for people who have paid for the course. Regards, Guy.
  • Mary Beth C: I am trainable. Thank you
  • Joseph F: how do you delete the chart if you want to start over with the chart?
    • Motion Training: Hi Joseph. Put the mouse pointer on (or close to) the edge of the chart and you should see 'Chart Area' in a pop up label. When you see this click to select the whole chart and then press the Delete key. Hope that helps.
  • David H: Awesome.
  • Jcke H: Thanks for the tips!
  • Paul B: Great demo
  • velvaline J: Very well explained. Thank you
  • 慧縈 謝: Thank you for teaching me how to use auto sum. It saves my time.
  • Linda m: I use excel a lot but I learned something new. Very good presentation. Thank you!
  • ALBERTINA M: I do enjoy this lesson.
  • Ahlam B: Thank u for this beneficial lesson...i enjoyed it.
  • cynthia b: Easy to understand. Thank you!
  • joan b: very good presentation , I will be using this site regularly and will contribute in the future. Thanks again.
  • Albert E: Trank
  • Mimi M: Nice! Thank you I know how to make a graph now!!
  • Leonie J: The lesson was very informative, wondering if buy the full course do you get to keep it, so in future if you need to refresh on something it is still there or is it just the one time use? Thanks
  • Brenda W: Unemployed and all the jobs for which I might qualify require excel, word, outlook and/or powerpoint. Should have started as soon as I was laid off, but procrastination. Hope the course teaches me how to print an excel sheet?
    • Motion Training: Hi Brenda, I am working on a new lesson that covers printing in Excel 2010 that will be available soon. Stay tuned and thanks for watching! Regards, Guy
  • Tammy M: Easiest computer lesson I've every had!
  • Jacob K: Appreciate the refresher have a blessed life??
  • Hanan K: Thank you so much for the lesson.
  • Srevan S: Great basic introduction to Excel.
  • Diane L: Very easy to follow
  • Jody L: that was a good start
  • Mary B: Thanks for test ?,s after each section
  • Ruth G: Thank you so much for taking the time to teach us. You are generous, kind and patient. God bless you!
  • L S: Great Lesson
  • Brenden P: That was very well done and detailed.
  • Sherry W: Great tutorials! Thank you
  • Glenville G: Thank you for the lessons on Excel. I have learn a lot and know this will be helpful in my new job. Looking forward to the next lesson.
  • ayesha g: Excellent easy to learn
  • Carol S: Very clear and precise...I am a true beginner and your teaching and speed is perfect.
  • Mandy l: thanks?
  • DJ V: Thank you! Very helpful for my job!!
  • maria y: I am interested in learning how to work with several spreadsheets at the same time. More like extracting data from several reports and then manipulate that data.
  • james j: its not working
  • Alfredo R: Bull shit
  • Rene W: Thank you, I enjoyed the presentation
  • Barbara T: Thank you for this useful class!
  • Thomas B: Thanks ps a more visible review button would be great or save lesson to:
  • warren j: teach me excel pivot tables and lookups
  • Jesse James G: Noice!
  • Tina C: Thanks so much I learned a lot more about Excel.
  • Mishi J: This was great! Hope to learn more from you. ????
  • Joseph A: You're doing a great service at a affordable price. Thank you. jj ash
  • Lori M: Nice!
  • Kareen Y: Very interesting n helpful! Thanks!
  • Ellen w: Thanks
  • Richhie R: Thank you so much ..
  • Gary P: It's a great feeling that this lecture refreshes yet hones my memory on Excel. Thank you very much teacher. It's really a great help especially for students and learners.
  • Jeanne S: Very clear instructions.
  • Keith M: Good work.
  • Faye Elizabeth B: Omg I'm using excel in my data class this is so handy for me ;) thank u
  • Sharon R: The lesson was great. Very informative and I learned quite a bit. Thank you
  • Leander C: Simple and concise. Thanks!
  • Emily B: thanks easy to understand
  • Judy S: Very helpful boost, thank you for the hand up! :)
  • Pat L: ThNk you. I was totally let in making a spread sheet. What a great help
  • esther s: I just want to know how to label the columns
  • Ashwag A: Thanx
  • Musbah Q: Tnku for your more in formation????
  • Jennifer M: Thank you! Once the spread sheet is created how do you save it?
  • Sharon A: ????
  • Becky p: Thank you
  • Leonel S: Great review
  • Love L: Great job!!! Simple, well-articulated!
  • Ramona M: this was quite helpful to me. well worth the cost. thanks. r.minisee
  • Juana C: Excellent
  • Sharma F: this lesson was absolutely on my level. it was straight forward without all the extra information I did not need. I totally comprehended and absorbed the material which is a compliment to you!
  • anne d: great job ---
  • Will L: This was extremely well done indeed .
  • Pat B: Very easy to follow. Thank you.
  • Bazlur R: A very good teacher of Excel.
  • Juan J L: Very helpful
  • Victor P: Excellent presentation!
  • Foriegn B: Awesome job
  • Ha V: Your guidance to excel is brief and every helpful. U did explain clearly so tat beginners can follow. Thank you!
  • Raj S: Thank you
  • Laurie B: Thank you. I had a great time and fun learning the basic of excel. I am looking forward for more. Thanks again!
  • Ramdai P: Awesome!!!
  • Patrice M: teach how to use excel
  • Tammy R: Amazing
  • Luz C: You've done an excellent job making this lesson learnable
  • Patty n: awesome.
  • Akilesh S: Well explained
  • Sarah A: That was awesome! Thanks
  • McKenna M: Thanks so much for these videos! They are very helpful and FREE! Is there a way to get lbs on the chart?
  • Drew S: Great lesson! Easy to follow and very useful tools being taught.
  • Pete V: Learned something
  • Theresa L: Thank you
  • Amanda T: Thanks for the lesson
  • Donnella P: Love your voice. ;-)
  • Laura H: Great lesson ????
  • Franc Peterson A: Thank you very much for giving me a refresher to the Excel basics! :)
  • Sue S: Excellent!!
  • Hansel A: Easy way, keep it up
  • RussnCat R: I learned so much in a short period of time playing around with Excel is now fun instead of frustrating
  • Yuri H: Thanks you for this lesson.I learned so much.
  • D. C: Thank you so much! Makes me want to know more!
  • Asif M: Thank you very much.well explained and very usefull
  • Valarie L: Great...You've made excel less scary for me.
  • Osman S: Thank you for the tutorial
  • melanie h: thanks. I will endeavor a full class on Excel,.
  • David J: Great presentation hope I can remember all that I Learned
  • Barbara M: Thank you
  • Noella C: That was fairly nifty. I didn't know any of that.
  • Тимофей Б: Very useful and simple to understand. Thank you!
  • Lika W: Thank you!
  • Mitzi T: Thank you! Never could understand excel before!
  • Jesika E: Very good
  • Janice C: Love your accent and your humor in the Q&A. Your lessons are not intimidating.
  • Dean P: Very straight forward and clear. Thanks
  • Marian L: ????
  • Pamela G: Thank you this is great information. Pam
  • Tina R: Thank you for the refresher course!
  • arm n: Excellent teacher, easy to follow
  • Curious U: This is the old version of Excel. Please update.
  • Kelli S: Great tips, thank you!
  • Stefanie B: Omg thank you! I already feel 100% smarter!! :)
  • Charis J: That was brilliant.
  • Lisa L: Very well taught, easy to follow and understand...thank you!
  • Limary R: Thanks. Very helpful.
  • Ana H: Thank you for the knowledge that you gave me
  • CARLOS O: Having little education myself , I found this tutorial easy to understand and I am grateful for your work. Thank you very much. handshake
  • Ellen T: Good explanation of a sometimes difficult topic.
  • Mary B: I like the session. Can I repeat it?
  • Jessica P: This was a really great lesson! It was easily to follow and I can now use some more functions I had not learned about before.
  • Sundararaj K: Simply explained Thank u
  • Angelo B: Thank you very much this lesson was very helpful
  • Alaa H: Thank you so much teacher. The presentation was so simple and useful. Hope to attend more lessons about the microsoft Excel
  • ST B: Good class
  • Xtina L: Very helpful for basic use!
  • Steve G: First visit to this site and first lesson observed. Excellent work and I can tell I will utilize this a great deal. Thank you.
  • Donna C: Thank you! Great tutorial--concise and easy to follow.
  • Venia J: Many thanks for streamlined, easily understood lesson!
  • Laurina J: Thank u. Very informative
  • M. M: Good job
  • Enoch F: Thank you very much for this refresher.
  • Joe E: Thank you Mr. But can u upload video for how to use Functions in Excel
  • Stephanie H: I have worked with Excel spreadsheets for y are in multiple roles but it has always remained ominous to me. Thank you for simplifying the best way to create a simple spreadsheet. I never knew it was so intuitive.
  • Andres P: is there a website that I can download excel 2010 free?
    • Bethany B: where can i find the website to down load i need to practice for a test this site has been fantastic
  • Joshua S: Simple clear lessons. Great.
  • Maureen T: I don't know how this works. I purchased the course for $29.99 and because of the difficulties in getting this course gave me a credit of $30.00 over and above the purchase price.
  • mary j: Wow i learned a very important excel function today. which is applicable to my work...thank you so much
  • Rouillie W: Very comprehensive class. Info, no fluff - just the way I like it. Thanks!
  • Taekwan Y: Thanks for basic skills
  • Sharon T: Allowed me to be more understanding of the system and begin to use it. What a time saver!
  • Jay J: Thanks
  • Mari S: Excellent!
  • Lindsey R: Great tutorial, quick and easy to follow ????
  • Victoria N: You are a great teacher! My respects!
  • Jael L: Thank you very much!! Keep it up. ??
  • Bessie M: I enjoyed the refresher course of spreadsheet.. Taught at the right speed ..
  • Annar C: Awesome .Thank you
  • christy e: I am very appreciative of the opportunity. Thank you.
  • Mae M: This tutorial is better than any teachers effort in sharing info of excel. They seem to complicate things. Truly grateful for this thanks
  • Cyril O: it was great
  • Ursula E: Thank you for teaching this class.????
  • Neil F: THE mechanics of switching from Excel's symbol [cross] curser versus the usual for typing and widening the cells is tricky and frustrating. any tips on managing the curser?
  • Mushir M: very simple way a technical presentation brought home, a great teacher
  • Hunter P: I loved the way you make it so easy thank you Sir
  • Rim S: excellent ...thank you
  • terry s: thank you for this resource it has been very helpful.
  • crystal s: Really beneficial thanks soooo much
  • Elham F: Great job
  • Sanjeev T: Great experience of learning in simplest way
  • Elham F: Great job
  • Diane V: great lesson, would like to know if there is a way to get this in print for future reference? would purchase if you could also print lesson..thank you
    • mary Jo H: does the program load to my computer?
  • Agnes K: Great, thanks!
  • Matt F: Thanks for the help !
  • Martine B: Thank you
  • Sang C: Thank you for the excellent job.
  • Matt F: Great Job You should add google sheets tutorial , it seems like the number of users is growing and nobody else has put anything on curious yet, you'll be the spreadsheet expert !
  • Aj W: Thanks man! I already feel like I can operate exell much better after only one video
  • Tara E: Thank you! This section was very helpful.
  • Guido C: Thank you teacher. This lesson helped a lot. Kind regards, Guido
  • Abdellatif H: Thanks a lot, it was really useful
  • Vincent M: Concise, thanks
  • Christopher A: Excellent instruction, easy to understand. Thank you
  • Rich B: Really enjoyed presentation. It was very help full. Thanks
  • Sandra D: I am a quilter n would love to learn how to design quilt blocks using Excel would that be easy to do. I would like to design different blocks n see how to put it together in different formats to get different looks in the quilts
  • Arna L: Just started using Excel 2010 and was lost a little bit; thanks for the quick lesson.
  • Sandra D: Thank you
  • Patricia M: love!
  • Patrice P: This was simple, easy and straight to the point. I wish all classes were like this. Thank you!
  • Leon B: Thanks, learning a lot
  • Lesher F: Thank you very much, is it as simple with an Ipad?
  • Alice M: Fantastic.
  • Douglas L: Good job teach
  • Ugo I: thanks a million
  • Whitney J: I'm applying for a new job, excel is required! Thank you for getting me caught back up in how excel functions! Thus allowing to to future my professional development!
  • Joni B: I have worked on computers for years but never had the opportunity to learn excel. Thanks for the beginners lesson.
  • Nicholas H: Thanks so much for the helpful lesson! I just started an internship that requires some basic excel skills and this video helped a lot!
  • Sari P: Thank you
  • Martin M: Thank you very much
  • S. G: Good job--
  • John B: Cheers, Mate!
  • Akash I: I've learned many new things. Thank you.
  • Chen S: good job
  • David B: Great course!!
  • Sapna B: This was great. Thank you.??
  • Lynda S: Clear and well presented. Thank you so much!