image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Do you work with charts but struggle to identify which chart to use?



Are you new to data analysis?



Do you want to learn about the charting options Excel 2013/2010 offers?



Are you looking for a structured way to learn about the Excel charting tools?


If your answer was
YES
to some of the questions, this course might be of interest to you.


When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works.
This course is especially suited towards a beginners audience to data visualization with Excel.


Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010.

Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge.

I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on.

There is also a section about the frequently used types of charts and how you can easily create them in Excel.

At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs.

I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.
Who this course is for:
Everybody interested in data visualization
Everybody willing to try out the material at home and solve the exercises
Everybody starting out to work with Excel
Everybody needing charts for work or study purposes

What you'll learn

create the most common type of charts in Excel

know which chart to use for a given dataset

perform standard format changes in charts

use Excel 2013 confidently for charts and graphs

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
5
1.1-Introduction
1.2-Chart Types - Which chart should I use?
1.3-Chart Types - Which chart should I use?
1.4-Chart Types
1.5-Course Datasets
2-General Tools
6
2.1-Excel Basic Tools - Insert Tab
2.2-Our First Chart - Pie Charts
2.3-Excel Basic Tools - Design Tab
2.4-Excel Basic Tools - Chart Buttons
2.5-Chart Axes
2.6-Exercise - Editing Tools
3-Chart Types in Detail
9
3.1-Pie of a Pie Chart
3.2-Doughnut Charts
3.3-Scatterplots
3.4-Bubble Charts
3.5-Line Charts
3.6-Area Charts
3.7-Exercise - Lynx Trappings
3.8-Column or Bar Charts - Paired Data
3.9-Dynamic Charts with Tables
4-Bonus Lectures: New Chart Types in Excel 2016
11
4.1-Introduction to New Charts
4.2-Statistical Charts 1: Histogram
4.3-Histogram - alternative method
4.4-Statistical Charts 2: Pareto Chart
4.5-Pareto Chart - alternative method
4.6-Statistical Charts 3: Box and Whisker Plot
4.7-Hierarchical Charts 1: Treemap
4.8-Hierarchical Charts 2: Sunburst
4.9-Which one should I choose? Treemap vs. Sunburst
4.10-Finance: Waterfall Chart
4.11-Waterfall Chart - alternative method