× Successfully! Added to wish list

Learn Microsoft Excel : Basic to Super Advanced

By: Rishabh Bhandari

  • 5
  • (14)
  • 12:46:08
  • 90
  • 51
  • Language: English

Course Summary

This  12+ hrs of course is taught by CA. Rishabh Pugalia, Founder, Excel Next.

So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -

  • Is a qualified&nb

Read More

Target Audience

If you have to use excel in 

  • Data analytics
  • Finance Audits & CAAT
  • Consulting
  • Investment banking
  • MIS Reporting

This course is for you.

Pre-Requisites

  • No Prerequired skills, anybody intreated in excel or data can take this course
  • Micorsoft excel for practicing

Curriculum

  • Introduction
    05:53
  • Downloadable excel files for practice
  • Reference Material in PDF
  • Warm-up I: Key Shortcuts
    10:07
  • Warm-up II: Essential formulas & application tricks
    13:55
  • Warm-up II: Essential formulas & application tricks-2
    12:26
  • Warm-up II: Essential formulas & application tricks-3
    01:53
  • Formatting Tricks
    11:33
  • Formatting Tricks-2
    07:49
  • Formatting Tricks-3
    06:54
  • Formatting Tricks-4
    11:10
  • Multi-level Sort & Custom Sort; Color Sorting
    10:53
  • Filter & SUBTOTAL formula
    17:05
  • Advanced Filter
    09:28
  • Advanced Filter-2
    05:04
  • Cell Referencing ($)
    03:23
  • Cell Referencing ($) - 2
    05:39
  • Cell Referencing ($) - 3
    04:22
  • Cell Referencing ($) - 4
    04:34
  • Cell Referencing ($) - 5
    02:49
  • Dates – Concepts
    10:14
  • Dates – Concepts -2
    17:44
  • Dates – Concepts -3
    10:13
  • Dashboards
    19:31
  • Dashboards-2
    07:18
  • Dashboards-3
    05:32
  • VLookup & HLookup
    05:49
  • VLookup & HLookup - 2
    06:46
  • VLookup & HLookup - 3
    10:38
  • VLookup & HLookup - 4
    10:42
  • VLookup & HLookup - 5
    03:29
  • 2-way Lookup – VLOOKUP with MATCH
    12:44
  • 2-way Lookup – VLOOKUP with MATCH - Part 2
    05:31
  • 2-way Lookup – VLOOKUP with MATCH - Part 3
    05:59
  • 2-way Lookup – HLOOKUP with MATCH
    07:42
  • SUMIFS, COUNTIFS, Remove Duplicates
    05:33
  • SUMIFS, COUNTIFS, Remove Duplicates - 2
    15:12
  • SUMIFS, COUNTIFS, Remove Duplicates - 3
    06:43
  • Data Validation II (Numbers, Dates, Text length)
    10:24
  • Reverse 2-way Lookup – INDEX with MATCH
    14:56
  • Reverse 2-way Lookup – INDEX with MATCH - 2
    03:35
  • Reverse 2-way Lookup – INDEX with MATCH-3
    05:26
  • Pivot Table – Applications with % Computation, Grouping
    13:25
  • Pivot Table – Applications with % Computation, Grouping - 2
    06:44
  • Pivot Table – Applications with % Computation, Grouping-3
    13:36
  • Pivot Table – Applications with % Computation, Grouping - 4
    11:56
  • Subtotal
    13:58
  • Subtotal - 2
    07:14
  • Subtotal - 3
    07:01
  • Joining data strings using CONCATENATE
    11:30
  • Text to Columns – Applications, Tricks
    06:01
  • Text to Columns – Applications, Tricks - 2
    06:33
  • Text to Columns – Applications, Tricks - 3
    04:08
  • Find & Replace – Advanced
    10:15
  • Text Formulas I
    13:02
  • Text Formulas II
    10:40
  • Text Formulas II - Part-2
    05:48
  • Text Formulas III – REPLACE, SUBSTITUTE
    07:14
  • Logical formulas - Part - 1
    06:48
  • Logical formulas - Part - 2
    09:01
  • Logical formulas - Part - 3
    09:30
  • Logical formulas - Part - 4
    09:01
  • Conditional Formatting I (Blanks, Errors, Values, Duplicates)
    10:51
  • Conditional Formatting II (Formula-based)
    11:38
  • Conditional Formatting III (Data Bars, Color Scales, Icon Sets)
    06:53
  • What IF Analysis – Scenario Managers
    07:00
  • What IF Analysis – Goal Seek
    08:12
  • What IF Analysis – Data Tables
    12:28
  • What IF Analysis – Using Form Control Buttons
    08:19
  • Tables
    05:09
  • 3-D Data Consolidation from same/different Workbooks
    07:52
  • 3-D Data Consolidation from same/different Workbooks- 2
    08:12
  • Formula Auditing techniques
    07:32
  • File Security & password Protection
    06:57
  • File Security & password Protection - 2
    07:50
  • Printing
    17:18
  • Comments
    08:36
  • Split Windows, Viewing multiple Windows
    05:03
  • Hyperlinking
    04:56
  • Charts – Basic Concepts
    08:13
  • Basic Charts – Bar, Column, Pie
    05:45
  • Special Charts: Thermometer Charts
    06:07
  • Special Charts: Multi-axis charts
    06:57
  • Special Charts: Exploded Pie charts
    07:22
  • Chart tips-n-tricks
    06:42
  • Chart tips-n-tricks - 2
    05:54
  • Macros – Overview, Developer tab, Settings
    10:40
  • Macros – Recording, Running; Using Buttons to run Macros
    10:23
  • Bonus Topic - INDIRECT()
    08:12
  • Bonus Topic - OFFSET()
    15:09

About the Author

Rishabh Bhandari,

Yodalearning.com is focused on teaching professional courses to people across the world for professional development and business growth. We offer courses on MS Office tools like Excel, PowerPoint, Word, Outlook, Access, VBA, SQL and other areas like Data analysis using Python programming language.

More From Author

Reviews

Anurag Pant
5

This is one comprehensive course I learned on excel. The tutor explained each concept clearly with examples.

Shardul Shandilya
5

Excellent!! Very nicely explained. The content is too good and the price at which it is being offered is simply outstanding. looking forward to take some other courses as well.

Learn Microsoft Excel : Basic to Super Advanced

  • 12:46:08
  • 90
  • 51
  • Language: English
  • 15 days Money back Gurantee
  • Unlimited Access
  • Android, iPhone and iPad Access
  • Certificate of Completion

Course Summary

This  12+ hrs of course is taught by CA. Rishabh Pugalia, Founder, Excel Next.

So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -

  • Is a qualified&nb

Read More

Target Audience

If you have to use excel in 

  • Data analytics
  • Finance Audits & CAAT
  • Consulting
  • Investment banking
  • MIS Reporting

This course is for you.

Pre-Requisites

If you have to use excel in 

  • Data analytics
  • Finance Audits & CAAT
  • Consulting
  • Investment banking
  • MIS Reporting

This course is for you.

About the Author

Rishabh Bhandari,

Yodalearning.com is focused on teaching professional courses to people across the world for professional development and business growth. We offer courses on MS Office tools like Excel, PowerPoint, Word, Outlook, Access, VBA, SQL and other areas like Data analysis using Python programming language.

More From Author

Review & Rating

Anurag Pant 5

This is one comprehensive course I learned on excel. The tutor explained each concept clearly with examples.

Shardul Shandilya 5

Excellent!! Very nicely explained. The content is too good and the price at which it is being offered is simply outstanding. looking forward to take some other courses as well.