MS Excel Basic to Advance 2024

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.

Excel Tutorial & Training Details

Project-based tutorials– 

• This means that you won’t be wasting time on the theory behind spreadsheet development, you will be able to jump right in and learn how to build practical worksheets.

Comprehensive series –

• Whether you are a beginning level student or you have been using Excel for years, this course offers a full suite of tutorials that can supply you with tools that will help you in your job immediately.

Experienced instructor –

• The instructor for this course, Vky Malik, has been teaching users all over the Industries how to design, manage and improve Excel worksheets for the past years, and in this course, you will get access to a wealth of knowledge!

What we offer:

• Well-designed and easy-to-understand materials
• Detailed explanations with comprehensible case studies based on real situations
• Downloadable course materials
• Regular course updates
• NEW! Includes professional chart examples that are
• Unlimited access to all course materials
• Certificate After Completion of Training

Course Requirements or Prerequisites?

• Basic accounting knowledge
• Be able to operate a PC. That’s all.

• Excel users who have basic skills but want to get really, REALLY good
• This online course is suitable for anyone who wants to learn Excel. 
• Anyone hoping to expand their analytics skillset
• Whether you are a business professional, student, teacher, freelancer, or solopreneur, this training can benefit you and help you take your Excel skills to the next level
• Anyone looking to pursue a career in data analysis or business intelligenc

In this Course, You Will Learn:

• • Video 1: MS Excel Basic Introduction
  • Video 2: Excel Common Functions and Formulas in Hindi
  • Video 3: How to Protect Excel Workbook with Password
  • Video 4: How to Make Password Protected Excel File
  • Video 5: How to use Freez Panes Function in Excel in Hindi
  • Video 6: Personalizing the Environment Using Backstage
  • Video 7: Printing Configuration in Excel in Hindi
  • Video 8:  Conditional Formatting in Excel in Hindi (Part-1)
  • Video 9: Conditional Formatting in Excel in Hindi (Part-2)
  • Video 10: Conditional Formatting in Excel in Hindi (Part-3)
  • Video 11: Conditional Formatting in Excel Min and Max Value (Part-4)
  • Video 12: Conditional Formatting in Excel in Hindi (Part-5)
  • Video 13: Data Validation in Excel How to Create Drop-Down List
  • Video 14: How to use IF Function in Excel in Hindi
  • Video 15: How to Use Nested If Function in Excel in Hindi
  • Video 16: How to Create Bill Using IF Function in Excel in Hindi
  • Video 17: How to Use AND Function in Excel in Hindi
  • Video 18: How to Use OR Function in Excel in Hindi
  • Video 19: How to Use IF With AND Function in Excel In Hindi
  • Video 20: How to Use SUMIF Function in Excel in Hindi
  • Video 21: How to Use MAX and MIN Function in Excel
  • Video 22: How to Use MAX with INDIRECT Function in Excel
  • Video 23: How to Use MIN with INDIRECT Function in Excel in Hindi
  • Video 24: How to Use RIGHT and LEFT Function in Excel in Hindi
  • Video 25: How to Use MID Function in Excel in Hindi
  • Video 26: How to Use CONCATENATE Function in Excel in Hindi
  • Video 27: How to Use ROW and ROWS Function in Excel
  • Video 28: How to Use COLUMN and COLUMNS Function in Excel
  • Video 29: How to Use DATE, DAY, MONTH, YEAR Function in Excel 
  • Video 30: How to Use TIME, HOUR, MINUTE, SECOND Function
  • Video 31: How to Use NOW and DAYS360 Function in Excel in Hindi
  • Video 32: How to Use HYPERLINK Function in Excel
  • Video 33: How to Use Conditional Formatting in Excel in Hindi
  • Video 34: How to Use Conditional Formatting in Excel in Hindi
  • Video 35: How to Use DSUM Function in Excel in Hindi
  • Video 36: How to Use DGET Function in Excel in Hindi
  • Video 37: How to Use DMAX Function in Excel
  • Video 38: How to Use DMAX Function in Excel in Hindi Part 2
  • Video 39: How to Use DMIN Function in Excel in Hindi
  • Video 40: How to use DMIN Function in Excel in Hindi
  • Video 41: How to Use Count, CountA, CountBlank, Countif Function
  • Video 42: How to Use REPLACE Function in Excel in Hindi
  • Video 43: How to Use Find Function in Excel in Hindi
  • Video 44: How to Use CHOOSE Function in Excel in Hindi
  • Video 45: How to Use LEN Function in Excel in Hindi
  • Video 46: How to Use ISODD Function in Excel in Hindi
  • Video 47: How to Use CONVERT Function in Excel in Hindi
  • Video 48: How to Use ISEVEN Function in Excel in Hindi
  • Video 49: How to Use ISTEXT Function in Excel in Hindi
  • Video 50: How to Use ISNUMBER function in Excel in Hindi

