When you visualize your data, it’s easier for others to understand and rally behind your shared goals. In this course, data visualization expert and consultant Heather Johnson teaches you how to begin visualizing your data in Microsoft Excel. Heather starts the course by reviewing why data visualization is so important, and provides guidance for showcasing specific numbers/text points. She then discusses her tips for creating pivot tables and charts, and reviews how you can highlight key points in your data with customization and drawing features. Finally, Heather shows you how to transform a traditional spreadsheet into a fancy dashboard. You’ll finish this course armed with all the tools needed to start visualizing your data in Excel.
Syllabus
- Introduction: Data visualization with Excel
- Why Visualize Data?: Value of data visualization
- Display Numbers Elegantly: Data in a sentence
- Display Numbers Elegantly: Making big numbers meaningful
- Display Numbers Elegantly: Utilizing text boxes
- Display Numbers Elegantly: Demystifying wingdings
- Display Numbers Elegantly: Enhancing your tables
- Using Pivot Tables and Charts: Building pivot tables and pivot charts
- Using Pivot Tables and Charts: Using basic Excel charts
- Using Pivot Tables and Charts: Customizing basic charts
- Using Pivot Tables and Charts: Tips and tricks
- Displaying Data with Objects: Using text boxes
- Displaying Data with Objects: Adding images and icons
- Displaying Data with Objects: Combining text, icons, and charts
- Creating a Dashboard: Combining charts to create dashboards
- Creating a Dashboard: Moving and aligning charts
- Creating a Dashboard: End user filtering
- Creating a Dashboard: Pushing dashboards to Powerpoint
- Conclusion: Let’s visualize
