Learn Tally ERP 9 with GST video training complete course
Learn Tally ERP 9 Accounting Software from basic to advance level with real...
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 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 : –
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.
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,
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 |
No Reviews found for this course.