Name: Excel 2010 Advance online Course in Hindi
Price: 499 INR
Rating: 5 (1 reviews)

90 Videos in HD
8 Hours Video Training
Language : Hindi
Practice files available for download
Full support from the Author

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 formulasalso 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.

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

Course Curriculum

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