Microsoft
Microsoft Office Specialist (MOS) on Microsoft Office 2013
77-418: Word 2013
Adding Lists and Objects in Word 2013 (Update Avail.)
Adjusting Document Views and Customizing the Appearance of Word 2013
Advanced Formatting in Word 2013
Advanced Table Customization in Word 2013 (Update Avail.)
Customizing Document Layout in Word 2013
Editing and Formatting in Word 2013
Inserting and Formatting Graphics in Word 2013 (Update Avail.)
Navigating and Reviewing Documents in Word 2013
Performing Basic Tasks in Word 2013
Reference Tools and Mail Merge in Word 2013
Sharing and Collaboration in Word 2013
Structuring a Document in Word 2013
Using Tables in Word 2013
Mentoring 77-418 Word 2013
77-419: SharePoint 2013
Community Sites, Search, and Office Integration in SharePoint 2013
Configuring Lists, Libraries, E-mail, and Announcements in SharePoint 2013
Configuring Pages, Sites, and Content in SharePoint 2013
Managing Templates, Views, and Versioning in SharePoint 2013
Managing Web Parts, Users, and Groups in SharePoint 2013
My Site and Social Features in SharePoint 2013
Navigating, Lists, Libraries, Alerts, and Document Sets in SharePoint 2013
Using and Configuring Search in SharePoint 2013
Workflows, Collaboration, and Analysis in SharePoint 2013
77-420: Excel 2013
Creating and Customizing Visual Elements in Excel 2013
Creating Workbooks, Worksheets, and Data in Excel 2013
Customizing Options and Views in Excel 2013
Data Search, Data Validation, and Macros in Excel 2013
Formatting Cells and Worksheets in Excel 2013
Formatting Data in Excel 2013
Manipulating Data in Excel 2013
Performing Calculations Using Functions in Excel 2013
Presenting Data in Tables and Charts in Excel 2013
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
Saving and Printing Data in Excel 2013
Mentoring 77-420 Excel 2013
77-422: PowerPoint 2013
Advanced Slide Shows Tools in PowerPoint 2013
Animations and Media in PowerPoint 2013
Creating Presentations in PowerPoint 2013
Enhancing PowerPoint 2013 Presentations
Finalizing a PowerPoint 2013 Presentation
Sharing, Printing, Protecting and Delivery Presentations In PowerPoint 2013
77-423: Outlook 2013
Collaboration and Customization with the Calendar, Contacts and Tasks in Outlook 2013
Formatting E-mail and Configuring Message Options in Outlook 2013
Mail Automation, Cleanup, and Storage in Outlook 2013
Management and Customization in Outlook 2013
Managing E-mail in Outlook 2013
Scheduling with Appointments, Events, and Tasks in Outlook 2013
Working with Contacts in Outlook 2013
Working with E-mail in Outlook 2013
Working with Meetings in Outlook 2013
77-427 Excel 2013 Expert Part One
Advanced Formats and Layouts in Excel 2013
Advanced Formulas and Functions in Excel 2013
Reviewing and Protecting Content in Excel 2013
Sharing and Linking Data, and Adding Office Apps to Excel 2013
Using Financial Functions and What-If Analysis in Excel 2013
Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013
Mentoring 77-427 Excel 2013 Expert Part One
77-428 Excel 2013 Expert Part Two
Advanced Formats and Layouts in Excel 2013
Advanced Formulas and Functions in Excel 2013
Reviewing and Protecting Content in Excel 2013
Sharing and Linking Data, and Adding Office Apps to Excel 2013
Using Financial Functions and What-If Analysis in Excel 2013
Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013
Mentoring 77-428 Excel 2013 Expert Part Two

Adding Lists and Objects in Word 2013

Course Number:
mo_bgwo_b04_dt_enus
Lesson Objectives

Adding Lists and Objects in Word 2013

  • describe ways to create lists in Word 2013
  • choose the best way to create a list in Word 2013
  • describe ways to add hyperlinks to Word 2013 documents
  • choose the best way to connect content using hyperlinks in a Word 2013 document
  • standardize dates and times in Word 2013 documents
  • add a digital signature to a document in Word 2013
  • choose the best way to add the date and a digital signature to a document in Word 2013

Overview/Description
You can add a number of different objects to your Word 2013 documents to help increase readability and functionality, and also improve their appearance. Several available types of lists, such as bulleted and numbered lists, allow you to format and organize information. Signature lines offer added data security and allow you to easily specify that a signature is required on a document. You can include dates and times to mark when a document was created, when something is due, or for tracking purposes. Hyperlinks allow you to link to other sections of a document, to other documents, to web sites, and to e-mail addresses. This course demonstrates how to create and format various types of lists, and to work with hyperlinks in your document. It demonstrates how to insert the date and time in a document and how to add digital signatures. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Adjusting Document Views and Customizing the Appearance of Word 2013

Course Number:
mo_adwo_b07_dt_enus
Lesson Objectives

Adjusting Document Views and Customizing the Appearance of Word 2013

  • select the appropriate view for a document in Word 2013
  • zoom a document to different levels of magnification in Word 2013
  • choose appropriate views and zooms given a scenario
  • arrange windows while working in multiple documents in Word 2013
  • view multiple documents, split a document, and scroll two documents simultaneously in Word 2013
  • create a master document with subdocuments in Word 2013
  • create subdocuments within a master document in Word 2013
  • customize the ribbon and Quick Access Toolbar in Word 2013
  • add a custom tab to the Ribbon and add commands to the Quick Access Toolbar in Word 2013

Overview/Description
When working with documents in Word 2013, you can easily zoom in on your text and change views to get a better view of what you're working on. This course demos zooming, and also splitting and arranging multiple documents within the same work area. It also shows you how to switch document views, reorganize a document outline, and use master documents and subdocuments to facilitate working with large or unwieldy documents. It also explores how to customize the Ribbon and the Quick Access Toolbar so you have the commands you need within a single click of your mouse. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Advanced Formatting in Word 2013

Course Number:
mo_adwo_b01_dt_enus
Lesson Objectives

Advanced Formatting in Word 2013

  • apply, modify, and save a theme in Word 2013
  • create a background for a page in Word 2013
  • adjust the spacing of a document in Word 2013
  • adjust AutoFormat settings in Word 2013
  • use Paste Special options in Word 2013
  • adjust paragraph formatting and use auto formatting tools in Word 2013
  • adjust the tabs within a document in Word 2013

Overview/Description
Word 2013 offers features that make it easier to format your documents to give them a professional, stylized appearance. The Design tab offers features that alter the appearance of your entire document. You can quickly apply a theme to give the document visual continuity. You can also easily create and customize a page background. This course covers these features and also includes tips on adjusting paragraph tab settings, using Paste Special to maintain greater control over how text and its formatting are pasted into a document, adjusting line spacing within a paragraph, and changing AutoFormat settings to automatically change the appearance of text as it's typed. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Advanced Table Customization in Word 2013

Course Number:
mo_adwo_b03_dt_enus
Lesson Objectives

Advanced Table Customization in Word 2013

  • move columns and rows of a table in Word 2013
  • resize a row, column, or cell in a Word 2013 table
  • manipulate columns and rows of a table in Word 2013
  • sort data in a table
  • use formulas in a Word 2013 table
  • sort data and use formulas in a table in Word 2013
  • use tools for integrating tables within a page in Word 2013
  • adjust table properties, view gridlines, and convert a table to text in Word 2013

