Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
बेसिक से एडवांस तक MS-Excel कोर्स हिंदी में सीखें
Highest Rated
Rating: 4.1 out of 5(34 ratings)
141 students

बेसिक से एडवांस तक MS-Excel कोर्स हिंदी में सीखें

Learn MS-Excel from Basic to Advance in Hindi
Created bySaurav Ghosh
Last updated 6/2021
Hindi

What you'll learn

  • Introduction to MS Excel 2010 with using Formula
  • Basic Formulas
  • Formatting Cell and workbook
  • Filter Data
  • Draw Symbol and Insert Pictures
  • Text to column
  • Page setup
  • Array Function
  • Date Time Functions
  • Conditional functions
  • Logical Functions
  • Conditional Formatting
  • Hyperlink
  • Information Functions
  • Macro
  • Statistical Functions
  • Text Functions
  • Logical Functions
  • VLookup and Hlookup functions
  • Advance Formatting
  • Different types of Graphs
  • Pivot Table
  • More than 100s of trick and tips
  • Practical Examples

Course content

2 sections102 lectures7h 28m total length
  • Introduction to MS Excel 2010 with using Formula8:45
  • Formula, Cut, Copy, Paste, Format Painter, Alignment8:26
  • Wrap Text, Merge and Center, Number10:48
  • Conditional Formatting, Format as table, Cell Style, Cell Insert, Cell Delete10:07
  • Format, AutoSum, Fill, Clear8:10
  • Sort Filter, Find Select5:13
  • Pivot Table, Table, Picture, Clipart13:45
  • Shapes, Smart Art, Screen Shot, Charts7:22
  • Page Setup, Scale to Fit, Sheet Options10:24
  • Hyperlink, Text box, Header Footer, Word Art, Signature, Equation, Symbol9:29
  • Formulas10:19
  • Text to Column, Remove Duplicate, Data Validation, Consolidate, What if analysis10:57
  • Group, UN Group, Sub Total, Spelling, Thesaurus7:27
  • New Comment, Protect Sheet, Protect Work Book, Track Change6:39
  • Page Break, Full Screen, Zoom, Freeze Pane, Macros8:47
  • Practical Example8:01

Requirements

  • Basic knowledge of computer

Description

इस कोर्स में एक्सेल पेशेवर को जानने के लिए आवश्यक सभी बुनियादी बातों को शामिल किया गया है। यह कोर्स उन लोगों के लिए उपयुक्त है जिनके पास एक्सेल में कोई पिछला अनुभव नहीं है। हम बहुत बुनियादी बातों से शुरू करेंगे और धीरे-धीरे कुछ अधिक उन्नत सुविधाओं की ओर बढ़ेंगे, जैसे लुकअप फ़ंक्शन, शर्तों के साथ कार्य, लक्ष्य की तलाश, पिवट टेबल, कस्टम स्वरूपण, एक्सेल चार्ट, और अन्य उपकरण जो अक्सर वित्तीय मॉडलिंग के उद्देश्यों के लिए उपयोग किए जाते हैं।

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.


5 Reasons why you should choose this Excel course

  1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

  2. Concise - you can complete this Microsoft Excel course within one weekend

  3. Business related examples, data analysis and case studies solved using Advanced Excel.

  4. You will learn various data analysis techniques using MS Excel

  5. This course is described in Hindi language


Who this course is for:

  • Anyone who wants to learn Advance Excel in Hindi