What will i learn?
Curriculum for this course
46 Lessons
04:57:03 Hours
Introduction to our Program
4 Lessons
00:30:13 Hours
- Introduction to the Course 00:03:06
- Workscreen 00:04:38
- 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
8
INR4000
About the instructor
- 139 Reviews
- 2297 Students
- 12 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..