Microsoft Office

Saving & Sharing Presentations in PowerPoint 2016 for Windows

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Inserting & Manipulating Data in Excel 2016 for Windows

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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 Databases in Access 2016 for Windows

Overview/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

Overview/Description:

Data is key for any database application and you;ll 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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Working with Formulas in Excel 2016 for Windows

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Setting Up in Outlook 2016 for Windows

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/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

Calendar Tools in Outlook 2016 for Windows

Overview/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

Preparing & Delivering Slideshows in PowerPoint 2016 for Windows

Overview/Description:

Ready to go live? All that work you put into your presentation has come to this. It 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

Overview/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

Overview/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

Overview/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

Overview/Description:

Typing manipulating and checking your text is made easy with Word 2016 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

Overview/Description:

Control every aspect of your text appearance and structure with Word 2016 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

Overview/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

Overview/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

Overview/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

Overview/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

Overview/Description:

With Word 2016 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

Overview/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

Creating Forms & Bulk Mailings in Word 2016 for Windows

Overview/Description:

With Word 2016 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

Overview/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

Overview/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 aren;t enough you can even install new tools and services via the add-in store.

Course Number:

ds_msw16_13_enus

Configuring the Client in Outlook 2016 for Windows

Overview/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

Overview/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

Overview/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