Excel 2010 Basic to Advance in Hindi by Veer Tutorial
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
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 Basic to Advance in Hindi by Veer Tutorial to your Wishlist.

Add to Wishlist

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
Created by Veer Tutorial
Last updated 9/2015
Hindi
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • You need basic level of understanding of computers. That's all you need to know before start our 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

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 88 Lectures Collapse All 88 Lectures 07:58:46
+
Introduction
4 Lectures 41:07

Move Action
12:21

Data Autofil in Cell
15:46

Numbers Customs Format
08:50
+
Text
14 Lectures 43:20

Special Symbols
01:50

String Identical
01:47

Join Text
02:48


Remove Space
01:49

Count Charactors
01:22

Padding A Number
04:10

Change Case
01:41

Extract Charctor
05:31


Ordinal Numbering
08:04

First word Extract
02:50

Extract String Except First Word
03:26
+
Date Related Functions / Formulas
15 Lectures 56:50
Introduction of Dates in Excel
07:58


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


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
+
TIME
5 Lectures 16:01
Display Time
05:25

How to Sum of Hours
02:25

Number of Hours
02:16


Rounding of Time Values
02:42
+
Count
5 Lectures 20:15
Basic of Count formulas
06:06

Formula countif
03:47

Mode
03:22

Countif Text
02:36

+
Sum, Sumif, Sumifs
3 Lectures 25:58
Fomula - Sum
06:34

Fomula - Sumif
11:21

Fomula - SumIfs
08:03
+
Lookup
8 Lectures 36:09
VLookup
06:15


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
+
Table
4 Lectures 26:02
Fill in the Gaps
04:31


Database Function
07:33

Sub Total
04:57
+
Financial Formulas
14 Lectures 01:39:53
Present Value of Money
08:10

Present Value of Lum sum Money
02:19

Annuity with Lum Sum
03:41


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


Depriciation
09:42
+
Logical Formula
1 Lecture 11:57
Logical Formula
11:57
6 More Sections
About the Instructor
Veer Tutorial
3.9 Average rating
95 Reviews
769 Students
12 Courses
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.