Introduction to Data Analysis using Excel

Archived
Course
en
English
8 h
This content is rated 4 out of 5

You can't access an archived course

Source
  • From https://www.edx.org/
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 4 Sequences
  • Introductive Level

You can't access an archived course

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

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.

Prerequisite

None.

Instructors

Dany Hoter
Solutions Architect
DataRails

Jonathan Sanito
Senior Content Developer
Microsoft

Editor

Microsoft Corporation is an American multinational technology company headquartered in Redmond, Washington, that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems, Microsoft Office office suite, and Internet Explorer web browser.

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 4 out of 5
(no review)
This content is rated 4 out of 5
(no review)
Complete this resource to write a review