Excel 2010 Tutorial: A Comprehensive Guide to Excel for Anyone



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.

Nguồn: https://awbphotocontest.com

Xem thêm bài viết khác: https://awbphotocontest.com/tong-hop/


Article Categories:
Tổng Hợp

Comments

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

    Richard Interplain August 3, 2020 10:20 pm Reply
  • Anyone know where training 1 is?

    bernard chongo August 3, 2020 10:20 pm Reply
  • thank you! this is very helpful

    Nada Maou August 3, 2020 10:20 pm Reply
  • Thank you sir
    It helped me a lot
    Awesome explanation
    Hats off to you!
    Great job sir
    Thanks again

    Kalindi Gupta August 3, 2020 10:20 pm Reply
  • Just Wanted to tell that you have 2 Evernote shortcut available in desktop. 1:25:26

    Pushpendra Yadav August 3, 2020 10:20 pm Reply
  • Awesome tutorial. Loved it

    Pushpendra Yadav August 3, 2020 10:20 pm Reply
  • Wonderful!!! This training helped me to enhance my knowledge in excel… Thank you sir………

    nancy anil August 3, 2020 10:20 pm Reply
  • Thanks from Egypt. It was very helpful

    Sarah Abdel Hamid August 3, 2020 10:20 pm Reply
  • Hello oh no ist a long l don t know ok😃😃😃😃😃🖒🖒🖒🖒

    vinhover Vinhhoang August 3, 2020 10:20 pm Reply
  • Just what I was looking for. Thanks.

    HowToExcel August 3, 2020 10:20 pm Reply
  • teacher thanks

    Hussein Mohamud August 3, 2020 10:20 pm Reply
  • 1:30:52–1:31:00 How do I do the tutorial.I didn't have the URL.Plz help me.

    Poh hooi ching August 3, 2020 10:20 pm Reply
  • thanx <3

    Aura Arab August 3, 2020 10:20 pm Reply
  • Perfect Tutorial you can find in the whole internet!

    Bhupen Mandal August 3, 2020 10:20 pm Reply
  • Thanks Kaceli, God bless you for blessing the others.

    Sam Manook August 3, 2020 10:20 pm Reply
  • Fantastic explanation to get refreshed on Excel if you haven't been using it for a while. Excellent! Thank you very much.

    Eva de Paz Urueña August 3, 2020 10:20 pm Reply
  • Thank You

    Nz Sumon August 3, 2020 10:20 pm Reply
  • It's was helpful. Thank you for upload.

    Ognjen Petrović August 3, 2020 10:20 pm Reply
  • 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.

    Jamil Mansoori August 3, 2020 10:20 pm Reply
  • Tq sir.
    Super sir,
    This video s really helpful .
    Keep update like dis video sir 👍

    Akshata Baliger August 3, 2020 10:20 pm Reply
  • 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.

    Moustafa Mahmoud August 3, 2020 10:20 pm Reply
  • Thanks you so much for the Excel Tutorial. I am sure I will benefit a lots from this lesson.

    Jon Mander-Jones August 3, 2020 10:20 pm Reply
  • very helpful,great work

    vivek kumar August 3, 2020 10:20 pm Reply
  • thank u sir.its very helpful to achieve a new gol.

    riyad khan August 3, 2020 10:20 pm Reply
  • Very useful tutorial. It helps me get familiar with basic Excel functionalities quickly. Thanks!

    Harris Zeng August 3, 2020 10:20 pm Reply
  • Thank you so much.
    you have explained very pleasing.

    venkata srikanth August 3, 2020 10:20 pm Reply
  • hello

    oliviaa 123 August 3, 2020 10:20 pm Reply
  • Thank you for this very helpful video!

    flwolf2000 August 3, 2020 10:20 pm Reply
  • I must say this is truly a blessing! This is the best I've seen so far. Thank you!

    Tonya Nesbitt August 3, 2020 10:20 pm Reply
  • the excel tutorial was highly informative and excellent for learning, very good and clear tutorial. the way education should be made. thankssssss.

    Denny T August 3, 2020 10:20 pm Reply
  • Ledgend! I'm upto 19 minutes and already learnt a lot!

    Mathew Farry August 3, 2020 10:20 pm Reply
  • nice great job

    Abbas Nadir August 3, 2020 10:20 pm Reply
  • How can I learn excel details ?

    Unush Khan August 3, 2020 10:20 pm Reply
  • Its very good and useful session.Thanks Sali kaceli

    kumar pavan August 3, 2020 10:20 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *