Excel 2010 Basic to Advance in Hindi by Veer Tutorial
5.0 (1 rating)
9 students enrolled
Wishlisted 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)
9 students enrolled
Created by Veer Tutorial
Last updated 9/2015
Hindi
Current price: \$10 Original price: \$20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 8 hours on-demand video
• 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.

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
Compare to Other Microsoft Courses
Curriculum For This Course
88 Lectures
07:58:46
+
Introduction
4 Lectures 41:07
Preview 04:10

Move Action
12:21

Data Autofil in Cell
15:46

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

Special Symbols
01:50

String Identical
01:47

Join Text
02:48

Preview 03:05

Remove Space
01:49

Count Charactors
01:22

04:10

Change Case
01:41

Extract Charctor
05:31

Preview 02:44

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

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

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

How to Sum of Hours
02:25

Number of Hours
02:16

Preview 03:13

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

Preview 04:24
+
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

Preview 02:39

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

Preview 09:01

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

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

04:54

Preview 04:07

Depriciation
09:42
+
Logical Formula
1 Lecture 11:57
Logical Formula
11:57
6 More Sections