Creating Charts & Graphics in Excel 2019 for Windows
Excel 2019 (Windows)
| Intermediate
- 9 videos | 34m 4s
- Includes Assessment
- Earns a Badge
- CPE
Analyze and present your data in a more visually attractive manner in Excel 2019. Excel features several different chart types, each of which can be customized to suit your needs. In this 9-video course, you will learn how to insert and customize charts; to create chart templates and work with different chart types; and how to use trendlines. Key concepts covered in this course include how to insert, edit, and remove charts; how to customize chart labels including adding a chart title and data labels; land how to change a chart appearance by using the chart format tools. Next, learn how to customize individual chart elements in Excel, including customizing chart axes, moving a chart, and customizing the chart's titles, labels, and axes; how to create a chart template if you plan on reusing your customized chart; and how to present negative values in a chart. Finally, learn how to insert and customize trendlines that can be used for data ranges, movements, or correlations. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating Charts & Graphics Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
Insert a chart
Label a chart
Format a chart
Customize a chart
Customize chart axes -
Create a chart template
Present negative values in a chart
Insert trendlines
Customize trendlines
IN THIS COURSE
-
3m 51sCharts can be used to analyze and present your data in a visually attractive manner. Excel comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
-
3m 39sYour Excel charts will often contain a large amount of information. You can make your charts easier to read by adding and adjusting different information elements, including labels, legends and titles. These elements can all be moved, resized and formatted. FREE ACCESS
-
3. Formatting a chart in Excel 2019 for Windows5m 37sOnce you have created your chart in Excel, you can begin to change its appearance by using the formatting tools. You can, for example, change the color setup for each element, adjust the font styles of any text item that you have added, and change the overall visual style of your chart. FREE ACCESS
-
4. Customizing your charts in Excel 2019 for Windows3m 56sIn this tutorial you'll see how to customize your chart titles to adapt their overall design and display to your spreadsheet. FREE ACCESS
-
5. Customizing your chart axes in Excel 2019 for Windows5m 15sYour chart axes can be modified to display a large amount of information. In Excel, you can adjust the measurement unit, move the maximum and minimum values, and even change where the two axes cross in the chart. FREE ACCESS
-
6. Creating a chart template in Excel 2019 for Windows2m 12sYour chart axes can be modified to display a large amount of information. In Excel, you can adjust the measurement unit, move the maximum and minimum values, and even change where the two axes cross in the chart. FREE ACCESS
-
7. Presenting negative values in your chart in Excel 2019 for Windows2m 51sIf your chart contains negative values, your Excel chart will need to be adjusted. Once your chart contains negative values, you can change the way in which these individual values are formatted and arranged on your axis. FREE ACCESS
-
8. Inserting trendlines in Excel 2019 for Windows3m 48sIn Excel, you can insert miniature charts that track the overall trend of a data series. These are called SparkLines and they can help your reader to grasp the general progression of your data series. FREE ACCESS
-
9. Customizing your trendlines in Excel 2019 for Windows2m 54sSparkLines that have been inserted into your Excel worksheet can be formatted. You can adjust the color scheme that is applied, activate and deactivate different data points, and even visualize negative values in your trends. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
