What You Will 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

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 Should Attend!

  • Anyone who wants to learn Advance Excel in Hindi

TAKE THIS COURSE

Tags

  • Excel Analytics
  • Excel Charts
  • Excel Macros
  • Excel

Subscribers

89

Lectures

102

TAKE THIS COURSE



Related Courses