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
Student Ratings & Reviews
Thank you Sir.
i am very happy with this course
is tarha se sab ko educated karte rahe
aap acha sikhate ho
I am very happy with your services
this is very usefull