Overview/Description
Word 2013 offers a number of in-depth ways to edit and work with tables. This course demonstrates how to resize and move parts of a table, convert tables to text, sort the data within a table, and use formulas to calculate numerical data. It also covers methods for integrating tables into the rest of the content on a page to create a professional look to your document. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Customizing Document Layout in Word 2013

Course Number:
mo_adwo_b02_dt_enus
Lesson Objectives

Customizing Document Layout in Word 2013

  • arrange text into columns in Word 2013
  • use page and section breaks in a Word 2013 document
  • use tools to arrange objects on a page in Word 2013
  • create a macro in Word 2013
  • record a macro and set appropriate security settings for it in Word 2013
  • use Quick Parts in Word 2013

Overview/Description
You can use the many layout options in Word 2013 to create flowing, easy-to-read documents with a balanced visual appearance. Word lets you break your document into multiple sections so you can alter aspects of the page formatting - such as page orientation, numbering, or headings - from one section to the next. Word 2013 also enables you to organize text into newspaper-style columns or even tables. This course introduces all of these concepts and teaches you to align page elements, create and work with reusable pieces of content known as Quick Parts, and create reusable actions known as macros. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Editing and Formatting in Word 2013

Course Number:
mo_bgwo_b02_dt_enus
Lesson Objectives

Editing and Formatting in Word 2013

  • check for spelling and grammar errors in a Word 2013 document
  • find and replace terms in a Word 2013 document
  • format fonts in Word 2013
  • change the style of text in a Word 2013 document

Overview/Description
A wide variety of tools and features are available in Word 2013 to help you format the overall appearance of your document. Word also provides a number of tools that make it easier to edit your document, including spelling and grammar checking features. This course covers checking the spelling and grammar in a document using the associated panes, finding and replacing terms, formatting fonts using the ribbon and the Mini toolbar, using styles, and copying formatting with the Format Painter. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Prerequisites: none

Inserting and Formatting Graphics in Word 2013

Course Number:
mo_adwo_b04_dt_enus
Lesson Objectives

Inserting and Formatting Graphics in Word 2013

  • insert and edit a picture in Word 2013
  • add screenshots to a document in Word 2013
  • add a picture and a screenshot to a document in Word 2013
  • adding graphical objects to a document in Word 2013
  • create a text box in Word 2013
  • add SmartArt and WordArt to a document in Word 2013
  • use pictures from online sources in Word 2013
  • insert video content from online sources in Word 2013
  • add online pictures and video to a document in Word 2013

Overview/Description
To add to a Word 2013 document's visual appeal, you can choose from a number of types of images and explanatory graphical lists. You can make eye-catching changes by simply adding your own pictures or choose clip art from Office.com. This course explains how to add pictures, shapes, WordArt, SmartArt, screenshots, text boxes, and even online video to documents. It also covers how to stylize and caption any of these graphical objects. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Mentoring 77-418 Word 2013

Lesson Objectives

Mentoring 77-418 Word 2013

  • Create and Manage Documents
  • Format Text, Paragraphs, and Sections
  • Create Tables and Lists
  • Apply References
  • Insert and Format Objects

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-418 Word 2013. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Navigating and Reviewing Documents in Word 2013

Course Number:
mo_adwo_b05_dt_enus
Lesson Objectives

Navigating and Reviewing Documents in Word 2013

  • search and navigate a document in Word 2013
  • search for a specific term and navigate to a specific page in a Word 2013 document
  • reorganize and add document headings in Word 2013
  • reorganize headings in a Word 2013 document
  • configure AutoCorrect settings in Word 2013
  • configure grammar and spelling options in Word 2013
  • personalize AutoCorrect options, and spelling and grammar in Word 2013
  • add, edit, and modify comments in Word 2013
  • track changes and review markup in Word 2013
  • add comments and markup in Word 2013

Overview/Description
Word 2013 offers a number of features that make it easier to navigate, search, and review your documents. Using the Navigation pane and the Find and Replace feature, you can quickly locate a specific term within a document, replace any or all instances of terms, or move to a specific heading, section, page, graphic, and more. To help you create professional documents, free of spelling and grammatical errors, you can make use of the AutoCorrect options, and customize spelling and grammar options to suit your needs. When collaborating on documents, you can use the numerous reviewing features to easily track changes and manage comments. This course explores how to search and navigate within a document, reorganize document headings, configure AutoCorrect settings, and customize grammar and spelling options. Working with comments, tracking changes, and reviewing markup are also covered. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Performing Basic Tasks in Word 2013

Course Number:
mo_bgwo_b01_dt_enus
Lesson Objectives

Performing Basic Tasks in Word 2013

  • create a new document and open an existing document in Word 2013
  • cut, paste, and copy text in Word 2013
  • save a document in Word 2013
  • print a document in Word 2013

Overview/Description
Microsoft Word 2013, the latest offering of Microsoft's popular word-processing software, offers a variety of features that enable you to create well organized, visually appealing, and professional documents. This course introduces and demonstrates commonly used Word tasks, such as creating documents, entering and editing text, cutting, copying, and pasting, and saving and printing documents. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Individuals and business users with basic computer literacy

Reference Tools and Mail Merge in Word 2013

Course Number:
mo_adwo_b06_dt_enus
Lesson Objectives

Reference Tools and Mail Merge in Word 2013

  • add a table of contents to a document in Word 2013
  • add and format a table of contents to a document in Word 2013
  • add endnotes and footnotes to a document in Word 2013
  • create citations and a bibliography in a Word 2013 document
  • add a footnote, a citation, and a bibliography to a document in Word 2013
  • perform a mail merge in Word 2013
  • perform a mail merge on a letter in Word 2013

Overview/Description
Word 2013 offers a variety of features that let you quickly add reference document elements often found in formal, published papers. This course explores endnotes, footnotes, how to build and update a table of contents, and citations, cross-references, and bibliographies. The course also delves into how to perform a mail merge manually or by following along with a step-by-step wizard. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Sharing and Collaboration in Word 2013

Course Number:
mo_adwo_b08_dt_enus
Lesson Objectives

Sharing and Collaboration in Word 2013

  • protect a document in Word 2013
  • configure document protection in Word 2013
  • work with draft versions in Word 2013
  • manage draft versions in Word 2013
  • share a document in Word 2013
  • share a document using e-mail and SkyDrive
  • create a PDF document in Word 2013
  • export a Word document as a PDF
  • work with blogs in Word 2013
  • post a Word 2013 document to a blog

Overview/Description
Word 2013 enables you to share and collaborate on documents in a variety of ways. To protect a document you can mark it as final, making it read only, you can add a password to the document, and you can edit who changes the document, and what changes they can make. This course explores these concepts along with restoring draft versions of documents and sharing documents via e-mail or SkyDrive. It also examines working with PDF documents in Word and working with blogs. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Structuring a Document in Word 2013

Course Number:
mo_bgwo_b03_dt_enus
Lesson Objectives

Structuring a Document in Word 2013

  • adjust the paper size and margins in a Word 2013 document
  • add headers and footers to a document in Word 2013
  • add page numbers to a document in Word 2013
  • adjust the spacing in a Word 2013 document

Overview/Description
Within Word 2013, there are numerous options that allow you to customize how the contents of your documents appear. Items like page margins, paper sizes, and spacing are fully customizable. You can also add headers and footers to easily include important information on some or all of the pages in your document and add page numbers to make it easier to navigate longer documents This course demonstrates how to adjust page margins and paper size, as well as how to add, edit, and remove headers and footers. Adding page numbers, configuring indentation, and adjusting paragraph spacing are also covered. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Using Tables in Word 2013