• • Video 51: How to Use ISBLANK Function in Excel in Hindi
  • Video 52: How to Use TRIM Function in Excel in Hindi
  • Video 53: How to Use SUBSTITUTE Function in Excel in Hindi
  • Video 54: How to Use MATCH Function in Excel in Hindi
  • Video 55: How to Use MATCH Function in Excel in Hindi
  • Video 56: How to Use INDEX Function in Excel in Hindi
  • Video 57: How to Use INDEX with MATCH Function in Excel in Hindi
  • Video 58: How to Use INDEX with MATCH Function in Excel
  • Video 59: How to Use INDEX with MATCH Function in Excel
  • Video 60: How to Use INDEX with MATCH Function in Excel
  • Video 61: How to Use ISERR Function in Excel
  • Video 62: How to Use IFERROR Function in Excel
  • Video 63: How to Use LOOKUP Value in Excel
  • Video 64: How to Use VLOOKUP Function in Excel in Hindi
  • Video 65 Advanced Filter in MS Excel in Hindi
  • Video 66 How to Use Slip Function in Advanced Way
  • Video 67 Advanced Conditional Formatting in Excel (Part-1)
  • Video 68 Advanced Conditional Formatting in Excel (Part-2)
  • Video 69 Advanced Conditional Formatting in Excel (Part-3)
  • Video 70 Advanced Conditional Formatting in Excel (Part-4)
  • Video 71 Employee Time Management System in Excel
  • Video 72 How to Remove Duplicate Text & Value in Excel
  • Video 73 How to Change Excel File Icon Every
  • Video 74 How to Combine Excel Files Into One Excel File
  • Video 75 How to Convert Excel all Sheets to PDF Without Software
  • Video 76 How to Create Checklist in Excel in Hindi
  • Video 77 How to Create Password for Excel File
  • Video 78 How to Reconcile Your Data in Excel
  • Video 79 How to Extract Number from Text in Excel
  • Video 80 How to Hide and Unhide Sheets in Excel with VBA Button
  • Video 81 How to Insert Pictures in Excel Sheet
  • Video 82 How to Make Password Protected Excel Sheet
  • Video 83 How to Save Excel File Automatically
  • Video 84 How to Set Advanced Password in Excel
  • Video 85 How to Show Large Data into Small View in Excel
  • Video 86 How to Split Full Name to First, Mid, Last Name
  • Video 87 How to Use Choose Function in Excel
  • Video 88 Excel Data Tab Complete Video in Hindi
  • Video 89 How to Create Automatic Excel Reports Using Macro
  • Video 90 How to Create Dashboard in Excel Part-1
  • Video 91 How to Create Advance Dashboard in Excel Part-2
  • Video 92 How to Create Dashboard in Excel Using Macro Part-3
  • Video 93 How to Disable Copy Paste in Excel
  • Video 94 How to Remove Special Characters & Symbols 
  • Video 95 How to use Advanced Filter Using Macro in Excel
  • Video 96 How to Use Advanced Macro in Excel Part-1
  • Video 97 How to Use Advanced Macro in Excel Part-2
  • Video 98 Advanced Conditional Formatting in Excel
  • Video 99 How to Convert Zero into Blank Cell
  • Video 100 Top 5 Excel Tips and Tricks Part-1

• Video 101 How to Create Seat Booking Sheet in Excel
• Video 102 How to Create Presentation in Excel
• Video 103 How to Create Advanced Chart in Excel
• Video 104 How to Autofil Cell in Excel With VBA Code
• Video 105 How to Create Multiple Sheet Using Pivot Table in Excel
• Video 106 How to Use VBA in Excel Part-1
• Video 107 How to Use VBA in Excel Part-2
• Video 108 How to Use VBA in Excel Part-3
• Video 109 How to Use VBA in Excel Part-4
• Video 100 Excel ‘Printing Configuration Setting
• Video 111 How to Combine Date & Number in Excel
• Video 112 How to Display Number in Thousand & Millions
• Video 113 How to Use Prediction Function in Excel
• Video 114 Excel Tips and Tricks Part-1
• Video 115 Excel Tips and Tricks Part-2
• Video 116 Excel Tips and Tricks Part-3
• Video 117 Excel Tips and Tricks Part-4
• Video 118 Excel Tips and Tricks Part-5
• Video 119 Excel Tips and Tricks Part-6
• Video 120 Excel Tips and Tricks Part-7
• Video 121 Excel Tips and Tricks Part-8
• Video 122 Excel Tips and Tricks Part-9
• Video 123 Excel Tips and Tricks Part-10
• Video 124 Excel Tips and Tricks Part-11
• Video 125 Excel Tips and Tricks Part-12
• Video 126 Excel Tips and Tricks Part-13
• Video 127 How to Create Advance Dashboard in Excel
• Video 128 How to Create Basic Checklist in Excel
• Video 129 How to Create Advanced Checklist in Excel
• Video 130 How to Insert Pictures in Excel Sheet
• Video 131 How to Do Data Entry Work in Excel 
• Video 132 How to Create Salary Payslip in Excel
• Video 133 How to Create Attendance Sheet in Excel Part-1
• Video 134 How to Use VLOOKUP in Excel in Hindi
• Video 135 Vlookup with Match Function in Excel
• Video 136 How to Use Pivot Table in Excel 
• Video 137 How to Add Multiple Password in Single Excel Sheet
• Video 138 How to Use Advanced Choose Function in Excel
• Video 139 How to Recover Excel File
• Video 140 How to Compare Two Month Sales in Excel
• Video 141 How to Create Multiple Dropdown List in Excel
• Video 142 How to Use Custome View in Excel
• Video 143 How to Create Search Box in Excel
• Video 144 How to Create Your Own Tab in Excel
• Video 145 How to Use Subtotal Function in Excel
• Video 146 Top 10 Excel Most Useful Shortcuts Keys
• Video 147 Sales Analysis in Excel in Hindi
•