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

Codecademy

Learn Microsoft Excel for Data Analysis

via Codecademy

Overview

Learn how to analyze and visualize data in Microsoft Excel!

Microsoft Excel is one of the most popular data tools in the business world. Excel is designed as a one-stop shop for storing and analyzing data, with built-in tools to help you transform data of all kinds into business insights. Used for everything from complex financial modeling to tracking shipment orders, knowledge of Excel is foundational to any career in data analysis or business intelligence.



### Take-Away Skills

In this course, you’ll learn to take raw data and produce insightful analyses using Excel's import tools, formulas, sorting and filtering tools, pivot tables, and charts. You will also learn best practices for managing, protecting, and cleaning data in Excel.

Syllabus

  • Welcome to Learn Microsoft Excel for Data Analysis: Get started with Excel for Data Analysis!
    • Informational: Welcome to Learn Microsoft Excel for Data Analysis
    • Informational: Download and Install Excel
  • Exploring Data: Learn how to leverage Excel to explore data.
    • Lesson: Exploring Data
    • Lesson: Pivot Tables
    • Project: Explore GDP in Excel
    • Quiz: Exploring Data Quiz
  • Visualizing Data: Learn to visualize data in Excel!
    • Lesson: Visualizing Data
    • Project: Visualizing Hotel Data in Excel
    • Quiz: Visualizing Data
  • Handling Data: Get a handle on handling data in Excel!
    • Lesson: Handling Data
    • Project: Handling Hotel Data in Excel
    • Quiz: Handling Data
  • Analyze Bitcoin Data in Excel: Use Excel to analyze Bitcoin price behavior.
    • Project: Analyze Bitcoin Data in Excel
  • Next Steps: See where you can take your new Microsoft Excel skills!
    • Informational: Learn Microsoft Excel for Data Analysis Next Steps
    • ExternalResource: Microsoft Excel to Google Sheets Cheat Sheet

Taught by

Ada Morse

Reviews

3.0 rating, based on 1 Class Central review

4.3 rating at Codecademy based on 331 ratings

Start your review of Learn Microsoft Excel for Data Analysis

  • Profile image for Sukhpreet Singh Lohiya
    Sukhpreet Singh Lohiya
    From the moment I enrolled in the course, I was impressed by the user-friendly interface and the well-structured curriculum. Each module is thoughtfully organized, guiding learners from the fundamentals to more advanced concepts. This progressive approach ensured a smooth learning curve, even for someone like me who had limited prior coding experience.

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.