YoVDO

Analyze Data with Microsoft Excel

Offered By: Codecademy

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Spreadsheets Courses Macros Courses Financial Modeling Courses PivotTables Courses

Course Description

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

Sarai Fernandez

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent