Excel 2010 Tutorial: A Comprehensive Guide to Excel for Anyone

Rate this post

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ậ

Nguồn: https://blogthủthuậ


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

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

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


Post Comment