An easy to follow step-by-step tutorial outlining everything you need to know for the corporate environment on Excel. Learn Excel in just a about one hour: Concepts based. Easy to understand. Try it now. You will not be disappointed and also spread the word. Become a pro in just one hour. See also
The video is based on Excel 2007. The same concepts apply to later versions too.
The data file to follow hands-on is available from here:
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.
Excel 2013 tutorial is available from here:
Excel 2010 tutorial is available from here:
Excel 2007 tutorial is available from here:
If you want to take get a deeper understanding of Microsoft Office applications, take a look at
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.
Xem thêm bài viết khác: https://thetanglebay.org/tong-hop/
Thank you sir…..it is actually very helpful
Thank you so much
Thank you so much ❤️❤️💗
Thank you sir for the video and I am sure that it is going to help me in the future saving a lot of time. 👍👍
This is such an amazing tutorial!
Thanks you very much sir
Thank you for the video.
Sir Good Effort .
i just want to know microsoft excel 2007 because thats our lesson on computer i want to advance study
I really need this right now….Thank you Alot
Thank you very much! what a kindess person!
This is the best tutorial i've seen on YouTube. Subscribed
Very informative and interesting presentation. All the best and Thank you!
When you started explaining the column part,mine just showed numbers from a $ column,above and on the right side,and there were no lines or anything compering with other results.do you know what did I do wrong.hope you still use this channel, thank you in advance,wish you all the best.
Great Work, it helped me a lot learning Excel in an hour !
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.
Thank you for creating such a wonderful video Sali. It certainly has created alot of value in terms to my excel journey. Cheers
i would very glad if you would highlight us MS word the same way or procedure that you use during that were explaining/excel 2007. thanks sir.
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
je veus savoir comment telecharger une video
sir why not you make a vedio on ms word
very good video on excel thank you
coupe la musique.
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 are……
This is a wonderful tutorial at no cost. My sincere thanks to the author. Regards,
ESE SIR…. that in my language means Thank you…
thank you so much, this video is very helpful
THANKYOU SO MUCH SIR. THIS VIDEO IS OF GREAT HELP.MOREOVER EACH AND EVERY FUNCTION HAS BEEN EXPLAINED VERY WELL .
i have intrested in computer
great video Sali thank you
God bless people like you
Thank you.. It was informative and time saving video
Thanks a lot! You are indeed a great teacher. I understood it perfectly.
I don't know …How can some people dislike such a nice effort…
explained in simple language and understandable.
thank you sir.hats off to you.
thank you very much i couldn't control myself to appreciate you, this is one of finest lecture on excel i have ever seen, i have learnt a lot of things. Thank you very very much.
its a good one Sali. it really helped.
Sir, may God bless U abundantly . U have a blessed heart and mind. 10Q hundred times!!!
Big thanks to you!!
Thank you very much for your time sir!this is a very useful video..