Certificate Course in Excel

This is a certificate course in Excel have three modules - Beginner, Intermediate and Advanced

free 301 Students Enrolled
Created By Imurgence Learning Last Updated Mon, 23-Nov-2020
+ View More
Description
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 Excel 00:15:02
  • Add in Excel 00:03:33
  • Subtraction in Excel 00:02:04
  • Divide in Excel 00:01:12
  • Multiply in Excel 00:01:40
  • Running Total in Excel 00:02:36
  • Percentage in Excel 00:01:54
  • Bar Chart in Excel 00:03:27
  • Column Chart in Excel 00:02:41
  • Pie Chart in Excel 00:03:36
  • Line Chart in Excel 00:02:21
  • Average in Excel 00:02:05
  • Concatenate In Excel 00:03:36
  • Count Formula in Excel 00:02:22
  • Counta Formula in Excel 00:02:34
  • CountBlank Formula in Excel 00:01:36
  • Date Formula in Excel 00:02:27
  • Transpose in Excel 00:01:54
  • Month Formulas 00:01:13
  • Vlookup in Excel 00:05:36
  • Hlookup in Excel 00:02:56
  • If Formula in Excel 00:03:03
  • Sumif Formula in Excel 00:07:31
  • Countif Formula in Excel 00:03:01
  • Averageif Formula in Excel 00:03:20
  • Wrap Text in Excel 00:01:39
  • Merge in Excel 00:02:47
  • Number Formatting in Excel 00:05:44
  • Comments in Excel 00:03:05
  • Paste Special in Excel 00:04:42
  • Create Borders in Excel 00:04:17
  • Conditional Formatting in Excel 00:03:47
  • Filter in Excel 00:08:29
  • Sort in Excel 00:03:08
  • Pivot Tables in Excel 00:03:55
  • Print in Excel 00:01:59
  • Doughnut Chart in Excel 00:01:26
  • Abs Formula 00:02:15
  • Averagea Formula 00:02:39
  • Averageif Formula 00:01:53
  • Cell Formula 00:04:18
  • Char Formula 00:02:18
  • Clean Formula 00:01:53
  • Code Formula 00:01:59
  • Exact Formula 00:02:08
  • Large Formula 00:02:16
  • Lower Case Formula 00:01:02
  • Upper Case Formula 00:01:29
  • Proper Case 00:01:39
  • Max Formula 00:01:20
  • Min Formula 00:01:31
  • Median Formula 00:01:31
  • Mode Formula 00:02:36
  • Round Formula 00:01:44
  • RoundDown Formula 00:02:25
  • Roundup Formula 00:02:06
  • Rank Formula 00:06:16
  • N Formula 00:01:25
  • Autofill 00:03:15
  • Customize Quick Access Toolbar 00:04:19
  • Insert Special Characters 00:01:32
  • Insert Themes in Excel 00:01:27
  • Use Tables in Excel 00:05:35
  • Use Templates 00:03:19
  • Remove Duplicates 00:01:46
  • How To Insert A Custom Background Image In Excel 00:01:56
  • Averageifs Formula 00:02:16
  • Random Numbers 00:02:23
  • SumProduct Formula 00:02:27
  • Data Validation with List Feature 00:05:45
  • Data Validation with Date 00:04:06
  • Data Validation with Whole Numbers 00:03:20
  • Treemap Chart 00:02:37
  • Sunburst Chart 00:03:56
  • And Formula 00:02:40
  • Choose Formula 00:04:04
  • Ceiling Formula 00:02:32
  • Correl Formula 00:03:01
  • Find Formula 00:05:56
  • Or Formula 00:02:32
  • Vlookup with DropDown List 00:05:26
  • Indirect Formula 00:02:39
  • left Formula 00:02:09
  • Mid Formula 00:02:09
  • Replace Formula 00:03:59
  • Datedif Formula 00:02:37
  • DateValue Formula 00:01:48
  • Edate Formula 00:01:33
  • Multiple Vlookup With Coulmns Formula 00:04:25
  • Daverage Formula 00:02:03
  • Dcount Formula 00:01:55
  • Dcounta Formula 00:01:32
  • Dget Formula 00:01:51
  • Dmax Formula 00:01:52
  • Dproduct Formula 00:02:21
  • Dsum Formula 00:02:31
  • Index 1 00:01:29
  • Match 1 00:01:42
  • Index and Match 1 00:01:43
  • Index and Match 2 00:01:15
  • Index and Match 3 00:02:01
  • Index and Match 4 00:01:24
  • Index and Match 5 00:02:20
  • Isblank Formula 00:03:43
  • Iserr Formula 00:02:04
  • Sumifs Formula 00:02:12
  • Depreciation Formula 00:02:44
  • Sum of Years Depreciation syd 00:02:14
  • Straight line depreciation 00:01:21
  • PMT Formula New 00:01:32
  • IPMT Formula 00:02:42
  • Create Pivot Chart 00:02:36
  • Slicer in Pivot Table 00:02:16
  • Timeline in Pivot Table 00:02:25
  • Heighlight a cell based on a Formula 00:02:32
  • Charts That Update Automatically 00:02:46
  • Create Combo Chart in Excel 00:02:45
  • Create Visual In-cell Indiacators In Excel 00:03:52
  • Create Visual In-cell Indiacators With Icon Sets In Excel 00:02:07
  • Sparkline Charts in Excel 00:07:26
  • Heighlight a Column based on a Formula 00:02:11
  • Heighlight a Row based on a Formula 00:02:23
  • Auto Updating DropDown Lists 00:02:22
  • Compare 2 lists in Excel with Vlookup Formula 00:03:05
  • Insert Serial Number Automatically 00:02:35
  • Find and Replace in Excel 00:01:37
  • Create Custom Tab in Excel 00:02:12
  • Strikethrough in Excel 00:01:12
  • Customize Status Bar 00:01:06
  • Add Password in Excel 00: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.
  • Kriti Mehra
    Mon, 13-May-2019
    Rohit Gupta
    Already know Excel, but not bad for value addition. Great Content!
  • Rohit Gupta
    Tue, 21-May-2019
    Surya Joshi
    Good presentation and explanation, you get Advance Excel Certificate after completing the course.
  • Surya Joshi
    Thu, 30-May-2019
    Jay Dikshit
    Helpful topics!
  • Jay Dikshit
    Tue, 04-Jun-2019
    Rakesh Jadhav
    I like excel and this course has tought me many new excel tricks.
  • Rakesh Jadhav
    Wed, 05-Jun-2019
    Ravi Sharma
    The topics  taught are helpful while Data Cleaning.
  • Ravi Sharma
    Wed, 05-Jun-2019
    Aditya patil
    Good topics and good content
  • Aditya  patil
    Wed, 05-Jun-2019
    Pradeep Gandhi
    I already know some Excel, however, free access is welcomed.
  • Pradeep Gandhi
    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.
  • Shyam Makwana
    Wed, 05-Jun-2019
    Ruben Nair
    Good content and index but not much of Data Science topics.
  • Ruben Nair
    Wed, 05-Jun-2019
    Pooja Rajput
    Learnt but can be referred for specific topics through the Course's Index.
  • Pooja Rajput
    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.
  • Gautam Kumar
    Mon, 08-Jul-2019
    Aadi Deshmukh
    Good to know, hence I learn it.
  • Aadi Deshmukh
    Tue, 09-Jul-2019
    Tejas Naik
    Revised my Excel learning with this course. Good to learn Excel tricks and tips.
  • Tejas Naik
    Fri, 12-Jul-2019
    Pranit Laghari
    Not totally related to Data Science but useful.
  • Pranit Laghari
    Sat, 13-Jul-2019
    Naveen Agarwal
    Good tips.
  • Naveen Agarwal
    Mon, 15-Jul-2019
    Balendra Singh
    The course covers good topics.
  • Balendra Singh
    Tue, 16-Jul-2019
    Jatin Banerjee
    The tricks and formulas are excellent.
  • Jatin Banerjee
    Tue, 16-Jul-2019
    Darpan Jha
    Comprehensive, so couldn’t cover all topics.
  • Darpan Jha
    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.
  • Mitesh Purohit
    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.
  • Harish Reddy
    Tue, 27-Aug-2019
    Chetan Parekh
    Very nice and valuable tricks have been explained in this course.
  • Chetan  Parekh
    Thu, 29-Aug-2019
    Tejas Singh
    Very nice course!
  • Tejas Singh
    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.
  • Navin Naidu
    Wed, 11-Sep-2019
    Shauree Rastogi
    Overall great experience with this course.
  • Shauree Rastogi
    Fri, 13-Sep-2019
    Baloo Naran
    Those who want to upgrade their excel skill can go for it.
  • Baloo Naran
    Mon, 16-Sep-2019
    Kushit Malik
    Highly recommend!
  • Kushit Malik
    Mon, 16-Sep-2019
    Anthra Srivas
    Excellent course!
  • Anthra Srivas
    Mon, 16-Sep-2019
    Arundhti Krishan
    Good!
  • Arundhti Krishan
    Tue, 17-Sep-2019
    Aabhi Soni
    Excellent course with the hidden tricks.
  • Aabhi Soni
    Tue, 17-Sep-2019
    Abhyank Mishra
    Excellent course by the Imurgence.
  • Abhyank Mishra
    Tue, 17-Sep-2019
    Knika Jain
    Good and exhaustive content.
  • Knika Jain
    Wed, 18-Sep-2019
    Prutvi Gupta
    Brilliant excel tricks have been imparted through this course.
  • Prutvi Gupta
    Wed, 18-Sep-2019
    Harmil Das
    Overall good.
  • Harmil Das
    Thu, 19-Sep-2019
    Aakashdeep Chauhan
    This course has taught me many added excel features.
  • Aakashdeep Chauhan
    Thu, 19-Sep-2019
    Shaurya Batra
    Good presentation and voice, you will learn advance excel skills and get certificate after completing the course.
  • Shaurya Batra
    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.
  • Ishaan Shah
    Fri, 20-Sep-2019
    Sanjay Sachdev
    Excellent!
  • Sanjay Sachdev
    Fri, 20-Sep-2019
    Parth Modi
    Easy to learn and practice, but much is needed to become an expert.
  • Parth Modi
    Fri, 20-Sep-2019
    Shivansh Rao
    Up-gradation of the basics skills of excel is very important.
  • Shivansh Rao
    Fri, 20-Sep-2019
    Shusmita Kulkarni
    Good content!
  • Shusmita Kulkarni
    Tue, 07-Jan-2020
    Rajul Agarwal

free

EMI starts at 0/month for 0 months. View Plan >
Includes:
  • Self-Paced Training
  • 6:08:26 Hours Videos
  • 130 Lessons
  • Certification Course
  • All Levels