Excel 2010 Tutorial: A Comprehensive Guide to Excel for Anyone

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.

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.

[Tankerbell]

I enrolled in a statistics class and found out that the class extensively used excel. I have never had any formal training on Excel and when I found this excellent video...Thank you. Thank you so much. I will continue to reference this and I can watch it as many times as I need. Thank you so much for taking the time to put together such a comprehensive video!

[traceytillman]

Sali, Thank you for your fine tutorials, Excel has challenged me over the years. I have never been able to "crack" the learning curve successfully until I started watching your channel. As i continue to learn and master the Excel skill set, I will highly recommend your channel. Thank you Sali for helping all of us, it is greatly appreciated. I finally feel comfortable with Excel thanks to your teachings.

[issatomusakamara]

It is only God can reward you....Mr Sali Kaceli, thanks very much for your effort in educating the world...

[ohshebesoimmortal]

This is one of the most insightful tutorials on excel I have come across. Although I used the 2007 version, to follow along, I am now confident in my ability to navigate through the 2010 version like a pro.
This video has been saved to my favorites as superb reference material.
Dude, you rock! Thank you immensely.

[elizabethjoseph]

Mr. Sali Kaceli, you are wonderful and a great teacher, you know what you are teaching and how to make understand the students in a simple way. Thank you so much Mr.Kaceli

[InterplainMusic]

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

[yakovmatityahu]

This was the first time ever that i seriously studied Excel...thats only due to excellent and easy way of explanation by Sali Kaceli...
Thank u Sali...

[yvette]

You practically cover all important points in your session, what awesome! Thanks!

A good teacher makes things easy to understand, and that is what Mr Kaceli has achieved here.  Superb.

[Shamshu]

Very simple tutorial on not so simple subject. What is best is you go at your own pace, you may not proceed to next step unless you have picked the last one however you can jump lesson if you so choose. Thank you Sali Kaceli .

[darrellmartinquinn]

Thanks mate. You just save my day! I watch your channel and Vanna Excel to solve my questions on my work!!!

[sandybeaches]

This video is well put together, very comprehensible. Now all I have to do is practice, practice, practice. Thank you.

[lajambedumilieu]

Merci beaucoup Sali! That was great! I understood everything however English is not my first language. It was a big pleasure listen to you. You are really a very good teacher. Thank you very much!

[andreealipan]

Very good tutorial for Creatives that are afraid of Excel! I needed all day to finish it because I lack patience, but I understood everything and for people that wish to manage their business, seems pretty complete in the information offered! Thank you!

[neveragain]

Thank you Sali for sharing your knowledge. I'm in my 40's and applying for an admin apprenticeship, a job that was totally out of my depth as I've never done this kind of work ever, not now though as you've made it really simple for me to understand. I had no knowledge what so ever of any spreadsheets or data input, this free tutorial is actually quite fantastic.

[peliwejubase]

THANK I have been looking for this for weeks and U just saved me. I feel like hugging u. Tears of joy are running down my chubby cheeks now.

[lelowakpan]

I lost your channel but I got you back! Thank you so much my mentor. I love this video

[megabojan]

Excellent tutorial sir. You saved me. By mistake I chose to learn advanced excel instead of basic excel. It would have been really difficult for me to learn advanced excel without any previous basic knowledge of excel. Thanks to your video I don't have that problem anymore.

[thisoldtubsoapery]

I have to take an Excel test as the next step in the interview process... THANK YOU for this tutorial... This has totally freshened up my skills plus given me new ones! I'm ready for the test now!!!

[SupremeTycoon]

Ledgend! I'm upto 19 minutes and already learnt a lot!