About Course

Microsoft Excel

Microsoft Excel is a software program produced by Microsoft that allows users to organize, format, and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite.

MS Excel Full Course

The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This specialization uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts.

Course Content

MS Excel Basic to Advanced

Lecture 1 MS Excel Basic Introduction

13:19
Lecture 2 Excel Common Functions and Formulas in Hindi

13:58
Lecture 3 How to Protect Excel Workbook and Worksheet with the help of Password

10:17
Lecture 4 How to Make Password Protected Excel File

06:17
Lecture 5 How to use Freez Panes Function in Excel in Hindi

08:12
Lecture 6 Personalizing the Enviroment Using Backstage

13:28
Lecture 7 Printing Configuration in Excel in Hindi

08:35
Lecture 8 Conditional Formatting in Excel in HIndi (Part-1)

10:18
Lecture 9 Conditional Formatiing in Excel in Hindi (Part-2)

09:05
Lecture 10 Conditional Formatting in Excel in Hindi (Part-3)

09:00
Lecture 11 Conditional Formatiing in Excel Min and Max Value (Part-4)

10:22
Lecture 12 Conditional Formatting in Excel in Hindi (Part-5)

11:19
Lecture 13 Data Validation in Excel How to Create Drop Down List In Excel in Hindi

12:11
Lecture 14 How toUuse IF Function in Excel in Hindi

07:46
Lecture 15 How to Use Nested If Function in Excel in Hindi

09:50
Lecture 16 How to Create Bill Using IF Function in Excel in Hindi

12:27
Lecture 17 How to Use AND Function in Excel in Hindi

07:41
Lecture 18 How to Use OR Function in Excel in Hindi

07:49
Lecture 19 How to Use IF With AND Function in Excel In Hindi

09:37
Lecture 20 How to Use SUMIF Function in Excel in Hindi

07:11
Lecture 21 How to Use MAX and MIN Function in Excel

07:12
Lecture 22 How to Use MAX with INDIRECT Function in Excel

07:30
Lecture 23 How to Use MIN with INDIRECT Function in Excel in Hindi

07:36
Lecture 24 How to Use RIGHT and LEFT Function in Excel in Hindi

05:42
Lecture 25 How to Use MID Function in Excel in Hindi

06:08
Lecture 26 How to Use CONCATENATE Function in Excel in Hindi

04:47
Lecture 27 How to Use ROW and ROWS Function in Excel

05:35
Lecture 28 How to Use COLUMN and COLUMNS Function in Excel

05:33
Lecture 29 How to Use DATE, DAY, MONTH, YEAR Function in Excel in Hindi

07:25
Lecture 30 How to Use TIME, HOUR, MINUTE, SECOND Function in Excel in Hindi

07:12
Lecture 31 How to Use NOW and DAYS360 Function in Excel in Hindi

05:35
Lecture 32 How to Use HYPERLINK Funtion in Excel

08:27
Lecture 33 How to Use Conditional Formatting in Excel in Hindi

06:55
Lecture 34 How to Use Conditional Formatting in Excel in Hindi

07:14
Lecture 35 How to Use DSUM Function in Excel in Hindi

09:01
Lecture 36 How to Use DGET Function in Excel in Hindi

08:29
Lecture 37 How to Use DMAX Function in Excel

06:42
Lecture 38 How to Use DMAX Function in Excel in Hindi Part 2

06:33
Lecture 39 How to Use DMIN Function in Excel in Hindi

06:18
Lecture 40 How to use DMIN Function in Excel in Hindi

05:46
Lecture 41 How to Use Count, CountA, CountBlank, Countif Function in Excel

10:26
Lecture 42 How to Use REPLACE Funtion in Excel in Hindi

07:41
Lecture 43 How to Use Find Function in Excel in Hindi

07:29
Lecture 44 How to Use CHOOSE Function in Excel in Hindi

06:31
Lecture 45 How to Use LEN Function in Excel in Hindi

04:16
Lecture 46 How to Use ISODD Funtion in Excel in Hindi

05:56
Lecture 47 How to Use CONVERT Funtion in Excel in Hindi

07:22
Lecture 48 How to Use ISEVEN Funtion in Excel in Hindi

05:01
Lecture 49 How to Use ISTEXT Funtion in Excel in Hindi