Course Number:
mo_bgwo_b05_dt_enus
Lesson Objectives

Using Tables in Word 2013

  • create a table in Word 2013
  • manipulate cells, columns, and rows in a table in Word 2013
  • split and merge table cells in Word 2013
  • change the style of a table in Word 2013

Overview/Description
Tables are a great way of sorting and organizing data to make it easier to read and analyze. In Word 2013, you can create tables in a variety of ways, either using the ribbon to specify the number of columns and rows required, drawing a table and customizing it as needed, or converting existing text to a table. Once you've created a table, there are many options available to customize its overall appearance. You can add and remove cells, columns, and rows as needed, as well as merge cells, split them apart, or even split a table into more than one table. You can use row and column design options, predefined styles, and border settings to further customize a table's appearance. This course demonstrates how to create tables and add and remove cells, columns, and rows. It shows how to split or merge cells and split tables, adjust table style options, and customize table borders. This course will help prepare learners for the Microsoft Certification Exam 77-418: Word 2013 which certifies individuals as Microsoft Office Specialist (MOS): Word 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Word 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2013; end-users seeking a basic IT certification

Community Sites, Search, and Office Integration in SharePoint 2013

Course Number:
mo_speu_b03_dt_enus
Lesson Objectives

Community Sites, Search, and Office Integration in SharePoint 2013

  • rate a discussion in a SharePoint 2013 community site
  • create a category for a discussion and a badge in Sharepoint 2013
  • search in SharePoint 2013
  • search and view results in SharePoint 2013
  • create a new Office file from SharePoint 2013
  • edit a Word document in the Word Web App

Overview/Description
As a move towards an even more collaborative working environment, SharePoint 2013 now includes community sites. These allow users to have discussions, store contents, and interact with others in a manner that would be familiar to anyone already using various forms of social media. SharePoint 2013 also provides powerful search capabilities that you can make use of to easily locate any items across a SharePoint site. This version of SharePoint also continues to offer integration with the Microsoft Office suite of products, allowing you to create new Office documents from within SharePoint, or to launch either the full version or Web App version of a product as needed. This course covers participating in a community site, including joining the site, viewing categories and membership, discussions, and leaving the site. In addition, this course explores administering a community site by managing discussions, creating categories, adjusting settings, creating and assigning badges, and configuring reputation settings. Using the basic search functionality included with SharePoint 2013 is also covered, as well as launching Office applications from within SharePoint 2013 and using the Office Web Apps. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification.

Configuring Lists, Libraries, E-mail, and Announcements in SharePoint 2013

Course Number:
mo_sppu_b02_dt_enus
Lesson Objectives

Configuring Lists, Libraries, E-mail, and Announcements in SharePoint 2013

  • configure lists and libraries in SharePoint 2013
  • create a list and customize its columns in SharePoint 2013
  • recover deleted items in SharePoint 2013
  • restore deleted items in SharePoint 2013
  • configure incoming e-mail settings in SharePoint 2013
  • create and manage announcements in SharePoint 2013
  • manage e-mail and announcements in SharePoint 2013

Overview/Description
You can use SharePoint 2013 to manage a variety of environments including those that house item lists and libraries. This course explores adding and configuring lists and document libraries - two of the most common apps that SharePoint 2013 users work with on a daily basis. It also delves into the communication side of SharePoint 2013 and walks you through configuring e-mail options so document libraries can receive items added through incoming e-mails messages, and teaches you how to work with the announcements app. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013, which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Configuring Pages, Sites, and Content in SharePoint 2013

Course Number:
mo_sppu_b01_dt_enus
Lesson Objectives

Configuring Pages, Sites, and Content in SharePoint 2013

  • create, edit, and delete pages in SharePoint 2013
  • create and configure a site in SharePoint 2013
  • configure the Content Organizer in SharePoint 2013
  • activate and deactivate document sets in SharePoint 2013
  • activate a document set in SharePoint 2013
  • edit the Quick Launch in SharePoint 2013

Overview/Description
This course explores SharePoint tasks such as creating sites using templates, and creating, editing and deleting pages. It also walks through processes such as using the Content Organizer to create rules to organize site content in SharePoint 2013. Other configuration topics include activating Document Sets, and customizing the Quick Launch. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Managing Templates, Views, and Versioning in SharePoint 2013

Course Number:
mo_sppu_b03_dt_enus
Lesson Objectives

Managing Templates, Views, and Versioning in SharePoint 2013

  • manage document templates in SharePoint 2013
  • create and manage a view in SharePoint 2013
  • manage views and templates in SharePoint 2013
  • configure content types in SharePoint 2013
  • associate a content type to a list and add a column for a content type in SharePoint 2013
  • enable ratings and add content validation in SharePoint 2013
  • enable ratings using likes and add content validation in SharePoint 2013
  • enable versioning in SharePoint 2013
  • publish an asset in SharePoint 2013
  • work with assets and versions in SharePoint 2013

Overview/Description
SharePoint 2013 is highly configurable and you can tweak your settings to manage even the way in which the information is presented. This course demonstrates how to manage list views so you can view more types of metadata about a particular item, the creator or the last modified date, for example. The course also shows you how to manage your document templates so that a document library's users can create Excel files by default, for example. In addition, it walks through enabling versioning and teaches you how to enable ratings and content validation, and how to publish assets in SharePoint 2013. It also instructs you on working with content types and column properties so libraries can support more types of files and SharePoint stores more metadata associated with the file types supported. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Prerequisites: none

Managing Web Parts, Users, and Groups in SharePoint 2013

Course Number:
mo_sppu_b04_dt_enus
Lesson Objectives

Managing Web Parts, Users, and Groups in SharePoint 2013

  • add and configure Web Parts in SharePoint 2013
  • add and configure Web Parts in SharePoint 2013
  • remove and hide Web Parts in SharePoint 2013
  • export and import Web Parts in SharePoint 2013
  • hide and export a Web Part in SharePoint 2013
  • add an app part to My Site from the SharePoint 2013 store
  • add a built-in app and find and add an app from the SharePoint 2013 Store
  • manage users and groups in SharePoint 2013
  • display user alerts in SharePoint 2013
  • manage user access and alerts in SharePoint 2013

Overview/Description
You can use the features of SharePoint 2013 to manage a page's Web Parts and a site's apps so the end result is a highly configurable collection of sites. This course explores adding and configuring Web Parts on personal My Site pages, and how to hide, remove, and export those Web Parts. It also delves into the process of downloading an app from the SharePoint Store. Another essential component of SharePoint 2013 is its array of user and group configuration tools. The course walks you through creating a group, adding users to a group, changing group permissions, and viewing a list of user alerts. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Prerequisites: none

My Site and Social Features in SharePoint 2013

Course Number:
mo_speu_b02_dt_enus
Lesson Objectives

My Site and Social Features in SharePoint 2013

  • configure a profile in My Site
  • work with the SkyDrive Pro and Sites pages in SharePoint 2013
  • create a blog post in a certain category
  • create tags and notes in SharePoint 2013
  • interact with the Newsfeed in SharePoint 2013

Overview/Description
In SharePoint 2013 social networking and collaboration have become even more of a focus. With the changes to My Site - now consisting of the NewsFeed, SkyDrive, and Sites pages - you have a number of social networking features and organizational efficiencies at your fingertips. This course explores how to configure My Site, including how to access your About Me page and edit your profile to include additional information. It also covers the use of the SkyDrive and Sites pages for managing files and collaboration. In addition, this course demonstrates how to create and manage blog posts, enabling efficient sharing of information with colleagues. Using tags and notes to classify and organize content and using the Newsfeed to keep track of activity on sites, people, tags, and documents you follow are also covered. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification.

