Visualizing the Answer to Stock Questions Using Spreadsheet Charts
- Guided Project
- 1.4 hours
- Beginner
- Excel
Practice applying design principles to create engaging Excel visualizations and a report using real stock market data.
Overview
In this project, you'll take on the role of a business analyst and dive into historical stock market data using Excel. You'll create a variety of charts to analyze trends and relationships in the data.
Applying information design principles, you'll ensure your visualizations are both engaging and insightful - maximizing the data-ink ratio, leveraging Gestalt principles, and employing pre-attentive attributes to make key insights pop. You'll then combine your charts into a polished, cohesive report. By the end, you'll have developed valuable skills in data visualization and communication that are highly sought-after by employers across industries.
Objective: Analyze stock data in Excel to create an insightful visual report applying information design best practices.
What You'll Learn
- ✓ Import a dataset to an Excel spreadsheet
- ✓ Create a report in Excel using data visualizations and tabular data
- ✓ Represent data using effective data visualizations
- ✓ Apply Gestalt principles and pre-attentive attributes to all visualizations
- ✓ Maximize data-ink ratio in all visualizations
Before You Start
- ✓ Creating various chart types in Excel to visualize data
- ✓ Selecting appropriate chart types to effectively present data
- ✓ Applying design principles to create clear and informative charts
- ✓ Designing charts for an audience using Gestalt principles
Project Steps
10 steps
- 1 Introduction
- 2 Possible Datasets
- 3 Pie Chart
- 4 Column Chart
- 5 Histogram Chart
- 6 Line Chart
- 7 Scatter Chart
- 8 Combo Chart
- 9 Generate a Report
- 10 Next Steps
Join 1M+ data learners on Dataquest.
- 1
Create a free account
- 2
Choose a learning path
- 3
Complete exercises and projects
- 4
Advance your career