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.

Amazon Auto Links: No products found.

this video is really helpful for me thanku so much

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.

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

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

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

Excellent.

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

thanks you fore leaning this lesson

now um gonna nail it. this came in handy

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!

Very explicit and clear. Thanks for your help

lol 52:16

very helpful. thank you sir.

well done presentation easy to learn

thanks for this fantastic course

Thanks!

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

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.

THANKS TO YOU ALOT

Thank you so much . Its really helpfull to me.

ty so much for a well explained, video!

Thank you very much your video was excellent

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 ?

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

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

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

Actually a great tutorial. Thanks a lot.

a truly wondeful totorial

Great tutorial, easy to follow!

Thanks for the basic insights.

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

Thanks for the video! Very useful to me

tanks goodness to yuup

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

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

simplified thanks

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!

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!

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