04:56
Lecture 50 How to Use ISNUMBER FUntion in Excel in Hindi

05:14
Lecture 51 How to Use ISBLANK Funtion in Excel in Hindi

03:47
Lecture 52 How to Use TRIM Funtion in Excel in Hindi

05:28
Lecture 53 How to Use SUBSTITUTE Funtion in Excel in Hindi

06:03
Lecture 54 How to Use MATCH Function in Excel in Hindi

07:14
Lecture 55 How to Use MATCH Funtion in Excel in Hindi

07:35
Lecture 56 How to Use INDEX Funtion in Excel in Hindi

05:50
Lecture 57 How to Use INDEX with MATCH Function in Excel in Hindi

06:05
Lecture 58 How to Use INDEX with MATCH Function in Excel

05:41
Lecture 59 How to Use INDEX with MATCH Funtion in Excel

05:31
Lecture 60 How to Use INDEX with MATCH Funtion in Excel

09:01
Lecture 61 How to Use ISERR Funtion in Excel

03:58
Lecture 62 How to Use IFERROR Funtion in Excel

04:28
Lecture 63 How to Use LOOKUP Value in Excel

05:51
Lecture 64 How to Use VLOOKUP Funtion in Excel in Hindi

06:52
Lecture 65 Advanced Filter in MS Excel in Hindi

12:50
Lecture 66 How to Use Slip Function in Advanced Way

07:20
Lecture 67 Advanced Conditional Formatting in Excel in HIndi (Part-1)

09:01
Lecture 68 Advanced Conditional Formatting in Excel in Hindi (Part-2)

12:52
Lecture 69 Advanced Conditional Formatting in Excel in Hindi (Part-3)

13:32
Lecture 70 Advanced Conditional Formatting in Excel in Hindi (Part-4)

09:59
Lecture 71 Employee Time Management System in Excel

17:50
Lecture 72 How to Remove Duplicate Text & Value in Excel

08:29
Lecture 73 How to Change Excel File Icon Every Excel User Must Know

05:22
Lecture 74 How to Combine Excel Files Into One Excel File

09:55
Lecture 75 How to Convert Excel all Sheets to PDF Without any Converter

10:23
Lecture 76 How to Create Checklist in Excel in Hindi

09:11
Lecture 77 How to Create Password for Excel File

07:43
Lecture 78 How to Reconcile Your Data in Excel

14:33
Lecture 79 How to Extract Number from Text in Excel

06:16
Lecture 79 How to Extract Number from Text in Excel

06:16
Lecture 80 How to Hide and Unhide Sheets in Excel with VBA Button

14:15
Lecture 81 How to Insert Pictures in Excel Sheet

09:33
Lecture 82 How to Make Password Protected Excel Sheet

07:56
Lecture 83 How to Save Excel File Automatically

06:17
Lecture 84 How to Set Advanced Password in Excel

08:40
Lecture 85 How to Show Large Data into Small View in Excel

13:34
Lecture 86 How to Split Full Name to First Name, Mid Name and Last Name in Excel

09:00
Lecture 87 How to Use Choose Function in Excel

12:20
Lecture 88 Excel Data Tab Complete Video in Hindi

01:04:22
Lecture 89 How to Create Automatic Excel Reports Using Macro

11:58
Lecture 90 How to Create Dashboard in Excel Part-1

16:55
Lecture 91 How to Create Advance Dashboard in Excel Part-2

22:09
Lecture 92 How to Create Dashboard in Excel Using Macro Part-3

21:56
Lecture 93 How to Disable Copy Paste in Excel

06:55
Lecture 94 How to Remove Special characters & Symbols From Text Data in Excel

06:27
Lecture 95 How to use Advanced Filter Using Macro in Excel

16:23
Lecture 96 How to Use Advanced Macro in Excel Part-1

22:56
Lecture 97 How to Use Advanced Macro in Excel Part-2

11:32
Lecture 98 Advanced Conditional Formatting in Excel

08:45
Lecture 99 How to Convert Zero into Blank Cell

12:08
Lecture 100 Top 5 Excel Tips and Tricks Part-1

10:39
Lecture 101 How to Create Seat Booking Sheet in Excel

13:23
Lecture 102 How to Create presentation in Excel

14:20
Lecture 103 How to Create Advanced Chart in Excel

19:38
Lecture 104 How to Autofil Cell in Excel With VBA Code

