Learn Excel in Hindi

Course

Online

£ 150 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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 whateach 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 ListData ToolsData 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 SubtotalIntroduction
Group and Ungroup and subtotals
Subtotals
Consolidate Pivot TablesIntroduction
Creating Pivot Tables
Choosing Fields
Pivot Table Layout
Filtering Pivot Tables
Modifying Pivot Tables Data
Pivot ChartsSpecial FunctionsCount / Counta / Countif / Countifs
Sum /sumif / sumifs Macros Mail merge

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Basics to Advance Microsoft Excel

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Excel
  • Hindi
  • MS Excel

Course programme

Introduction to Excel 2 lectures 16:41 How to start Excel In this Lecture you will study how to start Excel. Introduction to Excel In this lecture you will study what is Excel and why we should study it. Introduction to Excel 2 lectures 16:41 How to start Excel In this Lecture you will study how to start Excel. Introduction to Excel In this lecture you will study what is Excel and why we should study it. How to start Excel In this Lecture you will study how to start Excel. How to start Excel In this Lecture you will study how to start Excel. How to start Excel In this Lecture you will study how to start Excel. How to start Excel In this Lecture you will study how to start Excel. In this Lecture you will study how to start Excel. In this Lecture you will study how to start Excel. Introduction to Excel In this lecture you will study what is Excel and why we should study it. Introduction to Excel In this lecture you will study what is Excel and why we should study it. Introduction to Excel In this lecture you will study what is Excel and why we should study it. Introduction to Excel In this lecture you will study what is Excel and why we should study it. In this lecture you will study what is Excel and why we should study it. In this lecture you will study what is Excel and why we should study it. Excel Basics 2 lectures 19:35 Creating a new Workbook and Saving files How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. Excel Basics 2 lectures 19:35 Creating a new Workbook and Saving files How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. Creating a new Workbook and Saving files Creating a new Workbook and Saving files Creating a new Workbook and Saving files Creating a new Workbook and Saving files How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. How to select text and do Cut, Copy and Paste In this Lecture you will study Cut, Copy and Paste commands of Excel. In this Lecture you will study Cut, Copy and Paste commands of Excel. In this Lecture you will study Cut, Copy and Paste commands of Excel. Adding, Editing and Organizing Data 3 lectures 34:40 Adding Data and Working with Formulas Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Adding, Editing and Organizing Data 3 lectures 34:40 Adding Data and Working with Formulas Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Adding Data and Working with Formulas Adding Data and Working with Formulas Adding Data and Working with Formulas Adding Data and Working with Formulas Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Data Sorting In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. In this lecture you will study how to organize data using the sort technique in Ascending or Descending order. You will also study Multiple Sorting. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Autofill and Creating Custom Lists In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. In this Lecture you will study the Autofill feature of Excel and you will also study how to create your own Custom Lists. Data Tools 10 lectures 01:10:56 Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. Data Table In this lecture you will study how to use the data table feature in Excel. Scenario Manager In this lecture you will study three different scenarios to present to the client. Goal Seek How to do Goal Seek in Excel Vlookup and Hlookup Approximate Vlookup In this lecture you will study difference between Exact and Approximate vlookup Multiple Vlookup In this lecture you will study how to do lookup within lookup. Identifying and Deleting Duplicates Graphs in Pivot Data Tools. 10 lectures 01:10:56 Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. Data Table In this lecture you will study how to use the data table feature in Excel. Scenario Manager In this lecture you will study three different scenarios to present to the client. Goal Seek How to do Goal Seek in Excel Vlookup and Hlookup Approximate Vlookup In this lecture you will study difference between Exact and Approximate vlookup Multiple Vlookup In this lecture you will study how to do lookup within lookup. Identifying and Deleting Duplicates Graphs in Pivot Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. Data Validation In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. In this lecture you will study how to do Data Validation and put checks so that you can avoid wrong entry of data. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. PMT Function In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. In this lecture you will study how to use the PMT function in Excel to find the monthly EMI using fixed interest and fixed period. Data Table In this lecture you will study how to use the data table feature in Excel. Data Table In this lecture you will study how to use the data table feature in Excel. Data Table In this lecture you will study how to use the data table feature in Excel. Data Table In this lecture you will study how to use the data table feature in Excel. In this lecture you will study how to use the data table feature in Excel. In this lecture you will study how to use the data table feature in Excel. Scenario Manager In this lecture you will study three different scenarios to present to the client. Scenario Manager In this lecture you will study three different scenarios to present to the client. Scenario Manager In this lecture you will study three different scenarios to present to the client. Scenario Manager In this lecture you will study three different scenarios to present to the client. In this lecture you will study three different scenarios to present to the client. In this lecture you will study three different scenarios to present to the client strongCount, Countif and Countifs Count, Countif and Countifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Sum, Sumif and Sumifs Macros and Mail Merge 2 lectures 17:33 Creating a Simple Data Entry Macro Mail Merge between Excel and Word Macros and Mail Merge 2 lectures 17:33 Creating a Simple Data Entry...

Additional information

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

Learn Excel in Hindi

£ 150 VAT inc.