Page 15 - Maintenance Course Catalog-MT

data labels; land how to change a chart appearance by how to use ranking formulas to find smallest and
using the chart format tools. Next, learn how to largest values in a list. Next, learn how to extract data
customize individual chart elements in Excel, including and separate values into separate cells; how to
customizing chart axes, moving a chart, and combine existing data values in a single cell; and how
customizing the chart's titles, labels, and axes; how to to analyze complex tables with multiple arrays to
create a chart template if you plan on reusing your obtain summarized results. Continue by observing how
customized chart; and how to present negative values to use VLOOKUP and HLOOKUP formulas to cross-
in a chart. Finally, learn how to insert and customize reference data lists and check for missing values; how
trendlines that can be used for data ranges, to use conditional formulas to perform a search across
movements, or correlations. multiple tables and automatically insert data; and how
to use VLOOKUP formula to cross-reference data lists
MS-E-10 Excel 2019: Custom and Conditional and retrieve corresponding values.
Formatting
MS-E-12 Excel 2019: Finding & Grouping Data

Duration: 47 minutes
To customize data, you can use the built-in formats in Duration: 35 minutes
Excel 2019, or you can use your own. In this 10-video Excel 2019 includes a number of methods for locating,
course, learners will observe how to create custom displaying, and manipulating data entries. In this 8-
formats for numbers, text, and date and time, as well video course, learners observe how to work with
as how to create and use conditional formatting. To specific data using the Find and Replace tools, and
begin, discover how to customize your number manipulate data with the Group and Outline tools.
formats, formatting currency, percentages, and phone Begin by learning how to find items in a worksheet, by
numbers for data values. Next, observe how to using the Find tools to jump to locations in a worksheet
customize your text formats, changing the text format and find items with basic search queries. Then learn
by adding or modifying a text element's appearance; how to use advanced Find tools to customize and refine
create custom color formatting for data entries; and search queries; the Selection tools to locate and select
apply conditional custom formatting to data values. graphical objects in a worksheet; and the Replace tools
Delve into creating conditional format rules to enhance to replace cell contents and formats. Next, examine
your data values display; use conditional formatting to how to use the Find and Replace tools when working
highlight data in cells, rows, and columns; and use specifically with formulas, and use the Freeze tools to
conditional formatting tools to analyze your data change the view settings within a worksheet. Finally,
further. This leads into exploring advanced conditional observe how to group rows and columns in a worksheet
formatting tools, and using these tools to find duplicate and control their display, and use the Group tools to
values or hide values. Conclude the course by create Outlines in a worksheet.
discovering how to organize conditional formatting
rules applied to a worksheet.
MS-E-13 Excel 2019: Forecasting & Solving
MS-E-11 Excel 2019: Finding & Analyzing Problems
Information with Formulas

Duration: 33 minutes
Duration: 37 minutes Discover how to go further with your Excel document
A wide variety of Excel tools can be used to retrieve, through understanding potential formula errors, use
return, and calculate data. In this 9-video course, intelligent data types, and set goals to reach targets as
learners will see how to retrieve date information and well as problem-solve with the Solver and Forecast
rank values, combine and separate data already tools offered by Excel 2019. Key concepts in this 7-video
available, and automate and simplify calculations with course include how to identify formula errors and to
look-up tools and SUMPRODUCT. Key concepts covered understand the wide range of formula error messages;
here include how to extract date values and perform how to check for and evaluate formulas in a workbook;
calculations by using dates; how to retrieve information and how to use formulas to estimate loan-related costs
relating to dates in the past, present, and future; and and help you estimate and managed repayments.

11 | P a g e 1 0 . 1 4 . 2 0