Excel 2007 Tutorial - A Comprehensive Guide to Excel for Anyone - Excel Made Easy

The video is based on Excel 2007. The same concepts apply to later versions too.

TABLE OF CONTENTS WITH MARKERS is below. This tutorial covers various aspects of commonly used features in today's business environment and is intended to be completed in one hour. It is concise and useful for beginners and those who want to sharpen their skills. Take one hour and become proficient as a student or professional. It is concepts based and simple to follow and understand. It covers:
00:13 - Getting started with Excel 2007
03:40 - Entering Data and Data Types
09:10 - Calculating the SUM and Using the Autofill Feature
13:10 - Max, Minimum, Average, Count Functions
15:20 - Division, Multiplication, Subtraction
17:15 - Understanding Absolute vs. Relative References
21:40 - Formatting and Styles
23:20 - Headers and Footers
25:20 - Calculating Percentages
27:50 - Conditional Formatting
30:20 - Undestanding Additional Excel Functions
32:50 - Sorting Data
34:30 - Data Filtering
36:30 - Creating Charts
39:20 - Cross-Sheet Calculations
44:40 - Using Comments
46:05 - Integrating Excel with Word
52:00 - Performing a mailmerge
59:00 - Excel Pivot Tables.

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.

[donnabarton]

What a really nice person you are to take your time to do this for people who don't have the money to go somewhere to learn this. Thank you.

[tedaokeihn]

The 35 people who disliked this video seemed to have very poor understanding or confused what a tutorial even is.
~
Thank you so much for taking the time to make and post this video.
This has worked wonders for me and indeed one of the best Excel tutorials I've stumbled upon. More power to you, sir! :)

[lagosbaby]

I just got a job as an EA and I hardly know anything on Excel you just saved me. Thank you

[THEHIDEAWAY-PH]

Thank you so much for taking your time out :) Greatly appreciate it.

[MrGroovySpirit]

I think your approach and presentation deserves an award. Thank you very much!

[khybermomand]

I don't have enough money to go outside and learn Excel therefore Only Sali Kaceli helped me a lot to learn Excel.
Thank you very much! What a nice person you

[louiseplease]

I have really enjoyed learning Excel with this tutorial, I've taken my time and stopped the video every few seconds to copy everything being taught. I started with 2007 and now use 365 excel and this tutorial works with both. I'm nearly finished with the tutorial. Just another few minutes left to watch which will take me probably another hour or so to replicate and understand. The Pivot table"s I needed a little more help with but apart from that this tutorial was just great. I think if I knew word first it would have helped me be more familiar with the ribbon. Thank you for a great tutorial.

[jessicadwyer]

You just saved me hours of manual work! Thank you so much!

[jaswantsingh-zhtf]

I don't know ...How can some people dislike such a nice effort...

[lcsaldana]

This is the most informative tutorial I have seen so far.

[tintinc]

WOW! I'm now addicted!  Thank You So Very Much!!!! Very Kind Of You!

[kecu]

Thanks so much for this video. I feel a little more confident going into my apprenticeship, now :)

[creativetvliberia]

This is one of the best lesson ever in my life... You are so amazing and much gratitude from my end..

[loofarmabashir]

I had a great confusion about excel before but now I understood it vividly due to your diligence/effort that made us apprehend it. thanks a lot. professor

[dapo]

This video gave me the basics I wished to learn for many years...Thank you!

[sheikhishfaq]

Thanks sir. You really upload wonderful and enlightening videos. I watch yours, learn them, practice them and teach them others. Thanks a lot. You are my best teacher in computer teaching. Love you Sali Kaceli.

[FourthElement]

This is the best tutorial i've seen on YouTube. Subscribed

[ronnie]

thank you for the effort your a great person teaching the world about exel for free... more power to you

[lisasun]

Thank you very much for this easy to follow step by step tutorial Mr.Kaceli.

[mukundgodbole]

This is a wonderful tutorial at no cost. My sincere thanks to the author. Regards,