Microsoft Excel in Hindi: Basic to Super Advanced (updated)
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
14 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel in Hindi: Basic to Super Advanced (updated) to your Wishlist.

Add to Wishlist

Microsoft Excel in Hindi: Basic to Super Advanced (updated)

Learn Beginner to Advanced tricks on VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, Text formulas and more in Hindi
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
14 students enrolled
Last updated 9/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.)
View Curriculum
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 is the target audience?
  • Course is purely focussed on helping you achieve Ninja level status for Excel functions
  • Student must know Hindi Language to understand this course
Compare to Other Excel Courses
Curriculum For This Course
88 Lectures
05:35:35
+
Beginner level
34 Lectures 01:40:14

Find Maximum value
02:10

Find Average value
02:28

COUNTBLANK() - Count the no. of blank cells
02:44


Writing a simple logical statement (True/False)
05:14

Writing a simple logical statement (True/False)
03:08

Status Bar - Easily see average, count, min, max or sum
01:43

Basic data formatting tricks
03:24

AutoFill - Automatically write Dates, Months, Years
03:11


Sort Data - Largest to Smallest (descending order)
03:05

Sort Data - A to Z (alphabetically)
01:51

Sort Date - Dates (oldest to newest)
02:04

Sort by Color
01:49

Filtering Data & Calculating Sum
03:13

Filtering Data correctly
01:54

How to ignore hidden values of a filtered data while computing Sum, Average
04:48

Filtering rows with values more than 10,000
03:26

Remove Duplicates from a list
03:39

Create a Drop Down list
03:29

Remove a Drop Down list
01:59

Freeze Panes - for easy reading
04:43

Format Painter - Copy & Paste cell format
02:37

Formatting Trick - for lengthy table headings
02:39

Create a hyperlink to another worksheet
02:15


TRIM
01:58


MROUND Basics 01
04:05

Why is number stored as Text in Excel
03:06

VALUE
03:09

LEN
01:42

LEFT, RIGHT, MID
04:09
+
Intermediate level
30 Lectures 02:10:59
Flash Fill - Intelligent Data Cleaning
03:01

VLOOKUP() - Basics Part 1 of 5
06:53

VLOOKUP() - Basics Part 2 of 5
05:41

VLOOKUP() - Basics Part 3 of 5
07:25

VLOOKUP() - Basics Part 4 of 5
05:39

VLOOKUP() - Basics Part 5 of 5
05:52

Debtors Ageing Analysis using VLOOKUP()
06:31

Score Grading using VLOOKUP()
05:14

Food Grading using VLOOKUP()
04:00

Using correct Service Tax rate using VLOOKUP()
05:32

Interworksheet VLOOKUP()
08:31

VLOOKUP vs HLOOKUP
04:16

Basics of 2 logical functions - AND(), OR()
04:26

IF() and Nested IF()
06:45

COUNTIF() Basics 01 - Criteria based cell counting
04:01

SUMIF() Basics 01 - Adding numbers based on criteria
04:36

AVERAGEIF() Basics 01 - Finding Average using criteria
03:45

SUMPRODUCT() for total cost calculation
03:48

Calculating Year on Year % Growth
03:14

Add Serial No. column before Sorting
02:17

2 level Sorting
02:25

SUBTOTAL() function - a Mystery solved
04:47

Using Format Painter continuously
03:00

Color multiple sheet tabs together
01:37

Conditional Formatting - Basics 01
04:19

Conditional Formatting - Basics 02
03:07

Adding leading zeroes to incomplete Cheque Nos.
03:22

Calculating Fixed Deposit maturity amount - 1
02:20

Calculating Fixed Deposit maturity amount - 2
03:08

Formatting Trick to write x3
01:27
+
Advanced level
20 Lectures 01:24:41
Delete Error Cells using Go To Special
02:38

Excel Super Shortcut: Ctrl + Enter
02:02

Fill intermittent Blank Cells
05:07

MATCH() counts position no. - Example 1
05:07

MATCH() counts position no. - Example 2
04:25

Using VLOOKUP with MATCH for 2d lookup Example 1
06:32

Using VLOOKUP with MATCH for 2d lookup Example 2
05:25

Using VLOOKUP with MATCH for 2d lookup Example 3
07:50

Using VLOOKUP with MATCH for 2d lookup Example 4
06:47

ROUNDUP() & ROUNDDOWN() Basics 02 - Round off numbers
02:30

ROUND() Basics 03 - Practical Applications
02:03

ROUND() Trick for Excel Superstars
05:26

SUBSTITUTE() to replace characters
02:59

Activate Developer Tab in 2007-2016
03:10

Dashboard trick - Create a Spin Button
04:28

Dashboard trick - Create a Scroll Bar
03:37

Create a hyperlinked shape (with Shortcut)
02:40

Horizontal Sort - Re arrange columns easily
04:35

Add a blank row after every data row
03:18

Sort Data as per your own Custom list
04:02
+
God mode
4 Lectures 19:41
Hide a Sheet so that no one can easily unhide
03:53

CONFIDENTIAL: Remove "Protect Sheet" Password with Notepad
07:18

CONFIDENTIAL: Remove "Protect Workbbook" Password with Notepad
05:01

Making a text magically invisible
03:29
About the Instructor
Yoda Learning
4.4 Average rating
1,607 Reviews
37,161 Students
50 Courses
MS OFFICE & PMP | Join 40K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.2 Average rating
566 Reviews
9,891 Students
31 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.