Microsoft Office Specialist: Associate (Office 2019): MO-200: Microsoft Excel (Office 2019)
Certification Exam:
- 14 Courses | 9h 13m 22s
- 3 Books | 14h 56m
- 14 Courses | 8h 52m 44s
- 3 Books | 15h 24m
- 17 Courses | 10h 52m 33s
- 8 Books | 55h 6m
Acquire knowledge of Office programs such as Excel, Word, and PowerPoint as you prepare to earn a Microsoft Office Specialist: Associate (Office 2019) certification.
GETTING STARTED
Opening & Setting Up in Word 2019 for Windows
-
3m 30s
-
4m 31s
GETTING STARTED
Getting Started with PowerPoint 2019 for Windows
-
4m 28s
-
5m 21s
GETTING STARTED
Getting Started in Excel 2019 for Windows
-
3m 14s
-
6m 43s
COURSES INCLUDED
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
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
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
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Getting Started with PowerPoint 2019 for Windows
Create presentations quickly using PowerPoint 2019 for Windows. Key concepts covered in this course include how to open the app from the Search bar or the Start menu, or pin the app to your taskbar for quicker access. Learners will observe how to use the variety of different tools such as the Office tool ribbon to operate key menus and functions and different ways of navigating and visualizing presentation slides. There are also topics on how to activate rulers and gridlines to align and adjust slide elements. Conclude by discovering how to handle several documents at the same time and move between open windows and presentations.
6 videos |
24m
Assessment
Badge
Creating Presentations in PowerPoint 2019 for Windows
Create your slides, and finesse them like a pro. Discover how to use themes, create and manipulate slides, and work with slide elements in PowerPoint 2019, in this 13-video course. Key concepts covered here include how to create and edit a new presentation; how to use themes and templates to create presentations; and how to specify the preset layout that can be applied when you insert a new slide. Begin by learning how to insert slides from an existing presentation; how to adjust a slide layout to add structure to your presentation and insert text elements and objects into the presentation automatically; and how to add slides quickly and easily move them around in presentations. Next, learn how to create a template from scratch which can be used to speed up the creation process; how to create sections to help structure your presentation; and how to use headers and footers. Finally, observe how using Master mode allows changes to the overall appearance of your presentation and changes to multiple slides at once.
13 videos |
53m
Assessment
Badge
Saving Presentations in PowerPoint 2019 for Windows
Explore the methods for saving, backing up, exporting, and protecting PowerPoint 2019 presentations. Key concepts in this 15-video course include how to save presentations; how to back up and recover presentations; and how to save your presentation as a PDF, a good format for sharing presentation. Begin by observing how to create a video presentation and run a slideshow automatically; how to create a presentation package, a tool which allows you to export elements you will need to deliver your presentation; and how to create a version of your presentation in Word. Next, learn how to use PowerPoint to check for compatibility issues that might be present in your document and help you correct them; how to edit your presentation properties; and how to access and configure layouts to adjust the print page layout. Finally, learn how to check for personal and confidential information in your presentation using the Document Inspector feature; how to protect presentations by adding password encryption; and how to use Compare function to differentiate multiple versions of a presentation.
15 videos |
1h 6m
Assessment
Badge
Inserting & Manipulating Text in PowerPoint 2019 for Windows
PowerPoint 2019 presentations contain two key elements: graphics and text. Discover how to manipulate text and images like a pro in this 10-video course. Key concepts covered in this course include how to insert text into your presentation by creating and formatting text boxes to position your text; how to insert special characters from the symbols library by using the symbols menu on your tool ribbon; and how to insert icons by using the tool ribbon. Begin by learning about keyboard shortcuts to make quick changes; how to adjust the language settings to select your spellcheck options; and how to adjust the AutoCorrect options to catch typing and spelling errors as they happen. Next, you will learn how to use the Find tool if looking for a particular word or section in your presentation; you can use the Find function to scan through different matches throughout your presentation one by one. Finally, learn how to use the Replace tool to replace instances of a word or phrase.
10 videos |
39m
Assessment
Badge
Formatting Presentations in PowerPoint 2019 for Windows
Once you start adding text elements to a presentation, you will need to know how to format and organize them. In this 9-video course, learners will observe how to adjust text, add elements such as bulleted lists, and modify paragraph settings within PowerPoint 2019. Key concepts covered here include how to adjust the appearance of text by using font and text size tools and adding effects; how to align your text and adjust its position on the slide by using the standard horizontal and vertical alignment options; and how to rotate your text by adjusting the text position on your slide by using the Rotate tool. Begin by learning how to organize your text into columns to help maximize the space within a slide; how to insert bullet points and to adjust the points' style and appearance; and how to insert a number list. Finally, learn how to modify your paragraph indentation to help give your text element structure, and learn to modify your line and paragraph spacing to make text easier to read.
9 videos |
36m
Assessment
Badge
Enhancing Presentation Designs in PowerPoint 2019 for Windows
In order to help your presentation stand out, you can add color, modify the theme, and even add design elements by using the Designer tool with PowerPoint 2019. The key concepts covered in this 10-video course include how to add color to a presentation to help elements stand out or to change the overall appearance of inserted objects; how to create custom colors to add to text and inserted objects; and how to use the text direction tools to change the rotation and orientation of text. Begin by learning how to apply presentation themes that complete with a variety of different predefined elements, such as text font, size and background images or colors; how to create your own custom presentation theme; and how to create a custom background by using textiles, saved images, and online sources. Finally, learn how to access and use Draw tools; how to use WordArt tools to customize a title and convert existing text into a WordArt title; and how to customize text effects applied to a WordArt title.
10 videos |
41m
Assessment
Badge
Using Multimedia in Presentations in PowerPoint 2019 for Windows
A picture speaks a thousand words, but why stop there? Explore the graphic elements of PowerPoint, from working with images to audio and video files as well as hyperlinks with PowerPoint 2019 in this 11-video course. Key concepts covered here include how to insert hyperlinks to access websites, files, and send e-mails; how to insert an image from existing files or online locations; and how to insert screenshots from an open program or online source. You will learn how to modify an image position by using rotation and cropping; how to edit an image's size, border, and apply effects; and how to modify an images aspects to improve its appearance. The course continues by demonstrating how to insert a 3D model from an existing file or an online source; how to insert an existing audio file or an audio recording; and how to insert a file from your computer or an online source. Finally, learn how to edit a video in a presentation; and learn to create a photo album presentation.
11 videos |
49m
Assessment
Badge
Adding Data to Presentations in PowerPoint 2019 for Windows
If you would like to present data in a table or from another file, PowerPoint 2019 gives you multiple possibilities. In this 7-video course, learners will observe how to add tables to store and organize data, insert files, and create and modify equations. Key concepts covered in this course include how to insert a table to display data in a presentation, which can add structure to your data; how to use the alignment tools to format your table for better display or edit tables by inserting, resizing, and removing table elements; and how to insert a preset equation to display calculations in a presentation and to edit your equations by adding special characters. You will learn how to create a custom equation within a presentation by using the Ink Equation tool to write your own equations; how to import charts and tables from Excel; and how to insert an existing file or newly created file of other formats into your presentation.
7 videos |
31m
Assessment
Badge
Creating Graphics & Diagrams in PowerPoint 2019 for Windows
PowerPoint 2019 allows you to take your presentation to the next level by creating diagrams, inserting shapes, and adding SmartArt graphics. Key concepts covered in this 10-video course include how to insert predefined shapes to create a diagram and once inserted, to customize by changing dimensions, style, or adding text to it; how to create custom shapes, as well as being able to design a shape with freehand tools; and how to add fill effects to inserted shapes such as using block colors, applying gradients, adding pictures, and even bitmap textures. You will learn how to customize your shapes and text boxes by changing the border styles, by creating thicker lines, colored lines, and adjusting line style; how to add effects like a shadow to inserted shapes; and how to use the chart creation tool or insert a preexisting chart and format either one. Finally, learners observe how to insert predefined SmartArt graphics into a presentation, and edit it by changing size and layout and change the format by modifying style and color.
10 videos |
39m
Assessment
Badge
Organizing Presentation Assets in PowerPoint 2019 for Windows
This 6-video course explores how to produce more memorable presentations by using PowerPoint. Learners will first examine several editing elements to improve the visuals of a presentation. You will also learn how to move items in a presentation by using the cut, copy, and paste functions. Observe how data is stored via the clipboard, which where PowerPoint stores copied or deleted items. Then see how the formatting of an original item is saved via clipboard. You will learn several options available in PowerPoint to adjust how data is pasted back into the slides. Next, you will learn how to customize items in a presentation by selecting them with your mouse and the keyboard. Continue by examining how PowerPoint uses several different tools to organize items in a slide, and then learning how to change how items are layered within a slide. Finally, you will learn how to group items to modify and move them together.
6 videos |
25m
Assessment
Badge
Sharing & Collaborating on a Presentation in PowerPoint 2019 for Windows
Explore the ways in which PowerPoint enables you to share presentations via e-mail, to upload them to OneDrive, and to SharePoint for team collaboration, in this 7-video course. First, learn how to use the integrated mail function to create a new e-mail message with your presentation automatically attached, and how to select the format of a presentation. Learners then observe how to share a presentation on SharePoint, and how to create a shareable link that can be sent via e-mail. This course demonstrates how PowerPoint allows you to access and edit your sharing permissions for each location, and how to change and remove shared document link permissions. You will examine Microsoft's OneDrive service to store files on the cloud. Next, learn how to use the History panel in PowerPoint, allowing you to view changes in actions made in a document; and see how to manage a document's version history, as well as restore a previous version. Finally, you will learn how to communicate with other collaborators via the Comments function.
7 videos |
26m
Assessment
Badge
Adding Animations in PowerPoint 2019 for Windows
In this 8-video course, learners can explore how to add animation to a PowerPoint presentation to create more interesting presentations. You will learn to add animations to different types of objects in your slides, such as Shapes, Images, and Text boxes. You will learn how to modify the basic effects, adjust the duration, to delay an animation, and create a trigger. Then you will examine how color and text effects enhance the appearance of presentations. You will learn how to personalize a slide show by using the create animation tool, or how to create your own animation. If a presentation contains multiple animations, you will learn to manage them all at the same time, by using the Animation pane. You will learn how to use Master View to add animation to multiple slides. Continue by learning how to make a PowerPoint presentation more interesting by inserting transitions between slides. Finally, learners will observe how to make a presentation smoother and more dynamic by adding a morph transition to slides.
8 videos |
34m
Assessment
Badge
Preparing & Delivering Slideshows in PowerPoint 2019 for Windows
This 11-video course helps learners explore the use of PowerPoint by focusing on how to control the delivery of a slide show. After you have activated your slide show, you will observe several tools to control how your presentation progresses. You will then learn how to turn your mouse into a laser pointer, and to activate the Summary View, and the Presenter View to control the slide show. Next, learn how to use the notes pane to store and access information you may need to help present your presentation. Learners will then explore how to associate an action with an item, including another slide, file, program, or website. You will learn how to use the Annotation tools, including the pen, highlighter, and eraser. Continue the course by learning how to use the PowerPoint Zoom tool to add slide summaries and to access different slides and sections in your presentation. You will explore how to record narrations, annotations, and timings. Finally, you will observe how to use PowerPoint to deliver your presentation online.
11 videos |
44m
Assessment
Badge
Configuring PowerPoint 2019 for Windows
Explore different ways to adjust and customize the Presentation View in PowerPoint in this 5-video course, which demonstrates how the PowerPoint interface can be customized to make presentations more visually appealing. This course demonstrates how to customize the View interface, Quick Access Toolbar, and ribbon. You will learn to how to resize the size of each display section; to change the amount of space taken up by each element on your screen; to change the size of the Slide pane; and to change the size of the thumbnails of your slides. This course demonstrates how to obtain Add-ins from the office store, and how install and use Add-ins. You will learn how to choose a different color scheme, change the Office background design, and how to activate or deactivate certain tools. You will see how to use Toolbar as a shortcut to access frequently used tools. Finally, learners will observe how to customize and use the PowerPoint ribbon.
5 videos |
21m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Getting Started in Excel 2019 for Windows
Get started with Excel 2019, the spreadsheet application included with the Microsoft Office 2019 Suite. During this course, you will familiarise yourself with the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Begin the course by learning how to find the application on the desktop and open it. To get the most out of Excel, you need to understand how the interface is laid out, so the course next explores the application. This leads into the zoom function, which can be used to adjust how to visualize the spreadsheet in Excel by making data entries larger or smaller. Discover how to examine mode views, which in Excel features three different preset view modes: Normal, Page Layout, and Page Break. Conclude the course by observing how to move between documents, allowing work on multiple documents simultaneously while using a number of tools to organize a workspace. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting Started Exercise as well as the associated materials in the Resources section.
5 videos |
21m
Assessment
Badge
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
Formatting Data in Excel 2019 for Windows
Refine your data's appearance with Excel 2019 for Windows. In this course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format and align their data. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Formatting Data Exercise as well as the associated materials in the Resources section.
14 videos |
49m
Assessment
Badge
Illustrating Documents in Excel 2019 for Windows
Augment the descriptive power of your data with Excel 2019 for Windows. In this course, learners will discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature. Begin by learning how to insert an image or photograph, which can be used to illustrate your table, and then learn how to insert a screenshot. Discover how to edit an image, adjust its brightness, contrast, saturation levels, and apply different artistic effects or add a border. Learners can also observe how to create diagrams by using shapes and insert icons to help illustrate a worksheet. There are several different types of links that can be inserted into your document, including hyperlinks. Finally, learners will explore how to use the Smart Lookup tool in Excel to quickly access additional information about words used in a document. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Illustrating Documents Exercise as well as the associated materials in the Resources section.
7 videos |
31m
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
Sorting & Filtering Data in Excel 2019 for Windows
The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sorting & Filtering Data Exercise as well as the associated materials in the Resources section.
10 videos |
37m
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
Creating Charts & Graphics in Excel 2019 for Windows
Analyze and present your data in a more visually attractive manner in Excel 2019. Excel features several different chart types, each of which can be customized to suit your needs. In this 9-video course, you will learn how to insert and customize charts; to create chart templates and work with different chart types; and how to use trendlines. Key concepts covered in this course include how to insert, edit, and remove charts; how to customize chart labels including adding a chart title and data labels; land how to change a chart appearance by using the chart format tools. Next, learn how to customize individual chart elements in Excel, including customizing chart axes, moving a chart, and customizing the chart's titles, labels, and axes; how to create a chart template if you plan on reusing your customized chart; and how to present negative values in a chart. Finally, learn how to insert and customize trendlines that can be used for data ranges, movements, or correlations. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating Charts & Graphics Exercise as well as the associated materials in the Resources section.
9 videos |
34m
Assessment
Badge
Working with Different Chart Styles in Excel 2019 for Windows
Excel offers a variety of different chart types and styles for presenting and analyzing data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. Key concepts covered in this 6-video course include how to insert and edit pie charts, helpful when working with percentages; how to create and edit scatter charts be used to cross-reference values and combine different data types; land how to create and edit a bubble chart used to cross-reference three different types of information in a single chart. Continue by learning how to create and edit radar charts, which can be used to plot five different data values, and how to combine two types of chart by using the combo chart which you can use to create a graphic that combines multiple data types. Finally, you will observe how to create and edit a map chart for situations when you have data relating to locations, so you can use the map chart to plot values on a geographic display. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Different Chart Styles Exercise as well as the associated materials in the Resources section.
6 videos |
23m
Assessment
Badge
Working with Excel Tables in Excel 2019 for Windows
Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data, as well as change its appearance and formatting. Key concepts covered in this 6-video course include how to convert a data range into an table and edit its contents, giving you greater control over the inserted information; and how to perform calculations and manipulate data in an table such as create calculated columns to perform automatic calculations on data, quickly clean up your data with a sweep, and transform your data range into a PivotTable. Learners continue by examining how tables are highly customizable, as you learn how to use formatting tools and styles to change the appearance of a table, then learn to customize the table settings and tools. Finally, you will learn how to use slicers which can be used to filter and manipulate data in a table; and how to resize and format a slicer. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Excel Tables Exercise as well as the associated materials in the Resources section.
6 videos |
18m
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
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
MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide: Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300This book refers to word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
7h 57m
By Eric Butow
Book
Word 2019 in Easy StepsUsing detailed images and easy-to-follow instructions, this clear, concise and colorful visual reference guide is an invaluable tool for both newcomers and those upgrading from older versions.
1h 48m
By Scott Basham
Book
Word 2019 for DummiesWhether you've used older versions of this popular program or have never processed a single word, this hands-on guide gets you going with the latest version of Microsoft Word.
5h 11m
By Dan Gookin
BOOKS INCLUDED
Book
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: PowerPoint Associate Exam MO-300This Study Guide also covers creating professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.
2h 56m
By Eric Butow
Book
MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide: Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300This book refers to word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
7h 57m
By Eric Butow
Book
PowerPoint 2019 for DummiesTaking the pain out of working with PowerPoint, this plain-English guide presents full-color illustrations and step-by-step instructions to show you how to use this popular tool to make show-stopping presentations that will get your message across - and your audience excited.
4h 31m
By Doug Lowe
BOOKS INCLUDED
Book
MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide: Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300This book refers to word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas.
7h 57m
By Eric Butow
Book
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Word Associate Exam MO-100This Sybex Study Guide offers a thorough, well-organized approach to learning the job role and responsibilities of a Microsoft Office Specialist as well as mastering the requirements of the Word certification exam.
2h 16m
By Eric Butow
Book
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200This book starts you off with an assessment test to measure what you already know and what you still need to learn. Then you move into professional scenarios and examples, practical exercises, and challenging chapter review questions.
2h 42m
By Eric Butow
Book
Excel 2019 in Easy StepsUsing detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise, yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.
1h 48m
By Michael Price
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
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 for DummiesWritten by a bestselling author and seasoned educator, this easy-to-follow guide has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand.
7h 19m
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
SHOW MORE
FREE ACCESS
