Excel 2010 Tutorial: Comprehensive Part 1 of 2 – Become a Pro in 1 Hour

An easy to follow step-by-step tutorial outlining everything you need to know for the corporate environment, work or school. 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. Website: http://kaceli.com

This is part 1 of a 2 part series. The full two part series is also available from here: https://www.youtube.com/watch?v=hBy7BZs-zx0 as one video tutorial.

The data file for this video is available from here if you want to follow hands-on: 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/excel2013in2hours/?couponCode=salikaceli

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

Word 2013 Tutorial is available from here: https://www.youtube.com/watch?v=SCEfzjTRObA
Excel 2007 Full tutorial here: https://www.youtube.com/watch?v=IbAfTCN2qwg
Excel 2013 tutorial: https://www.youtube.com/watch?v=1mNwJkUYS9A

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.


deepika Kapoor says:

this video is really helpful for me thanku so much

Sridhar Kaushik says:

In Excel 2010, in order to Lock a cell (L20 here) as an example of “absolute reference”, it does not work if I just do G23*$L20. Thiw will only lock the L column but not the row 20. You have to put dollar in front of both row and column.
Correct way that works for me is: G23*$L$20. This locks both L column and row 20 at position L20.

Asfiya Zainab says:

Im a kid and i loved your video it really helped me

Angelei Regidor says:

awesome excel tutorial!!! that was very comprehensive. Indeed, i think i’m a pro now!!! 😀

Mehran Hossain says:

awesome video!!!! my third time watching it. fell asleep the first 2 times

Lisa Surles says:


Online Marketing Essentials says:

I had to slow it down a bit to 0.50 and finally understood everything, thank you

Ayuub Ibraahiim says:

thanks you fore leaning this lesson

felize johane says:

now um gonna nail it. this came in handy

Guilherme Domingos D'Osualdo says:

Love the tutorial, but got confused by one thing: two parts of it seemed to have had their order switched. The ones that begin at 6:47 and 22:47. If it’s just my impression, please tell me so. Keep up the good work!

arif merdol says:

Very explicit and clear. Thanks for your help

Jared Brooks says:

lol 52:16

T.A. Starr says:

very helpful. thank you sir.

Khawar Rasheed says:

well done presentation easy to learn

meidf says:

thanks for this fantastic course

Eric Wallin says:


I have actually gone through this video twice. Once about a year ago, and again just recently to brush up. It is that good! Very well put together, and easy to understand! You can pause and replay the video as many times as you like. This is important, because when you are in a class, it is easy to miss an important point here and there. These points or concepts, may be essential to understanding other concepts covered in later classes.

Eric Wallin

mavic coronel says:

Hi, I really do appreciate your tutorials. I have watched MS Excel, Outlook, PowerPoint and Word all 2010. As for MS Excel, I am using a Macbook, and in Mac, F4 doesn’t work to activate the “absolute reference” or the “mix references”. Do you know what is the equivalent of F4 in Mac? Thank you.

jaajuum jaangoi says:


Pallabi Dutta says:

Thank you so much . Its really helpfull to me.

Prasanna Bhandary says:

ty so much for a well explained, video!

Anne Peters says:

Thank you very much your video was excellent

Zeus Kaka says:

Thank you for this useful tutorial.
Still i am having an issue on the mint 16.30 i am having [0] as a result for summing up the deductions cells how can i fix it ?

Fredis Sagastizado says:

Thank you so much. I didn’t know a thing about Excel. Now I can do the basic.This tutorial is great!!!

A T says:

The best tutorial that I have ever watched, highly appreciate!

Gil Jackson says:

trying to get a new page for each salesman.. have many sales lines just want 1 page for each salesman

yoeligish says:

Actually a great tutorial. Thanks a lot.

Jared Brooks says:

a truly wondeful totorial

SadeS says:

Great tutorial, easy to follow!

Christopher THOMAS says:

Thanks for the basic insights.

Nasim Sahel says:

Thank you for the great video. I recommend it to everyone who has no idea how to work with excel.

Kristia Pamungkas says:

Thanks for the video! Very useful to me

Jean vandame says:

tanks goodness to yuup

titus chan says:

wonderful and detailed tutorial! thank you so much for the effort.

Jazmine Reynolds says:

I love this! He doesn’t sound pretentious like some of the other guys. Easy to follow and just fantastic!

Dadwell Mandiya says:

simplified thanks

Joy Stokes says:

People are saying is too slow but I’ve been a baker for years; not an office worker. It’s perfect for me. thank you!

Yvette says:

This is so great! I was dreading it as I expected it to be very confusing and boring but you describe things very well and it’s actually made me want to learn more!
Thank you so much!

edgar says:

Great job….been working with excel for some time but still get something from this..

 Write a comment


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

Please click below to support us on Facebook!