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
Data file for this video:
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:
Word 2013 Tutorial is available from here:
Excel 2007 Full tutorial here:
Excel 2013 tutorial:
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.
Tag: eexcel online, Microsoft Office, Office 2010, Excel 2010, Computer concepts, basic Excel, excel autofill feature, cell references, excel sorting and filtering, excel charts, excel if statement, excel cross sheet calculations, excel comments, excel headers, excel footers, excel importing data, excel pivot tables, Full excel tutorial, basic excel tutorial, simple tutorial, simple tutorial on excel, easy to understand excel tutorial, excel 2010 tutorial, Microsoft Excel (Software)
Xem thêm: https://blogthủthuật.vn/category/review
Nguồn: https://blogthủthuật.vn
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..
fine
Oh my goodness you explained absolute reference perfect never got it. I udnerstand now thank you.
Thank you for sharing this in youtube. This is really great!!!!
Thanks mate. You just save my day! I watch your channel and Vanna Excel to solve my questions on my work!!!
Really enjoyed tutorial while practicing 👏
Anyone know where training 1 is?
thank you! this is very helpful
Thank you sir
It helped me a lot
Awesome explanation
Hats off to you!
Great job sir
Thanks again
Just Wanted to tell that you have 2 Evernote shortcut available in desktop. 1:25:26
Awesome tutorial. Loved it
Wonderful!!! This training helped me to enhance my knowledge in excel… Thank you sir………
Thanks from Egypt. It was very helpful
Hello oh no ist a long l don t know ok😃😃😃😃😃🖒🖒🖒🖒
Just what I was looking for. Thanks.
teacher thanks
1:30:52–1:31:00 How do I do the tutorial.I didn't have the URL.Plz help me.
thanx <3
Perfect Tutorial you can find in the whole internet!
Thanks Kaceli, God bless you for blessing the others.
Fantastic explanation to get refreshed on Excel if you haven't been using it for a while. Excellent! Thank you very much.
Thank You
It's was helpful. Thank you for upload.
xcellent tutorial sir. You saved me. By mistake I chose to learn advanced excel instead of basic excel. It would have been really difficult for me to learn advanced excel without any previous basic knowledge of excel. Thanks to your video I don't have that problem anymore.
Tq sir.
Super sir,
This video s really helpful .
Keep update like dis video sir 👍
Thanks a lot!
It's really a highly appreciated work and I have bookmarked it to review it again whenever I may need it and I will recommend it to my colleagues for sure.
Well done Prof.
Thanks you so much for the Excel Tutorial. I am sure I will benefit a lots from this lesson.
very helpful,great work
thank u sir.its very helpful to achieve a new gol.
Very useful tutorial. It helps me get familiar with basic Excel functionalities quickly. Thanks!
Thank you so much.
you have explained very pleasing.