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.

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 October 2019
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':
Google_logo_41 Digital Analytics Fundamentals
This three-week course provides a foundation for marketers and analysts seeking...
F4ce8928-2ca9-47f0-bc53-804769ffe095-aebda55d0779.small IoT Programming and Big Data
Learn how to apply software solutions for different systems and Big Data needs...
48708e7e-0152-4a4b-ad4c-2dadce29c87f-78359bf75888.small Data Analysis in Social Science-Assessing Your Knowledge
Learn the methods for harnessing and analyzing data to answer questions of cultural...
5c7385bf-01ae-4f77-a628-1586471a91ac-3fc9f3407eac.small Evaluation of Predictive Modelling
Gain an in-depth understanding of evaluation and sampling approaches for...
Ef5dcb87-b65b-46a6-bb2a-c5a3f7807845-7cb915944555.small Engineering Calculus and Differential Equations
Learn fundamental concepts of single-variable calculus and ordinary differential...
More from 'edX':
5dedf011-dfb5-4ea4-8714-30196590eb52-d940b2594513.small Product Design: The Delft Design Approach
Learn to design meaningful products and services in this introductory design...
13adc099-5ad9-43f5-aa3f-b0b989ada21e-d7008b8bf1e5.small Crafting Realities: Work, Happiness and Meaning
Learn to create and experience your work as a joyful and meaningful activity...
840acc48-0d64-4a9d-a424-712406a034a6-2ba1eb03fbae.small Steps in Japanese for Beginners1 Part1
Learn basic Japanese expressions to survive in Japanese. Andy, an exchange student...
79f21ace-02c3-4d4b-9b02-8eb4ce735f7b-e1fbfdd8da2f.small Shakespeare's The Merchant of Venice: Shylock
An exploration of the magnetic and ambivalent character of Shylock in William...
26f7e9fe-9780-4433-ac49-4c67631d43d3-d54b0a83080d.small First Nights - Monteverdi’s L’Orfeo and the Birth of Opera
Learn about Claudio Monteverdi's L 'Orfeo , one of the first operas ever written...

© 2013-2019