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
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
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 lectures16:41How 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 lectures16:41How 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 lectures19:35Creating a new Workbook and Saving filesHow 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 lectures19:35Creating a new Workbook and Saving filesHow 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 filesCreating a new Workbook and Saving filesCreating a new Workbook and Saving filesCreating a new Workbook and Saving filesHow 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 lectures34:40Adding Data and Working with FormulasData 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 lectures34:40Adding Data and Working with FormulasData 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 FormulasAdding Data and Working with FormulasAdding Data and Working with FormulasAdding Data and Working with FormulasData 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 lectures01:10:56Data 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 ExcelVlookup and HlookupApproximate Vlookup In this lecture you will study difference between Exact and Approximate vlookupMultiple Vlookup In this lecture you will study how to do lookup within lookup.Identifying and Deleting DuplicatesGraphs in Pivot
Data Tools.
10 lectures01:10:56Data 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 ExcelVlookup and HlookupApproximate Vlookup In this lecture you will study difference between Exact and Approximate vlookupMultiple Vlookup In this lecture you will study how to do lookup within lookup.Identifying and Deleting DuplicatesGraphs in PivotData 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 CountifsSum, Sumif and SumifsSum, Sumif and SumifsSum, Sumif and SumifsSum, Sumif and Sumifs
Macros and Mail Merge
2 lectures17:33Creating a Simple Data Entry MacroMail Merge between Excel and Word
Macros and Mail Merge
2 lectures17:33Creating 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