Navigating, Lists, Libraries, Alerts, and Document Sets in SharePoint 2013

Course Number:
mo_speu_b01_dt_enus
Lesson Objectives

Navigating, Lists, Libraries, Alerts, and Document Sets in SharePoint 2013

  • navigate the SharePoint 2013 interface
  • create, edit, view, and delete a list item in SharePoint 2013
  • add, edit, check in and out, and delete documents in SharePoint 2013
  • create and manage alerts in SharePoint 2013
  • create and manage document sets in SharePoint 2013

Overview/Description
SharePoint 2013, the new release of Microsoft's popular file storage and collaboration platform, offers a number of new and enhanced features to increase efficiency and organization across users and locations. SharePoint lists allow you to keep track of important workplace elements, such as tasks and contacts, and are fully customizable to suit the needs of your organization. Organize, track, and share files across users and locations by storing them in document libraries, or organize related files further into document sets. Stay in tune with the pulse of your organization by creating alerts on SharePoint items and getting e-mail or text alerts when they change. This course covers how to navigate within the SharePoint 2013 interface using the Quick Launch and top link bar, as well as the Settings menu and the Newsfeed, SkyDrive, and Sites tabs. It also explores list and library management, including adding new items, adjusting item properties, and removing items. It demonstrates how to set alerts on list and libraries, as well as how to set an alert on search query results. Creating and adding files to document sets is also covered. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Using and Configuring Search in SharePoint 2013

Course Number:
mo_sppu_b05_dt_enus
Lesson Objectives

Using and Configuring Search in SharePoint 2013

  • configure search options in SharePoint 2013
  • configure site search visibility in SharePoint 2013
  • configure search settings in SharePoint 2013
  • configure query rules in SharePoint 2013
  • create a query rule in SharePoint 2013
  • work with the Refinement panel in SharePoint 2013
  • refine a search in Sharepoint 2013
  • search using Boolean operators and wildcards in Sharepoint 2013
  • run phonetic and advanced searches in SharePoint 2013
  • use operators and run a phonetic search in SharePoint 2013

Overview/Description
Having the ability to execute an effective online search has become an essential professional skill. SharePoint 2013 offers search capabilities that let you refine a search, use operators in your search to pinpoint exactly what you're looking for, and configure search settings. This course explores the search tools available in SharePoint 2013, including configuring search options, creating query rules and using promoted results, using the Refinement panel, running property and phonetic searches, and using wildcards and operators in search phrases. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Workflows, Collaboration, and Analysis in SharePoint 2013

Course Number:
mo_sppu_b06_dt_enus
Lesson Objectives

Workflows, Collaboration, and Analysis in SharePoint 2013

  • manage workflows in SharePoint 2013
  • create, edit, and remove a workflow in SharePoint 2013
  • collaborate with Microsoft Office assets in SharePoint 2013
  • collaborate using Microsoft Office applications in SharePoint 2013
  • view site activity in SharePoint 2013
  • view popularity trends and popular items in SharePoint 2013

Overview/Description
SharePoint makes it easy for end users to work with the file types they're familiar with by offering easy integration with other Office products. This course demonstrates how to use connect and synchronize SharePoint data with Office data and how to use Office web apps. It also shows you how to create and manage workflows, and view most popular items and a usage report. This course will help prepare learners for the Microsoft Certification Exam 77-419: SharePoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): SharePoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft SharePoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft SharePoint 2013; end-users seeking a basic IT certification

Creating and Customizing Visual Elements in Excel 2013

Course Number:
mo_adel_b01_dt_enus
Lesson Objectives

Creating and Customizing Visual Elements in Excel 2013

  • add text boxes and shapes in Excel 2013
  • insert a picture in Excel 2013
  • insert a SmartArt Graphic in Excel 2013
  • apply a watermark in Excel 2013
  • change the workbook theme in Excel 2013

Overview/Description
Excel has more than just charts to offer in the way of visual presentation. Graphic tools such as pictures, shapes, SmartArt, WordArt, and screenshots are all ways to enhance the visual impact of documents that tend to be dominated by numbers and text. The course shows how to insert and edit shapes, text boxes, and pictures. We'll see how to add a SmartArt graphic and we'll demonstrate how to add watermarks to your spreadsheets. We'll also look at how you can use workbook themes to enhance the presentation of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Creating Workbooks, Worksheets, and Data in Excel 2013

Course Number:
mo_bgel_b01_dt_enus
Lesson Objectives

Creating Workbooks, Worksheets, and Data in Excel 2013

  • create a new workbook and open a workbook in Excel 2013
  • move around Excel and enter data
  • cut, copy, and paste in Excel 2013
  • delete or hide a worksheet
  • organize and modify worksheets in Excel 2013

Overview/Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Customizing Options and Views in Excel 2013

Course Number:
mo_adel_b02_dt_enus
Lesson Objectives

Customizing Options and Views in Excel 2013

  • hide and show worksheet data and elements in Excel 2013
  • change how worksheet data displays in Excel 2013
  • create a custom worksheet view
  • create appropriate worksheet views in Excel 2013
  • change how worksheet windows display in Excel 2013
  • arrange worksheet windows in Excel 2013
  • change default options for new workbooks in Excel 2013
  • personalize the ribbon and quick access toolbar in Excel 2013
  • customize your default options in Excel 2013

Overview/Description
Excel 2013 allows you to customize options and views to create a personalized environment. You can change how data displays by hiding and unhiding rows and columns; enable Show options; and also change the zoom level. You can switch workbook views from Normal to Page Layout, to Page Break Preview, or create custom views. This course will also cover the ways to arrange windows including Arrange All, Freeze Panes, Split, and View Side by Side. It will also show you how to change the defaults for creating new workbooks and personalize the Ribbon and Quick Access Toolbar. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Data Search, Data Validation, and Macros in Excel 2013

Course Number:
mo_adel_b04_dt_enus
Lesson Objectives

Data Search, Data Validation, and Macros in Excel 2013

  • edit workbook properties in Excel 2013
  • change the row height and column width in Excel 2013
  • find and replace data in Excel 2013
  • decide how to find and replace data in Excel 2013
  • add basic data validation to a worksheet in Excel 2013
  • use advanced data validation in Excel 2013
  • decide how to use data validation in Excel 2013
  • run a macro in Excel 2013
  • create a macro in Excel 2013
  • decide how to record a macro in Excel 2013 and make it available on Quick Access Toolbar and the ribbon

Overview/Description
Excel 2013 provides time-saving tools to manage data, validate data, and automate repetitive tasks. You can import files, and add and adjust columns and rows, as well as edit workbook properties. Find and replace allows users to find and replace data, in a specific format, or within the worksheet or workbook. It also allows you to use wildcard characters to customize the search. Data validation can be applied to a cell or range to restrict the data being entered. You can put upper and lower limits, restrict the number of characters, put items in a list, or validate against other cells. You can also add error alerts and identify invalid data. This course will also introduce you to macros in Excel and show you how to automate repetitive tasks to make working in Excel easier. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Formatting Cells and Worksheets in Excel 2013

Course Number:
mo_bgel_b03_dt_enus
Lesson Objectives

