Description:
Analyze and present your Excel data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to edit a chart's data series and customize the chart's titles, labels, and axes. You will also see how to save a chart type or chart formatting choice as a template to make it easier to use and include in future spreadsheets.
Target Audience:
Duration: 00:30
Description:
You can analyze and present your Excel 365 data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to customize individual chart elements, including customizing chart axes, moving or combining two types of chart, and customizing the chart's titles, labels, and axes. You will also explore how to insert and customize trendlines that can be used for data ranges, movements, or correlations; as well as how to add and modify Sparklines, which are at-a-glance visualizations.
Target Audience:
Duration: 00:32
Description:
An Excel 365 worksheet can contain more than just numbers and text. In this course, you will discover how to make your worksheets more visually appealing using hyperlinks, images, screenshots, shapes, icons, special characters, as well as colors and themes. Start by learning how to insert an image or photograph, which can be used to illustrate your data, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You will then explore how to adjust an image's brightness, contrast, saturation levels, apply a variety of artistic effects and even add a border. You can also create diagrams using shapes and insert icons to help illustrate a worksheet. You will explore the different types of links and hyperlinks you can insert into your document. You will learn how to insert special characters into a cell and see how to use colors and themes to help data stand out and make a table easier to read. Also, you will discover how to create and edit clean, professional-looking titles with WordArt.
Target Audience:
Duration: 00:39
Description:
Discover how to go further with your Excel 365 content by understanding the potential for formula errors. See how to use error checking and formula auditing tools, use the Goal Seek tool to let Excel 365 update variables for a formula to meet a specific outcome, and use the Watch Window tool to monitor data entries stored in different locations. Key concepts in this course include how to identify formula errors and understand the wide range of error messages. You will also learn how to check for and evaluate formulas in a workbook and how to use the Goal Seek tool to change constraints and variables to optimize your data values accordingly. Finally, you will explore how to use the Watch Window tool to monitor specific data entries, even from other workbooks.
Target Audience:
Duration: 00:17
Description: In Excel 365, manipulating data requires knowing how to reference cells. This involves using cell coordinates to extract a specified cell's value. You can reference individual cells, a range of cells, or entire columns and rows.
In this course, you will learn about absolute and relative cell references and how to use data references across multiple worksheets. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to work with named ranges to refer to data and facilitate calculations, how to use cell references indirectly, and how to perform calculations using constant values.
Target Audience:
Duration: 00:22