Name: MS Excel Basic to Advance Online Course in Hindi
Price: 499 INR
Rating: 5 (1 reviews)

Learn Excel Complete Full Online Training Course in Hindi
130 Videos in HD
13 Hours Video Training
Language : Hindi
Practice files available for download
Full support from the Author

Learn MS Excel Advance Online Course Complete Training Program in Hindi.

Course Description

Learn Excel in hindi with lots of examples and practical assignments. We have designed this course to everybody’s real life work situations. This course will start with general understandings of Excel and finish with the depth knowledge of each formulas which used in our daily life.

Excel is the excellent software developed by the Microsoft. Excel it used to do data analysis, simple & complex calculates, data modeling, MIS reporting. There are hundred of task we do in the excel. It is widely used in each office in daily routine work.

Keeping above all facts in mind. We designed this course that start from the basic level i.e. introduction of excel, it’s interface, tab, menu, enabling functionality. Then we will move step by step learning Excel’s functions with practical examples & queries.

We will cover below topics of Excel : –

Text
Date & Time
Lookup, Vlookup, Hlookup
Table
Database
Financial
Array
Pivot Table
Form Design
Named Functions
Insert Images
Security
Macro
VBA

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.

You will get VBA code and method for converting numbers in to words in Excel. 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

Advance Excel, Excel Training, Learn Excel Online, Advance Excel Course, Excel Courses, Excel online Courses, Excel Course online free, excel training, excel classes near me, Advance Excel Training, ms excel basics,

Course Curriculum

Introduction of Excel 2016
	Excel Learning Practice Files		00:00:00
	Excel file types	FREE	00:04:00
	Selection and Move of Data	FREE	00:12:28
	User Interface of Excel 2016	FREE	00:10:43
	Alignment	FREE	00:09:20
	Cut copy and paste		00:03:13
	Formatting in excel 2016		00:07:56
Form Design in Excel
	Form Design in Excel 2016 Basic Level		00:09:42
	Form Design in Excel 2016 Advance Level		00:05:55
Essential Things to Learn about Excel
	Data Types in Excel		00:04:48
	Special Character in excel		00:07:37
	Autofil List in Excel		00:06:47
	Mini Tool Bar		00:11:32
	Table Format Cell Style		00:04:04
	Insert Delete Row and Column in Excel		00:02:22
	Format Cell Hide Unhide Row and Column		00:01:55
	Move Worksheet in Excel		00:03:34
	Find Search option in Excel		00:05:55
	Find and Replace in Excel		00:02:38
	View Tab Freeze Unfreeze Split and Arrange Excel		00:07:46
	Page Setup Print in Excel		00:16:15
Introduction of Formulas and Function
	Introduction of Formula and Functions in Excel		00:04:19
	Cell References in Excel		00:06:56
	Inbuilt Functions Sum		00:05:54
	Error Handling in Functions		00:04:51
	Circular References		00:02:52
	Goal Seek in Excel		00:04:06
	Value Paste in Excel		00:01:56
Naming Concept in Excel
	Concept of Name in Excel		00:03:48
	Name Manager in Excel		00:02:49
	Use Name in Formula		00:02:26
	Retrieve Value from other worksheet using name		00:02:04
	Scope of Name		00:04:47
	Concept of Inter Section in Excel Advance Level		00:04:47
Text Function in Excel
	Determine Cell Value is Text or Note		00:03:46
	Insert Symbols in Excel		00:02:20
	Cell Values are Identical or Note		00:02:33
	Concatenate for Join Text		00:05:48
	Display Text in Well Format		00:03:35
	Remove Unwanted Space from Text		00:03:12
	Len Function Get Length of String		00:01:59
	Padding Numbers		00:04:57
	Change Case of Text to Lower Upper Proper		00:01:18
	Extract Text from String		00:07:05
	Remove Trailing Minus Sign from String		00:05:36
	Ordinal Number		00:02:42
	Extract First Word from String		00:03:27
	Extract everything except first word from String		00:02:57
