5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Desktop Certifications     Microsoft     Microsoft Office Specialist: Expert (Office 365 and Office 2019)     MO-201: Microsoft Excel Expert (Excel and Excel 2019)

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.



Objectives

Excel 2019 for Windows: Creating Charts & Graphics

  • 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
  • Knowledge Check: Creating Charts & Graphics