Description
In this course, you will learn:-
- Learn how to use Excel to make well-designed graphs.
- Learn how to format graphs in Excel beyond the usual options.
- Learn how to make data that is "graph-worthy."
- To summarise data before graphing, use lookups and Pivot Tables.
- Create graphs in Excel that are similar to those found in today's most prestigious magazines.
Syllabus:-
-
Introduction
-
Prepping your data
-
Cleaning and organizing data with Vlookups
-
Choosing the right graph
-
Let's graph
-
Formatting your graphs
-
From a bar to a line graph
-
Changing a graphs color scheme
-
Pasting your graphs into PowerPoint
-
Create a graph in "The Economist" style
-
Create a graph in "Five Thirty-Eight" style