Join Nate Makdad for an in-depth discussion in this video Introduction to visual design, part of Creating Interactive Dashboards in Excel 2013.
- Visual design, data visualization really as topics,…can be heard just about everywhere when you get…into the topic of data analysis and viewing information,…but how does it apply to designing charts in Excel?…Well, we know charts are an incredibly powerful way…to view and analyze data to see trends or differences,…and our brains are really good at processing that visual…information very quickly and looking for differences…in size, shape, and color.…So, by keeping some principles in mind, we can improve…the layout of our final template and make it easy to look at…and quick for people to understand.…
To quote from Edward Tufte's…Visual Display of Quantitative Information,…we wanna generate the most ideas in the shortest amount of…time with the least ink using the smallest possible space.…Excel offers a lot of default options with creating charts,…and the purpose of good visual design is to let your users…quickly and easily read and understand the information…presented, graphics reveal data.…To go back to our example on Anscombe's quartet,…
- Recognize three dimensions of a PivotTable.
- Summarize four design tips.
- Identify the two default sections for values in Excel.
- Explain how to add slicers in a single column.
- Recall the shortcut used to insert a hyperlink.
- Determine the location to look when you have an error while pasting data.