Excel 2010 Basic to Advance in Hindi by Veer Tutorial

Learn all option or formulas with real time examples and become expert in all fields of excel 2010
5.0 (1 rating) 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.
8 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 88
  • Length 8 hours
  • Skill Level All Levels
  • Languages Hindi
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 Hindi

Course Description

We have designed this course to everybody's real life work situations. This course will start with general understandings of Excel 2010 and finish with the depth knowledge of each formulas which used in our daily life.

You will get all excel files used to create this course in which we have explained the syntax of formulas also include real life problems. We have also included advance use of each formula such as Vlookup formula used if iferror formula.

Advance use of Tables, Macros, Pivot Tables, Filtering etc.

You will get VBA code and method for converting numbers in to words in Excel 2010. This formula is not included in excel formulas but we explained all the procedures to do this task.

you will get more than your expectation that we can bet.

See List of content for more information of our course

What are the requirements?

  • You need basic level of understanding of computers. That's all you need to know before start our course

What am I going to get from this course?

  • You will be able to do complex calculations / Formats / Data Analysis including all things which you are not able right now. This course start from basic level but at the end you will be expert in the Excel

What is the target audience?

  • Whether you are fresher or working person and want to improve your skills in the excel to develop yourself. This course is for you. We included real time situation and calculation problems in the examples for easy learning

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction of Excel 2010
Preview
04:10
Move Action
12:21
Data Autofil in Cell
15:46
Numbers Customs Format
08:50
Section 2: Text
Cell Contain Text
Preview
02:13
Special Symbols
01:50
String Identical
01:47
Join Text
02:48
Format Text Values
Preview
03:05
Remove Space
01:49
Count Charactors
01:22
Padding A Number
04:10
Change Case
01:41
Extract Charctor
05:31
Remove Trailing Minus sign
Preview
02:44
Ordinal Numbering
08:04
First word Extract
02:50
Extract String Except First Word
03:26
Section 3: Date Related Functions / Formulas
Introduction of Dates in Excel
07:58
Date Autofil Tips and Formulas
Preview
06:14
Convert Non Date String to Date
02:57
Calculate Number of Days between two dates
02:17
Calculate Number of Working Days between two dates
03:34
Date Formulas
03:00
Date Value Formula
06:20
Network Days Formula
02:57
Working Days between Two Dates - Advance Verision
Preview
06:26
Offsetting a Date using only work Days
03:50
Number of years between two dates
02:54
Calculate Age of any person
02:17
Calculate Days Remain in a year
02:26
Weekday Determination
02:06
Calculate last Day of the month
01:34
Section 4: TIME
Display Time
05:25
How to Sum of Hours
02:25
Number of Hours
02:16
Converting Decimal Hours, Minutes, Seconds into Time
Preview
03:13
Rounding of Time Values
02:42
Section 5: Count
Basic of Count formulas
06:06
Formula countif
03:47
Mode
03:22
Countif Text
02:36
Examples of Count
Preview
04:24
Section 6: Sum, Sumif, Sumifs
Fomula - Sum
06:34
Fomula - Sumif
11:21
Fomula - SumIfs
08:03
Section 7: Lookup
VLookup
06:15
HLookup
Preview
02:39
Advance - Vlookup
03:07
Use of Vlookup with If
03:56
Use of Vlookup with Iferror Function
03:24
Vlookup Exmaple - 1
03:05
Vlookup Exmaple - 2
07:38
Vlookup Exmaple - 3
06:05
Section 8: Table
Fill in the Gaps
04:31
Advance Filter
Preview
09:01
Database Function
07:33
Sub Total
04:57
Section 9: Financial Formulas
Present Value of Money
08:10
Present Value of Lum sum Money
02:19
Annuity with Lum Sum
03:41
Future Value of Money
Preview
09:08
PMT Function
09:34
Rate
13:14
NPER
09:38
Defferred Payment
05:23
Price Bond
06:29
NPV : Part-1
07:20
NPV : Part-2
06:14
NPV - Advance Version
04:54
Internal Rate of Return
Preview
04:07
Depriciation
09:42
Section 10: Logical Formula
Logical Formula
11:57
Section 11: Macros
Marco part-1
12:45
Marco part-2
Preview
05:03
Section 12: Security in Excel
Security in Excel - Part 1
04:12
Security in Excel - Part 2
03:56
Section 13: Pivot Table
Pivot Table - Part 1
09:27
Pivot Table - Part 2
01:37
Pivot Table - Part 3
Preview
02:48
Pivot Table - Part 4
03:24
Section 14: Data Validation
Data Validation Feature
08:19
List Feature
02:59
Section 15: Page Setup
Page Setup Header Footer
06:49
Page Setup
Preview
10:22

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Veer Tutorial, Ultimate Destination for All Computer Course

Veer Tutorial is an Indian company having high quality of computer related courses. We teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course