The Course is a lucid one which help a beginner to learn skill sets in Excel and use it for application
At the end of the course the user would be able to apply the leanings on practical used cases in business
This course is ideal for anyone looking to improve their skills or start a career in data management
Access Time frame
Six months from the date of access.
There are no prerequisites for this course.
Type of Certification
Certificate of Completion
Format of Certification
The certificate is issued by Imurgence an autonomous institution and endorsed by SiCureMi an IIT Delhi incubated Analytics Firm
Method of Obtaining Certification
Upon successfully completing 80% of this course, the learner will be able to download digital copy of the Certificate and Mark sheet from the Certificates section . The Mark Sheet will keep on updating as the learner progresses towards 100% completion.
Curriculum For This Course
Basic Of Excel00:15:02
Add in Excel00:03:33
Subtraction in Excel00:02:04
Divide in Excel00:01:12
Multiply in Excel00:01:40
Running Total in Excel00:02:36
Percentage in Excel00:01:54
Bar Chart in Excel00:03:27
Column Chart in Excel00:02:41
Pie Chart in Excel00:03:36
Line Chart in Excel00:02:21
Average in Excel00:02:05
Concatenate In Excel00:03:36
Count Formula in Excel00:02:22
Counta Formula in Excel00:02:34
CountBlank Formula in Excel00:01:36
Date Formula in Excel00:02:27
Transpose in Excel00:01:54
Vlookup in Excel00:05:36
Hlookup in Excel00:02:56
If Formula in Excel00:03:03
Sumif Formula in Excel00:07:31
Countif Formula in Excel00:03:01
Averageif Formula in Excel00:03:20
Wrap Text in Excel00:01:39
Merge in Excel00:02:47
Number Formatting in Excel00:05:44
Comments in Excel00:03:05
Paste Special in Excel00:04:42
Create Borders in Excel00:04:17
Conditional Formatting in Excel00:03:47
Filter in Excel00:08:29
Sort in Excel00:03:08
Pivot Tables in Excel00:03:55
Print in Excel00:01:59
Doughnut Chart in Excel00:01:26
Lower Case Formula00:01:02
Upper Case Formula00:01:29
Rank Formula 00:06:16
Customize Quick Access Toolbar00:04:19
Insert Special Characters00:01:32
Insert Themes in Excel00:01:27
Use Tables in Excel00:05:35
How To Insert A Custom Background Image In Excel00:01:56
Data Validation with List Feature00:05:45
Data Validation with Date00:04:06
Data Validation with Whole Numbers00:03:20
Treemap Chart 00:02:37
Vlookup with DropDown List00:05:26
Replace Formula 00:03:59
Multiple Vlookup With Coulmns Formula00:04:25
Index and Match 100:01:43
Index and Match 200:01:15
Index and Match 300:02:01
Index and Match 400:01:24
Index and Match 500:02:20
Sum of Years Depreciation syd00:02:14
Straight line depreciation00:01:21
PMT Formula New00:01:32
Create Pivot Chart00:02:36
Slicer in Pivot Table00:02:16
Timeline in Pivot Table00:02:25
Heighlight a cell based on a Formula00:02:32
Charts That Update Automatically00:02:46
Create Combo Chart in Excel00:02:45
Create Visual In-cell Indiacators In Excel00:03:52
Create Visual In-cell Indiacators With Icon Sets In Excel00:02:07
Sparkline Charts in Excel00:07:26
Heighlight a Column based on a Formula00:02:11
Heighlight a Row based on a Formula00:02:23
Auto Updating DropDown Lists00:02:22
Compare 2 lists in Excel with Vlookup Formula00:03:05
I got this as the elective optional Learning from Imurgence and thanks for the same as Its really great Learning. Although the Basic excel module was something I was aware of but really a new dimension to my existing Knowledge. The Level 2 and 3 very absolutely new and added a great value to my learning.
Already know Excel, but not bad for value addition. Great Content!
Good presentation and explanation, you get Advance Excel Certificate after completing the course.
I like excel and this course has tought me many new excel tricks.
The topics taught are helpful while Data Cleaning.
Good topics and good content
I already know some Excel, however, free access is welcomed.
The course is very comprehensive and some concepts are already known to me. I will keep accessing the course to learn advanced functions.
Good content and index but not much of Data Science topics.
Learnt but can be referred for specific topics through the Course's Index.