12:09
Lecture 105 How to Create Multiple Sheet Useing Pivot Table in Excel

07:51
Lecture 106 How to Use VBA in Excel Part-1

10:01
Lecture 107 How to Use VBA in Excel Part-2

10:52
Lecture 108 How to Use VBA in Excel Part-3

08:01
Lecture 109 How to Use VBA in Excel Part-4

07:51
Lecture 110 Excel ‘Printing Configuration Setting

13:51
Lecture 111 How to Combine Date & Number in Excel

06:06
Lecture 112 How to Display Number in Thousand & Millions

11:13
Lecture 113 How to Use Predication Function in Excel

08:55
Lecture 114 Excel Tips and Tricks Part-1

08:41
Lecture 115 Excel Tips and Tricks Part-2

11:56
Lecture 116 Excel Tips and Tricks Part-3

09:15
Lecture 117 Excel Tips and Tricks Part-4

07:18
Lecture 118 Excel Tips and Tricks Part-5

10:05
Lecture 119 Excel Tips and Tricks Part-6

06:04
Lecture 120 Excel Tips and Tricks Part-7

09:40
Lecture 121 Excel Tips and Tricks Part-8

08:34
Lecture 122 Excel Tips and Tricks Part-9

09:34
Lecture 123 Excel Tips and Tricks Part-10

09:07
Lecture 124 Excel Tips and Tricks Part-11

15:26
Lecture 125 Excel Tips and Tricks Part-12

06:33
Lecture 126 Excel Tips and Tricks Part-13

09:32
Lecture 127 How to Create Advance Dashboard in Excel

22:09
Lecture 128 How to Create Basic Checklist in Excel

10:10
Lecture 129 How to Create Advanced Checklist in Excel

08:55
Lecture 130 How to Insert Pictures in Excel Sheet

09:33
Lecture 131 How to Do Data Entry Work in Excel

10:12
Lecture 132 How to Create Salary Payslip in Excel

11:17
Lecture 133 How to Create Attendance Sheet in Excel Part-1

18:28
Lecture 134 How to Use VLOOKUP in Excel in Hindi

06:43
Lecture 135 Vlookup with Match Function in Excel

10:04
Lecture 136 How to Use Pivot Table in Excel

05:57
Lecture 137 How to Add Multiple Password in Single Excel Sheet

06:53
Lecture 138 How to Use Advanced Choose Function in Excel

06:19
Lecture 139 How to Recover Excel File

03:54
Lecture 140 How to Compare Two Month Sales in Excel

06:32
Lecture 141 How to Create Multiple DropDown List in Excel

07:00
Lecture 141 How to Create Multiple DropDown List in Excel

07:00
Lecture 142 How to Use Custome View in Excel

06:58
Lecture 143 How to Create Search Box in Excel

08:10
Lecture 144 How to Create Your Own Tab in Excel

06:35
Lecture 145 How to Use Subtotal Function in Excel

05:42
Lecture 146 Top 10 Excel Most Useful Shortcuts Keys

07:44
Lecture 147 Sales Anaysis in Excel in Hindi

07:32

About Course

Microsoft Excel

MS Excel Full Course

What Will You Learn?

Course Content

MS Excel Basic to Advanced

Lecture 1 MS Excel Basic Introduction

Lecture 2 Excel Common Functions and Formulas in Hindi

Lecture 3 How to Protect Excel Workbook and Worksheet with the help of Password

Lecture 4 How to Make Password Protected Excel File

Lecture 5 How to use Freez Panes Function in Excel in Hindi

Lecture 6 Personalizing the Enviroment Using Backstage

Lecture 7 Printing Configuration in Excel in Hindi

Lecture 8 Conditional Formatting in Excel in HIndi (Part-1)

Lecture 9 Conditional Formatiing in Excel in Hindi (Part-2)

Lecture 10 Conditional Formatting in Excel in Hindi (Part-3)

Lecture 11 Conditional Formatiing in Excel Min and Max Value (Part-4)

Lecture 12 Conditional Formatting in Excel in Hindi (Part-5)

Lecture 13 Data Validation in Excel How to Create Drop Down List In Excel in Hindi

Lecture 14 How toUuse IF Function in Excel in Hindi

Lecture 15 How to Use Nested If Function in Excel in Hindi

