Page 16 - Admin Course Catalog_LS

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

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

ST-MS-E-13 Excel 2019: Forecasting & Solving
Duration: 37 minutes Problems
Jr. Category: n/a
A wide variety of Excel tools can be used to retrieve,
return, and calculate data. In this 9-video course, Duration: 33 minutes
learners will see how to retrieve date information and Jr. Category: n/a
rank values, combine and separate data already Discover how to go further with your Excel document
available, and automate and simplify calculations with through understanding potential formula errors, use
look-up tools and SUMPRODUCT. Key concepts intelligent data types, and set goals to reach targets as
covered here include how to extract date values and well as problem-solve with the Solver and Forecast
perform calculations by using dates; how to retrieve tools offered by Excel 2019. Key concepts in this 7-
information relating to dates in the past, present, and video course include how to identify formula errors

12 | P a g e v 1 0 . 2 . 2 0