Data Analysis in Spreadsheets

Course Duration: 1 hour

Course Summary

“Data Visualization in Spreadsheets” is a one-hour course designed to equip learners with the necessary skills and knowledge to create effective data visualizations using spreadsheet tools. This course covers the fundamental principles of data visualization, hands-on creation and customization of various chart types, and advanced visualization techniques. It also introduces the role of data visualization in storytelling. The course provides a solid foundation for anyone looking to enhance their data presentation skills in both personal and professional settings.

Course Curriculum

1. Welcome and Introduction (5 minutes)

Give an overview of the course
Highlight the importance of data visualizations in decision making

Highlight all learning objectives

2. Introduction to Spreadsheet Tools (10 minutes)

Give an overview of spreadsheets
Highlight the differences between Google Sheets vs Microsoft Excel
Discuss the basics of spreadsheet functions and formulas

3. Principles of Data Visualization (10 minutes)

State the importance of data visualizations
Cover the principles and elements of a good data visualization
Go over some common pitfalls in data visualizations

4. Using Spreadsheets for Data Visualization (15 minutes)

Highlight how to create basic charts and graphs: bar, line, pie, scatter plot
Show how to customize charts: titles, labels, legends, colors
Explore interactive charts and dashboards

5. Advanced Data Visualization Techniques (10 minutes)

Cover conditional formatting for data visualizations
Highlight how to use pivot tables for summarizations and visualizations
Go over the advanced chart types: histograms, box plots, heat maps

6. Using Data Visualization for Storytelling (5 minutes)

Highlight the role of data visualization in data storytelling
Highlight conditional formatting
Show how to develop a narrative using visualizations

7. Wrap-up and Next Steps (5 minutes)

Give a short review of the key takeaways from this course
Discuss the importance of continued learning and practice
Initiate Q&A and course feedback

Note: This course is designed for learners who have basic familiarity with spreadsheets and wish to enhance their skills in data visualization. While the course focuses on spreadsheets, the principles and techniques discussed are applicable to other data visualization tools as well. For optimal learning, students are encouraged to follow along with their own spreadsheets and experiment with creating their own visualizations.