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

80043368 - Strategies to Improve Human Papillomavirus (HPV) Vaccination Rates Among College Students
Johns Hopkins University via Independent
MBA Core Curriculum
University System of Maryland via edX
A Beginner’s Guide to Data Analytics
Boxplay via FutureLearn
A Beginner’s Guide to Data Handling and Management in Excel
Packt via FutureLearn
A Day in the Life of a Data Engineer (Korean)
Amazon Web Services via AWS Skill Builder