Introduction to Data Analysis using Excel

Dany Hoter, Jonathan Sanito, Microsoft

Learn the basics of Excel, one of the most popular data analysis tools, to help visualize and gain insights from your data.

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In this course, you will learn how to perform data analysis using Excel's most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

You should have a basic understanding of creating formulas and how cells are referenced by rows and columns within Excel to take this course. If required, you can can find many help topics on Excel at the Microsoft Office Support Site. You are welcome to use any supported version of Excel you have installed in your computer, however, the instructions are based on Excel 2016. You may not be able to complete all exercises as demonstrated in the lectures but workarounds are provided in the lab instructions or Discussion forum. Please note that Excel for Mac does not support many of the features demonstrated in this course.

After taking this course you'll be ready to continue to our more advanced Excel course, Analyzing and Visualizing Data with Excel.

Note: These courses will retire in June. Please enroll only if you are able to finish your coursework in time.

What will you learn

  • Create flexible data aggregations using pivot tables
  • Represent data visually using pivot charts
  • Calculate margins and other common ratios using calculation on pivot table
  • Filter data using slicers in multiple pivot tables
  • Create aggregate reports using formula based techniques

Dates:
  • 1 April 2020
Course properties:
  • Free:
  • Paid:
  • Certificate:
  • MOOC:
  • Video:
  • Audio:
  • Email-course:
  • Language: English Gb

Reviews

No reviews yet. Want to be the first?

Register to leave a review

Show?id=n3eliycplgk&bids=695438
NVIDIA
More on this topic:
Small-icon.hover Introduction to Computational Finance and Financial Econometrics
Learn mathematical and statistical tools and techniques used in quantitative...
Tree-logo-600x340 How Green Is That Product? An Introduction to Life Cycle Environmental Assessment
In this course you will learn the basics of the life-cycle assessment (LCA)...
6.00x-listing-banner 6.00x: Introduction to Computer Science and Programming
6.00x is an Introduction to computer science as a tool to solve real-world analytical...
54466_0f26_13 Excel 2010 Tutorial - Online Excel Course
This excel training covers both basic excel and advanced excel tutorial This...
18517_3c78_3 The Zen of Data - Part I: Stats for Analytics by Todd Wieland
Relax. It's Just Data. You have data. You need insights. The bridge between...
More from 'Mathematics, Statistics and Data Analysis':
7b2ecb24-2874-402b-ad86-473e246cae0c-aa0d4ca8dc73.small RiceX Linear Algebra Part 1
This course is an introduction to linear algebra. You will discover the basic...
91f52ef3-fa3f-4934-9d19-8d5a32635cd4-d99e27f09d19.small Data Science: R Basics
Build a foundation in R and learn how to wrangle, analyze, and visualize data...
B4072f23-f746-43a1-9819-8e3d8b066f38-76465b3bdbcc.small Data Science: Visualization
Learn basic data visualization principles and how to apply them using ggplot2...
54a056bd-bfd5-45a2-ba71-aad017e1d275-a2fbb913691a.small Data Science: Probability
Learn probability theory -- essential for a data scientist -- using a case study...
C654bfe1-69ba-4a2b-8be1-9acb2e846855-3aa512994f13.small Data Science: Inference and Modeling
Learn inference and modeling, two of the most widely used statistical tools...
More from 'edX':
4e32f396-cd37-43a3-a856-3704a1061849-f64a6df7ccc4.small Leadership and Influence
Develop the skills to motivate and inspire others so you can confidently lead...
E435bd5b-8843-40c8-b260-ce34433d9a0e-a3897f869072.small Global Business Strategy
Learn how to capitalize on opportunities, and manage the challenges of the global...
B093db1a-4553-4ec3-a44b-96c71d1da0a5-b6dc2ba5887a.small Mining for Development: The Taxation Linkage
Understand taxation for development and sustainability in mining. Tax revenues...
C2f40fe6-7bcf-45f5-b1bc-e906563c1f3d-30f087164b1d.small Digital Transformation in Business
Learn about the explosion of technologies that are transforming business and...
7b2ecb24-2874-402b-ad86-473e246cae0c-aa0d4ca8dc73.small RiceX Linear Algebra Part 1
This course is an introduction to linear algebra. You will discover the basic...

© 2013-2019