Learn how to prepare your data in Excel, create a chart, improve your chart's design, and avoid common mistakes
What you'll learn Requirements Description
Clean up data in Excel
Learn the principles of effective chart design
Avoid common pitfalls of chart design
Improve the design of bar charts, line graphs, histograms, and scatterplots
Use advanced techniques to enhance your charts
No prior knowledge of chart design is required.
Commitment to the learning the principles of design
Transform your charts and graphics into memorable visualizations.Your audience can quickly connect with your message with a chart or graphic. Creating effective visualizations, however, requires knowledge of key design principles. The design principles in this class cover all aspects of creating your chart. Fonts, titles, sizes, effects, numbers, colors, and other aspects of chart design will be addressed. After creating a compelling graphic, you'll learn how to implement it in PowerPoint and Word so you can share it with others. Common pitfalls of chart design are also included. Being able to create appealing visual graphics is crucial as data becomes more readily available. This class will focus on designing effective and elegant charts and graphs.In this class, we'll be focusing onPreparing data in ExcelCreating a chartKnowing which elements to include and which to avoidTips for designing charts in PowerPoint and WordAvoiding common design mistakesUsing advanced techniques such as error barsWho is this class for?Researchers, data analysts, students, and other individuals interested in presenting their findings in a visually compelling format.Course materials: Lecture videosReadings - for further knowledge on chart designExercise files - so you can follow alongA project file - to help you practice
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.