Formatting Cells and Worksheets in Excel 2013

  • change font formatting in Excel 2013
  • apply borders and fills and create a cell style
  • copy formatting with Format Painter in Excel 2013
  • change the alignment, indentation, and orientation of data in Excel 2013
  • merge cells and wrap text in Excel 2013

Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Formatting Data in Excel 2013

Course Number:
mo_bgel_b04_dt_enus
Lesson Objectives

Formatting Data in Excel 2013

  • format numbers in Excel 2013
  • use Auto Fill to copy and fill a series in Excel 2013
  • extract or add data using Flash Fill in Excel 2013
  • create and modify a hyperlink in an Excel 2013 workbook

Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Manipulating Data in Excel 2013

Course Number:
mo_adel_b03_dt_enus
Lesson Objectives

Manipulating Data in Excel 2013

  • sort data in Excel 2013
  • group data in Excel 2013
  • filter data in Excel 2013
  • convert text to columns in Excel 2013

Overview/Description
Excel 2013 provides multiple features for organizing and managing data, including sorting and filtering tools that are essential to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Data tab allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2013 using the built-in features. It also covers converting text to columns for easy of splitting text. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Mentoring 77-420 Excel 2013

Lesson Objectives

Mentoring 77-420 Excel 2013

  • Create and Manage Worksheets and Workbooks
  • Create Cells and Ranges
  • Create Tables
  • Apply Formulas and Functions
  • Create Charts and Objects

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-420 Excel 2013. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Performing Calculations Using Functions in Excel 2013

Course Number:
mo_bgel_b06_dt_enus
Lesson Objectives

Performing Calculations Using Functions in Excel 2013

  • create a basic formula in Excel 2013
  • reference cells in formulas in Excel 2013
  • create a named range in Excel 2013
  • use basic functions in Excel 2013
  • create formulas using basic logical functions in Excel 2013
  • create an IF-type formula in Excel 2013

Overview/Description
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Presenting Data in Tables and Charts in Excel 2013

Course Number:
mo_bgel_b07_dt_enus
Lesson Objectives

Presenting Data in Tables and Charts in Excel 2013

  • create a table in Excel 2013
  • format a table and customize a table style in Excel 2013
  • create a chart in Excel 2013
  • add elements to a chart in Excel 2013
  • change the appearance of a chart in Excel 2013

Overview/Description
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Presenting Data using Conditional Formatting and Sparklines in Excel 2013

Course Number:
mo_bgel_b05_dt_enus
Lesson Objectives

Presenting Data using Conditional Formatting and Sparklines in Excel 2013

  • apply conditional formatting to a worksheet in Excel 2013
  • create custom conditional formatting rules in Excel 2013
  • create a basic sparkline in Excel 2013
  • create an advanced sparkline in Excel 2013

Overview/Description
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Saving and Printing Data in Excel 2013

Course Number:
mo_bgel_b02_dt_enus
Lesson Objectives

Saving and Printing Data in Excel 2013

  • save a workbook in Excel 2013
  • change the default save options in Excel 2013
  • recover a workbook in Excel 2013
  • print a workbook
  • configure the page layout in Excel 2013

Overview/Description
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Advanced Slide Shows Tools in PowerPoint 2013

Course Number:
mo_adpw_b01_dt_enus
Lesson Objectives

Advanced Slide Shows Tools in PowerPoint 2013

  • create custom animations in PowerPoint 2013
  • modify PowerPoint 2013 presentation objects to suit your purpose
  • add charts to PowerPoint 2013 presentations
  • modify the look of a chart in PowerPoint 2013
  • maintain a consistent look and feel across slides in a PowerPoint 2013 presentation

Overview/Description
PowerPoint 2013 provides you with all the tools necessary to create and present engaging and effective presentations. As an advanced user, you can take advantage of features that allow you to customize your animations to create just the right effect. PowerPoint has tools for getting your animations to move at the right speed and in the right order using custom animation effects and motion paths. You'll learn how to merge shapes, add shape effects and how to use pictures and shapes as links to other pages in the presentation, or to pages on the Internet. This course also explores various ways of incorporating and modifying charts to create professional and effective presentations. Lastly, you'll learn how to create consistent looking presentations using tools like Smart Guides and Master Level Guides to align objects across all slides. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification

Animations and Media in PowerPoint 2013

Course Number:
mo_bgpw_b03_dt_enus
Lesson Objectives

Animations and Media in PowerPoint 2013

  • apply animations to PowerPoint 2013 presentations
  • use audio in PowrPoint 2013 presentations
  • add video and manage its playback in PowerPoint 2013

Overview/Description
PowerPoint 2013 can help you make presentations more dynamic by adding audio and video clips to any slide. You can directly insert, edit, and play video in your presentation, as well as add audio clips to create attention-grabbing sound effects. PowerPoint 2013 also has new animation tools which make slide shows more fluid and interesting. All of these features are discussed in this course. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification

Creating Presentations in PowerPoint 2013

Course Number:
mo_bgpw_b01_dt_enus
Lesson Objectives

Creating Presentations in PowerPoint 2013

  • create and view a PowerPoint 2013 presentation
  • add text to a PowerPoint 2013 presentation and format it
  • add an image to a PowerPoint 2013 presentation and format it
  • arrange slides in a presentation
  • determine the best saving option and save a presentation

Overview/Description
Microsoft PowerPoint 2013 allows you to create professional-looking slide-show presentations on PCs, tablets, and phones. This course provides an introduction to the main components of the PowerPoint 2013 interface, covering opening and saving a presentation, working with slides, formatting text and text boxes, and using templates and themes variations to create professional looking presentations. You will also learn how to insert images, clip art, and shapes, as well as how to format your images so that they provide the maximum impact for your presentation. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification.

Enhancing PowerPoint 2013 Presentations

Course Number:
mo_bgpw_b02_dt_enus
Lesson Objectives

Enhancing PowerPoint 2013 Presentations

  • add a table to a PowerPoint 2013 presentation
  • modify an existing table in PowerPoint 2013
  • use SmartArt in PowerPoint 2013 presentations
  • add WordArt to PowerPoint 2013 presentations
  • present images using the Photo Album feature in PowerPoint 2013

Overview/Description
PowerPoint 2013 enables you to create visually appealing presentations. Adding simple enhancements through the use of, tables, WordArt, and SmartArt allows you to make your presentations more engaging and interesting. This course introduces the SmartArt and WordArt features that allow you to add flair to your presentations by using colors and shapes to emphasize text and data. Also covered are the ways of incorporating and formatting tabular data to create a professional and effective presentation. You will also learn how to create a photo album to display your personal or business photographs. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification

Finalizing a PowerPoint 2013 Presentation

Course Number:
mo_bgpw_b04_dt_enus
Lesson Objectives

Finalizing a PowerPoint 2013 Presentation

  • apply transitions to a PowerPoint 2013 presentation
  • collaborate with others on powerPoint 2013 presentations
  • review PowerPoint 2013 presentations
  • prepare and present a PowerPoint 2013 presentation

Overview/Description
PowerPoint 2013's collaborative tools allow multiple people to work on the single presentation at the same time. To simplify the process of reviewing changes, you can now merge the reviewed version with your original version into one presentation. This course explores these topics and other collaboration features available in PowerPoint 2013 such as navigating through comments that were added to slides and accepting and rejecting changes. Also covered are slide transitions, proofing, language, and research tools, along with setting up and starting slide show presentations. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification

Sharing, Printing, Protecting and Delivery Presentations In PowerPoint 2013

Course Number:
mo_adpw_b02_dt_enus
Lesson Objectives

