Excel for Data Analysis

Data Analyst

In this Course, you will learn about Data Analysis in Excel. You will understand more about Pivot Tables, Dashboards.


What will you learn?

  • You will learn about VLOOKUP and HLOOKUP functions.
  • You will learn about the use of index and match functions.
  • You will learn about making Pivot tables and Pivot Charts in Excel.
  • You will learn about the Basics of Visualisation.
  • You will learn about making charts in Excel.
  • You will learn how to make dashboards and formatting dashboards in excel.
  • You will learn about the three types of What If Analysis i.e., Goal Seek, Data Tables and Scenario Management.

Who is this Course for?

Lookup Functions

Course Requirements

Lookup Functions







Course Curriculum

Section 1
Lookup Functions
Lookup Functions
Section 2
Index and Match
Index and Match
Section 3
Pivot Tables
Pivot Tables
Section 4
Section 5
What If Analysis
What If Analysis
Section 6

Every Course Comes with…


Every Projects comes with 2-3 hours of video lessons giving you step-by-step solution with explanation of the entire project


You will get the entire project workbooks, datasets, and other resources with it


Build your Project Portfolio by adding these projects to your Online Profiles like GitHub, LinkedIn, Kaggle etc

I was amazed by how much I was able to gain in such a short amount of time.
The #1 thing I got from the course was the confidence to complete complicated projects.

Now I am also a believer in Projects over Degrees
Prashant Singh
Vice President, PayTM
I was very sceptical that I can complete a course Online, but thankfully DataisGood proved me wrong.

They helped me chose the right path, the right projects and gave me the right guidance.
DataisGood has changed my life.
Sourav Kumar
Sr. Data Analyst, TCS

Your Rock-Solid Money Back Guarantee 

Our Guarantee is simple.
If you are not 100% satisfied.


We insist you take your money back.


Just sent one email (with the Order Id and same email you used to make the purchase, within 7 days of your purchase) to us at [email protected]


If you contact us for a refund, we’ll issue it promptly and courteously. We’ll even bear the processing fees at our end.


There is no RISK on your part. Zero, Nada, Nil…

Our learners work at


We are on a mission to create Data Science courses that will make our students not just learn the subject, but fall in ❤️ love with that subject so that they become lifelong passionate learners and explorers of that subject.

Office Location 


All rights reserved. © 2019-21. || Email: [email protected] || Phone: +91 88649 50180
Data is Good, B-33, 1st Floor, Sector 6, Noida – 201301
Terms | Privacy

Call us on +91 88649 50180

  (Nancy Bajaj, Senior Admission Councellor)