This module is designed to demonstrate how to use Excel to create powerful data visuals.
Activity learning objectives:
Learn how to choose the best chart for datasets
Build knowledge of excel functionalities to help quickly make visuals or analyze data
As you work through the activities, consider the following questions:
What are your main takeaways from the activity?
How did this activity enhance your knowledge of data visualization best practices?
Where do you see yourself applying this knowledge in your work?
Activities may be completed in any order.
This course, created by Chris Dutton (Microsoft Excel Expert and analytics consultant), proves that doing journalism with data and designing compelling charts, maps, and graphics is a matter of learning some key principles, skills, practicing, and receiving feedback.
Time Commitment: ~2.5 hours
Access: LinkedIn Learning account needed
This course, created by Richie Cotton and Amy Peterson, presents the fundamentals of data visualization with Google Sheets, a free and collaborative resource. This course provides a guide on how to create both common and advanced chart types to share complex data efficiently.
Time Commitment: ~1-4 hours
Access: Open (Comparable to Activity 1)
Ann K. Emory previously appeared in the Best Practices Module and she has a lot more content on Youtube! These videos were intentionally selected by an NRMN CC team member (shout out to Jimmy Robinson) around creating data visuals and analyzing data in Excel.
Time Commitment: ~1 hour
Access: Open