Free Online Excel Course Curriculum

If you are new to excel doesn’t know about “ABCD” of excel then we have designed this video course to introduce you to Excel Spreadsheet.

This Free Online Excel Course starts from scratch which can fit to all the kind of learners. This course covers the important basic features which are essential as a new learner. This course describes you to about how excel works, methodology of excel and importance of excel in current corporate world.

If you go to any of the interview excel skills make you stand apart from other in the interview especially if you are a fresher. I have seen many interviews where interviewer asks how much you rate in excel out of 10.

Excel is the universals languages which speaks in almost all the offices. Except you are a surgeon doctor everybody uses spreadsheet at their work place regularly. That is the impact it has.

Below are the topics we cover in this Free Online Excel Course.

• Introduction to Microsoft Excel.
• What is spreadsheet or worksheet?
• What are cells and how they works?
• Working area in the worksheet.
• Introduction to “Ribbon” tab in excel.
• How to enter data into the cell?
• Basic mathematical formulas like addition, deletion, division, multiplication in excel.
• Difference between cell formulas and hard core formulas.
• Cell references and types of cell references.
• Cells formatting, number formatting, text formatting etc…
• Basic excel built-in formulas.
• Essential shortcut keys on excel.
• How to refer to worksheets.
• Applying filters to the data.
• Applying pivot table and how to work with it.
• Some of the important functions like SUM, AVERAGE, MIN, MAX, VLOOKUP, HLOOKUP, SUMIF, COUNTIF, IF and many other important functions.
• Sorting the data in order.
• Common errors in excel.

These formulas and techniques are essential in excel. This Free Online Excel Course covers all the above content in detail from scratch to advanced level.

Free Online Excel Course – Certificate of Completion

Prerequisites

• Mobile or laptop or tab with stable internet connection.
• Hunger and passion to learn the new skill.
• Most importantly dedication at any cost.

Target Audience

As I told except you are a surgeon doctor you will be using excel spreadsheet in workplace one or other way. So, who are the target audience then???

Target audience is mass but below are important target audience who uses excel spreadsheets quite often.

• Students of Commerce Stream: Before even they finish their academics they must started using excel without knowing the importance of it for their projects. As s student of commerce domain their career will be based on excel spreadsheet only. So MBA, BBM, BBA, BCOM and all finance students require this.
• Working Professionals in Corporate: Professional who deal with data requires excel knowledge. For data entry excel is required, for data analysis, creating reports, chart, presentation content, dynamic formulas etc..
• Rest of the world: There is no limitation in learning new skill, so everybody who are interested in it can take up this free excel certification course.

Sample Preview

Career Benefits

As I told in the beginning excel spreadsheet is the universal language which speaks in almost all the offices.

Keeping in mind the career benefits it is important to have the skill of excel spreadsheet. As per one of the survey all top paying jobs in the world requires advanced excel knowledge. Below is the list of the same.

All the top paying jobs requires advanced level of excel skills. But to get to the advanced level you need string basic level knowledge. Without the strong basic level knowledge we cannot go further to advanced level of excel.

So keeping this in mind we are offering this basic excel course at a free of cost.

By the moment you complete the basic excel course you will get used to the excel spreadsheet then you can take up our advanced level of excel course which covers all the advanced level formulas and techniques.

Reviews

VANSHIKA GADODIA

The video lectures were very good.learnt a lot about excel. The course structure was very good. The flow of the topics was apt and was taught with clarity and ease. Now i know the importance of excel and how useful tool it is. Even the downloadable material provided is very good, i could along with the course apply on excel whatever was taught. Great learning experience.
Linked

 

Mamadou N Golo DEME

It’s was very simple to learn and Apply in the same time. I really enjoyed Learning this free excel certification course. And also each topics are well presented with a very easy English (easy to understand for french speaker) Don’t stop and continue to provide what you do. You are the best. Thanks a lot for all your effort and keep it up.
Linked

 

Jose Martinez

Easy to follow content. Very basic and well explained. The free excel certification course has the worksheets available for download so the student can review the content after each lecture. If you are an avid Excel user this course will be very boring. This Free Online Excel Course is perfect for someone who knows nothing about Excel or someone who knows a little. The keyboard shortcuts are a tool everyone should learn.
Linked

 

William Kendall McCoy

The free excel certification course was great. It highlighted and expanded on my basic knowledge of excel. Even though the course is titled Basic Excel Training, many of the concepts used went into the intermediate level of excel use. I would highly recommend this for anyone who processes, analyzes data, and packages it for presentation.
Linked

 

Zaheer Woodally

This was an excellent Free Online Excel Course and very well explained. The course tutor took the time to drill into the basic concepts. It was a good refresher course which allowed me to navigate excel more comfortably and also to tap in the other excel capabilities and functionalities I was not previously using. Cheers!
Linked