Master Specialization Training Program on Ms-Excel (Hindi)

Course Content

Beginner Level In Excel (Hindi)

Preview of Excel Program

18:45
MS Excel – Brief History and Advantages

07:02
Comparison of Various Versions of Excel (hn)

07:10
Front Look of Excel (hn)

04:39
Basic Concepts of Excel (hn)

02:03
Renaming of Worksheets in Excel

01:04
How to save and save as excel files (Hn)

02:19
How to Open Excel File (Hn)

01:11
How to rename and delete excel files (hn)

01:10
How to do cut copy and paste of excel file (Hn)

01:22
Excel Shortcuts (hn)

11:12
How to enter data in excel sheet (hn)

02:03
Cell reference and its usage (hn)

04:25
Absolute and relative cell reference in Excel (hn)

03:26
How to cut copy paste cell data in excel (hn)

02:03
How to transpose data in excel (hn)

02:14
How to use basic formula in excel (hn)

03:09
Sum and auto sum function in Excel (hn)

04:35
Count and average formula in Excel (hn)
Max and Min formula in excel (hn)

01:42
Round, Roundup and round down in Excel (hn)

03:16
green flag error in excel (hn)

02:57
Autofill function in excel (hn)

03:14
Basic Math Function (hn)

05:34
adding deleting rows and columns in excel (hn)

02:56
How to increase width and length of row and column in excel (hn)

02:19
How to hide and unhide row and column in excel (hn)

01:53
how to use percentage and decimal points in excel (hn)

01:47
How to make document presentable (font size, font type, bold, italic, Background color and font color)

02:55
How to use border and alignment in excel (hn)

03:17
How to add currency in excel (hn)

02:26
How to use format painter in excel (hn)

03:32
How to use cell styles in excel (hn)

02:48
How to use Wrap text in Excel (hn)

02:32
How to use merge and center in excel (hn)

02:13
Conditional Formatting Part 1 highlighting cells (hn)

04:13
Conditional Formatting part 2 Data Bars (hn)

