Visualizing Data in Excel
Visualizing Data in Excel
What you’ll learn
Skills you’ll gain
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
Download syllabus-
1
Value of data visualization Visualizing your data makes it easier to understand, interpret, and compare. 1m
-
1
Data in a sentence One of the best ways to get more understanding from your data is to put it in plain text. 5m
-
2
Making big numbers meaningful In order to support your key points, you'll want to make your numbers stand out by using larger fonts and meaningful colors. 3m
-
3
Utilizing text boxes Text boxes allow you to include supporting text, definitions, or sub-headers. 5m
-
4
Demystifying wingdings Wingdings are a standard font that is made up of symbols that allows you to enhance your data. 8m
-
5
Enhancing your tables There are tons of tools available to you in Excel that can help you make the tables you build more engaging. 6m
-
1
Building pivot tables and pivot charts You can create pivot tables and charts simultaneously, giving you options for how your data can be easily understood. 4m
-
2
Using basic Excel charts There are several more basic charts you can leverage when looking to build your visualizations. 6m
-
3
Customizing basic charts Every individual chart element can be customized to make even your most basic charts unique. 9m
-
4
Tips and tricks There are plenty of useful hacks in Excel that can save you time when visualizing data. 5m
-
1
Using text boxes Text boxes are an easy tool you can use to supplement the storyline you're telling with the data. 6m
-
2
Adding images and icons You can add pictures, shapes, icons, and more in Excel. 13m
-
3
Combining text, icons, and charts You can use tools like layering in Excel to help create dynamic, visually appealing spreadsheets. 4m
-
1
Combining charts to create dashboards You can use single sheets in Excel to mimic the layout and options that a dashboard might have. 5m
-
2
Moving and aligning charts Absolute placement in Excel allows you to get all of your charts in one view. 3m
-
3
End user filtering Although you have many options for how your end users can filter your data, ultimately, VLOOKUPs offer the most seamless experience. 3m
-
4
Pushing dashboards to Powerpoint If you're presenting your data to a group, it might make more sense to host in PowerPoint. 10m
-
1
Let's visualize Thanks for watching this course! Now, you should feel confident in your ability to visualize data while utilizing Microsoft Excel. 1m
Certificate
Certificate of Completion
Awarded upon successful completion of the course.
Instructor
Heather Johnson
Heather Johnson is an experienced senior data analyst with a passion for making business analytics easier to understand. In 2002 she got her start at Visa, Inc. creating dashboards that helped clients easily understand their operations metrics. She is certified in Tableau and equally skilled in Excel and other desktop data tools. Recently, she has consulted in data visualization for Intuit and Salesforce.
Heather Johnson
Data Visualization Engineer and Consultant
Accreditations
Link to awards
How GoSkills helped Chris
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth. Seeing how much this has helped me become a more efficient employee is a big motivation.
