| Setting Up in Outlook 2016 for Windows | Course | View detailsSetting 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 |
| Saving & Sharing Presentations in PowerPoint 2016 for Windows | Course | View detailsSaving & 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 detailsInserting & 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 |
| Opening & Setting Up in Word 2016 for Windows | Course | View detailsOpening & 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 |
| Formatting Data in Excel 2016 for Windows | Course | View detailsFormatting 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 detailsCustom & 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 detailsIllustrating 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 detailsFinding 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 |
| Basic Formulas in Excel 2016 for Windows | Course | View detailsBasic 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 detailsWorking 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 |
| Inserting & Manipulating Data in Excel 2016 for Windows | Course | View detailsInserting & 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 |
| Creating Charts & Graphics in Excel 2016 for Windows | Course | View detailsCreating 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 |
| Extracting Information with Formulas in Excel 2016 for Windows | Course | View detailsExtracting 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 |
| Sending & Receiving Email in Outlook 2016 for Windows | Course | View detailsSending & 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 |
| Organizing Email in Outlook 2016 for Windows | Course | View detailsOrganizing 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 detailsContact Tools in Outlook 2016 for WindowsOverview/Description: Outlook 2016 makes it easy to keep track of people you connect with. Discover how to add importexport and categorize contacts; create and manage groups; and configure your address book. Course Number: ds_msou2016_06_enus |
| Configuring the Client in Outlook 2016 for Windows | Course | View detailsConfiguring 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 |
| Creating Opening & Saving Documents in Word 2016 for Windows | Course | View detailsCreating 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 |
| Formatting Documents in Word 2016 for Windows | Course | View detailsFormatting 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 |
| Illustrating Documents in Word 2016 for Windows | Course | View detailsIllustrating 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 detailsUsing 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 detailsCreating 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 |
| Creating Forms & Bulk Mailings in Word 2016 for Windows | Course | View detailsCreating 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 |
| Getting Started in PowerPoint 2016 for Windows | Course | View detailsGetting 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 detailsCreating 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 |
| Referencing Data in Excel 2016 for Windows | Course | View detailsReferencing 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 |
| Getting Started in Excel 2016 for Windows | Course | View detailsGetting 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 detailsCreating 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 |
| Using Conditional Formulas in Excel 2016 for Windows | Course | View detailsUsing 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 |
| Configuring Options & Settings in Excel 2016 for Windows | Course | View detailsConfiguring 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 |
| Formatting Email in Outlook 2016 for Windows | Course | View detailsFormatting 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 |
| Calendar Tools in Outlook 2016 for Windows | Course | View detailsCalendar 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 |
| Formatting Presentations in PowerPoint 2016 for Windows | Course | View detailsFormatting 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 detailsIllustrating 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 detailsCreating 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 detailsOrganizing 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 detailsAdding 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 detailsPreparing & 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 detailsConfiguring 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 |
| Editing Documents in Word 2016 for Windows | Course | View detailsEditing 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 |
| Shaping & Structuring Documents in Word 2016 for Windows | Course | View detailsShaping & 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 detailsUsing 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 |
| Using Research Tools in Word 2016 for Windows | Course | View detailsUsing 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 |
| Using Sharing & Collaboration Tools in Word 2016 for Windows | Course | View detailsUsing 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 detailsConfiguring 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 detailsWorking 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 detailsSaving 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 detailsTables 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 detailsInserting 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 detailsFinding & 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 detailsCreating 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 detailsUsing 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 |
| Illustrating Email in Outlook 2016 for Windows | Course | View detailsIllustrating 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 |
