Introduction to Data Analysis using Excel

BY
Microsoft Corporation via Edx

Lavel

Beginner

Mode

Online

Duration

4 Weeks

Fees

Free

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based
Learning efforts 2-4 Hours Per Week

Course and certificate fees

Type of course

Free

certificate availability

Yes

certificate providing authority

Microsoft Corporation

certificate fees

₹8,307

The syllabus

Week 1

  • Learn about Excel tables and what is their advantage over regular ranges.
  • Use a table to filter, sort and see totals.
  • See how calculations can be used to add columns to the existing data in Excel table.

Week 2

  • Create our first pivot table.
  • Use multiple pivot tables and pivot charts to create our first dashboard.
  • Connect multiple slicers to the pivot tables.

Week 3

  • Explore in more depth the full power of pivot tables.
  • See how to filter the data shown in the pivot in many ways to achieve interesting subsets of the data.
  • Use calculated fields on top of the pivot table to calculate profitability and find anomalies.

Week 4

  • Use formulas to aggregate the data as an alternative to pivot tables for more flexible reporting layouts.
  • See how a pivot can use more than one table and introduction to the Excel data table that is described in detail in the more advanced course in these series.

Similar Courses

Data Analysis with Excel for Complete Beginners

CloudSwyft Global Systems, Inc via Futurelearn

10 Weeks Online
Beginner

Foundations of Data Analysis Part 1 Statistics Usi...

University of Texas, Austin via Edx

6 Weeks Online
Beginner
Free

Data Analysis Essentials

Imperial College Business School, London via Edx

6 Weeks Online
Beginner
Free

Sabermetrics 101 Introduction to Baseball Analytic...

BU Boston via Edx

4 Weeks Online
Beginner

Visualization for Data Journalism

University of Illinois, Urbana Champaign via Coursera

3 Weeks Online
Beginner
Free

Population Health Responsible Data Analysis

Leiden University, Leiden via Coursera

3 Weeks Online
Beginner
Free

Assessment for Data Analysis and Visualization Fou...

IBM via Coursera

1 Hour Online
Beginner

RShiny for Everyone

Davidson College, Davidson via Edx

4 Weeks Online
Beginner
Free

Data for Effective Policy Making

IDB via Edx

10 Weeks Online
Beginner
Free

Courses of your Interest

How to start Blogging

Great Learning

Online
Beginner
Free

Smart English Basics for Professionals

Great Learning

Online
Beginner
Free
Write a Book Creative Writing Skills For Beginner ...

Write a Book Creative Writing Skills For Beginner ...

Simpliv Learning

Online
Beginner
$9 $49
Learn How To Start Your Own Soap Making Business L...

Learn How To Start Your Own Soap Making Business L...

Simpliv Learning

Online
Beginner
$149 $749
Revolutionize Your Career Competitive Edge

Revolutionize Your Career Competitive Edge

Simpliv Learning

Online
Beginner
$149 $749

Microsoft Excel 2013 Course Beginners Intermediate...

Udemy

Online
Beginner
₹399 ₹2,699
Write A Feature Length Screenplay For Film Or Tele...

Write A Feature Length Screenplay For Film Or Tele...

MSU East Lansing via Coursera

20 Weeks Online
Beginner
Free

LIVE Streaming Pro Ultimate Course From Beginner t...

Udemy

Online
Beginner
₹499 ₹2,499
Becoming a Successful Leader Inclusive Leadership ...

Becoming a Successful Leader Inclusive Leadership ...

Catalyst via Edx

4 Weeks Online
Beginner
Free
Communicating Strategically

Communicating Strategically

Purdue University, West Lafayette via Edx

5 Weeks Online
Beginner
Free

More Courses by Microsoft Corporation

Introduction to C++

Microsoft Corporation via Edx

4 Weeks Online
Beginner
Free

Learn to Program in Java

Microsoft Corporation via Edx

4 Weeks Online
Beginner
Free
Artificial Intelligence on Microsoft Azure

Artificial Intelligence on Microsoft Azure

Microsoft Corporation via Coursera

1 Week Online
Beginner

Microsoft Service Adoption Specialist

Microsoft Corporation via Edx

4 Weeks Online
Beginner
Free

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books