Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel 365 in Hindi - Basic to Advanced Level
Rating: 3.9 out of 5(8 ratings)
27 students

Microsoft Excel 365 in Hindi - Basic to Advanced Level

Excel Basic to Advance. Excel Formatting, Excel Functions, Excel Charts, Excel Pivot Table.. (2016, 2019 & Excel 365)
Created byHimanshu Dhar
Last updated 6/2025
Hindi

What you'll learn

  • Basic to Advance Level Excel in the latest Office 365
  • Mastering the use of Text Functions, Math Functions, Logical Functions, Lookup & Reference Functions, Date and Time Functions
  • Mastering the use of Pivot Table and Power Pivot
  • Mastering the use of Chart Preparation
  • Mastering the use of What If Analysis Tools
  • Mastering the use of Data Organizing Tools
  • Mastering the use Record Macro Feature

Course content

1 section • 83 lectures • 11h 33m total length

  • Excel Introduction - New File and Title Bar9:08

    Download the practice files from Resource option

  • Customize Ribbon & Quick Access Toolbar8:16
  • Understanding Excel Structure and Worksheets Properties10:47
  • How to do Data Entry and Formatting Effectively14:15
  • Fill Series Options in Excel11:22
  • Flash Fill Option in Excel3:13
  • Understanding Cell Reference5:57
  • How to Use Math Operators in Excel15:47
  • Basic Math Functions in Excel17:17
  • Advance Level Math Function in Excel17:10
  • Database Math Functions in Excel8:44
  • IF Function in Excel7:38
  • Understanding Nesting IF Methodology4:44
  • IF Function Related Project Solution8:42
  • IF Function - Project Task1:07
  • IF Project - Task Solution4:44
  • IFS Function4:57
  • AND & OR Function in Excel6:07
  • XOR Function in Excel4:34
  • Filter Option in Excel15:08
  • Date and Color Filter4:45
  • Advanced Filter Option in Excel6:57
  • Sort and Custom Sort in Excel4:37
  • Conditional Formatting - Learn How to Apply6:11
  • Types of Rules in Conditional Formatting11:56
  • Manage Rules in Conditional Formatting4:52
  • UPPER, LOWER, PROPER & TRIM Function8:28
  • LEFT, RIGHT & FIND Function7:18
  • Find Function Task Solution6:21
  • Nesting LEFT, RIGHT & FIND Function3:53
  • MID Function in Excel4:17
  • CONCATENATE Function4:25
  • CONCATENATE Function Project Task Solution2:40
  • CONCAT and TEXTJOIN Function4:20
  • REPLACE Function in Excel7:15
  • REPLACE Function Project Solution1:55
  • SUBSTITUTE Function in Excel4:30
  • REPT, LEN Function and Project2:23
  • Project Task Solution2:35
  • NUMBERVALUE Function in Excel3:24
  • Text to Column14:28
  • Practice Test - Mastering Text in Excel
  • Chart Preparation - Getting Started with Elements16:30
  • Designing and Format Chart14:23
  • Chart Customization - 1st Part3:50
  • Chart Customization - 2nd Part5:29
  • Pie Chart in Excel12:25
  • Quick Analysis & Chart Recommendation4:05
  • Power Map in Excel5:11
  • Pivot Table in Excel - Complete Guide53:52
  • Power Pivot - Most Powerful Analysis Tool29:57
  • PDURATION Function in Excel2:33
  • PMT Function - Create EMI Calculator6:13
  • What if Analysis - Data Table11:45
  • What if Analysis - Goal Seek5:45
  • Solver Plugin in Excel4:52
  • Scenario Manager - Scenario Manager7:22
  • Define Name Feature9:00
  • Hyperlink (Link) in Excel7:49
  • Group and Subtotal Options7:24
  • Understanding Draw Tab in Excel5:20
  • Print Options in Excel - Part 110:25
  • Print Options in Excel - Part 28:44
  • Protect Workbook (Excel File) in Excel4:47
  • Protect Sheet in Excel8:56
  • How to Hide Formulas and Unlocked Cell5:11
  • Protect Excel File with Password2:43
  • Date and Time Setting5:55
  • Date and Time Format8:39
  • Date and Time Functions in Excel7:03
  • NETWORKDAYS and NETWORKDAYS.INTL Function4:40
  • DATEDIF Function in Excel3:35
  • VLOOKUP Function in Excel13:53
  • IFERROR Function with VLOOKUP8:05
  • Array VLOOKUP Function in Excel6:05
  • HLOOKUP Function4:23
  • MATCH and INDEX Function4:47
  • MATCH and INDEX Function Nesting4:25
  • VLOOKUP TRUE Feature4:43
  • Amazing Trick in VLOOKUP Function9:56
  • XLOOKUP Function in Excel28:00
  • Macro Recording Feature in Excel15:30
  • Macro Recording Examples5:56
  • Ways to Run Macros in Excel5:58
  • Practice Test - 50 Questions

Requirements

  • Basic Computer Knowledge
  • No previous knowledge is required
  • Great for students who want to learn at their own pace

Description

Do you want to learn how to work like a pro with latest Excel even if you don’t have any prior experience?

If so, then this is the right course for you!

***A Certificate of completion is presented to all students who complete this course.

Microsoft Excel serves today as the one essential business tool you must understand and master to manage large quantities of data. However, it’s essential that you learn how to work with it effectively.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 365 in Hindi - Basic to Advanced Level is here for you. One of the best Excel course online. This training includes everything you’ll need. We will start from the very basics like data entry in Excel and then gradually build a solid foundation through this 11 hours 30 minutes course that will help you mastered Microsoft Excel.

Why you should take this course on Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths in every field.

  • Promotions and Growth. Top Excel users are often promoted very easily inside large corporations

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and high quality sound.

  • Knowledgeable instructor (More then 19000 Udemy students, More then 14 years of working experience in the Industry)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc., Check the Resource option for that)

  • Extensive practical examples that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer promptly

  • Dynamic: The course doesn't waste your time! It maintains a very good pace throughout the whole course.

  • Coverage: The course covers almost everything in Excel.

  • Latest Version: Its in the latest Office 365 however you can work on any version of Excel after the course completion.

This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Buy the course today and let's start this journey!

Who this course is for:

  • MIS Job Aspirants
  • Anyone want to get expertise in Excel

Report abuse