COURSES
Microsoft Office
OUR COURSES SERIES
Microsoft Office Course Directory
Microsoft Office Specialist (MOS)
| Course Name | Course Type | Syllabus |
|---|---|---|
| Collaborating & customizing PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Collaborating & customizing PowerPoint 365Overview/Description: As you become more expert in your command of PowerPoint, it is important to be able to personalize your experience of the application. This course explores how to customize the PowerPoint interface and its various components, including the Quick Access Toolbar and the Office Ribbon. It also highlights essential settings and options. For example, you will learn how to adjust saving and language options. In addition, you will discover a variety of tools and features that will help you to collaborate and take full advantage of the application. In particular, the course covers how to add and manage comments, compress and embed media, customize notes and handouts, create a presentation from a Word outline, and present your slideshow in Microsoft Teams.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_14_enus |
| Creating Presentations in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Creating Presentations in PowerPoint 365Overview/Description: PowerPoint offers a wide array of tools for setting the layout and appearance of your slides as well as the overall organization of your presentation. See how to insert new slides and reuse existing slides in your presentation, and how to remove them, reorder them and organize them into sections. Discover how to find and apply themes and templates in PowerPoint to change your presentation’s look and feel, save your own templates for use in future presentations, and utilize useful features like Slide Master, headers and footers and summary slides.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_02_enus |
| Designing your slides in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Designing your slides in PowerPoint 365Overview/Description: This course covers the essential PowerPoint design tools to help you create a visually engaging presentation. You will see how to modify the color of a variety of presentation elements, from text and shapes to slide backgrounds. The course will show you how to apply preset themes and variants. You will also see how to customize your slides size and background style, insert WordArt titles and digital ink drawings, and discover the vast design possibilities of PowerPoints A.I.-driven Design Ideas tool.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_07_enus |
| Formatting your presentation in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Formatting your presentation in PowerPoint 365Overview/Description: In addition to formatting your presentation’s slides, PowerPoint offers a wide variety of styles and options for formatting text. This course covers the essentials of font and paragraph formatting in PowerPoint. You will learn how to set and modify such essential elements as font type, size, and style to help your text stand out. Discover how to format paragraph attributes, including indentation, text direction, alignment, and spacing, to improve the visual structure of your presentation and the legibility of your text.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_06_enus |
| Getting started in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Getting started in PowerPoint 365Overview/Description: PowerPoint is the presentation application that is included with Microsoft Office 365. Discover how to locate and open the application from your desktop, explore the essential interface tools and menus, such as the Slide Pane and Office Ribbon, and navigate between slides and presentations. Change the way you visualize your presentations using the applications various view modes. Learn also common functions of the application like creating and opening presentations, adding and removing slides and presenting in PowerPoint. Explore how to use Copilot for PowerPoint to easily create presentations and add new slides.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps). Course Number: ds_ms365pp_01_enus |
| Inserting text in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Inserting text in PowerPoint 365Overview/Description: Once You’ve inserted slides in your presentation, chosen themes and layouts and configured your work preferences, no presentation is complete without text. In this course, you will find a variety of tools, settings and features to allow you to add and edit text in PowerPoint. Concepts covered include inserting standard text and special characters in placeholders, text boxes and shapes You will also discover tools to help you in editing your text: see how to configure and utilize Spell Check and AutoCorrect to check the accuracy of your text, as well as how to quickly locate and change specific words or phrases using Find and Replace.Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_05_enus |
| Saving & Sharing Presentations in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Saving & Sharing Presentations in PowerPoint 365Overview/Description: When you have created and edited a presentation, PowerPoint allows you not only to save your changes, but to share the presentation with others. In this course, you will learn how to save a presentation, automatically save edits to the cloud using AutoSave and create a copy of your presentation. You will also see how to export your file to a variety of different file formats, including PDF, images (JPEG) and video (MPEG-4). You will also discover how to create a presentation package for use on another computer and how to generate an editable, printable handout version of your presentation in Microsoft Word.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_03_enus |
| Setting up slide shows in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Setting up slide shows in PowerPoint 365Overview/Description: Transitions and animations are two essential features of PowerPoint to bring your slide shows to life and capture your audience’s attention. PowerPoint contains over fifty kinds of animations of different types: entrance, exit, emphasis, and motion paths. In this course, you will see how to add these animations to various kinds of slide objects and to configure their options for maximum effect. You will also see how to add transitions to move from slide to slide in a more captivating way. Finally, the course explores a number of useful ways to personalize the slide show itself. This includes setting up slide show options, creating a custom show, and using presenter view.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_13_enus |
| Ten common tools in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Ten common tools in PowerPoint 365Overview/Description: To make the most out of working in PowerPoint 365, you need to know your way around the interface as well as understand some of its frequently-used features. In this course, you will discover tools to identify and fix different kinds of issues in your presentations, from compatibility to accessibility. You will also learn how to print your presentation with your desired settings, view and edit your presentation properties, manage different versions of the same presentation, protect it from unwanted changes and search the web for content without opening your internet browser.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_04_enus |
| Using charts in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Using charts in PowerPoint 365Overview/Description: Charts and graphs are powerful tools for visually presenting data, patterns, and trends. This course covers the essentials of chart creation, formatting, and design in PowerPoint. In this course, you will see how to create charts in PowerPoint and insert them from Excel. You will learn how to edit data and format the way it is presented, by changing your chart type and layout. The course also introduces a number of tools to enhance the way you present your data, from titles and labels to gridlines and legends. You will not only see how to format the overall appearance of your charts, but also how to manage and adjust these various different chart elements. Finally, the course will teach you how to style your chart using colors, effects, and WordArt.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_12_enus |
| Using graphic elements in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Using graphic elements in PowerPoint 365Overview/Description: Along with images and text, adding shapes and other graphic elements to your slides can help you create a complete, well-rounded presentation. This course explores the fundamentals of using and formatting graphic elements in PowerPoint 365. In particular, you will learn how to insert and resize text boxes and shapes. You will see how to format these objects by modifying fill, outline, and effects, and discover tools that will help you position different elements precisely on the slide. You will also see how these different elements relate to one another by learning how to align them with other objects, group them together as one element, and rearrange the stacking order.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_09_enus |
| Using images in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Using images in PowerPoint 365Overview/Description: Adding images is an effective way to visually enhance presentations and present information. This course explores the different ways in which images can be inserted, manipulated, and adjusted directly in PowerPoint. You will see how to add pictures from different sources, whether from a file, stock images, for the web. Once you have got images onto your slide, you will be able to reposition, reorder, resize, and crop them. Discover how to enhance images by applying visual effects, styles, and borders, as well as how to correct brightness, sharpness, color, and contrast. This course will also teach you how to use screenshots and how to create a digital photo album directly in PowerPoint.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_08_enus |
| Using multimedia in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Using multimedia in PowerPoint 365Overview/Description: If you would like to create an engaging sensory experience for your intended audience, multimedia can be an excellent addition to your presentations. This course explores the many ways to use multimedia elements in PowerPoint, from audio and video to links and 3D models. You will see how to use hyperlinks to integrate websites, files, and emails to your slides. You will also discover how to use Summary, Section, and Slide Zooms to allow you to freely navigate to different slides and sections of your presentation. This course will not only cover how to insert these various elements onto your slide, but also how to manage and format them to ensure you get the most out of them.This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_10_enus |
| Using tables & SmartArt in PowerPoint 365 | Course | View details Course Syllabus | Print Syllabus Using tables & SmartArt in PowerPoint 365Overview/Description: PowerPoint is all about presenting information in a clear and intuitive way. What better way to visually communicate data and complex ideas than through tables and diagrams? In this course, you will learn how to insert and format tables in your presentation. You will see how to insert them from outside sources like Excel, create them from scratch in PowerPoint, and modify their layout and style. In addition, you will discover an essential PowerPoint design element: the SmartArt graphic. SmartArt allows you to create diagrams and other visual layouts to illustrate complex ideas. Find out all about how to use and format this handy tool in this course!This course aligns with the objectives of Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps).Would you like hands-on practice? Go to the Course Contents pane or the Resources section of the course and download the sample files to follow along with select videos. Course Number: ds_ms365pp_11_enus |
| Sharing & Collaborating on a Document in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Sharing & Collaborating on a Document in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_06_enus |
| Structuring Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Structuring Documents in Word 2019 for WindowsOverview/Description: 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 Words 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. Course Number: ds_msw2019_07_enus |
| Shaping Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Shaping Documents in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_08_enus |
| Illustrating Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Documents in Word 2019 for WindowsOverview/Description: 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 Words 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. Course Number: ds_msw2019_09_enus |
| Creating Graphics & Diagrams in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Graphics & Diagrams in Word 2019 for WindowsOverview/Description: Word 2019s 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. Course Number: ds_msw2019_10_enus |
| Adding Data & Calculations in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Adding Data & Calculations in Word 2019 for WindowsOverview/Description: 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 Words 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. Course Number: ds_msw2019_11_enus |
| Using Table Tools in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Table Tools in Word 2019 for WindowsOverview/Description: 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 Words 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. Course Number: ds_msw2019_12_enus |
| Using Research Tools in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Research Tools in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_13_enus |
| Configuring the Application in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring the Application in Word 2019 for WindowsOverview/Description: 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 Words advanced options to modify many of the programs display settings. You will also observe how to customize Words 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. Course Number: ds_msw2019_16_enus |
| Getting Started in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Getting Started in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_01_enus |
| Creating & Saving Workbooks in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating & Saving Workbooks in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_02_enus |
| Inserting & Manipulating Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting & Manipulating Data in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_03_enus |
| Formatting Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Data in Excel 2019 for WindowsOverview/Description: Refine your datas 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. Course Number: ds_msex2019_04_enus |
| Illustrating Documents in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Documents in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_05_enus |
| Using Basic Formulas in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Basic Formulas in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_06_enus |
| Sharing & Collaborating on a Document in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Sharing & Collaborating on a Document in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_07_enus |
| Custom & Conditional Formatting in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Custom & Conditional Formatting in Excel 2019 for WindowsOverview/Description: 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 elements 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. Course Number: ds_msex2019_08_enus |
| Finding & Grouping Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Finding & Grouping Data in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_09_enus |
| Sorting & Filtering Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Sorting & Filtering Data in Excel 2019 for WindowsOverview/Description: The first step in analyzing the data in a worksheet is often taken with Excels 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. Course Number: ds_msex2019_10_enus |
| Referencing Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Referencing Data in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_11_enus |
| Creating Charts & Graphics in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Charts & Graphics in Excel 2019 for WindowsOverview/Description: 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 charts 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. Course Number: ds_msex2019_13_enus |
| Working with Different Chart Styles in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Different Chart Styles in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_14_enus |
| Working with Excel Tables in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Excel Tables in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_15_enus |
| Using Conditional Formulas in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Conditional Formulas in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_18_enus |
| Finding & Analyzing Information with Formulas in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Finding & Analyzing Information with Formulas in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_19_enus |
| Configuring Options & Settings in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring Options & Settings in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_20_enus |
| Getting Started with PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Getting Started with PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_01_enus |
| Creating Presentations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Presentations in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_02_enus |
| Saving Presentations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Saving Presentations in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_03_enus |
| Inserting & Manipulating Text in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting & Manipulating Text in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_04_enus |
| Formatting Presentations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Presentations in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_05_enus |
| Enhancing Presentation Designs in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Enhancing Presentation Designs in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_06_enus |
| Using Multimedia in Presentations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Multimedia in Presentations in PowerPoint 2019 for WindowsOverview/Description: 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 images 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. Course Number: ds_mspp2019_07_enus |
| Adding Data to Presentations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Adding Data to Presentations in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_08_enus |
| Creating Graphics & Diagrams in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Graphics & Diagrams in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_09_enus |
| Organizing Presentation Assets in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Organizing Presentation Assets in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_10_enus |
| Sharing & Collaborating on a Presentation in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Sharing & Collaborating on a Presentation in PowerPoint 2019 for WindowsOverview/Description: 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 Microsofts 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 documents version history, as well as restore a previous version. Finally, you will learn how to communicate with other collaborators via the Comments function. Course Number: ds_mspp2019_11_enus |
| Adding Animations in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Adding Animations in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_12_enus |
| Preparing & Delivering Slideshows in PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Preparing & Delivering Slideshows in PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_13_enus |
| Configuring PowerPoint 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring PowerPoint 2019 for WindowsOverview/Description: 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. Course Number: ds_mspp2019_14_enus |
| Opening & Setting Up in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Opening & Setting Up in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_01_enus |
| Creating Opening & Saving Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Opening & Saving Documents in Word 2019 for WindowsOverview/Description: 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 documents 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. Course Number: ds_msw2019_02_enus |
| Editing Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Editing Documents in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_03_enus |
| Formatting Documents in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Documents in Word 2019 for WindowsOverview/Description: Discover how to use Word 2019s 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. Course Number: ds_msw2019_04_enus |
| Using Find & Replace Tools in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Using Find & Replace Tools in Word 2019 for WindowsOverview/Description: 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 words 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 documents 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. Course Number: ds_msw2019_05_enus |
| Creating Forms in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Forms in Word 2019 for WindowsOverview/Description: 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 Words 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. Course Number: ds_msw2019_14_enus |
| Creating Bulk Mailings in Word 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Bulk Mailings in Word 2019 for WindowsOverview/Description: 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. Course Number: ds_msw2019_15_enus |
| Creating Forms & Bulk Mailings in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Forms & Bulk Mailings in Word 2016 for WindowsOverview/Description: With Word 2016s forms and mailings tools, you can collect, process, and re-use data in a variety of different ways. Build data collection forms, import mailing lists, and create mail merge documents in a matter of minutes. Course Number: ds_msw16_11_enus |
| Using Sharing & Collaboration Tools in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using Sharing & Collaboration Tools in Word 2016 for WindowsOverview/Description: Collaboration is made easy in Word 2016 for Windows. Share your document via email, upload your document to your OneDrive storage space, and use the comment and change tracking tools to keep on top of any modifications made to your files. Course Number: ds_msw16_12_enus |
| Configuring the Application in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring the Application in Word 2016 for WindowsOverview/Description: Every aspect of your Word 2016 for Windows application, from interface and language to input and save options, can be customized. If these default settings arent enough, you can even install new tools and services via the add-in store. Course Number: ds_msw16_13_enus |
| Working with Databases in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Databases in Access 2016 for WindowsOverview/Description: Access 2016 is the database application in the Microsoft Office 2016 suite. Discover how to open existing databases and create new ones, and learn how you can customize the interface, including the Quick Access Toolbar and ribbon. Course Number: ds_msac2016_01_enus |
| Saving Printing & Exporting Databases in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Saving Printing & Exporting Databases in Access 2016 for WindowsOverview/Description: Data is key for any database application, and youll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2016. Course Number: ds_msac2016_02_enus |
| Tables Fields & Entries in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Tables Fields & Entries in Access 2016 for WindowsOverview/Description: To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties. Course Number: ds_msac2016_03_enus |
| Inserting Importing & Formatting Data in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting Importing & Formatting Data in Access 2016 for WindowsOverview/Description: There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data. Course Number: ds_msac2016_04_enus |
| Finding & Organizing Data in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Finding & Organizing Data in Access 2016 for WindowsOverview/Description: As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records. Course Number: ds_msac2016_05_enus |
| Creating Forms & Queries in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Forms & Queries in Access 2016 for WindowsOverview/Description: Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries. Course Number: ds_msac2016_06_enus |
| Using the Report & Analysis Tools in Access 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using the Report & Analysis Tools in Access 2016 for WindowsOverview/Description: For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity. Course Number: ds_msac2016_07_enus |
| Getting Started in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Getting Started in Excel 2016 for WindowsOverview/Description: Excel 2016 is the spreadsheet application in the Microsoft Office 2016 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Course Number: ds_msex2016_01_enus |
| Creating Saving & Sharing Workbooks in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Saving & Sharing Workbooks in Excel 2016 for WindowsOverview/Description: Excel 2016 is highly customizable and easy to share with others. Learn how to create, manage, and save documents; insert headers and footers; edit document properties; and protect and share your workbooks. Course Number: ds_msex2016_02_enus |
| Inserting & Manipulating Data in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting & Manipulating Data in Excel 2016 for WindowsOverview/Description: Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range. Course Number: ds_msex2016_03_enus |
| Formatting Data in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Data in Excel 2016 for WindowsOverview/Description: Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2016 to change data presentation. Course Number: ds_msex2016_04_enus |
| Custom & Conditional Formatting in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Custom & Conditional Formatting in Excel 2016 for WindowsOverview/Description: To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting. Course Number: ds_msex2016_05_enus |
| Illustrating Documents in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Documents in Excel 2016 for WindowsOverview/Description: An Excel 2016 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes; insert hyperlinks; and use the new Smart Lookup feature. Course Number: ds_msex2016_06_enus |
| Finding Sorting & Filtering Data in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Finding Sorting & Filtering Data in Excel 2016 for WindowsOverview/Description: Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping. Course Number: ds_msex2016_07_enus |
| Referencing Data in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Referencing Data in Excel 2016 for WindowsOverview/Description: Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016. Course Number: ds_msex2016_08_enus |
| Basic Formulas in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Basic Formulas in Excel 2016 for WindowsOverview/Description: The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers. Course Number: ds_msex2016_09_enus |
| Working with Formulas in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Formulas in Excel 2016 for WindowsOverview/Description: In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values. Course Number: ds_msex2016_10_enus |
| Creating Charts & Graphics in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Charts & Graphics in Excel 2016 for WindowsOverview/Description: Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines. Course Number: ds_msex2016_11_enus |
| Using Conditional Formulas in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using Conditional Formulas in Excel 2016 for WindowsOverview/Description: In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT. Course Number: ds_msex2016_15_enus |
| Extracting Information with Formulas in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Extracting Information with Formulas in Excel 2016 for WindowsOverview/Description: Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP. Course Number: ds_msex2016_16_enus |
| Configuring Options & Settings in Excel 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring Options & Settings in Excel 2016 for WindowsOverview/Description: Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Course Number: ds_msex2016_17_enus |
| Forecasting & Solving Problems in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Forecasting & Solving Problems in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_12_enus |
| Inserting PivotTables in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting PivotTables in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_16_enus |
| Working with Data in PivotTables in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Data in PivotTables in Excel 2019 for WindowsOverview/Description: 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 PivotTables 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. Course Number: ds_msex2019_17_enus |
| Managing Data in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Managing Data in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_21_enus |
| Getting to Know Macros in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Getting to Know Macros in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_22_enus |
| Creating & Editing Macros in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Creating & Editing Macros in Excel 2019 for WindowsOverview/Description: In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. Its 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 its 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. Course Number: ds_msex2019_23_enus |
| Working with Macros in Excel 2019 for Windows | Course | View details Course Syllabus | Print Syllabus Working with Macros in Excel 2019 for WindowsOverview/Description: 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. Course Number: ds_msex2019_24_enus |
| Setting Up in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Setting Up in Outlook 2016 for WindowsOverview/Description: Outlook 2016 is the email client that ships with the Microsoft Office suite. Discover how to configure an account, explore the interface and available tools, access help, and use keyboard shortcuts to help you save time. Course Number: ds_msou2016_01_enus |
| Sending & Receiving Email in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Sending & Receiving Email in Outlook 2016 for WindowsOverview/Description: Outlook 2016 makes it easy to send and receive emails. Learn how to send, receive, reply to and forward emails; work with attachments; create out-of-office and automatic replies; and print emails. Course Number: ds_msou2016_02_enus |
| Formatting Email in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Email in Outlook 2016 for WindowsOverview/Description: There are numerous formatting techniques that can be applied to Outlook 2016 emails. Discover how to format text, use lists, work with styles and templates, and manage signatures. Course Number: ds_msou2016_03_enus |
| Illustrating Email in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Email in Outlook 2016 for WindowsOverview/Description: Outlook 2016 emails do not have to contain text only. Explore ways to illustrate your emails, including adding images, links, shapes, WordArt and SmartArt graphics, tables, charts, polls, and objects. Course Number: ds_msou2016_04_enus |
| Organizing Email in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Organizing Email in Outlook 2016 for WindowsOverview/Description: To be productive, you need to keep your Outlook 2016 emails organized. Explore how to mark, flag, categorize, filter, and sort emails; use conversations and folders; use conditional formatting; and handle junk email. Course Number: ds_msou2016_05_enus |
| Contact Tools in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Contact Tools in Outlook 2016 for WindowsOverview/Description: Outlook 2016 makes it easy to keep track of people you connect with. Discover how to add, import,export, and categorize contacts; create and manage groups; and configure your address book. Course Number: ds_msou2016_06_enus |
| Calendar Tools in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Calendar Tools in Outlook 2016 for WindowsOverview/Description: Keep track of events, meetings and appointments in Outlook 2016 using the calendar function. Discover how to configure your calendar; create and organize events and meetings; add, import, and export calendars; and work with tasks. Course Number: ds_msou2016_07_enus |
| Configuring the Client in Outlook 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring the Client in Outlook 2016 for WindowsOverview/Description: Customize Outlook 2016 to make it your own. Learn how to add multiple accounts; work with RSS feeds; customize the interface, ribbon, and Quick Access Toolbar; and use the import and export function. Course Number: ds_msou2016_08_enus |
| Getting Started in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Getting Started in PowerPoint 2016 for WindowsOverview/Description: PowerPoint is the presentation application that is included with Microsoft Office 2016. Discover how to locate and open the application, explore the interface tools and menus, and navigate between slides and presentations. Course Number: ds_mspp2016_01_enus |
| Creating Presentations in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Presentations in PowerPoint 2016 for WindowsOverview/Description: Create your slides, and finesse them like a pro. Discover how to use themes, create and manipulate slides, and work with slide elements. Course Number: ds_mspp2016_02_enus |
| Saving & Sharing Presentations in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Saving & Sharing Presentations in PowerPoint 2016 for WindowsOverview/Description: Once your presentation is done, you can save, export, and share it. Explore the methods for saving, backing up, exporting, and protecting PowerPoint 2016 presentations. Course Number: ds_mspp2016_03_enus |
| Inserting & Manipulating Text in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Inserting & Manipulating Text in PowerPoint 2016 for WindowsOverview/Description: PowerPoint 2016 presentations contain two key elements: graphics and text. Discover how to manipulate text like a pro. Course Number: ds_mspp2016_04_enus |
| Formatting Presentations in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Presentations in PowerPoint 2016 for WindowsOverview/Description: Presentations with visual impact are the key to a great talk. Explore the many ways you can polish your PowerPoint 2016 presentation, from working with color and WordArt to paragraphs, lists, themes, and backgrounds. Course Number: ds_mspp2016_05_enus |
| Illustrating Presentations in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Presentations in PowerPoint 2016 for WindowsOverview/Description: 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, hyperlinks, bookmarks, tables, equations, and inserting other file types. Course Number: ds_mspp2016_06_enus |
| Creating Graphics & Diagrams in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Graphics & Diagrams in PowerPoint 2016 for WindowsOverview/Description: Good presentations often require good visual elements that speak louder than words. Explore custom shapes, fill effects, shape effects, charts, and SmartArt. Course Number: ds_mspp2016_07_enus |
| Organizing Presentations Assets in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Organizing Presentations Assets in PowerPoint 2016 for WindowsOverview/Description: Your presentation needs to be tweaked to make it just right. Discover the various editing elements of PowerPoint, from copying and pasting to object grouping and slide organization. Course Number: ds_mspp2016_08_enus |
| Adding Animations in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Adding Animations in PowerPoint 2016 for WindowsOverview/Description: Presentations are far more impactful for the audience when animation is added to the mix. Discover how to create, customize, and manage animations in PowerPoint. Course Number: ds_mspp2016_09_enus |
| Preparing & Delivering Slideshows in PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Preparing & Delivering Slideshows in PowerPoint 2016 for WindowsOverview/Description: Ready to go live? All that work you put into your presentation has come to this. Its time to prepare and deliver your slideshow, from working with notes and action buttons to annotation and custom slide shows. Course Number: ds_mspp2016_10_enus |
| Configuring PowerPoint 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Configuring PowerPoint 2016 for WindowsOverview/Description: PowerPoint is ready to use out of the box, but configuring it can make it even better. Discover how to customize the view, interface, Quick Access Toolbar, and ribbon. Course Number: ds_mspp2016_12_enus |
| Opening & Setting Up in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Opening & Setting Up in Word 2016 for WindowsOverview/Description: Before getting started with Word 2016 for Windows, you will need to know how to open the application and use the basic navigation tools. Learn how to scroll, zoom, and use the different view modes to take control of your workspace. Course Number: ds_msw16_01_enus |
| Creating Opening & Saving Documents in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Opening & Saving Documents in Word 2016 for WindowsOverview/Description: Creating, saving, and opening documents are central to your user experience in Word 2016 for Windows. Learn how to create files, how to save them, and how to optimize your documents with accessibility and protection tools. Course Number: ds_msw16_02_enus |
| Editing Documents in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Editing Documents in Word 2016 for WindowsOverview/Description: Typing, manipulating, and checking your text is made easy with Word 2016s intuitive text tools. Discover how to build out your document more quickly with special characters, advanced AutoCorrect tools, and predefined AutoText items. Course Number: ds_msw16_03_enus |
| Formatting Documents in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Formatting Documents in Word 2016 for WindowsOverview/Description: Control every aspect of your texts appearance and structure with Word 2016s formatting tools. Use color, effects, and intuitive alignment tools to quickly transform your text and make your document more readable. Course Number: ds_msw16_04_enus |
| Shaping & Structuring Documents in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Shaping & Structuring Documents in Word 2016 for WindowsOverview/Description: Shaping and structuring text properly makes your document more readable. Use sections, headers, and cover pages to set out your ideas clearly, and advanced reference tools to help your reader find the information they need. Course Number: ds_msw16_05_enus |
| Using the Find & Replace Tools in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using the Find & Replace Tools in Word 2016 for WindowsOverview/Description: Whether you are looking for a word or phrase, Word 2016 for Windows has the tool for you. Perform simple searches, use wildcards to widen the scope, and define replacement text to quickly make changes to your document. Course Number: ds_msw16_06_enus |
| Illustrating Documents in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Illustrating Documents in Word 2016 for WindowsOverview/Description: Sometimes images and illustrations say it better than text. With Word 2016 for Windows, you can insert images and videos from online and local locations, build custom equations, and create hyperlinks to other sources of information. Course Number: ds_msw16_07_enus |
| Using Table Tools in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using Table Tools in Word 2016 for WindowsOverview/Description: Bring structure to your technical data with Word 2016 table tools. Insert new entries, columns, or rows on the fly; apply formatting to make values stand out; and manipulate your data with the sort, filter, and calculation tools. Course Number: ds_msw16_08_enus |
| Creating Graphics & Diagrams in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Creating Graphics & Diagrams in Word 2016 for WindowsOverview/Description: With Word 2016s graphics tools, you can create charts and diagrams to add visual impact to your documents. Learn how to build diagrams, insert customizable SmartArt graphics, and transform your data using different chart types. Course Number: ds_msw16_09_enus |
| Using Research Tools in Word 2016 for Windows | Course | View details Course Syllabus | Print Syllabus Using Research Tools in Word 2016 for WindowsOverview/Description: Word 2016 for Windows gives you a suite of research tools to enrich your documents. Organize your citations and sources, use the dictionaries to check your text, and pull information into your document directly from the web. Course Number: ds_msw16_10_enus |