Page 14 - Maintenance Course Catalog_MT

different ways of inserting, editing, and replacing data how to use automated formulas in a table; create
in a spreadsheet, and observe how to insert special automated cumulative tools; and insert subtotals.
characters. The course continues by demonstrating Following on from this, you will learn how to count cells
how to edit multiple worksheets simultaneously; in a range by using different formulas, and then rank
delete items in a spreadsheet; and how to use the undo values, which is extremely useful if you want to find out
and redo actions. Explore how to create automatic data where a particular value places on a list of data entries.
series; use the Flash Fill feature, and insert dropdown Examine rounding a number, to round up or down your
menus. Delve into configuring the spell check and data values. Use replacement formulas when you need
autoCorrect options; transferring, and copying and to make changes; convert number types, and factorize
pasting data. Complete this course by observing how to the results of a division. Conclude the course by
move data from one worksheet to another, and observing how to create random values.
transpose a data range.
MS-E-08 Excel 2019 for Windows:
MS-E-06 Excel 2019 for Windows: Sharing & Configuring Options & Settings
Collaborating on a Document

Duration: 33 minutes
Duration: 26 minutes Get more out of Excel by customizing it to your own
In this 7-video course, "Excel 2019: Sharing and needs. In this 10-video course, you will learn how to
Collaborating on a Document," learners will discover manage your account, connected services, and add-ins;
how Excel 2019 enables one to easily share documents configure input, template, and formula options; and
via email or upload them to OneDrive and SharePoint customize the interface, ribbon, and Quick Access
to collaborate with a team. Stay in the loop with Toolbar. Key concepts covered in this course include
document comments, version history, and track change how to configure your account and services, including
tools. Begin by learning how you can use the integrated connecting multiple services to your account; how to
email function to send your Excel spreadsheet to other install an add-in, access to manage it, and install add-
users via email. The email is quickly created, email ins from the Office Ribbon; and how to create a custom
recipients can be adjusted, and different formats can template and save that template for future use. Next,
be selected, including XLS and PDF. Next, learners will you will learn how to configure user and input
discover how to share workbooks via a link. You can behavior; how to change default formula and
also choose editing permissions. This leads into calculation settings; and how to change the workbook
managing link access and permissions, with which you default settings. Learners then observe how to
can change editing permissions for a link to be more customize the way in which workbooks are saved; how
restrictive or open. Explore how to save your to customize the appearance of the Excel application;
documents to OneDrive; which is used to store files and how to customize the Quick Access Toolbar and its
online; manage a workbook's version history, and commands. Finally, learn how to customize the Office
comment on a document. Finally, observe how to Ribbon and its commands.
follow and track document changes.
MS-E-09 Excel 2019: Creating Charts
MS-E-07 Excel 2019 for Windows: Using Basic &Graphics
Formulas

Duration: 35 minutes
Duration: 52 minutes Analyze and present your data in a more visually
The power of Excel 2019 is the support provided for attractive manner in Excel 2019. Excel features several
using formulas on your data. In this 12-video course, different chart types, each of which can be customized
learners will observe how to work with formulas, to suit your needs. In this 9-video course, you will learn
including built-in formulas such as SUM and COUNT, how to insert and customize charts; to create chart
perform rounding and ranking, and generate random templates and work with different chart types; and how
numbers. You will begin by discovering how to insert a to use trendlines. Key concepts covered in this course
formula by using the function library, and then perform include how to insert, edit, and remove charts; how to
simple calculations within an individual cell. Explore customize chart labels including adding a chart title and

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