Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Microsoft Advanced Excel in Hindi | Top Excel Tricks
Rating: 4.6 out of 5(33 ratings)
115 students

Learn Microsoft Advanced Excel in Hindi | Top Excel Tricks

Learn Beginner to Advanced tricks on VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, Text formulas and more in Hindi
Last updated 5/2020
Hindi

What you'll learn

  • Learn Beginner to Advanced tricks on Excel Formulas in Hindi
  • Get Downloadable Case Studies + Picture based eBook [mapped to the Lectures]
  • Get Course Completion Certificate
  • Learn from the Pro - a Professional Corporate Trainer (PwC, EY, RBS, Tata Group, XLRI etc.)

Course content

4 sections88 lectures5h 35m total length
  • AutoSum - Add up Numbers1:38
  • Find Maximum value2:10
  • Find Average value2:28
  • COUNTBLANK() - Count the no. of blank cells2:44
  • COUNT() & COUNTA() - Count the no. of non-blank cells1:59
  • Writing a simple logical statement (True/False)5:14
  • Writing a simple logical statement (True/False)3:08
  • Status Bar - Easily see average, count, min, max or sum1:43
  • Basic data formatting tricks3:24
  • AutoFill - Automatically write Dates, Months, Years3:11
  • AutoFill - Automatically create Serial Number list + 2 tricks4:31
  • Sort Data - Largest to Smallest (descending order)3:05
  • Sort Data - A to Z (alphabetically)1:51
  • Sort Date - Dates (oldest to newest)2:04
  • Sort by Color1:49
  • Filtering Data & Calculating Sum3:13
  • Filtering Data correctly1:54
  • How to ignore hidden values of a filtered data while computing Sum, Average4:48
  • Filtering rows with values more than 10,0003:26
  • Remove Duplicates from a list3:39
  • Create a Drop Down list3:29
  • Remove a Drop Down list1:59
  • Freeze Panes - for easy reading4:43
  • Format Painter - Copy & Paste cell format2:37
  • Formatting Trick - for lengthy table headings2:39
  • Create a hyperlink to another worksheet2:15
  • UPPER, LOWER, PROPER2:55
  • TRIM1:58
  • ROUND() Round off numbers - 013:29
  • MROUND Basics 014:05
  • Why is number stored as Text in Excel3:06
  • VALUE3:09
  • LEN1:42
  • LEFT, RIGHT, MID4:09

Requirements

  • Pre-requisite: Basic knowledge of Excel
  • Course works on all Excel versions 2010 & 2013

Description

"Microsoft Excel for Professionals" is a comprehensive online training program. It is divided in 3 Levels and covers exhaustive list of topics. There are 18 tutorial videos and the duration is 1.5 hrs. Topics often ignored in other intermediate/advanced online programs have been included. Watch Demo Preview Lectures to find the difference.

  • VLOOKUP() with MATCH()
  • HLOOKUP() with MATCH()
  • INDEX() with multiple arrays & two MATCH()
  • SUMIF() vs. SUMIFS()
  • SUM() vs. SUBTOTAL() while using Filter
  • Hidden Text-to-Columns tricks
  • Applications of INDIRECT() and OFFSET()
  • Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings
  • Power of "GO TO - Special" along with Ctrl+Enter
  • Using "Find and Replace" with wildcard characters
  • Combo techniques for Data cleaning
  • Formula-based Conditional formatting
  • Inserting Picture in Comments... and the list of such tricks is very long


Instructor:
 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 Chartered Accountant
  • Has worked with KPMG and J.P. Morgan
  • Has trained 5,500+ professionals (Apr 2010 - June 2014) in face-to-face training programs
  • Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction

And by the way he has conducted more than 100 (hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program.

-------------------------------------------------------------------------------------------------------------------

"The courses are really helpful whether in terms of saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda" by Arundhati Raychaudhuri, Finance Professional, India

-------------------------------------------------------------------------------------------------------------------

Important information before you join:

  • It's in HINDI language
  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice - over worksheets included for immediate practice
  • Access to all videos 24 x 7 - learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied) 

-----------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 1.5 hrs. for a benefit of lifetime Ninja status on Microsoft Excel!

Who this course is for:

  • Course is purely focused on helping you achieve Ninja level status for Excel functions
  • Student must know Hindi Language to understand this course