Lecture 16 How to Create Bill Using IF Function in Excel in Hindi

Lecture 17 How to Use AND Function in Excel in Hindi

Lecture 18 How to Use OR Function in Excel in Hindi

Lecture 19 How to Use IF With AND Function in Excel In Hindi

Lecture 20 How to Use SUMIF Function in Excel in Hindi

Lecture 21 How to Use MAX and MIN Function in Excel

Lecture 22 How to Use MAX with INDIRECT Function in Excel

Lecture 23 How to Use MIN with INDIRECT Function in Excel in Hindi

Lecture 24 How to Use RIGHT and LEFT Function in Excel in Hindi

Lecture 25 How to Use MID Function in Excel in Hindi

Lecture 26 How to Use CONCATENATE Function in Excel in Hindi

Lecture 27 How to Use ROW and ROWS Function in Excel

Lecture 28 How to Use COLUMN and COLUMNS Function in Excel

Lecture 29 How to Use DATE, DAY, MONTH, YEAR Function in Excel in Hindi

Lecture 30 How to Use TIME, HOUR, MINUTE, SECOND Function in Excel in Hindi

Lecture 31 How to Use NOW and DAYS360 Function in Excel in Hindi

Lecture 32 How to Use HYPERLINK Funtion in Excel

Lecture 33 How to Use Conditional Formatting in Excel in Hindi

Lecture 34 How to Use Conditional Formatting in Excel in Hindi

Lecture 35 How to Use DSUM Function in Excel in Hindi

Lecture 36 How to Use DGET Function in Excel in Hindi

Lecture 37 How to Use DMAX Function in Excel

Lecture 38 How to Use DMAX Function in Excel in Hindi Part 2

Lecture 39 How to Use DMIN Function in Excel in Hindi

Lecture 40 How to use DMIN Function in Excel in Hindi

Lecture 41 How to Use Count, CountA, CountBlank, Countif Function in Excel

Lecture 42 How to Use REPLACE Funtion in Excel in Hindi

Lecture 43 How to Use Find Function in Excel in Hindi

Lecture 44 How to Use CHOOSE Function in Excel in Hindi

Lecture 45 How to Use LEN Function in Excel in Hindi

Lecture 46 How to Use ISODD Funtion in Excel in Hindi

Lecture 47 How to Use CONVERT Funtion in Excel in Hindi

Lecture 48 How to Use ISEVEN Funtion in Excel in Hindi

Lecture 49 How to Use ISTEXT Funtion in Excel in Hindi

Lecture 50 How to Use ISNUMBER FUntion in Excel in Hindi

Lecture 51 How to Use ISBLANK Funtion in Excel in Hindi

Lecture 52 How to Use TRIM Funtion in Excel in Hindi

Lecture 53 How to Use SUBSTITUTE Funtion in Excel in Hindi

Lecture 54 How to Use MATCH Function in Excel in Hindi

Lecture 55 How to Use MATCH Funtion in Excel in Hindi

Lecture 56 How to Use INDEX Funtion in Excel in Hindi

Lecture 57 How to Use INDEX with MATCH Function in Excel in Hindi

Lecture 58 How to Use INDEX with MATCH Function in Excel

Lecture 59 How to Use INDEX with MATCH Funtion in Excel

Lecture 60 How to Use INDEX with MATCH Funtion in Excel

Lecture 61 How to Use ISERR Funtion in Excel

Lecture 62 How to Use IFERROR Funtion in Excel

Lecture 63 How to Use LOOKUP Value in Excel

Lecture 64 How to Use VLOOKUP Funtion in Excel in Hindi

Lecture 65 Advanced Filter in MS Excel in Hindi

Lecture 66 How to Use Slip Function in Advanced Way

Lecture 67 Advanced Conditional Formatting in Excel in HIndi (Part-1)

Lecture 68 Advanced Conditional Formatting in Excel in Hindi (Part-2)

Lecture 69 Advanced Conditional Formatting in Excel in Hindi (Part-3)

Lecture 70 Advanced Conditional Formatting in Excel in Hindi (Part-4)

Lecture 71 Employee Time Management System in Excel

Lecture 72 How to Remove Duplicate Text & Value in Excel

Lecture 73 How to Change Excel File Icon Every Excel User Must Know

Lecture 74 How to Combine Excel Files Into One Excel File