Sharing, Printing, Protecting and Delivery Presentations In PowerPoint 2013

  • choose the best way to share a presentation
  • use the PowerPoint Web App to work on presentations online
  • create appropriate PowerPoint 2013 printouts in a given scenario
  • finalize and protect a PowerPoint 2013 presentation
  • create presentations from Word outlines and create custom slide shows
  • use presenter tools in PowerPoint 2013
  • present a PowerPoint 2013 presentation online

Overview/Description
Today people can share and send the development of PowerPoint presentations in new and exciting ways. With the proper technological infrastructure in place, Microsoft PowerPoint Web App extends your Microsoft PowerPoint experience of the Web, where you can work with presentations directly on the web site where the presentation is stored. An alternative to sharing a presentation with other team members is to share or send the presentation as an e-mail attachment, send it by instant message, or save it to your SkyDrive Account or to Office 365 SharePoint . You can also export your presentation by creating a video, creating handouts, or packaging the presentation on a CD. This course explores the different methods of printing, protecting, and delivering presentations including how to use PowerPoint 2013 Presenter View, which includes tools such as highlighters and laser pointers, and how to present online using Microsoft Lync and Office Presentation Service. This course will help prepare learners for the Microsoft Certification Exam 77-422: PowerPoint 2013 which certifies individuals as Microsoft Office Specialist (MOS): PowerPoint 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft PowerPoint 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft PowerPoint 2013; end-users seeking a basic IT certification

Prerequisites: none

Collaboration and Customization with the Calendar, Contacts and Tasks in Outlook 2013

Course Number:
mo_adou_b04_dt_enus
Lesson Objectives

Collaboration and Customization with the Calendar, Contacts and Tasks in Outlook 2013

  • share a calendar in Outlook 2013
  • manage multiple calendars in Outlook 2013
  • configure Calendar options in Outlook 2013
  • share and manage contacts in Outlook 2013
  • manage assigned tasks in Outlook 2013

Overview/Description
Outlook 2013 has a range of management features for calendars, contacts and tasks. In this course, you will learn how to share calendars and manage multiple calendars. You will also learn how to customize your calendar to suit the way you work. The course will also cover how to share and manage contacts and will teach you how to import contacts and manage multiple address books. You also will learn how to forward and assign tasks and how to manage task assignments. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Formatting E-mail and Configuring Message Options in Outlook 2013

Course Number:
mo_adou_b01_dt_enus
Lesson Objectives

Formatting E-mail and Configuring Message Options in Outlook 2013

  • specify a format for your e-mail messages and save e-mail messages
  • format e-mail messages and check the spelling and grammar of your e-mail messages
  • insert tables, graphics, links, and Quick Parts into Outlook 2013 e-mails
  • configure options for tracking e-mail in Outlook 2013
  • configure options when sending mail in Outlook 2013

Overview/Description
The default installation of Outlook 2013 allows you to easily send and receive messages among colleagues and friends. There are, however, many options that help you make creative, more visually appealing messages, as well as options that change how messages are sent. This course discusses sending e-mail in different message formats as well as formatting options that can be applied to the text and background of an e-mail. Also covered are how to check your message's spelling and grammar, how to track outgoing messages, how to add voting buttons, and how to set importance and sensitivity options. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Mail Automation, Cleanup, and Storage in Outlook 2013

Course Number:
mo_adou_b03_dt_enus
Lesson Objectives

Mail Automation, Cleanup, and Storage in Outlook 2013

  • work with Quick Steps in Outlook 2013
  • create and modify Quick Steps in Outlook 2013
  • create, run, and modify rules in Outlook 2013
  • create rules for automatic replies in Outlook 2013
  • create, run, and manage rules in Outlook 2013
  • manage conversations in Outlook 2013
  • manage junk mail in Outlook 2013
  • manage conversations and junk mail in Outlook 2013
  • work with clean up tools in Outlook 2013
  • create and use data files in Outlook 2013
  • work with cleanup options, archiving options, and data files to manage your Outlook 2013 mailbox

Overview/Description
Outlook 2013 contains a range of features to help manage the large volume of e-mail that many users receive on a daily basis. This course discusses managing e-mail messages with rules as well as configuring rules for automatic replies. It also covers options for managing junk mail and it discusses the cleanup tools available in Outlook 2013. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Management and Customization in Outlook 2013

Course Number:
mo_adou_b02_dt_enus
Lesson Objectives

Management and Customization in Outlook 2013

  • use Instant Search and Search folders in Outlook 2013
  • search for items in Outlook 2013
  • flag items in Outlook 2013
  • color-code items in Outlook 2013
  • flag, set reminders on, and color-code items in Outlook 2013
  • customize views in Outlook 2013
  • create and use local folders in Outlook 2013
  • customize an Outlook 2013 list view
  • customize the Outlook 2013 content pane and configure Outlook 2013 options
  • modify the content pane and configure options for Outlook 2013
  • create and manage notes and create Journal entries in Outlook 2013
  • add an account to Outlook 2013
  • add a Hotmail account to Outlook 2013

Overview/Description
Outlook 2013 provides a range of search functions as well as functions to flag and categorize Outlook items. The Outlook 2013 environment itself is also customizable. So in addition to controlling items within Outlook, you can configure Outlook itself to suit the way you work. The course covers how to use the Instant Search feature, which allows you to instantly find e-mail messages, and how to refine your searches in Outlook 2013. It covers the creation of Search folders, which is a type of virtual folder used to automatically organize messages in Outlook. Options that allow you to categorize and flag messages are also discussed. You will learn how to create and use local folders, and use the Note and Journal management tools. In this course, you will also learn how to customize the content panes in Outlook, how to customize views, add an account, and configure Outlook options. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Managing E-mail in Outlook 2013

Course Number:
mo_bgou_b02_dt_enus
Lesson Objectives

Managing E-mail in Outlook 2013

  • attach items to messages and view attached items in Outlook 2013
  • create and add a signature in Outlook 2013
  • sort, filter, delete, restore, and print messages in Outlook 2013
  • personalize your content pane in Outlook 2013

Overview/Description
This course discusses working with attachments and adding signatures to your messages in Outlook 2013. Managing your e-mail by sorting, filter, printing and deleting messages is also covered. This course also covers ways to personalize your inbox in Outlook 2013, such as changing message preview settings, and adjusting the reading pane and people pane. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Scheduling with Appointments, Events, and Tasks in Outlook 2013

Course Number:
mo_bgou_b04_dt_enus
Lesson Objectives

Scheduling with Appointments, Events, and Tasks in Outlook 2013

  • create an appointment and an event in Outlook 2013
  • navigate the Calendar in Outlook 2013
  • create tasks in Outlook 2013
  • work with tasks in Outlook 2013

Overview/Description
The Outlook 2013 Calendar allows you to create appointments and events, as well as schedule meetings. The Calendar is fully integrated with the other components of Microsoft Outlook 2013 allowing you to easily incorporate your contacts and e-mail functionality with the Calendar. This course introduces the major components of the Calendar and discusses how to create appointments and events. Microsoft Outlook 2013 also provides the Tasks feature to help keep you organized and to assist you with the various tasks that you need to process on a daily basis. This course demonstrates how to create tasks in Outlook 2013 to help you to manage your time and stay organized. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification

Working with Contacts in Outlook 2013

Course Number:
mo_bgou_b03_dt_enus
Lesson Objectives

