Microsoft Office Specialist: Expert (Office 2019): MO-201: Microsoft Excel Expert (Excel and Excel 2019)
Certification Exam:
- 17 Courses | 11h 26m 15s
- 3 Books | 33h 4m
- 16 Courses | 10h 2m 25s
- 2 Books | 20h 30m
Acquire advanced knowledge of Office programs such as Excel and Word, as you prepare to earn a Microsoft Office Specialist: Expert (Office 2019) certification.
GETTING STARTED
Creating & Saving Workbooks in Excel 2019 for Windows
-
2m 57s
-
4m
GETTING STARTED
Creating, Opening & Saving Documents in Word 2019 for Windows
-
4m 27s
-
3m 35s
COURSES INCLUDED
Creating & Saving Workbooks in Excel 2019 for Windows
Create a new spreadsheet and workbook, with Excel 2019. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save your worksheet or workbook as an Excel version or pdf; and recover unsaved documents. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Examine how to set your print area; adjust your print page layout, and then print your document. Discover how to check for compatibility issues; edit your document properties; and check for personal information in your document. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Saving Workbooks Exercise as well as the associated materials in the Resources section.
15 videos |
1h 3m
Assessment
Badge
Inserting & Manipulating Data in Excel 2019 for Windows
Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.
17 videos |
1h 2m
Assessment
Badge
Using Basic Formulas in Excel 2019 for Windows
Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.
12 videos |
51m
Assessment
Badge
Sharing & Collaborating on a Document in Excel 2019 for Windows
Excel 2019 enables one to easily share documents via email or upload them to OneDrive and SharePoint for team collaboration. During this course, you will learn how to share your spreadsheet, or send it as a .xls or .pdf in Excel. You will learn how to set its editing permissions and send a link. Other topics include how to view your shared documents and save your Excel documents online with OneDrive, so that collaborators can check out a document to prevent others from working on it at the same time. Explore how to coordinate document modification to allow collaborators to make comments, and track document changes. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sharing & Collaborating on a Document Exercise as well as the associated materials in the Resources section.
7 videos |
25m
Assessment
Badge
Custom & Conditional Formatting in Excel 2019 for Windows
To customize data, you can use the built-in formats in 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 as how to create and use conditional formatting. To begin, discover how to customize your number formats, formatting currency, percentages, and phone numbers for data values. Next, observe how to customize your text formats, changing the text format by adding or modifying a text element's appearance; create custom color formatting for data entries; and apply conditional custom formatting to data values. Delve into creating conditional format rules to enhance your data values display; use conditional formatting to highlight data in cells, rows, and columns; and use conditional formatting tools to analyze your data further. This leads into exploring advanced conditional formatting tools, and using these tools to find duplicate values or hide values. Conclude the course by discovering how to organize conditional formatting rules applied to a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Custom & Conditional Formatting Exercise as well as the associated materials in the Resources section.
10 videos |
46m
Assessment
Badge
Finding & Grouping Data in Excel 2019 for Windows
Excel 2019 includes a number of methods for locating, displaying, and manipulating data entries. In this 8-video course, learners observe how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools. Begin by learning how to find items in a worksheet, by using the Find tools to jump to locations in a worksheet and find items with basic search queries. Then learn how to use advanced Find tools to customize and refine search queries; the Selection tools to locate and select graphical objects in a worksheet; and the Replace tools to replace cell contents and formats. Next, examine how to use the Find and Replace tools when working specifically with formulas, and use the Freeze tools to change the view settings within a worksheet. Finally, observe how to group rows and columns in a worksheet and control their display, and use the Group tools to create Outlines in a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Grouping Data Exercise as well as the associated materials in the Resources section.
8 videos |
35m
Assessment
Badge
Referencing Data in Excel 2019 for Windows
Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to create named ranges to refer to data and facilitate calculations; how to use the Name Manager to visualize, edit, and delete existing named ranges; and how to perform calculations using constant values. Finally, learn how to use cell references indirectly; how to monitor data entries for changes and errors; how to activate and configure automatic updates; and how to use formula auditing tools to track data. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Referencing Data Exercise as well as the associated materials in the Resources section.
10 videos |
43m
Assessment
Badge
Forecasting & Solving Problems in Excel 2019 for Windows
Discover how to go further with your Excel document through understanding potential formula errors, use intelligent data types, and set goals to reach targets as well as problem-solve with the Solver and Forecast tools offered by Excel 2019. Key concepts in this 7-video course include how to identify formula errors and to understand the wide range of formula error messages; how to check for and evaluate formulas in a workbook; and how to use formulas to estimate loan-related costs and help you estimate and managed repayments. Continue by learning how to use the Goal Seek tool to modify a data variable and reach a target value; how to use the Solver add-in to analyze constraints and variables and optimize data values; and how to insert a Forecast worksheet to display trends and predictions based on available historic data. Finally, observe how to use Data Tables to create what if, variable-based scenarios, and once created, learn to adjust the values and change the calculation options. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Forecasting & Solving Problems Exercise as well as the associated materials in the Resources section.
7 videos |
33m
Assessment
Badge
Inserting PivotTables in Excel 2019 for Windows
Excel includes powerful tools to summarize, sort, count, and chart data. In this 11-video course, you will learn how to create, edit, and format pivot tables, sort, filter, and group data, and work with slicers and timelines. Key concepts covered in this course include how to create and insert a PivotTable; how to edit the source data and field setup in a PivotTable; how to use predefined styles and formatting tools to change the appearance of a PivotTable; and how to copy and move a PivotTable within a workbook. Next, learn how to use sort tools to change the display of data; how to use filter tools to show and hide data; and how to use label and value filters to analyze data. Finally, learn how to use group tools to sort and analyze related data and use a slicer to filter data; examine how to customize the behavior and appearance of a slicer; and observe how to customize the behavior and appearance of a slicer. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting PivotTables Exercise as well as the associated materials in the Resources section.
11 videos |
31m
Assessment
Badge
Working with Data in PivotTables in Excel 2019 for Windows
Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the Data Model and use them in a PivotTable. Next, learners will examine how to add Calculated fields that use already inserted data; how to use the Value field settings to work with values for comparison calculations; and how to see data from a PivotTable in a PivotChart then customize and format the PivotChart. Finally, because a PivotTable is highly customizable, you will observe how to configure and customize a PivotTable's display and control settings. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Data in PivotTables Exercise as well as the associated materials in the Resources section.
8 videos |
28m
Assessment
Badge
Using Conditional Formulas in Excel 2019 for Windows
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own in this 8-video course. Key concepts covered in this course include how to insert a conditional sum formula to perform a sum calculation on certain data values in your range; how to insert a conditional message formula which can be used to display one message if a condition is met, and another if a condition is not met; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. Learners will continue by observing how to create multiple conditions; how to use IF & OR in conditional formulas; and how to use conditional formulas to count up value occurrences. Finally, you will learn to use reference positions in conditional formulas; and learn how to keep your table up to date with conditional formulas. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Conditional Formulas Exercise as well as the associated materials in the Resources section.
8 videos |
38m
Assessment
Badge
Finding & Analyzing Information with Formulas in Excel 2019 for Windows
A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest values in a list. Next, learn how to extract data and separate values into separate cells; how to combine existing data values in a single cell; and how to analyze complex tables with multiple arrays to obtain summarized results. Continue by observing how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to use conditional formulas to perform a search across multiple tables and automatically insert data; and how to use VLOOKUP formula to cross-reference data lists and retrieve corresponding values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Analyzing Information with Formulas Exercise as well as the associated materials in the Resources section.
9 videos |
36m
Assessment
Badge
Configuring Options & Settings in Excel 2019 for Windows
Get more out of Excel by customizing it to your own needs. In this 10-video course, you will learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Key concepts covered in this course include how to configure your account and services, including connecting multiple services to your account; how to install an add-in, access to manage it, and install add-ins from the Office Ribbon; and how to create a custom template and save that template for future use. Next, you will learn how to configure user and input behavior; how to change default formula and calculation settings; and how to change the workbook default settings. Learners then observe how to customize the way in which workbooks are saved; how to customize the appearance of the Excel application; and how to customize the Quick Access Toolbar and its commands. Finally, learn how to customize the Office Ribbon and its commands. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Configuring Options & Settings Exercise as well as the associated materials in the Resources section.
10 videos |
32m
Assessment
Badge
Managing Data in Excel 2019 for Windows
Excel offers a set of tools that allows you to explore more in detail data analysis and complex formulae. In this 8-video course, you will learn how to use different formulae to make calculations when you have multiple conditions imposed. You will also become able to forecast data by using the NPER function. Key concepts covered in this course include how to import, edit, and update data from a text file; how to import, edit and update data from a .csv file; and how to use the LOOKUP, MATCH, and INDEX functions to extract data. Next, you will learn how to run multiple conditions without nesting other functions; examine how to calculate averages by using one or more conditions; and learn how to calculate the smallest and the largest numbers that meet one or more criteria. Finally, learn how to count cells that meet one or more criteria; and how to calculate the number of periods to pay a loan and forecast loan approval that meet one or more criteria. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Managing Data Exercise as well as the associated materials in the Resources section.
8 videos |
42m
Assessment
Badge
Getting to Know Macros in Excel 2019 for Windows
If you have tasks in Excel 2019 that you do repeatedly, you can record a macro to automate those tasks. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works. Key concepts covered in this 10-video course include how to record macros and perform actions that can be implemented in Excel workbooks, how to save a workbook with macros and an Excel macro-enabled workbook, how to find and use macro tools that are available in multiple locations, and how to add macro recording to your status bar for easy access. Then learn how to navigate the VBA Editor interface, an application easily accessible via Excel, to manage your macros and workbook VBA code; how to manage macros, edit macros, and enable macros in a workbook; and how to access macro security settings and manage macro security options. Finally, you will observe how to use macros across multiple workbooks. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting to Know Macros Exercise as well as the associated materials in the Resources section.
10 videos |
33m
Assessment
Badge
Creating & Editing Macros in Excel 2019 for Windows
In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document. In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Editing Macros Exercise as well as the associated materials in the Resources section.
10 videos |
42m
Assessment
Badge
Working with Macros in Excel 2019 for Windows
If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users. Excel 2019 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Macros Exercise as well as the associated materials in the Resources section.
8 videos |
36m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Creating, Opening & Saving Documents in Word 2019 for Windows
Discover how to create, save, and open documents in Word 2019 in this 16-video course. Learners will observe how to use the Start page interface with its simple layout, giving you access to old and new documents, and how to optimize documents with accessibility and protection tools. You will learn how to change what gets displayed on the Start page through the various options offered by Word 2019. Key topics covered here include how to change a document's orientation from portrait to landscape; how to adjust margins, the blank areas around the contents of a document; and how to change a page size in Word when printing documents other than A4. Next, you will observe how Word allows you to insert information automatically using data fields with Quick Parts. For instance, you can insert a document character or word count, filename or size, and much more-data pulled automatically from properties and added to the text. Learn how to check out a document if you want to make edits without other people making changes. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Creating, Opening & Saving Documents Exercise as well as the associated materials in the Resources section.
16 videos |
58m
Assessment
Badge
Editing Documents in Word 2019 for Windows
In this 17-video course, learners will explore Word's primary function: adding text to a document. Typing, manipulating, and double-checking your text for accuracy is made easy with World 2019's intuitive text tools. Learn how to choose where to insert text, then navigate or remove that text with the keyboard. Learners will observe how to use special characters, advanced AutoCorrect tools, and predefined AutoText items to build out a document quickly. Key topics covered here include how to move and reposition text paragraphs manually; other ways to move words, lines, and paragraphs; and the helpful use of keyboard shortcuts; and practical uses of the undo function, which allows replacement of deleted pictures, paragraphs, and headings with the originals if you change your mind. Learn how to save various versions of a document so that you can choose which version to keep. Continue by observing how to configure your Spell Check feature, by choosing words to add to your dictionary, manage your dictionary settings, and confirming that the set language matches the language you are typing in. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Editing Documents Exercise as well as the associated materials in the Resources section.
17 videos |
1h 4m
Assessment
Badge
Formatting Documents in Word 2019 for Windows
Discover how to use Word 2019's formatting tools to personalize a document's properties in this 20-video course. Word allows users to change the font, size, and formatting such as bold, italic, and underline options, all giving the user greater control over the look and feel of a document. Key topics covered here include how to change the font, size, and formatting of a document, and how to use bold, italic, and underlining options effectively. First, observe how to use color, effects, and intuitive alignment tools to transform text quickly and give the document a more readable appearance. Learn about the use of such tools as double strikethrough and small caps checkboxes. Then learn how to apply multiple formatting tools simultaneously in the same way. Continue by learning how to use Themes in Word, which combine different elements in text styles, WordArt, SmartArt, and other features. You will also learn how to change paragraph spacing, using presets varying from Compact to more Open spacing, and how to set your theme as default. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Formatting Documents Exercise as well as the associated materials in the Resources section.
20 videos |
1h 19m
Assessment
Badge
Using Find & Replace Tools in Word 2019 for Windows
In this 7-video course, learners will explore handy tools allowing them to jump to essentially any point in a document. Discover how to navigate between pages or lines with the Go To tool or jump through headings by using the Navigation Pane. Key topics covered here include how to use wildcard codes to perform approximate searches in Word; how to search for variable spellings, specific prefixes, and even half-complete numbers; and how to use the Advanced Search options, which allow you to specify the word's case or format and even search for prefixes, suffixes or multiple forms of your search query. Observe how to define replacement text to allow quick changes to a document. Learn the special uses of symbols-including asterisks, square brackets, and exclamation points-to simplify a search. Continue by observing how to use Word Replace function to make systematic changes to a document's text-such as replacing double hyphens with em dashes, or replacing French-style quotation marks with normal quotation marks. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Using Find & Replace Tools Exercise as well as the associated materials in the Resources section.
7 videos |
25m
Assessment
Badge
Sharing & Collaborating on a Document in Word 2019 for Windows
Learners can explore how to share documents via e-mail or upload them to OneDrive and Sharepoint to collaborate with other team members, in this 10-video course. Word 2019 allows users to send documents via links, by choosing with whom to share the link and even adjust editing permission; this Word version comes with a chat feature to communicate with others in real time. Before sending a document via link, it must first be saved to OneDrive. Learn how to work collaboratively with multiple people, meaning that changes made by others to your document will be highlighted in your version so you can keep track of any updates. Continue by observing how to use inking tools in Word, with the Draw tab, to add artistic elements to documents; how to use different pens and tools available in this tab; and when you must use either a touch-screen device or a plug-in device allowing use of a stylus. Learn when you should install drivers or perform updates for this to work properly with Word. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Sharing & Collaborating on a Document Exercise as well as the associated materials in the Resources section.
10 videos |
37m
Assessment
Badge
Structuring Documents in Word 2019 for Windows
This 8-video course helps learners master the art of shaping a Word 2019 document by using sections, headers, and footers to set off ideas more clearly, and how to insert page numbers in a document. First, learn how to use page breaks skillfully-by moving titles for a new chapter onto the page where the chapter text begins, for instance-and how to use a keyboard shortcut to accomplish this. Key topics covered in this course include how to create and insert custom information in Word's headers and footers; how to save and reuse a header, and insert it into other documents; and how to customize paragraph outlines and the color, style, thickness, and locations of borders. Observe how to use the border and fill tools to apply colors to your document and design interesting borders to make your document more attractive. Next, learn the various ways you can change the page color and surrounded text with a border-with the paragraph tool set or the Design tab. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Structuring Documents Exercise as well as the associated materials in the Resources section.
8 videos |
30m
Assessment
Badge
Shaping Documents in Word 2019 for Windows
Word 2019 offers users a series of advanced tools to help your readers find the information they need from your document. In this 10-video course, learners can explore ways to structure text to make it more readable. First, use cover pages, tables of contents, and Quick Parts to set out your ideas more clearly. You will observe simple but effective ways to craft a cover page, always a good way to give a brief, but relevant, summary of your document. Next, learn how to create an effective table of contents, giving your reader a great way to navigate your document; if your document is formatted properly with titles and subtitles, this can be done quickly without manual insertions, but you must confirm that the headings have been formatted correctly. Key topics covered here include how to insert bookmarks and captions, or short descriptions that help readers identify contents of an illustration, graph, or table; using the cross-reference function; and planning and restructuring your document. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Shaping Documents Exercise as well as the associated materials in the Resources section.
10 videos |
41m
Assessment
Badge
Illustrating Documents in Word 2019 for Windows
The old adage-a picture is worth a thousand words-is still worth following, for mages and illustrations often get a point across more effectively than text alone. This 11-video course allows learners to explore the many effective tools offered by Word 2019 to amplify text with images, videos from online and local locations, and custom equations. Learn how to create hyperlinks to other sources of information as a guide to your reader. Key topics covered here include the use of universally recognized icons available in Word; various toolsets to help you choose the appropriate image; and how to use the Image styles feature. Observe how to adjust the text wrapping options of your document, if it contains images, figures or icons; images can be treated like words, surrounded by text, placed behind or in front of text and more. Learn practical methods for inserting a 3D model into your document-either from Word's collection or your own assembled file-and inserting watermarks, to indicate whether it is official or confidential. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Illustrating Documents Exercise as well as the associated materials in the Resources section.
11 videos |
38m
Assessment
Badge
Creating Graphics & Diagrams in Word 2019 for Windows
Word 2019's graphics tools allow users to create charts and diagrams to add visual impact to documents. This 8-video course demonstrates how to build diagrams, insert customizable SmartArt graphics, and transform data by using different chart types. Key topics covered here include how to use the Selection Pane to manage the objects in your document; how to organize your objects from the Selection Pane by reordering them or get a clear overview by hiding or showing certain objects; and how to create a drawing canvas, which provides a great way to group several shapes or objects. Once placed inside a canvas, several objects can then be treated as one large object. Observe how to insert a SmartArt graphic, by using the Word tool to add a professional-looking graphic to a document; these graphics are predefined shape-based diagrams, but are also highly customizable. Then learn how to format your SmartArt graphic to make it stand out with different shapes, styles, and text effects. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Creating Graphics & Diagrams Exercise as well as the associated materials in the Resources section.
8 videos |
31m
Assessment
Badge
Adding Data & Calculations in Word 2019 for Windows
This 7-video course explores how to enrich a Word 2019 document by inserting content, charts, equations, and how to add data from an Excel spreadsheet. You will learn how to access the AutoText and Quick Parts galleries to save and easily insert frequently used items or groups of items into other documents. Then you will learn to use for AutoText for smaller items like names or numbers, while Quick Parts is used for larger items like graphics. Continue by learning how to insert equations directly into Word by copying an equation from an online source, inserting it from one of the presets, or by creating your own equation. Learners will observe how to customize a chart, and manage the data table without using a separate spreadsheet application. You will observe how to customize a chart by using Word's presets, and alter individual elements to give your chart a personal style. Finally, you will learn how to insert charts and tables from Excel to Word. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Addind Data & Calculations Exercise as well as the associated materials in the Resources section.
7 videos |
27m
Assessment
Badge
Using Table Tools in Word 2019 for Windows
Learners can explore how to structure data in a Word 2019 document by using table tools, in this 9-video course which demonstrates how to create a table from scratch, convert prepared text into a table, or import a table. Explore how to modify a table by adding rows and columns. Once you have inserted a table, you will learn to change its appearance, and how data can be formatted like any other text with Word's formatting tools. This course then demonstrates how to add and adjust the width, style, and color of borders. You will learn how to apply color to individual cells or tables. Next, learners will observe how to adjust alignment settings, move tables, and change how text interacts with a table. If a table contains a large amount of data, you will learn how to sort data on the basis of different criteria to make the table visually easier to read and understand. Finally, this course demonstrates how Word allows you to perform calculations within the table you inserted. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Using Table Tools Exercise as well as the associated materials in the Resources section.
9 videos |
29m
Assessment
Badge
Using Research Tools in Word 2019 for Windows
This 8-video course explores Smart Lookup, which can be used to organize your information in a document, using a suite of tools available in Word 2019. You will learn how to use Smart Lookup to research a word, automatically have Bing provide you with definitions, find more information, and extra content about that word. You will then learn how to create a bibliography, and insert citations using the Citations and Bibliography toolset. The course next demonstrates how to create a database of articles, books, and journals which can then be used to insert sources quickly and efficiently. You will learn how to use the built-in translator tool, which will translate individual words, full sections, and even whole documents. You will learn to how to insert and format line numbers. Learners will observe how to use the footnotes tool, and the footnote style outbox launcher to format, customize, and manage footnotes that will be included in a document. Finally, this course demonstrates how to insert endnotes, and how to convert endnotes into footnotes. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Using Research Tools Exercise as well as the associated materials in the Resources section.
8 videos |
24m
Assessment
Badge
Creating Forms in Word 2019 for Windows
Explore how to use and reuse forms in Word 2019 in this 5-video course. Word has thousands of pre-formatted forms available for download, and you will learn to use them to create forms for specific requirements. You will also observe how to use Navigation Pane to create a form, for instance, for a quotation, by using Word's built-in templates. You will learn how to save a form you have customized as a template for future use. Next, you will learn how to create drop-down menus within a word document, if you are creating a survey, for example. The document with the drop-down menu will be available to anyone who has been sent the document. This course continues by demonstrating how to use multiple choice lists in a form, and how to customize the appearance of the list. Finally, if you are sharing a form or survey, you will learn how to protect it from unauthorized changes, which will allow users to add answers, but not to modify the questions or other elements. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Creating Forms Exercise as well as the associated materials in the Resources section.
5 videos |
18m
Assessment
Badge
Creating Bulk Mailings in Word 2019 for Windows
This 9-video course explores the bulk mail tools available in Word 2019. You will learn how to use the envelope creation tool to insert addresses, format the style, and place addresses on an envelope. You will then learn how to create address labels, and how to change the margins and dimensions. Next, you will learn to use the Mail Merge function, which allows data from a mailing list to be incorporated into a document when you send bulk e-mails or letters. You will learn to create a list of addresses and contact information in Word for a mail merge document, and to import a mailing list from an Excel spreadsheet or MS Access file to use in a mail merge. Continue by learning how to edit, sort data, filter, and search your data in a contact list. You will learn to create bulk e-mails or letters with multiple recipients. Finally, the course demonstrates how to create simple rules to change elements, for example, a greeting in a letter. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Creating Bulk Mailings Exercise as well as the associated materials in the Resources section.
9 videos |
30m
Assessment
Badge
Configuring the Application in Word 2019 for Windows
Learners can explore ways to customize every aspect of the Word 2019 application, from the interface and language, to input and save options, in this 10-video course. You will learn how to manage security preferences, connect services, and application updates from your account page. Then you will explore Add-ins, extensions that can be installed to increase productivity, and how to install, deactivate, and delete Add-ins. You will continue by examining some of Word's advanced options to modify many of the program's display settings. You will also observe how to customize Word's user and input behavior, including the Mini Toolbar, and instant previews to improve your performance. When working with or switching between languages, learners will observe how to access and update language settings in Word. You will learn how to adjust print options to print a document in draft form, adjust scale settings, and how to print a double-sided document. Finally, examine the Office ribbon, the most important element in Word, which has all the tools used when creating a document. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Configuring the Application Exercise as well as the associated materials in the Resources section.
10 videos |
33m
Assessment
Badge
Opening & Setting Up in Word 2019 for Windows
Discover the basics of your favorite word processor. This course shows you how to navigate the features and functions of Microsoft Word 2019. Find Microsoft Word on the Windows Start menu or find it pinned on the task bar. You can also find Microsoft Word 2019 through a search of the system or open it directly from a desktop shortcut. Familiarize yourself with the app's interface and navigation pane. See different view modes as well as the Read Mode. Learn how to zoom and scroll through your document and work on multiple documents at the same time. In order to practice what you have learned, you will find the Word document named Word 2019 for Windows: Opening & Setting Up Exercise as well as the associated materials in the Resources section.
8 videos |
29m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Excel 2019 BibleWhether you are just starting out or an Excel novice, this complete, easy-to-navigate resource is your comprehensive, go-to guide for all your Excel 2019 needs.
15h 14m
By Dick Kusleika, John Walkenbach, Michael Alexander
Book
Excel 2019 All-in-One for DummiesExcel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here!
14h 40m
By Greg Harvey
Book
Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth EditionEasy-to-understand with numerous step-by-step instructions, this book's extensive examples and the latest tips, worksheets, and shortcuts make it an excellent resource for all Excel users who want to understand, create, and apply formulas.
3h 10m
By Bernd Held, Brian Moriarty, Theodor Richardson
BOOKS INCLUDED
Book
Microsoft Word 365 Complete: In Practice, 2019Offering a fresh approach to teaching today's students Microsoft Word, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
17h 10m
By Randy Nordell
Book
Teach Yourself VISUALLY Word 2019Master one of the most popular word processors ever with this essential, visual reference which includes full-color, step-by-step instructions showing you how to perform all the essential tasks of Microsoft Word 2019.
3h 20m
By Guy Hart-Davis
