Description
Course info
Rating
(12)
Level
Beginner
Updated
Oct 4, 2019
Duration
1h 39m
Description

Data is an increasingly important part of our organizations, and it's critical that you learn how to effectively communicate and visualize this information. In this course, Charting Data with Excel, you will gain the ability to work with several fundamental components of Excel's charting tools. First, you will learn how to create and change charts. Next, you will discover how to work with multiple data series. Finally, you will explore how to enhance your charts with features like trendlines and secondary axes. When you are finished with this course, you will have the skills and knowledge of Excel charts needed to build a dashboard full of interesting visuals for your data.

About the author
About the author

Carlos Gutierrez is a Software Engineer working in the highly competitive world of professional motorsports. His career is focused on data analysis and application development for technical collaboration and decision making. Carlos uses SQL Server, .NET Framework, WPF, UWP, Office 365, R and Azure to build end-to-end solutions for a fast paced, dynamic industry.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Carlos Gutierrez, and welcome to my course, Charting Data with Excel. I'm a software engineer and data analyst, and I'm always looking for effective ways to visualize complex information. Microsoft Excel has been around for over 30 years, but its data visualization capabilities have never been better. This course will start with a few of the most common chart types in Excel, enhance them with interesting features, then move on to the most recent additions. Some of the major topics that we will cover include inserting and changing charts, and there are several ways to do this in Excel; working with multiple data series, which typically adds different colored elements; using trendlines and secondary axes to enhance an existing chart; and creating special chart types like the tree map and box-and-whisker chart. By the end of this course, you'll be able to build a full dashboard of compelling visuals for your data. Before beginning the course, you should be comfortable working with cells and data in worksheets. From here, continue your learning by diving into advanced charting with courses on pivot charts, chart formatting, and chart templates. I hope you'll join me on this journey to learn several interesting chart types with the Charting Data with Excel course at Pluralsight.