Visualizing Data In Excel

Learn the fundamentals of how to tell data stories and build dashboards within Microsoft Excel.

Course Curriculum

• 1 Data visualization with Excel Visualizing data gathered and interpreted for different projects can be a powerful way to gain buy-in, prove a hypothesis, or recognize a trend. 1m

• 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