Working with Contacts in Outlook 2013

  • create, view, and edit contacts in Outlook 2013
  • create and modify a contact group in Outlook 2013
  • manage contacts in Outlook 2013
  • integrate a contact's social network account in Outlook 2013

Overview/Description
By taking the time to create contacts in Outlook 2013, you can save yourself from having to type out full e-mail addresses every time you send a message, assign a task or send out meeting requests. You can further arrange contacts by creating contact groups that allow you to e-mail multiple contacts at once by only typing the group name. This course covers the multiple ways that contacts and contact groups can be created, and covers how to manage contact information within the People folder in Outlook 2013. It also covers how to integrate contact information from a social network with Outlook 2013. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Working with E-mail in Outlook 2013

Course Number:
mo_bgou_b01_dt_enus
Lesson Objectives

Working with E-mail in Outlook 2013

  • access messages in Outlook 2013
  • reply to e-mail in Outlook 2013
  • address new mail in Outlook 2013
  • sorting inbox items by Conversation in Outlook 2013
  • access mail through the People Pane in Outlook 2013

Overview/Description
Outlook 2013 is the latest release of Microsoft's primary messaging client. Outlook provides all of the tools necessary for managing e-mail, scheduling tasks, and communication. This course addresses the basic features and functionality of Outlook 2013 - how to navigate Outlook 2013, view and reply to incoming e-mails, and create new mail messages. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification

Working with Meetings in Outlook 2013

Course Number:
mo_bgou_b05_dt_enus
Lesson Objectives

Working with Meetings in Outlook 2013

  • create a meeting request in Outlook 2013
  • edit or cancel a meeting in Outlook 2013
  • use the available response options for a meeting request in Outlook 2013
  • manage meetings in Outlook 2013

Overview/Description
The Outlook 2013 Calendar allows you to schedule meetings in addition to creating appointments and events. This course shows how to schedule meetings with other Outlook users. It also demonstrates the available options when replying to meeting requests and managing meeting requests in Outlook 2013. This course will help prepare learners for the Microsoft Certification Exam 77-423: Outlook 2013 which certifies individuals as Microsoft Office Specialist (MOS): Outlook 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Outlook 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Outlook 2013; end-users seeking a basic IT certification.

Advanced Formats and Layouts in Excel 2013

Course Number:
mo_puel_b03_dt_enus
Lesson Objectives

Advanced Formats and Layouts in Excel 2013

  • create a custom data format in Excel 2013
  • create a custom fill series in Excel 2013
  • decide how to create a custom data format and fill series in Excel 2013
  • apply custom styles in Excel 2013
  • add form fields to a workbook and create a template in Excel 2013
  • add form fields to a workbook and create a template in Excel 2013
  • choose how to create a custom cell style and form control in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • decide how to apply advanced conditional formatting and filtering in Excel 2013
  • check for accessibility issues in Excel 2013
  • decide how to provide accessibility in a workbook in Excel 2013

Overview/Description
Excel 2013 provides many advanced features to customize formats and layouts. Data can be customized to any format and adding a customized fill series can not only save you time, but help ensure consistency and accuracy in your work. Customizing cells, adding forms, and creating templates all help tailor your workbooks to your individual needs. Conditional formatting can also format ranges according to specific criteria. Finally, Excel provides tools to help create workbooks that are accessible and consider international audiences. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Advanced Formulas and Functions in Excel 2013

Course Number:
mo_puel_b04_dt_enus
Lesson Objectives

Advanced Formulas and Functions in Excel 2013

  • use date and time functions in Excel 2013
  • decide how to use date and time functions in Excel 2013
  • use logical functions in Excel 2013
  • choose the logical functions to use in Excel 2013
  • transpose data in Excel 2013
  • look up data with functions in Excel 2013
  • decide how to look up data with functions in Excel 2013
  • trace errors in Excel 2013
  • decide how to trace errors in Excel 2013

Overview/Description
The Excel 2013 function library includes a number of functions in the Date and time, Logical, and Lookup and reference categories that enables you to quickly complete tasks and analyze data. Date and time functions allow you to capture dates and times properly. This course covers date and time functions such as NOW, TODAY, DATE, and NETWORKDAYS. Logical and IF-type functions help you make decisions. This course covers IF, AND, OR, AVERAGEIFS, COUNTIFS, and SUMIFS. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, and HLOOKUP. Excel 2013 also provides tools to identify, trace, and troubleshoot errors. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Mentoring 77-427 Excel 2013 Expert Part One

Lesson Objectives

Mentoring 77-427 Excel 2013 Expert Part One

  • Manage and Share Workbooks
  • Apply Custom Formats and Layouts
  • Create Advanced Formulas
  • Create Advanced Charts and Tables

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-427 Excel 2013 Expert Part One. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Reviewing and Protecting Content in Excel 2013

Course Number:
mo_puel_b02_dt_enus
Lesson Objectives

Reviewing and Protecting Content in Excel 2013

  • consolidate data and merge workbooks in Excel 2013
  • decide how to consolidate data in Excel 2013
  • choose how to merge workbooks in Excel 2013
  • use Track Changes in Excel 2013
  • add and edit comments in Excel 2013
  • spell check a workbook in Excel 2013
  • decide how to use comments and track changes in Excel 2013
  • protect sheets and workbooks in Excel 2013
  • choose how to protect workbooks in Excel 2013

Overview/Description
Excel 2013 provides tools that allow you to manage multiple workbooks as well review and protect them while creating and sharing content. You can consolidate data, control recalculation, merge and manage versions of a workbook. Excel also provides the track changes feature allowing you to track, accept, or reject changes. When reviewing comments, you can edit, add, or delete comments. In addition, the spell checker reviews the spelling and allows you to change, ignore, or add to the dictionary. Finally, Excel allows you to protect a range, worksheet, or workbook with a password. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Prerequisites: none

Sharing and Linking Data, and Adding Office Apps to Excel 2013

Course Number:
mo_puel_b01_dt_enus
Lesson Objectives

Sharing and Linking Data, and Adding Office Apps to Excel 2013

  • add a service to Excel 2013 so you can save workbooks online
  • save a workbook online with Excel 2013
  • connect a workbook to external data in Excel 2013
  • add an Office app to Excel 2013

Overview/Description
Excel 2013 provides tools to allow you to share workbooks, connect to external data, and add Office Apps. You can log into Office using an Office 365 Organizational ID or Microsoft account, allowing you to carry your personalized Office settings with you. You can add online services including SkyDrive and SharePoint storage, as well as Microsoft accounts to access and share your images and videos with social media sites. This course will show you how to link to external data including Access databases and other Excel workbooks. Finally, it will show you how to add Office Apps from the Office Store to extend the functionality of Excel, on demand. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Using Financial Functions and What-If Analysis in Excel 2013

Course Number:
mo_puel_b05_dt_enus
Lesson Objectives

Using Financial Functions and What-If Analysis in Excel 2013

  • use financial functions in Excel 2013
  • enable iterative calculations in Excel 2013
  • decide how to use financial functions in Excel 2013
  • decide how to allow circular references in Excel 2013
  • add a watch to a cell in Excel 2013
  • decide how to watch cells in Excel 2013
  • use Goal Seek to find the input for a result in Excel 2013
  • compare scenarios with Scenario Manager in Excel 2013
  • create a data table in Excel 2013
  • decide how to use what-if analysis in Excel 2013

Overview/Description
Excel 2013 provides powerful financial functions and data-analysis tools that enable you to explore data and to make educated business decisions based on that data. Using financial functions, iterative calculations, and the Watch Window can help you make the make better financial decisions and ensure the calculations are accurate. This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula results. These tools include Goal Seek, Scenario Manager, and Data Tables. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

