+91 8053074185     admin@veertutorial.com

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

Course Reviews

5

5
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 1,500.00 499.00
  • UNLIMITED ACCESS
  • Course Certificate
  • Wishlist
34 STUDENTS ENROLLED

Advanced Course Search Widget

Recent Posts

All right reserved VeerTutorial