02:24
Conditional Formatting part 3 (Color scales + icon sets (hn)

02:27
How to insert picture in excel (hn)

02:28
How to insert shapes in excel (hn)

02:49
How to make a bar or column charts

04:48
How to use chart elements (hn)

03:00
How to add or delete in charts (hn)

02:46
How to format graphs in excel (hn)

04:22
How to use chart filters and styles (hn)

02:33
How to cut copy paste graph in excel (hn)

03:39
How to make pie chart (hn)

04:53
How to make line graph in excel (hn)

02:54
How to make scatter plot (hn)

03:08
What is Excel Template (hn)

02:25
How to use existing template in excel (hn)

03:16
creating template in excel (hn)

03:53
how to check print preview(hn)

02:33
Understanding different options of printing in excel (hn)

04:30
How to use scaling in print option

02:24
How to setup margins in excel (hn)

02:39
Print titles in Excel (hn)

02:38
How to add Header and footer in excel (hn)

02:27
Print selection in excel (hn)

01:48
Quiz 1

Excel Intermediate level(Hindi)

Beginning of Intermediate module (hn)

02:39
How to make list and never make these two mistakes (hn)

04:38
simple sorting in excel (a to z or Z to A) hn

02:18
Multiple level sorting in excel (hn)

02:41
How to do custom sorting in excel (hn)

02:20
How to use find option in excel (hn)

01:55
How to use replace option in excel (hn)

01:53
HOW TO USE AUTO FILTER IN EXCEL (HN)

02:38
How to use subtotal in excel (hn)

03:23
how to identify duplicates in excel

02:31
removing duplicates in excel (hn)

02:43
Dsum function in excel (hn)

03:12
DSUM function with OR (hn)

02:04
Daverage and Dcount function in excel (hn)

02:56
Dmax and Dmin (hn)

01:37
using subtotal in excel (hn)

04:16
what is data validation in excel (hn)

03:02
Data validation in excel (drop down) (hn)

03:54
How to customize error message in data validation (hn)

03:36
How to import text files in excel (hn)

02:51
exporting data in text file (hn)

02:33
What is pivot tables and its purpose (hn)

02:33
Creating pivot tables in excel (hn)

05:14
modifying operations in power pivot (hn)

02:06
How to use filter in pivot table (hn)

02:31
How to get into details of pivot table data (hn)

02:18
using slide cutter in pivot tables (hn)

03:41
Why power pivot (hn)

01:18
How to activate power pivot in excel (hn)

01:18
adding and linking data sheets in power pivot (hn)

02:50
How to create power pivot (hn)

03:41
little math on power pivot (hn)

02:00
how to create KPI in power pivot (hn)

03:47
How to freeze or unfreeze headers in excel(hn)

01:58
Grouping ungrouping in excel (hn)

02:02
cell referencing for linking multiple sheets (hn)

02:34
use consolidate function in excel (hn)

03:06
Quiz Intermediate level

Ms-Excel Advance level(Hindi)

name ranges in excel (hn)

03:09
If function in excel (hn)

02:35
absolute referencing in if function (hn)

02:04
Name range with IF functions (hn)

02:18
AND function in Excel (hn)

03:58
Nested function in Excel (hn)

03:15
Count if function in excel (hn)

02:28
SUM IF function in excel (hn)

03:07
if error function in excel (hn)

03:14
vlookup function in excel (hn)

05:11
HLOOKUP FUNCTION IN EXCEL (HN)

02:59
Index function in excel (hn)

02:15
Match Function in Excel (hn)

02:12
index and match function combined in excel (hn)

02:46
problem with Vlookup (hn)

02:44
Reverse lookup with index match (hn)

02:53
left, right, mid function (hn)

04:21
TRIM function (hn)

01:36
Len function in excel (hn)

01:39
concat function in excel (hn)

01:29
Proper function in excel (hn)

01:08
Search Function in excel (hn)

03:31
Trace Precedents & Trace Dependents (hn)

03:47
Watch Window in Excel (Hn)

03:09
Auditing in Excel (hn)

02:29
Cell Protection in excel (hn)

03:32
protecting the workbook (hn)

01:52
Password protection in excel (hn)

02:08
Calculating EMI with PMT function (hn)

02:29
Goal Seek tool in excel (hn)

02:21
Solver Function in Excel (hn)

06:51
Using Data tables in Excel (hn)

02:33
Scenario Management in Excel (hn)

05:13
What is Macros in Excel (hn)

01:59
Activating Developer options in excel (hn)

00:59
How to record macro in excel (hn)

04:55
Creating Macros buttons in Excel (hn)

02:57
How to Execute Macro in excel (hn)

02:39
VBA editor window (hn)

03:14
Creating Modules and Procedures in VBA(en)

01:57
writing first code in VBA (hn)

01:49
creating variables in VBA (hn)

01:55
Conditional Statement in VBA (hn)

02:37
Loop function in VBA (hn)

02:54
Sorting in VBA Excel (hn)

04:30
Formatting through Input Box (hn)

03:43
Formatting code in VBA (hn)

01:51
linking formatting with input box (hn)

02:55
Error message in the VBA code (hn)

01:46
Running Macros on Multiple Sheets Part 1 (hn)

03:50
Running Macros on Multiple Sheets Part 2 (hn)

05:01
Creating, Designing and Formatting User Forms (hn)

07:53
Quiz 3

Student Ratings & Reviews

No Review Yet

Course Content

Beginner Level In Excel (Hindi)

Preview of Excel Program

MS Excel – Brief History and Advantages

Comparison of Various Versions of Excel (hn)

Front Look of Excel (hn)

Basic Concepts of Excel (hn)

Renaming of Worksheets in Excel

How to save and save as excel files (Hn)

How to Open Excel File (Hn)

How to rename and delete excel files (hn)

How to do cut copy and paste of excel file (Hn)

Excel Shortcuts (hn)

How to enter data in excel sheet (hn)

Cell reference and its usage (hn)

Absolute and relative cell reference in Excel (hn)

How to cut copy paste cell data in excel (hn)

How to transpose data in excel (hn)

How to use basic formula in excel (hn)

Sum and auto sum function in Excel (hn)

Count and average formula in Excel (hn)

Max and Min formula in excel (hn)

Round, Roundup and round down in Excel (hn)

green flag error in excel (hn)

Autofill function in excel (hn)

Basic Math Function (hn)

adding deleting rows and columns in excel (hn)

How to increase width and length of row and column in excel (hn)

How to hide and unhide row and column in excel (hn)

how to use percentage and decimal points in excel (hn)

How to make document presentable (font size, font type, bold, italic, Background color and font color)

How to use border and alignment in excel (hn)

How to add currency in excel (hn)

How to use format painter in excel (hn)

How to use cell styles in excel (hn)

How to use Wrap text in Excel (hn)

How to use merge and center in excel (hn)

Conditional Formatting Part 1 highlighting cells (hn)

Conditional Formatting part 2 Data Bars (hn)

Conditional Formatting part 3 (Color scales + icon sets (hn)

How to insert picture in excel (hn)

How to insert shapes in excel (hn)

How to make a bar or column charts

How to use chart elements (hn)

How to add or delete in charts (hn)

How to format graphs in excel (hn)

How to use chart filters and styles (hn)

How to cut copy paste graph in excel (hn)

How to make pie chart (hn)

How to make line graph in excel (hn)

How to make scatter plot (hn)

What is Excel Template (hn)

How to use existing template in excel (hn)

creating template in excel (hn)

how to check print preview(hn)

Understanding different options of printing in excel (hn)

How to use scaling in print option

How to setup margins in excel (hn)

Print titles in Excel (hn)

How to add Header and footer in excel (hn)

Print selection in excel (hn)

Quiz 1

Excel Intermediate level(Hindi)

Beginning of Intermediate module (hn)

How to make list and never make these two mistakes (hn)

simple sorting in excel (a to z or Z to A) hn

Multiple level sorting in excel (hn)

How to do custom sorting in excel (hn)

How to use find option in excel (hn)

How to use replace option in excel (hn)

HOW TO USE AUTO FILTER IN EXCEL (HN)

How to use subtotal in excel (hn)

how to identify duplicates in excel

removing duplicates in excel (hn)

Dsum function in excel (hn)

DSUM function with OR (hn)

Daverage and Dcount function in excel (hn)

Dmax and Dmin (hn)

using subtotal in excel (hn)

what is data validation in excel (hn)