Certificate Course in Excel

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

paid 5(21 Ratings) 91 Students Enrolled
Created By Imurgence Learning Last Updated Tue, 02-Apr-2019
+ 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
Six months from the date of 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
About The Instructor
  • 117 Reviews
  • 198 Students
  • 23 Courses
+ View More
A Data Science Training Company
Powered by Simple & Real Analytics
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.
2000 5000
Buy Now
Includes:
  • Self-Paced Training
  • 6:08:26 Hours Videos
  • 130 Lessons
  • Certification Course
  • All Levels