Page 14 - Admin Course Catalog_LS

accessible document, and how to protect your how to move between documents, allowing work on
document. multiple documents simultaneously while using a
number of tools to organize a workspace.
ST-MS-E-02 Excel 2019 for Windows:
Formatting Data ST-MS-E-04 Excel 2019 for Windows:
Illustrating Documents

Duration: 50 minutes
Jr. Category: n/a Duration: 31 minutes
Formatting data makes it easier to see and work with. Jr. Category: n/a
In this 14-video course, you will discover how you can An Excel 2019 worksheet can contain more than just
align data, use colors and themes, resize rows and numbers and text. In this 7-video course, "Excel 2019:
columns, and insert tables and borders in Excel 2019 Illustrating Documents," learners will discover how to
to change data presentation. Learners will begin by insert and edit images, screenshots, and shapes, insert
observing how to set a data type, and then format hyperlinks, and use the new Smart Lookup feature.
their data, the tools of which can be used to change Begin by learning how to insert an image or
the appearance of text in tables. Then move on to photograph, which can be used to illustrate your
aligning your data, by using tools to change where text table, and then learn how to insert a screenshot.
appears within its respective cell. Next, observe how Discover how to edit an image once it has been
to use colors, which can help data stand out for the inserted into your Excel spreadsheet. You can adjust
reader and make the table easier to read. Discover its brightness, contrast, saturation levels, and also
how to change the cell style; use document themes apply a variety of different artistic effects or add a
and use formulas to modify the text case. Explore how border. Learners can also observe how to create
to create clean, professional looking titles, and format diagrams by using shapes and insert icons to help
titles to make them presentable. Create tables to ease illustrate a worksheet. There are several different
organization; resize columns and rows; insert borders, types of links that can be inserted into your document,
and columns and rows. Conclude the course by including hyperlinks. Finally, learners will explore how
observing how to transfer format styles. to use the Smart Lookup tool in Excel to quickly access
additional information about words used in a
ST-MS-E-03 Excel 2019 for Windows: Getting document.
Started
ST-MS-E-05 Excel 2019 for Windows:
Inserting & Manipulating Data
Duration: 22 minutes
Jr. Category: n/a
Excel 2019 is the spreadsheet application in the Duration: 1 Hour 3 minutes
Microsoft Office 2019 suite. In this 5-video course, Jr. Category: n/a
"Excel 2019: Getting Started," learners are able to Excel contains a number of features to aid in data
explore the interface and some of its features, insertion and manipulation. In this 17-video course,
including the ribbon, status bar, zoom, and various learners can explore various ways to insert, edit, and
view modes. Begin the course by learning how to find manipulate data, including undo and redo, Flash Fill,
the application on the desktop and open it. To get the spell check, and transposing a data range. Begin by
most out of Excel, you need to understand how the learning how to select cells in order to apply changes
interface is laid out, so the course next explores the to individual or multiple cells. Then learners will
application. This leads into the zoom function, which discover different ways of inserting, editing, and
can be used to adjust how to visualize the spreadsheet replacing data in a spreadsheet, and observe how to
in Excel by making data entries larger in order to focus insert special characters. The course continues by
more precisely, or pull away from your data to get an demonstrating how to edit multiple worksheets
overall view of a spreadsheet and its structure. simultaneously; delete items in a spreadsheet; and
Examine mode views, which in Excel features three how to use the undo and redo actions. Explore how to
different preset view modes: Normal, Page Layout, create automatic data series; use the Flash Fill feature
and Page Break. Conclude the course by observing and insert dropdown menus. Delve into configuring

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