Date Function In Excel
	Display Date		00:05:36
	Date Autofill		00:05:40
	Convert Text to Date		00:04:07
	Calculate Days between two Dates		00:03:24
	Networkdays		00:02:48
	Networkdays.Intl		00:03:34
	Workdays		00:02:17
	Convert Date into String		00:02:47
Time Related Function in Excel
	Time Display in Excel		00:08:35
	Calculate Sum of Hours		00:03:41
	Calculate Time Involve Midnight working		00:03:38
	Convert Time		00:04:03
	Roundup Time Values		00:02:45
Play with Images in Excel
	Insert Image		00:05:18
	Insert Shapes		00:04:21
	Edit and Formatting of Shapes		00:12:36
	Take Screen Shots direct in Excel		00:02:49
	Smart Art in Excel		00:08:31
Pivot Table
	Introduction of Pivot Table		00:02:22
	Create First Pivot Table		00:13:15
	What’s Next in Pivot Table		00:03:16
	Change Data Format in Pivot Table		00:02:08
	Calculation in Pivot Table		00:08:48
	Formatting in Pivot Table – Part 1		00:05:28
	Formatting in Pivot Table – Part 2		00:02:10
	Analysis Tab of Pivot Table		00:05:00
	Recommended Format of Pivot Table		00:01:58
	Slicer		00:01:51
	Calculated Fields		00:02:29
	Grouping		00:03:02
	Extract Data		00:01:43
	Pivot Chart		00:03:51
Count Functions
	Basic of Count Function		00:05:58
	CountIFS Function		00:03:37
	Mode Function		00:03:12
	CountIF Text Function		00:02:26
Data Validation
	11.1 Data Validation in Excel		00:08:09
	Drop Down List Feature in Excel		00:02:49
Financial Function
	12.1 Present Value of Money		00:09:30
	12.2 Present Value of Lum Sum Money		00:02:09
	12.3 Annuity with Lum Sum Amount		00:03:21
	12.4 Future Value of Money		00:08:50
	12.5 PMT Function		00:09:23
	12.6 Rate Calculation		00:13:00
	12.7 NPER		00:08:23
	12.8 Deferred Payment		00:05:08
	12.9 Bond Pricing		00:06:17
	12.10 NPV Part 1		00:07:10
	12.11 NPV Part 2		00:04:04
	12.12 NPV Part 2		00:04:04
	12.13 Internal Rate of Return		00:03:57
	12.14 Depriciation		00:09:37
Logical Functions
	13.1 Logical Operator		00:11:42
Lookup Functions
	14.1 Vlookup		00:06:00
	14.2 Hlookup		00:02:39
	14.3 Vlookup Advance		00:02:57
	14.4 Vlookup with IF Function		00:02:57
	14.5 Vlookup with ifError		00:03:14
Security Feature in Excel
	15.1 Security Feature in Excel – Part 1		00:04:02
	15.2 Security Feature in Excel – Part 2		00:04:02
Sum Function
	16.1 Sum Function – Part 1		00:06:24
	16.2 Sum Function – Part 2		00:11:11
	16.3 Sum Function – Part 3		00:07:53
Advance Features of Excel
	17.1 Tables Part 1		00:21:22
	17.2 Advance Trick of Excel		00:04:21
	17.3 Advance Filter Technique in Excel		00:08:51
	17.4 Database Function		00:08:51
	17.5 Sub Total in Excel		00:04:47
Macro and VBA
	18.1 Recording Macro		00:06:22
	18.2 Edit Recorded Macro		00:04:47
	18.3 Assign Macro to Button		00:02:33
	18.4 VBA Project 2		00:14:12
	18.5 VBA Project 3		00:09:19
	18.6 VBA Project 4		00:10:32
	18.7 VBA Project 5		00:13:56