Learn Microsoft Excel for Data Analysis

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.

• 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