Page 15 - Admin Course Catalog_LS

the spell check and autocorrect options, transferring, want to find out where a particular value places on a
and copying and pasting data. Complete this course by list of data entries. Examine rounding a number, to
observing how to move data from one worksheet to round up or down your data values. Use replacement
another and transpose a data range. formulas when you need to make changes; convert
number types and factorize the results of a division.
ST-MS-E-06 Excel 2019 for Windows: Sharing Conclude the course by observing how to create
& Collaborating on a Document random values.

ST-MS-E-08 Excel 2019 for Windows:
Duration: 26 minutes Configuring Options & Settings
Jr. Category: n/a
In this 7-video course, "Excel 2019: Sharing and
Collaborating on a Document," learners will discover Duration: 33 minutes
how Excel 2019 enables one to easily share Jr. Category: n/a
documents via email or upload them to OneDrive and Get more out of Excel by customizing it to your own
SharePoint to collaborate with a team. Stay in the loop needs. In this 10-video course, you will learn how to
with document comments, version history, and track manage your account, connected services, and add-
change tools. Begin by learning how you can use the ins; configure input, template, and formula options;
integrated email function to send your Excel and customize the interface, ribbon, and Quick Access
spreadsheet to other users via email. The email is Toolbar. Key concepts covered in this course include
quickly created, email recipients can be adjusted, and how to configure your account and services, including
different formats can be selected, including XLS and connecting multiple services to your account; how to
PDF. Next, learners will discover how to share install an add-in, access to manage it, and install add-
workbooks via a link. You can also choose editing ins from the Office Ribbon; and how to create a
permissions. This leads into managing link access and custom template and save that template for future
permissions, with which you can change editing use. Next, you will learn how to configure user and
permissions for a link to be more restrictive or open. input behavior; how to change default formula and
Explore how to save your documents to OneDrive; calculation settings; and how to change the workbook
which is used to store files online; manage a default settings. Learners then observe how to
workbook's version history, and comment on a customize the way in which workbooks are saved;
document. Finally, observe how to follow and track how to customize the appearance of the Excel
document changes. application; and how to customize the Quick Access
Toolbar and its commands. Finally, learn how to
ST-MS-E-07 Excel 2019 for Windows: Using customize the Office Ribbon and its commands.
Basic Formulas
ST-MS-E-09 Excel 2019: Creating Charts
&Graphics
Duration: 52 minutes
Jr. Category: n/a
The power of Excel 2019 is the support provided for Duration: 35 minutes
using formulas on your data. In this 12-video course, Jr. Category: n/a
learners will observe how to work with formulas, Analyze and present your data in a more visually
including built-in formulas such as SUM and COUNT, attractive manner in Excel 2019. Excel features several
perform rounding and ranking, and generate random different chart types, each of which can be customized
numbers. You will begin by discovering how to insert a to suit your needs. In this 9-video course, you will
formula by using the function library, and then learn how to insert and customize charts; to create
perform simple calculations within an individual cell. chart templates and work with different chart types;
Explore how to use automated formulas in a table; and how to use trendlines. Key concepts covered in
create automated cumulative tools; and insert this course include how to insert, edit, and remove
subtotals. Following on from this, you will learn how charts; how to customize chart labels including adding
to count cells in a range by using different formulas, a chart title and data labels; land how to change a
and then rank values, which is extremely useful if you chart appearance by using the chart format tools.

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