Course Number:
mo_puel_b06_dt_enus
Lesson Objectives

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

  • create a PivotTable in Excel 2013
  • edit a PivotTable in Excel 2013
  • decide how to create a PivotTable in Excel 2013
  • create a PivotChart in Excel 2013
  • decide how to create a PivotChart in Excel 2013
  • use PowerPivot to create a PivotTable in Excel 2013
  • decide how to use PowerPivot in Excel 2013
  • use advanced chart features in Excel 2013
  • choose advanced elements to apply to charts in Excel 2013

Overview/Description
One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In addition to these benefits, PowerPivot has the ability to handle huge amounts of data, quickly and easily. The course also shows how to create advanced chart elements, such as trend lines and dual axis. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Advanced Formats and Layouts in Excel 2013

Course Number:
mo_puel_b03_dt_enus
Lesson Objectives

Advanced Formats and Layouts in Excel 2013

  • create a custom data format in Excel 2013
  • create a custom fill series in Excel 2013
  • decide how to create a custom data format and fill series in Excel 2013
  • apply custom styles in Excel 2013
  • add form fields to a workbook and create a template in Excel 2013
  • add form fields to a workbook and create a template in Excel 2013
  • choose how to create a custom cell style and form control in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • apply advanced conditional formatting in Excel 2013
  • decide how to apply advanced conditional formatting and filtering in Excel 2013
  • check for accessibility issues in Excel 2013
  • decide how to provide accessibility in a workbook in Excel 2013

Overview/Description
Excel 2013 provides many advanced features to customize formats and layouts. Data can be customized to any format and adding a customized fill series can not only save you time, but help ensure consistency and accuracy in your work. Customizing cells, adding forms, and creating templates all help tailor your workbooks to your individual needs. Conditional formatting can also format ranges according to specific criteria. Finally, Excel provides tools to help create workbooks that are accessible and consider international audiences. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Advanced Formulas and Functions in Excel 2013

Course Number:
mo_puel_b04_dt_enus
Lesson Objectives

Advanced Formulas and Functions in Excel 2013

  • use date and time functions in Excel 2013
  • decide how to use date and time functions in Excel 2013
  • use logical functions in Excel 2013
  • choose the logical functions to use in Excel 2013
  • transpose data in Excel 2013
  • look up data with functions in Excel 2013
  • decide how to look up data with functions in Excel 2013
  • trace errors in Excel 2013
  • decide how to trace errors in Excel 2013

Overview/Description
The Excel 2013 function library includes a number of functions in the Date and time, Logical, and Lookup and reference categories that enables you to quickly complete tasks and analyze data. Date and time functions allow you to capture dates and times properly. This course covers date and time functions such as NOW, TODAY, DATE, and NETWORKDAYS. Logical and IF-type functions help you make decisions. This course covers IF, AND, OR, AVERAGEIFS, COUNTIFS, and SUMIFS. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, and HLOOKUP. Excel 2013 also provides tools to identify, trace, and troubleshoot errors. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Mentoring 77-428 Excel 2013 Expert Part Two

Lesson Objectives

Mentoring 77-428 Excel 2013 Expert Part Two

  • Manage and Share Workbooks
  • Apply Custom Formats and Layouts
  • Create Advanced Formulas
  • Create Advanced Charts and Tables

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-428 Excel 2013 Expert Part Two. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Reviewing and Protecting Content in Excel 2013

Course Number:
mo_puel_b02_dt_enus
Lesson Objectives

Reviewing and Protecting Content in Excel 2013

  • consolidate data and merge workbooks in Excel 2013
  • decide how to consolidate data in Excel 2013
  • choose how to merge workbooks in Excel 2013
  • use Track Changes in Excel 2013
  • add and edit comments in Excel 2013
  • spell check a workbook in Excel 2013
  • decide how to use comments and track changes in Excel 2013
  • protect sheets and workbooks in Excel 2013
  • choose how to protect workbooks in Excel 2013

Overview/Description
Excel 2013 provides tools that allow you to manage multiple workbooks as well review and protect them while creating and sharing content. You can consolidate data, control recalculation, merge and manage versions of a workbook. Excel also provides the track changes feature allowing you to track, accept, or reject changes. When reviewing comments, you can edit, add, or delete comments. In addition, the spell checker reviews the spelling and allows you to change, ignore, or add to the dictionary. Finally, Excel allows you to protect a range, worksheet, or workbook with a password. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Prerequisites: none

Sharing and Linking Data, and Adding Office Apps to Excel 2013

Course Number:
mo_puel_b01_dt_enus
Lesson Objectives

Sharing and Linking Data, and Adding Office Apps to Excel 2013

  • add a service to Excel 2013 so you can save workbooks online
  • save a workbook online with Excel 2013
  • connect a workbook to external data in Excel 2013
  • add an Office app to Excel 2013

Overview/Description
Excel 2013 provides tools to allow you to share workbooks, connect to external data, and add Office Apps. You can log into Office using an Office 365 Organizational ID or Microsoft account, allowing you to carry your personalized Office settings with you. You can add online services including SkyDrive and SharePoint storage, as well as Microsoft accounts to access and share your images and videos with social media sites. This course will show you how to link to external data including Access databases and other Excel workbooks. Finally, it will show you how to add Office Apps from the Office Store to extend the functionality of Excel, on demand. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Using Financial Functions and What-If Analysis in Excel 2013

Course Number:
mo_puel_b05_dt_enus
Lesson Objectives

Using Financial Functions and What-If Analysis in Excel 2013

  • use financial functions in Excel 2013
  • enable iterative calculations in Excel 2013
  • decide how to use financial functions in Excel 2013
  • decide how to allow circular references in Excel 2013
  • add a watch to a cell in Excel 2013
  • decide how to watch cells in Excel 2013
  • use Goal Seek to find the input for a result in Excel 2013
  • compare scenarios with Scenario Manager in Excel 2013
  • create a data table in Excel 2013
  • decide how to use what-if analysis in Excel 2013

Overview/Description
Excel 2013 provides powerful financial functions and data-analysis tools that enable you to explore data and to make educated business decisions based on that data. Using financial functions, iterative calculations, and the Watch Window can help you make the make better financial decisions and ensure the calculations are accurate. This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula results. These tools include Goal Seek, Scenario Manager, and Data Tables. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

Course Number:
mo_puel_b06_dt_enus
Lesson Objectives

Using PivotTables, PivotCharts, and Advanced Charts in Excel 2013

  • create a PivotTable in Excel 2013
  • edit a PivotTable in Excel 2013
  • decide how to create a PivotTable in Excel 2013
  • create a PivotChart in Excel 2013
  • decide how to create a PivotChart in Excel 2013
  • use PowerPivot to create a PivotTable in Excel 2013
  • decide how to use PowerPivot in Excel 2013
  • use advanced chart features in Excel 2013
  • choose advanced elements to apply to charts in Excel 2013

Overview/Description
One of the most powerful tools that Excel 2013 provides is the collection of PivotTables, PivotCharts, and PowerPivot. These tools allow you to dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In addition to these benefits, PowerPivot has the ability to handle huge amounts of data, quickly and easily. The course also shows how to create advanced chart elements, such as trend lines and dual axis. This course will help prepare learners for the Microsoft Certification Exam 77-427: Excel 2013 Expert Part One, and Exam 77-428: Excel 2013 Expert Part Two, which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification

Close Chat Live