Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - from Beginner to Advanced - Hindi (हिन्दी)
Rating: 4.4 out of 5(6 ratings)
32 students

Microsoft Excel - from Beginner to Advanced - Hindi (हिन्दी)

Excel: The WHOLE Excel Mastery Series In One! Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2019
Created byGutoju Pallavi
Last updated 8/2020
Hindi

What you'll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Course content

2 sections • 46 lectures • 3h 40m total length

  • 1. How to Start MS Excel - Open Close , Preview Functionalities5:17
  • Home Tab - Clipboard Group Functions, Copy, Cut, Paste-Special, Past as Picture8:29
  • Home tab - Font Group Explained - Font Face Style, Font Color, Background color.7:53
  • Home tab Alignment group Explained in Ms excel5:11
  • Characteristics of a cell explained in Ms Excel1:14
  • How to Create Own Tabs & add tool Groups in Microsoft Excel5:30
  • Editing Data in MS Excel - Goto, FInd, Replace, Override, edit and more6:06
  • Speak cells explained in Ms Excel3:43
  • 2. Sum Functionality in MS Excel6:36
  • 3. Subtraction Functionality in MS Excel0:58
  • 4. Multiplication Functionality in MS Excel2:39
  • 5. Percentage Functionality in MS Excel1:31
  • 6. Division Functionality in MS Excel3:09
  • 7. Count Functionality in MS Excel5:59
  • 8. Date & Time Functionality in MS Excel2:57
  • 9. EMI Computation in Excel11:04
  • 10. Drop Down List Creation in MS Excel6:12
  • 11. Average Computation in Excel4:10
  • 12. Concatenate Functionality in MS Excel1:07
  • 13. Print Functionality in MS Excel2:00
  • 14. Trim Functionality in MS Excel1:33
  • 15. Student Marksheet Formulas in Excel13:16
  • 16. V Lookup & H Lookup Functionality in MS Excel10:08
  • 17. Attendence Sheet Creation in MS Excel12:27
  • 12. Text to columns Explained in Ms Excel4:45
  • 13. MS Excel - Comments - add, edit, delete & Show all3:06
  • 14. MS Excel - Fill Series - with formatting, without formatting & more2:44
  • 15. Fill Series - Advance Fill - Numbers, Months, Daya, Custom List Edit & Add,7:49
  • 16. Fill Series - Flash Fill4:13
  • 17. MS Excel - How to Hide and Unhide Rows, Columns, Sheets6:20
  • 18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns in Hindi7:07
  • 20. MS Excel - Split Sheet Window2:29
  • 22. MS Excel - Working with Sheets6:23
  • 23. MS Excel - View Sheets Side by Side from One Excel File3:46
  • 24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel3:28
  • 25. MS Excel - Sheet & Cells Protection5:02
  • 27. Concatenate - Join Multiple Text Strings into ONE1:22
  • 28. MS Excel - Trim Functions - Remove unnecessary Elements from strings in Hind1:50
  • 29. MS Excel - Print Formulas Left, Right, Middle4:10
  • 30. MS Excel - Date Related Formulas3:11
  • 39. MS Excel - Import Data from Text Document - with Auto Refresh in Hindi3:34
  • 41. MS Excel - Format Multiple Sheets at a time4:24
  • 42. MS Excel 3d Sum4:12
  • 43. MS Excel - Consolidate ( 3d Sum extension)4:14
  • Download Certificate from Udemy I Learn How to Download Certificate from udemy1:36

Requirements

  • Be able to listen
  • be able to watch
  • No other knowledge is required, as each step is explained fully in the course.

Description

Who this course is for:

  • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros).

  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

    This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

Who this course is for:

  • Excel users who have basic skills but want to get really, REALLY good
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
  • Excel users looking to build strong analytical thinking and business intelligence skills
  • Anyone looking to pursue a career in data analysis or business intelligence Featured review

Report abuse