<<--Back

Microsoft Excel - Complete Guide

Get lifetime access to this complete course on Excel along with practice workbooks. Instructors - 1. Ishaan Arora, FRM,FMVA (Grant Thornton) 2. Murrad Beigh, FRM

Beginner 5(8 Ratings) 82 Students enrolled
Created by Finladder Last updated Sat, 31-Oct-2020 English
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
  • 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
  • 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
Requirements
+ View more
Description
+ View more
Other related courses
13:25:34 Hours
Updated Tue, 15-Sep-2020
5 553 INR4000
10:24:50 Hours
5 1315 INR2000
05:37:21 Hours
Updated Sun, 06-Sep-2020
0 19 INR3999
09:17:50 Hours
Updated Sun, 27-Sep-2020
0 7 INR5000
09:57:30 Hours
Updated Sun, 06-Sep-2020
0 7 INR3000 INR2000
02:39:44 Hours
Updated Wed, 07-Oct-2020
0 12 INR2500
14:00:29 Hours
Updated Mon, 23-Nov-2020
0 27 INR18000
06:49:27 Hours
0 8 INR4000
About the instructor
  • 124 Reviews
  • 1915 Students
  • 11 Courses
+ View more
Name
Biography
Student feedback
5
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
Reviews
  • Thu, 02-Apr-2020
    Pranav Shastry
  • Thu, 30-Apr-2020
    Ashish
  • Thu, 18-Jun-2020
    manas
  • Sun, 05-Jul-2020
    Vatsal lunawat
    I 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-2020
    Aniket Rana
  • Wed, 15-Jul-2020
    Akash
  • Sat, 07-Nov-2020
    Joy Christo
  • Sun, 04-Oct-2020
    Prachee
    It was am amazing experience to learn Excel advance course from efinladder..
INR599
Buy now
Includes:
  • 04:57:03 Hours On demand videos
  • 46 Lessons
  • Full lifetime access
  • Access on mobile and tv