Page 17 - Admin Course Catalog_LS

and to understand the wide range of formula error worksheet; how to use data across multiple
messages; how to check for and evaluate formulas in a worksheets to reference data for formulas; and how
workbook; and how to use formulas to estimate loan- to define absolute and relative cell references. Next,
related costs and help you estimate and managed you will learn how to create named ranges to refer to
repayments. Continue by learning how to use the Goal data and facilitate calculations; how to use the Name
Seek tool to modify a data variable and reach a target Manager to visualize, edit, and delete existing named
value; how to use the Solver add-in to analyze ranges; and how to perform calculations using
constraints and variables and optimize data values; constant values. Finally, learn how to use cell
and how to insert a Forecast worksheet to display references indirectly; how to monitor data entries for
trends and predictions based on available historic changes and errors; how to activate and configure
data. Finally, observe how to use Data Tables to create automatic updates; and how to use formula auditing
what if, variable-based scenarios, and once created, tools to track data.
learn to adjust the values, and change the calculation
options. ST-MS-E-16 Excel 2019: Sorting and Filtering
Data
ST-MS-E-14 Excel 2019: Inserting PivotTables

Duration: 38 minutes
Duration: 32 minutes Jr. Category: n/a
Jr. Category: n/a The first step in analyzing the data in a worksheet is
Excel includes powerful tools to summarize, sort, often taken with Excel's sorting and filtering tools.
count, and chart data. In this 11-video course, you will These tools help you to control what is displayed in
learn how to create, edit, and format pivot tables, your data range, and how the values are organized.
sort, filter, and group data, and work with slicers and Key concepts covered in this 10-video course include
timelines. Key concepts covered in this course include how to sort data in a worksheet according to a specific
how to create and insert a PivotTable; how to edit the data type; how to customize sort options when sorting
source data and field setup in a PivotTable; how to use data in a worksheet and sort data by using multiple
predefined styles and formatting tools to change the criteria and sort levels; and how to create and use
appearance of a PivotTable; and how to copy and custom sort lists to sort data. Next, learn how to use
move a PivotTable within a workbook. Next, learn how column filters to filter data in a worksheet; to use
to use sort tools to change the display of data; how to column filters to apply multiple filters to data in a
use filter tools to show and hide data; and how to use worksheet; and to create filter arguments by using
label and value filters to analyze data. Finally, learn text and number data types. Finally, you will learn to
how to use group tools to sort and analyze related sort and filter data by using colors applied to data;
data and use a slicer to filter data; examine how to learn to use the advanced filter tools to filter and
customize the behavior and appearance of a slicer; extract data; and learn to use filter tools to hide
and observe how to customize the behavior and duplicate values in a data range.
appearance of a slicer.
ST-MS-E-17 Excel 2019: Using Conditional
ST-MS-E-15 Excel 2019: Referencing Data Formulas

Duration: 44 minutes
Duration: 39 minutes
Jr. Category: n/a Jr. Category: n/a
Manipulating data in Excel begins with knowing how Conditional formulas let you perform a calculation on
to reference cells. This involves using cell coordinates a range of values by specifying the criteria the data
to extract the specified cells value. You can reference
must meet. Discover how to use built-in conditional
individual cells, a range of cells and entire columns formulas and create your own in this 8-video course.
and rows. In this 10-video course, you will discover Key concepts covered in this course include how to
absolute and relative cell references, by using data insert a conditional sum formula to perform a sum
across multiple worksheets, and formula auditing in calculation on certain data values in your range; how
Excel 2019. Key concepts covered in this course
to insert a conditional message formula which can be
include how to reference cells in your Excel

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