Blog
Library

Learn Excel in Hindi

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

  • Categories

    Productive Expertise & Efficiency

  • Duration

    03:31:23

  • 0 Students Enrolled

Description

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well.

By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to:

Understanding basics:

  • AutoFill a Series
  • Creating a Custom List

Data Tools

  • Data Validation
  • Drop-Down Lists
  • Text to Columns
  • pmt
  • Goal Seek
  • Scenario Manager
  • Data Table
  • Vlookup
  • hlookup
  • Importing and Exporting Data
  • Identifying and deleting duplicates

 Outline, Sort, Filter and Subtotal

  • Introduction
  • Group and Ungroup and subtotals
  • Subtotals
  • Consolidate

 Pivot Tables

  • Introduction
  • Creating Pivot Tables
  • Choosing Fields
  • Pivot Table Layout
  • Filtering Pivot Tables
  • Modifying Pivot Tables Data
  • Pivot Charts

Special Functions

  • Count / Counta / Countif / Countifs
  • Sum /sumif / sumifs

 Macros

 Mail merge


Basic knowledge
  • Microsoft Excel should be installed on your system, this course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016
  • No previous experience of Spreadsheet required

What will you learn
  • Basics to Advance Microsoft Excel
Course Curriculum
Number of Lectures: 29 Total Duration: 03:31:23
Reviews

No Review Yet