Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

Analyze Data with Microsoft Excel

via Codecademy

Overview

Build spreadsheets with Microsoft Excel.

With over 750 million users Microsoft Excel is one of the most popular tools for storing and analyzing data. You can use spreadsheets to model complex financial data, keep track of user orders, manage a guest list for an event or build dashboards to forecast future sales performance. Whatever the task, Microsoft Excel is an incredibly powerful tool that enables you to store and make sense of your data.



### Take-Away Skills

This course teaches you how to use Microsoft Excel to analyze data. In this course, you'll learn how to import data, develop visualizations and use complex tools like macros and PivotTables. You'll put your skills to the test with an end-to-end guided project.

Syllabus

  • Introduction: Learn how to set up Microsoft Excel on your computer.
    • Article: Introduction to Excel Spreadsheets
  • Data Handling: Learn how to import and manipulate data using Microsoft Excel.
    • Article: Importing Data with Excel
    • Article: Handling and Manipulating Data with Excel
  • Data Visualization: Learn how to use Excel to build visualizations for your data.
    • Article: Basic Visualizations with Excel
  • Data Analysis and Macros: Learn how to use more complex tools like pivot tables and Macros to analyze and manipulate data.
    • Article: Data Analysis with Excel
    • Article: Macros with Excel
  • Off-Platform Project: Financial Modeling: Combine all your Excel skills to build an analysis from scratch.
    • Article: Project: Bitcoin Price Analysis

Taught by

Ada Morse

Reviews

4.1 rating at Codecademy based on 408 ratings

Start your review of Analyze Data with Microsoft Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.