Excel 2010 Tutorial: A Comprehensive Guide to Excel for Anyone

An easy to follow step-by-step tutorial outlining everything you need to know on Excel for the corporate environment. Learn Excel in just a couple hours: Concepts based. Easy to understand. Try it now. You will not be disappointed and also spread the word. For more info. visit http://learn.kaceli.com.

Data file for this video: https://drive.google.com/file/d/0B3-9HUBAvpxnZ2hRR19NN2RWaDQ/view

If you are interested in taking the full Excel course on Udemy or want to support this work, you can save up to 50% with the code: salikaceli or from here: https://www.udemy.com/excel2013in2hou…

TABLE OF CONTENTS (feel free to share the link to video)
1:00 Basic Spreadsheet Concepts
2:00 Getting Started with Excel
3:00 Worksheet concepts
4:00 Renaming worksheets
4:50 Active cells and cell references and concepts
6:55 Basic Functions and Calculations in Excel: SUM, AVERAGE, MAX, MIN
10:40 Finding the lowest number MIN
11:20 Average
12:00 The Count Function
13:00 The autofill feature
15:00 Addition, subtraction, multiplication, division
22:55 Basic use of formulas and functions
31:00 The autofill feature
33:00 Merge and center: Formatting cells and styles
35:00 Types of references: Relative, Relative and Mixed References
47:20 Conditional formatting
52:00 Calculating Percentages in Excel
56:00 Data sorting and filtering
1:00:00 Creating Charts: Various types of charts
1:09:45 Using the IF statement in Excel
1:15:00 Cross Sheet Calculations
1:22:50 How to link Excel data with Word
125:55 Inserting Headers Footers and Commets
1:29:00 Setting the print area
1:30:30 Freeze panes
1:33:30 Importing data from other systems
1:39:45 Financial Calculations: PMT, IPMT, PPMT
1:49:30 Pivot Tables

If you like this tutorial, subscribe to the channel. The tutorial for Excel 2013 is available on this channel too.

Learn Excel Full Tutorial: https://www.youtube.com/watch?v=hBy7B…
Word 2013 Tutorial is available from here: https://www.youtube.com/watch?v=SCEfz…
Excel 2007 Full tutorial here: https://www.youtube.com/watch?v=IbAfT…
Excel 2013 tutorial: https://www.youtube.com/watch?v=1mNwJ…

If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com

Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.

Comments

olivia kesby1 says:

hello

Youtube Bangla Channel says:

How can I use highlighted cursor in my computer like your. pls help me

Mohamed Yasin says:

very helpful video. Thanks sir

Matt Pearce says:

Perhaps you addressed this and I simply missed it, but at the 13:30 mark, when you auto-summed by dragging to the right, the values for both Maximum and Minimum are incorrect. The Totals should be $1,788 and $53, respectively. The total for Average, incidentally, is correct. Did I miss something? I ask this sincerely, for I really wanna get this down.

Giovanna Lubreto says:

you are a genius, thank you so much..do you do also power point?

akumar professional says:

Great very helping videos

Mali Kalantari says:

Thankyou so much for your great tutorial. You have a great way of teaching and explaining that everyone can understand and apply it.

flwolf2000 says:

Thank you for this very helpful video!

Ashish Mutalik says:

very low voice. cant hear you properly.

Louise POON says:

An outstanding tutorial!!! Thank you Sali

moaa maha says:

thanQ so much… it’s a highly appreciated effort… simple and clear

mohammed alouf says:

thanks very much

Natalie T says:

Thanks for the amazing tutorial. What videos do you recommend a beginner to watch after this one to learn more about Excel?

Denny T says:

the excel tutorial was highly informative and excellent for learning, very good and clear tutorial. the way education should be made. thankssssss.

sujan maharjan says:

simple to understand thanks sir

Nyson Gwatso says:

Wal-l thats a nice presntation Mr. Sali

Robin P Varghese says:

Outstanding.. Thank You

Bella Champ says:

You are a life saver! I have a test in this and our lecturer is terrible so I had no idea how to pass until I watched this, so thank you!

Imran Shafi says:

nice

Tonya Nesbitt says:

I must say this is truly a blessing! This is the best I’ve seen so far. Thank you!

Liseth Sierra says:

Excellent Tutorial!

Harris Zeng says:

Very useful tutorial. It helps me get familiar with basic Excel functionalities quickly. Thanks!

Unush Khan says:

How can I learn excel details ?

Yolanda DuVall says:

Exactly what I was looking for, thank you!

Jon Mander-Jones says:

Thanks you so much for the Excel Tutorial. I am sure I will benefit a lots from this lesson.

DJ Al-shaikh says:

very helpful lessons, clear and comprehensive. thanks alot!

Richard Interplain says:

This is a very simple and easy to understand, you have given me a insight into a program i have used years ago and needed to brush up on my skills for a new job.. i will be saving this for future ref..

Amber Krakauskas says:

Very helpful and you had my undivided attention! Best Excel tutorial yet.

BethanyCrottsImsland says:

Thank you so much, this was really helpful!

J Fernandez says:

Thank you for a very concise and helpful video for the basics of a lot of functions in Excel.

JustDonniemusic says:

Very easy to understand! Any chance you’d have one of my songs in a video?

Gurjot Singh says:

I had an exam yesterday. …i don’t have a PC ….Sir I don’t have the words to thank you….it was very helpful …#greetings_from_India ❤

Nadir Abbas says:

nice great job

sniper101 kreiish says:

thank you I needed this for an exam it really helped thank u for it like taught me everything about excel and so simple to understand the only problem was like it was an I could not hear anything the next time u make a video can you talk more loudly

Jealous Lawn Care says:

Nicely setup 🙂

Ryan Schmidt says:

Great video! Thank you for putting this together. It was very educational for a newbie 🙂

vivek kumar says:

very helpful,great work

kumar pavan says:

Its very good and useful session.Thanks Sali kaceli

Linda Sommer says:

Thank you Sali for doing this. Best explanations I’ve ever seen. I will subscribe and save this video to review again.

 Write a comment

*

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!