What will i learn?
Curriculum for this course
46 Lessons
04:59:03 Hours
Introduction to our Program
4 Lessons
00:32:13 Hours
- Introduction to the Course 00:04:04
- Workscreen 00:05:40
- Essentials Part 1 00:14:02
- Excel Essentials 2 00:08:27
Basic to Intermediate Excel
20 Lessons
02:04:42 Hours
- Print Area 00:03:13
- Paste Special 00:08:26
- Filter 00:05:34
- Sort 00:04:27
- Custom Formatting 00:11:17
- Conditional Formatting 1 00:05:10
- Conditional Formatting 2 00:03:59
- Sum, Sumif, Sumifs 00:08:46
- Count, Countif, Countifs 00:07:10
- Average, Averageif 00:02:56
- Max, Min 00:01:37
- Large, Small 00:03:49
- Round Function 00:08:45
- IF Function 00:14:56
- OR Function 00:07:00
- IF Error 00:05:44
- Sum Product 00:03:41
- Sub Total 00:04:21
- CAGR - Compounded Annual Growth Rate 00:04:14
- Freezing 00:09:37
Advanced Excel
19 Lessons
02:14:14 Hours
- Lookups 00:10:42
- Match Function 00:05:45
- Lookups with Match 00:06:41
- Data Validation 00:06:05
- Lookups Continued 00:03:01
- Index Function 00:03:02
- Index with Match (Imp for Financial Modelling) 00:02:53
- Text Function 00:10:39
- Choose Function 00:05:46
- Developer Tab 00:05:16
- Grouping and Ungrouping 00:05:30
- Texts to Columns 00:03:59
- Date Functions 1 00:09:06
- Date Functions 2 00:08:19
- Charts - Column and Types 00:08:11
- Charts - 2 00:12:30
- Pivot Table 00:11:57
- Protection 00:10:55
- Formula Auditing 00:03:57
Practice Workbook
1 Lessons
00:00:00 Hours
- Practice Workbook
Requirements
+ View more
Description
+ View more
Other related courses
06:49:27 Hours
Updated Fri, 20-Nov-2020
17
INR4000
03:34:26 Hours
Updated Fri, 19-Mar-2021
1
INR1000
INR99
About the instructor
- 235 Reviews
- 3936 Students
- 15 Courses
Student feedback
Reviews
-
Thu, 02-Apr-2020Pranav Shastry
-
Thu, 30-Apr-2020Ashish
-
Thu, 18-Jun-2020manas
-
Sun, 05-Jul-2020Vatsal lunawatI completed Microsoft advance excel course provided by Finladder. I believe learning courses from here is 'The Best'. Way of Explanation is really fantastic and workbooks are also provided for application of the concepts.
-
Tue, 14-Jul-2020Aniket Rana
-
Wed, 15-Jul-2020Akash
-
Sat, 07-Nov-2020Joy Christo
-
Sun, 04-Oct-2020PracheeIt was am amazing experience to learn Excel advance course from efinladder..
-
Sat, 03-Apr-2021Japsimran
-
Wed, 07-Apr-2021Amisha Jain
-
Wed, 07-Apr-2021Varun JainGood
-
Wed, 21-Apr-2021Sushil Kumavat -
Mon, 10-May-2021Nikhil Chaurasia
-
Thu, 27-May-2021NimishThe best course!! I was looking for. You should definitely charged more for it. The most awesome things you are sharing is tricks and shortcuts here which no one tells about.
-
Sun, 30-May-2021Ayush Rewatkar
-
Tue, 01-Jun-2021Shrishti Baranwal
-
Thu, 08-Jul-2021Aakriti Agarwalgood ,, and interesting , knowledgable course
-
Sun, 06-Jun-2021Sahil
-
Tue, 08-Jun-2021Mansi Dodiya
-
Wed, 09-Jun-2021SejalIt was wonderful learning.I really learned a lot from this course.I definitely got more efficient in using excel. -
Wed, 09-Jun-2021Shivendra
-
Sat, 19-Jun-2021Muskan
-
Wed, 23-Jun-2021AryaGreat learning experience
-
Tue, 13-Jul-2021Aditi
-
Sun, 25-Jul-2021Nivedha MohanThis course was really helpful to understand the basic functions of excel
-
Mon, 26-Jul-2021VaibhavAmazing and well design course