Introduction to Data Analysis using Microsoft Excel

4.7
stars

465 ratings

Offered By

22,442 already enrolled

In this Free Guided Project, you will:
2 hours
Intermediate
No download needed
Split-screen video
English
Desktop only

In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.

Requirements

Skills you will develop

  • Formulas and Functions in Spreadsheets

  • Data Analysis

  • Data Calculations

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Reviews

TOP REVIEWS FROM INTRODUCTION TO DATA ANALYSIS USING MICROSOFT EXCEL

View all reviews

Frequently Asked Questions