BASIC EXCEL TRAINING

Course Details

Modules : 6
Projects : 10
Eligibility : HSC/SSC
Learning Mode : Online / Classroom

Enroll Now

INTRODUCTION

In this course, you will get a basic knowledge of excel including how to create a pivot table, how to use the shortcuts, create graphs & charts, and also how to use the date and time.

CURRICULUM

In this course, we would cover everything that a beginner needs to be able to learn the basic MS Excel.

And before we look at the prerequisites, target audience, FAQs, career benefits, let’s look at the basic excel training modules briefly.

Sr. No.	Course Name	Total Duration	Course Description
1	Basic Microsoft Excel Training Course	4	This is the first module of basic excel training. And we will start this module with a brief overview on Ribbons Quick Access Toolbar and Excel Help Function. Then, we will take a case study that we can use for showing you how Excel works. Then, you will understand what data entry is in MS Excel. Next, we will feed the data into the excel sheet for the case study. Then, we will talk about the calculations, formulas, formatting, and how you can update a calculation. Next, we will teach you about the percentages absolute references, conditional formatting, IF function, Count-IF, SUMIF, Charts & Graphs, sorts & filters, pivot tables, freeze & split, presentation, print, shortcuts, and finally, common errors, You need to watch 28 videos in total to cover the module.
2	Excel Basic Training 2013 – Introduction MS Excel Basic Training Overview	4	This Basic Microsoft excel course online module is a little different than the earlier module. This training is based on MS Excel. We will start this module with a brief overview. Then, we will show you how to get started with MS Excel 2013. Then, we will take a case study and then would show you the data entry. Then, we will feed the data into the excel sheet for the case study. Then, we will talk about the calculations, formulas, formatting, and how you can update a calculation. Next, we will teach you about the percentages absolute references, conditional formatting, IF function in excel, Count-IF, SUM-IF in excel, Charts & Graphs, sorts & filters, pivot tables, freeze & split, presentation, print, shortcuts, and finally, common errors, You need to watch 38 videos in total to cover the module.
3	Microsoft Excel 2016 – Beginners	4	This is another module that is an extension of the previous two basic Microsoft excel training course modules. In this module, we will go into detail about Microsoft Excel 2016. And as you can expect, we will start with a brief overview of the MS Excel. Then, we will start with a case study so that showing you how things work would be easier. We will talk about calculations, formulas, updating a calculation, percentages & absolute references, conditional formatting, IF function, charts & graphs, etc. You will also learn about common errors and shortcuts in excel. This entire module will need you to watch 37 videos in total.
	Total Duration	12+ Hours

TARGET AUDIENCE

Students (graduate or undergraduate): If you are an undergraduate or graduate student, this course is just perfect for you. If you know MS Excel, still you can do this course as a refresher. This basic Microsoft excel training course will set the foundation for you so that you can go ahead and learn the advanced level, MS Excel.
Professionals: If you’re a professional and you never have put your hands on MS Excel, this is the perfect course for you. This course will teach you to step by step how you can use the basic functions, formulas, graphs, pivot tables, and many other features of MS Excel.