Free Excel Course

Introduction

‘Useful Excel for Beginners’ is a free on-demand video-based course tailored for beginners who are interested in learning Microsoft Excel.

This course is a series of 89 videos running for slightly more than 9.5 hours. You can watch the videos at your own schedule and pause/replay as you would like. The course covers the concepts and features that I believe will help you get started and become a functional user of Excel.

Course Highlights

Highlights of the course

  • 9.5 hours of videos covering all the key concepts and topics
  • Tailored for those who have never used Excel before and beginner level users
  • Easy to follow video demonstrations where all the operations are performed on screen
  • Create report on a fictional book store’s employees’ monthly work hours and salaries
  • Analyze product sales, customer and sales trends for the book store
  • 25 most used functions covered with examples
  • Important keyboard shortcuts highlighted
  • Includes Conditional Formatting, PivotTables and Tables
  • Downloadable exercise files so that you can easily follow the course

 

Table of Contents

  1. Introduction (7 m)
  2. Basics of Excel (11 m)
  3. Entering Data (2 h 45 m)
    • Keyboard shortcuts
    • Navigating in a worksheet
    • Selecting Cells
    • Number Formatting
    • Inserting & Deleting
  4. Formatting (37 m)
  5. Editing (1 h 10 m)
    • Auto Fill
    • Cut, Copy, Paste
    • Sort & Filter
    • Find & Replace
  6. Saving (10 m)
  7. Viewing (7 m)
  8. Calculations  (2 h 6 m)
    • Formula
    • 25 functions
    • Errors
  9. Visualizing  (1 h 20 m)
    • Charts
    • Conditional Formatting
    • Illustrations
  10. Analyzing (31 m)
    • Pivot Tables
    • Slicers
  11. Tables (16 m)
  12. Sharing (12 m)
    • Saving and Sending
    • Printing

Course Reviews

 I was impressed about the minimum knowledge I had of excel before this training, I though I knew enough but I was wrong, pretty good and well organized, I would recommend it for anyone who wants to a clean start up to begin using excel. Also as a refresh for those who know few things about it.

– Jonathan Rivera

The instructor has clearly put a lot of time and work into creating this terrific course. I think it is very generous of him to give it away for free.

I have excel 2013, and managed to follow along, even though this course is based on 2010 – and I had very little knowledge about it at all. I learned so much about excel after working my way through this course. It is very detailed. There are also explanations of why we do things in a certain way with excel, and even a lecture on the most common errors as well. Be prepared to allow more than 10 hours for this course. After all, it will take some time to action the lessons in each lecture. Also, you will not be at basic level when you finish them all!

This is definitely a favourite course of mine and one that I will come back to again. I can’t praise it enough!

– Annie Byway-Williden

I would definitely recommend this course, if you are new to Excel. The course introduces gradually the student to the Excel way of thinking, with well explained and easy-to-follow tutorias based on concrete examples. The support material (excel files that can be downloaded) allows you both to experiment during or after the course, but also have a large library of ready-to-use Excel templates. Ind Zara has done an amazing job, after a few days I feel ready to start using Excel and implement many of its features

– Theodoros Nakos

DOWNLOAD EXERCISE FILES

57 Exercise Files to follow along with the course

Sign up for FREE

58 thoughts on “Free Excel Course

  1. Thank you for the tutorials and am very greatful to be here………………………. thank you all God Bless you

    1. You are welcome. Thanks for feedback.
      Best wishes.

  2. Clear and detailed, this is a truly excellent course! I found it tremendously helpful. Thank you for the lessons!

    1. Thank you for the feedback. Glad to hear that it is helpful.
      Best wishes.

  3. Hi Indizara I need an excel template to evaluate teachers as to make annual appraisal.

    1. Sorry, I don’t have such a template. Best wishes.

  4. Thank you for your awesome lessons and generosity. you make it easy for the beginner like me to follow.

    1. You are welcome. Glad to hear. Best wishes.

  5. Wao ! What a fantastic course. What a generous lecturer.I often thought I know MS-EXCEL until l went through this course to realize that I know nothing.The slides are well prepared to suite anyone taking a course in excel for the first time.The lecturer has taken his time to explain concepts to the understanding of the beginner in EXCEL.Thanks for your generosity.May ALLAH bless you manifold.

    1. Thank you. I am glad that you found it useful.
      Best wishes.

  6. ì have basic idea about excel but i want to learn advance excel online (i.e. how to develop program etc..Could you suggest me.

    1. I don’t have any advanced Excel videos yet, but you can try udemy.com and search for Advanced Excel courses. There may be some free courses as well.
      Best wishes.

  7. Retail Inventory Tracker helps me alot, Although can i change the word Sale into “consumption”? Does it will affect all other tabs like in report/pivot tables etc.
    Please help me to update the file if i will be using the term consumption.
    Thanks a lot.
    More power!
    Please send to my email your reply.

    Regards,
    Gerardo Senin

    1. Thanks.
      Sorry, changing the word Sale will require modifications to many calculations.
      Best wishes.

  8. thank you so much sir for being make
    effort and generous. god bless you!

    1. You are very welcome. Glad to help. Best wishes.

  9. how you create Data in INDIA map as per District wise plz help

    1. I am sorry. I don’t have districts’ map. Please download the file in https://indzara.com/2013/04/geographic-heat-map-india-excel-template/ and see how the formulas are done. The outlines of states have to be replaced with districts. thanks.

  10. how you create formula for multiplying ft.inxft.in= area?

    1. If the numbers are in cells A1 and B1, then we can write a formula in C1 =A1*B1.
      Hope it helps. Thanks.

Leave a Reply

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