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.

Amazon Auto Links: No products found.

hello

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

very helpful video. Thanks sir

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.

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

Great very helping videos

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

Thank you for this very helpful video!

very low voice. cant hear you properly.

An outstanding tutorial!!! Thank you Sali

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

thanks very much

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

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

simple to understand thanks sir

Wal-l thats a nice presntation Mr. Sali

Outstanding.. Thank You

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!

nice

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

Excellent Tutorial!

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

How can I learn excel details ?

Exactly what I was looking for, thank you!

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

very helpful lessons, clear and comprehensive. thanks alot!

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

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

Thank you so much, this was really helpful!

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

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

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 ❤

nice great job

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

Nicely setup 🙂

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

very helpful,great work

Its very good and useful session.Thanks Sali kaceli

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