<<--Back

Microsoft Excel - Complete Guide

Get lifetime access to this complete course on Excel specially curated by advanced corporate trainers. Our practice workbooks combined with our quality makes us stand out.

Beginner 5(7 Ratings) 54 Students enrolled
Created by Finladder Last updated Thu, 18-Jun-2020 English
What will i learn?

Curriculum for this course
45 Lessons 07:49:21 Hours
Introduction to our Program
4 Lessons 00:48:29 Hours
  • Opening Excel 00:02:28
  • Workscreen 00:11:48
  • Essentials Part 1 00:20:56
  • Essentials part 2 00:13:17
  • Print Area 00:03:47
  • Paste Special 00:14:03
  • Filter and Sort 00:08:56
  • Custom Formatting 00:11:20
  • Conditional Formatting 1 00:08:04
  • Conditional Formatting 2 00:03:57
  • Sum, Sumif, Sumifs 00:13:48
  • Count, Countif, Countifs 00:07:53
  • Average, Averageif 00:02:49
  • Max, Min 00:01:32
  • Large, Small 00:07:42
  • Round Function 00:11:38
  • IF, OR, AND 00:26:10
  • IF Error 00:05:44
  • Sum Product 00:03:41
  • Sub Total 00:05:50
  • CAGR - Compounded Annual Growth Rate 00:03:37
  • Freezing 00:16:02
  • V lookup, H lookup 00:20:01
  • Match 00:03:48
  • Lookups with Match 00:13:50
  • Data Validation 00:12:29
  • Lookups Continued 00:14:43
  • Index Function 00:06:29
  • Index with Match (Imp for Financial Modelling) 00:15:55
  • Text Function 00:17:06
  • Choose Function 00:08:59
  • Developer Tab 00:08:24
  • Grouping and Ungrouping 00:06:22
  • Texts to Columns 00:08:28
  • Date Functions 1 00:15:50
  • Date Functions 2 00:12:49
  • Column Charts 00:29:33
  • Area and Line Charts 00:12:30
  • Doughnut and Pie Chart 00:10:36
  • Pivot Table 00:16:28
  • Protection 00:15:21
  • Formula Auditing 00:06:44
  • Practice Workbook
Requirements
+ View more
Description
+ View more
Other related courses
13:25:34 Hours
Updated Tue, 15-Sep-2020
5 487 INR4000
10:18:06 Hours
5 1145 INR2000
07:24:09 Hours
Updated Sun, 06-Sep-2020
5 14 INR7000
05:37:21 Hours
Updated Sun, 06-Sep-2020
0 18 INR3999
08:57:12 Hours
Updated Thu, 24-Sep-2020
0 7 INR5000
09:57:30 Hours
Updated Sun, 06-Sep-2020
0 7 INR3000 INR2000
23:28:43 Hours
Updated Thu, 24-Sep-2020
0 4 INR2500
About the instructor
  • 111 Reviews
  • 1656 Students
  • 9 Courses
+ View more
Name
Biography
Student feedback
5
Average rating
  • 14%
  • 0%
  • 0%
  • 0%
  • 85%
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
  • Sun, 02-Aug-2020
    Joy Christo
INR990
Buy now
Includes:
  • 07:49:21 Hours On demand videos
  • 45 Lessons
  • Full lifetime access
  • Access on mobile and tv