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
Target Audience
This course is ideal for anyone looking to improve their skills or start a career in data management
Access Time frame
Life Time Access.
Prerequisites
There are no prerequisites for this course.
Type of Certification
Certificate of Completion
Format of Certification
Digital
Professional Association/Affiliation
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
130 Lessons
6:08:26 Hours
Beginner
37 Lessons
02:08:18 Hours
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
Month Formulas00:01:13
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
Intermediate
37 Lessons
01:36:42 Hours
Abs Formula00:02:15
Averagea Formula00:02:39
Averageif Formula00:01:53
Cell Formula00:04:18
Char Formula00:02:18
Clean Formula00:01:53
Code Formula00:01:59
Exact Formula00:02:08
Large Formula00:02:16
Lower Case Formula00:01:02
Upper Case Formula00:01:29
Proper Case00:01:39
Max Formula00:01:20
Min Formula00:01:31
Median Formula00:01:31
Mode Formula00:02:36
Round Formula00:01:44
RoundDown Formula00:02:25
Roundup Formula00:02:06
Rank Formula 00:06:16
N Formula00:01:25
Autofill00:03:15
Customize Quick Access Toolbar00:04:19
Insert Special Characters00:01:32
Insert Themes in Excel00:01:27
Use Tables in Excel00:05:35
Use Templates00:03:19
Remove Duplicates00:01:46
How To Insert A Custom Background Image In Excel00:01:56
Averageifs Formula00:02:16
Random Numbers00:02:23
SumProduct Formula00:02:27
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
Sunburst Chart00:03:56
Advance
56 Lessons
02:23:26 Hours
And Formula00:02:40
Choose Formula00:04:04
Ceiling Formula00:02:32
Correl Formula00:03:01
Find Formula00:05:56
Or Formula00:02:32
Vlookup with DropDown List00:05:26
Indirect Formula00:02:39
left Formula00:02:09
Mid Formula00:02:09
Replace Formula 00:03:59
Datedif Formula00:02:37
DateValue Formula00:01:48
Edate Formula00:01:33
Multiple Vlookup With Coulmns Formula00:04:25
Daverage Formula00:02:03
Dcount Formula00:01:55
Dcounta Formula00:01:32
Dget Formula00:01:51
Dmax Formula00:01:52
Dproduct Formula00:02:21
Dsum Formula00:02:31
Index 100:01:29
Match 100:01:42
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
Isblank Formula00:03:43
Iserr Formula00:02:04
Sumifs Formula00:02:12
Depreciation Formula00:02:44
Sum of Years Depreciation syd00:02:14
Straight line depreciation00:01:21
PMT Formula New00:01:32
IPMT Formula00:02:42
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
Insert Serial Number Automatically00:02:35
Find and Replace in Excel00:01:37
Create Custom Tab in Excel00:02:12
Strikethrough in Excel00:01:12
Customize Status Bar 00:01:06
Add Password in Excel00:03:57
+ View More
Other Related Courses
Student Feedback
5
Average Rating
0%
0%
0%
0%
100%
Reviews
Tue, 02-Apr-2019
Kriti Mehra
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.
Mon, 13-May-2019
Rohit Gupta
Already know Excel, but not bad for value addition. Great Content!
Tue, 21-May-2019
Surya Joshi
Good presentation and explanation, you get Advance Excel Certificate after completing the course.
Thu, 30-May-2019
Jay Dikshit
Helpful topics!
Tue, 04-Jun-2019
Rakesh Jadhav
I like excel and this course has tought me many new excel tricks.
Wed, 05-Jun-2019
Ravi Sharma
The topics taught are helpful while Data Cleaning.
Wed, 05-Jun-2019
Aditya patil
Good topics and good content
Wed, 05-Jun-2019
Pradeep Gandhi
I already know some Excel, however, free access is welcomed.
Wed, 05-Jun-2019
Shyam Makwana
The course is very comprehensive and some concepts are already known to me. I will keep accessing the course to learn advanced functions.
Wed, 05-Jun-2019
Ruben Nair
Good content and index but not much of Data Science topics.
Wed, 05-Jun-2019
Pooja Rajput
Learnt but can be referred for specific topics through the Course's Index.
Thu, 04-Jul-2019
Gautam Kumar
The course voice is good and soothing. Quite comprehensive course, couldn’t complete it yet, good that they have given more than a years access.
Mon, 08-Jul-2019
Aadi Deshmukh
Good to know, hence I learn it.
Tue, 09-Jul-2019
Tejas Naik
Revised my Excel learning with this course. Good to learn Excel tricks and tips.
Fri, 12-Jul-2019
Pranit Laghari
Not totally related to Data Science but useful.
Sat, 13-Jul-2019
Naveen Agarwal
Good tips.
Mon, 15-Jul-2019
Balendra Singh
The course covers good topics.
Tue, 16-Jul-2019
Jatin Banerjee
The tricks and formulas are excellent.
Tue, 16-Jul-2019
Darpan Jha
Comprehensive, so couldn’t cover all topics.
Tue, 16-Jul-2019
Mitesh Purohit
Imurgence has granted more than a years access, so I do it as and when feasible. So far it is good.
Wed, 17-Jul-2019
Harish Reddy
I am working professional do I know excel very well but updating the skills is very important for nowadays. I enrolled this course and started learning the short-cuts and tricks which have boost my skill.
Tue, 27-Aug-2019
Chetan Parekh
Very nice and valuable tricks have been explained in this course.
Thu, 29-Aug-2019
Tejas Singh
Very nice course!
Sat, 07-Sep-2019
Navin Naidu
I already know about the basics of excel, but upgrading my skills was very important for my professional life. Thanks for this fabulous course.
Wed, 11-Sep-2019
Shauree Rastogi
Overall great experience with this course.
Fri, 13-Sep-2019
Baloo Naran
Those who want to upgrade their excel skill can go for it.
Mon, 16-Sep-2019
Kushit Malik
Highly recommend!
Mon, 16-Sep-2019
Anthra Srivas
Excellent course!
Mon, 16-Sep-2019
Arundhti Krishan
Good!
Tue, 17-Sep-2019
Aabhi Soni
Excellent course with the hidden tricks.
Tue, 17-Sep-2019
Abhyank Mishra
Excellent course by the Imurgence.
Tue, 17-Sep-2019
Knika Jain
Good and exhaustive content.
Wed, 18-Sep-2019
Prutvi Gupta
Brilliant excel tricks have been imparted through this course.
Wed, 18-Sep-2019
Harmil Das
Overall good.
Thu, 19-Sep-2019
Aakashdeep Chauhan
This course has taught me many added excel features.
Thu, 19-Sep-2019
Shaurya Batra
Good presentation and voice, you will learn advance excel skills and get certificate after completing the course.
Fri, 20-Sep-2019
Ishaan Shah
I already know some Excel, however, this course is comprehensive and advanced, therefore, learning it becomes very necessary for every employee.
Fri, 20-Sep-2019
Sanjay Sachdev
Excellent!
Fri, 20-Sep-2019
Parth Modi
Easy to learn and practice, but much is needed to become an expert.
Fri, 20-Sep-2019
Shivansh Rao
Up-gradation of the basics skills of excel is very important.
Write A Public Review