IT and Desktop Videos

Download a course collection

Select a category


Microsoft Office 2013 (543)

Expand all | Collapse all

Access 2013 (46)
Title Speaker Summary ID
Microsoft Access 2013: Access and SharePoint Gary Leenhouts Microsoft Access 2013 makes it easy to collaborate with users of SharePoint sites by allowing you to export a copy of a selected database object and storing the copy as a list in SharePoint. In this video; Gary Leenhouts uses the Export Wizard in Access to export a table to a SharePoint site as a list. 52277
Microsoft Access 2013: Access and SharePoint - Import Gary Leenhouts Microsoft Access 2013 allows you to take lists from SharePoint and either creates copies of the lists in Access by importing the data or connects to the data by linking to it. In this video; Gary Leenhouts uses the Import Wizard in Access 2013 to create a link between Access and a SharePoint list. 52278
Microsoft Access 2013: Access and SharePoint - Moving Data to SharePoint Gary Leenhouts Microsoft Access 2013 lets you move all your data to a SharePoint site to be displayed as lists in SharePoint that are linked back to the existing database. In this video; Gary Leenhouts uses the Export Tables in SharePoint Wizard to move the tables in an Access database to a SharePoint site. 52279
Microsoft Access 2013: Access Data Email and Outlook - Export Gary Leenhouts Microsoft Access 2013 interacts with your Outlook e-mail client to allow you to distribute Access data in multiple formats to your Contacts lists. In this video; Gary Leenhouts uses the E-mail feature to exploit Access 2013's integration with Microsoft Outlook and e-mail information; already attached as an Excel Workbook; to another user. 52294
Microsoft Access 2013: Access Data Email and Outlook - Import Gary Leenhouts Microsoft Access 2013's integration with Microsoft Outlook enables you to link to; append; or import information from your Contacts folder. In this video; Gary Leenhouts uses the Import Exchange/Outlook Wizard to create a live lookup by linking to and naming an Outlook Contacts folder; which presents as a table in Access. 52295
Microsoft Access 2013: Access Event Model Gary Leenhouts Microsoft Access 2013 enables you to construct user-friendly interfaces from forms containing controls incorporating configured events or user-triggered actions. In this video; Gary Leenhouts uses Access 2013's Builder tool to configure several form controls' user-triggered actions or events; before saving and demonstrating their use. 52290
Microsoft Access 2013: Action Queries - Append Query Gary Leenhouts Append queries in Microsoft Access 2013 are a subtype of action queries and are used to select data from one or more data sources before copying the selected data to an existing table. In this video; Gary Leenhouts uses the append query type in Access 2013 to produce a query that adds records to an existing table. 52276
Microsoft Access 2013: Action Queries - Delete Gary Leenhouts Delete queries in Microsoft Access 2013 are a subtype of action queries that allow you to delete data in a table based on specific criteria. In this video; Gary Leenhouts uses the delete query option in Access 2013 to set criteria; whereby specific rows of data are deleted from a table. 52275
Microsoft Access 2013: Action Queries - Make Table Gary Leenhouts Make tables in Microsoft Access 2013 are typically used to retrieve data from one or more tables and place the data in another table in order to make a copy or archive data. In this video; Gary Leenhouts demonstrates how to extract information from a table and place it in new table in Access 2013. 52274
Microsoft Access 2013: Action Queries - Update Gary Leenhouts Update queries in Microsoft Access 2013 are a subtype of action queries and are used to change existing data in your tables. In this video; Gary Leenhouts uses the update query option from the DESIGN tab within the QUERY TOOLS tab to write an update expression in Query Builder in order to change the list prices in a table. 52273
Microsoft Access 2013: Archiving a Table Lynn Tao In Microsoft Access 2013; you can archive a table without using queries or macros. In this video; Lynn Tao demonstrates how to archive an entire table. 55294
Microsoft Access 2013: Archiving All Tables Lynn Tao Microsoft Access 2013 lets you replace all tables by replacing the backend database with an empty copy for archiving purposes. In this video; Lynn Tao demonstrates how to archive all tables in a database. 55295
Microsoft Access 2013: Archiving Records Lynn Tao Microsoft Access 2013 helps you organize large amounts of data by archiving older and active data. In this video; Lynn Tao demonstrates how to archive records. 55293
Microsoft Access 2013: Attachments Gary Leenhouts Microsoft Access 2013 lets you add attachment fields to your tables; allowing you to efficiently store different file types in a single field. In this video; Gary Leenhouts demonstrates how to add an attachment field into an Access table; as well as how to attach and manage files. 52267
Microsoft Access 2013: Conditional Formatting Gary Leenhouts Microsoft Access 2013 conditional formatting lets you format data in your forms and reports based on certain criteria; providing an easy way to highlight and display differences in data. In this video; Gary Leenhouts uses the Conditional Formatting option in Access 2013 to specify a formatting rule and set the formatting for a specified object within a report. 52270
Microsoft Access 2013: Creating a Crosstab Query Lynn Tao In Microsoft Access 2013; the crosstab query allows you to summarize information by grabbing data from different tables and organizing into a spreadsheet-like format for easy reading and reference. In this video; Lynn Tao demonstrates how to create a crosstab query in Access 2013. 55298
Microsoft Access 2013: Creating a Parameter Query Lynn Tao Microsoft Access 2013 allows you to prompt for values to include in a query which helps to run different variations with the same query. In this video; Lynn Tao demonstrates how to create a parameter query in Access 2013. 55299
Microsoft Access 2013: Customizing Fields Lynn Tao Microsoft Access 2013 makes it possible to customize fields to suit specific needs. In this video; Lynn Tao discusses how to customize fields by making it Required; changing the data types; field captions; Field Width; and the Default Value. 55272
Microsoft Access 2013: Customizing the Default Format of Datasheets Lynn Tao Microsoft Access 2013 is a great tool to customize the datasheets which will be more personalized and will visually stand out. In this video; Lynn Tao will demonstrate how to customize the default datasheets. 55267
Microsoft Access 2013: Customizing the List of Recently Opened Databases and Folders Lynn Tao In Access 2013; you can modify the number of databases and folders you want to be displayed as well as pin folders or include recent databases for quick access. In this video; Lynn Tao discusses how to customize the list of recently opened databases and folders. 55318
Microsoft Access 2013: Customizing the Ribbon and Quick Access Toolbar Lynn Tao Microsoft Access 2013 has features that help you customize its default interface. In this video; Lynn Tao will show how to personalize the Ribbon and the Quick Access Toolbar to make commonly used commands more accessible. 55269
Microsoft Access 2013: Data Validation Gary Leenhouts Microsoft Access 2013 lets you create validation rules to help improve the accuracy of your tables by restricting input in table fields. In this video; Gary Leenhouts demonstrates how to use Access to create rules for validating fields within a table and create display messages for input that is not valid. 52266
Microsoft Access 2013: Enforcing Referential Integrity Lynn Tao As with any relational database; Microsoft Access 2013 lets you create specific relationships between tables and fields. There are a set of rules; also known as referential integrity; that ensure the table relationships are enforced. In this video; Lynn Tao demonstrates this concept and how to apply it in Access 2013. 55329
Microsoft Access 2013: Export Data from Access Gary Leenhouts Microsoft Access 2013 enables you to export Access data to other applications better able to manipulate it. In this video; Gary Leenhouts uses Access 2013 to export an Access query as a Microsoft Excel workbook to an external location. 52293
Microsoft Access 2013: Find Duplicates Query Wizard Lynn Tao Microsoft Access 2013 finds duplicates easily with its query wizard to keep redundant data out of your database. In this video; Lynn Tao demonstrates how to create a Duplicates query in Access 2013. 55301
Microsoft Access 2013: Find Unmatched Query Wizard Lynn Tao Microsoft Access 2013allows you to find unmatched records easily with its query wizard. In this video; Lynn Tao demonstrates how to create a Find Unmatched Query Wizard in Access 2013. 55302
Microsoft Access 2013: Hiding and Freezing Fields Lynn Tao Microsoft Access 2013 has features that let you manipulate the visibility of fields and columns. In this video; Lynn Tao discusses how to use these features by freezing / unfreezing and hiding / unhiding columns and fields. 55270
Microsoft Access 2013: Import Data to Access Gary Leenhouts Microsoft Access 2013 enables you to import data - by linking; appending; or creating a new file; from external storage locations in different formats; into your existing tables. In this video; Gary Leenhouts demonstrates how to import and append data from an Excel spreadsheet to an existing table. 52292
Microsoft Access 2013: Joins Gary Leenhouts Microsoft Access 2013 uses joins as a method of connecting multiple data sources; in order to perform a query based on the combined data values of the different sources. In this video; Gary Leenhouts performs a query on two related tables before demonstrating how to change the join between them and alter the query. 52271
Microsoft Access 2013: Lookup Fields Gary Leenhouts Microsoft Access 2013's Lookup wizard eases data entry and enables you to create table relationships by listing predefined values for fields. In this video; Gary Leenhouts uses the Lookup Wizard to insert a lookup field; containing predetermined values; from one linked database table into another. 52287
Microsoft Access 2013: Multiuser Apps - Locking Splitting Gary Leenhouts Microsoft Access 2013's Database Splitter Wizard enables you to separate your database into a front-end interface database file containing non-configurable design elements; queries; forms; reports; and macros and a linked back-end file storing your table or other data. This conserves space and resources; and enhances security. In this video; Gary Leenhouts uses the Database Splitter Wizard to split a database. 52291
Microsoft Access 2013: Optimize Database - Analyze Performance Gary Leenhouts Microsoft Access 2013's Performance Analyzer reveals how a database's many objects are working together; recommends structural improvements; and accepts suggestions before allowing you to fix and optimize the database. In this video; Gary Leenhouts demonstrates how to run database tables through Access 2013's Performance Analyzer; and then selects Ideas and Analysis Notes for review. 52283
Microsoft Access 2013: Optimize Database - Analyze Table Gary Leenhouts Microsoft Access 2013's Table Analyzer Wizard enables you to test table data; normalize it by implementing recommended changes; and generate a query enabling forms and reports based on your original table to retain their functionality. In this video; Gary Leenhouts uses Access's Table Analyzer Wizard to identify issues; carry out several recommended changes; and generate a query. 52282
Microsoft Access 2013: Optimize Database - Compact and Repair Gary Leenhouts The Microsoft Access 2013 compact and repair feature helps you maintain optimal performance in your database by eliminating unused space; as well as attempting to recover corrupted files. In this video; Gary Leenhouts uses the Compact and Repair Database tool to schedule maintenance on a database and reduce the size of files. 52280
Microsoft Access 2013: Optimize Database - Database Documenter Gary Leenhouts Microsoft Access 2013's customizable Database Documenter enables you to document database object revisions and changes; and generate a detailed; printable report. In this video; Gary Leenhouts uses Access 2013's Database Documenter to generate and review a report on all object types in an Access database. 52281
Microsoft Access 2013: Package and Sign Tool Gary Leenhouts Microsoft Access 2013's Package and Sign tool enables you to package and attach a secure digital signature to a database when deploying it into a production environment. In this video; Gary Leenhouts uses the Package and Sign tool to package a selected database and attach a certificate to it. 52285
Microsoft Access 2013: Proofing with AutoCorrect and Spelling Lynn Tao Microsoft Access 2013 has features to correct spelling and grammar inaccuracy. In this video; Lynn Tao discusses AutoCorrect; Spell Check and their associated tools. 55268
Microsoft Access 2013: Restricting Changes to the Front-end Database Lynn Tao Access 2013 allows you to save your databases in a compiled binary file or an ACCDE file that restrict design changes while still allowing you to edit the data. In this video; Lynn Tao discusses how to restrict design changes to front-end databases in Access 2013. 55288
Microsoft Access 2013: Security Gary Leenhouts Microsoft Access 2013 enables you to encrypt and password protect your organization's databases - in exclusive use mode - for secure use by individuals using mobile devices. In this video; Gary Leenhouts opens a database in Exclusive mode; uses the Encrypt with Password feature to set a password; and tests its encryption. 52284
Microsoft Access 2013: Sharing Access Databases Gary Leenhouts Microsoft Access 2013 enhances database security by allowing you to open Access databases in modes appropriate to their use. These modes include Open; Open Read-Only; Open Exclusive; and Open Exclusive Read-Only. In this video; Gary Leenhouts discusses the different mode in which databases can be viewed. 52286
Microsoft Access 2013: Splitting a Database Lynn Tao Microsoft Access 2013 allows you to split a database to improve its performance and minimize the chance of data corruption. In this video; Lynn Tao will discusses how to split a database. 55271
Microsoft Access 2013: SQL Queries Gary Leenhouts Structured Query Language; or SQL; is what Microsoft Access 2013 uses when building any query. By having an understanding of SQL; you will be able to build and edit queries directly in the SQL window. In this video; Gary Leenhout uses Query Builder to create a query before explaining the syntax behind the query while in SQL View. 52272
Microsoft Access 2013: Subforms Gary Leenhouts In Microsoft Access 2013; you can use subforms; which are forms that are inserted in other forms; as a convenient way of displaying data between tables or queries that have a one-to-many relationship. In this video; Gary Leenhouts uses the Subform Subreport control in Access 2013 to embed a subform into a form. 52268
Microsoft Access 2013: Subreports Gary Leenhouts You can use subreports in Microsoft Access 2013; which are reports inserted in other reports; to display data from more than one table in a logical way in the same report. In this video; Gary Leenhouts uses the Subform Subreport control in Access 2013 to insert a report into another report to express a one-to-many relationship between two tables. 52269
Microsoft Access 2013: User Interface Macros Gary Leenhouts Microsoft Access 2013's macros ease and regulate data entry by automating interaction with the user interface through events customized in the Macro interface. In this video; Gary Leenhouts uses the Macro interface's Expression Builder to configure actions governing selected form field events. 52288
Microsoft Access 2013: VBA in Access Gary Leenhouts Microsoft Access 2013's embedded programming language; Microsoft Visual Basic for Applications (VBA) enables you to program the user interface through the macro tool. In this video; Gary Leenhouts uses Access 2013's Design view to open a macro and introduce the blocks of code making up submacros; which can be run independently when called from within form events. 52289
Excel 2013 (66)
Title Speaker Summary ID
Microsoft Excel 2013: Add a Calculation Using the Paste Function Erin Olsen The paste function feature in Microsoft Excel 2013 simplifies the task of adding calculations to your workbook; guiding you through the process of creating functions while providing you with information about the arguments that the functions take. In this video; Erin Olsen uses the Function Arguments dialog box in Excel 2013 to build and add a function to a cell. 51843
Microsoft Excel 2013: Add Comments to Cells Erin Olsen Microsoft Excel 2013 gives users the ability to comment individual cells or a range of cells in a worksheet. These comments can contain explanatory notes or reminders; and can be useful for communication in a shared workbook. In this video; Erin Olsen demonstrates how to identify a cell that contains a comment and how to insert or delete a comment. 51847
Microsoft Excel 2013: Add Text to Calculated Values Erin Olsen By understanding the syntax and using custom formatting in Microsoft Excel 2013; you will be able to add labels to the calculated values in cells that will help clarify the data for users. In this video; Erin Olsen demonstrates how to add text to a cell containing a calculated value. 51822
Microsoft Excel 2013: Adjust Row Height and Column Width Erin Olsen You can adjust the default row height and column width in Microsoft Excel 2013 to accommodate the content onscreen or when printed out; as well as add visual appeal to certain elements by creating extra whitespace. In this video; Erin Olsen demonstrates the various methods used to adjust the row height and column width in an Excel worksheet. 51819
Microsoft Excel 2013: Allow Editing of Select Cells Erin Olsen Microsoft Excel 2013 provides users with the ability to allow editing of selected cells by authorized users; leaving the rest of the worksheet unavailable for editing. In this video; Erin Olsen demonstrates how to protect sections of a worksheet while allowing editing of other sections. 51854
Microsoft Excel 2013: Calculate Due Dates Based on Work Days Erin Olsen Microsoft Excel 2013's WORKDAY date and time function differs from the DAYS and DAYS360 functions by allowing you to easily exclude weekends and holidays from your calculations. In this video; Erin Olsen demonstrates how to use the Excel 2013 WORKDAY date and time function in a worksheet; and explains how it differs from the DAYS and DAYS360 functions. 51827
Microsoft Excel 2013: Calculate the Current Date Erin Olsen Microsoft Excel 2013 allows you to easily display the current date on a worksheet; saving you the trouble of having to know it and update it manually. In this video; Erin Olsen uses the TODAY function in Excel 2013 to return the system date to a cell in a worksheet. 51826
Microsoft Excel 2013: Calculate the Payments on a Loan Erin Olsen Microsoft Excel 2013 financial functions include the PMT function that you can use to calculate the payment amounts on a loan that will help you determine the affordability before committing to a long-term transaction. In this video; Erin Olsen uses the PMT function in Excel 2013 to calculate the monthly repayment amounts on a loan. 51825
Microsoft Excel 2013: Change a Cell Entry to Proper Case Erin Olsen In Microsoft Excel 2013; you can use the proper function to reformat text that has been entered in all caps so that it displays in title; or proper; case without you having to completely retype everything. In this video; Erin Olsen demonstrates how to create a formula using the proper function to automatically change case. 51842
Microsoft Excel 2013: Change How Zero Values Display Erin Olsen Depending on how you want the data to appear; you can change how zero values are presented in Microsoft Excel 2013. In this video; Erin Olsen demonstrates how to hide and show zeroes in cells containing a zero value before applying a custom format that determines how zero values are displayed in a specified range of cells. 51821
Microsoft Excel 2013: Concatenate Text Erin Olsen The CONCATENATE function in Microsoft Excel 2013 allows you to create elegant-looking results by joining text data from several cells together in a single destination cell to form easily read phrases and sentences. In this video; Erin Olsen highlights the CONCATENATE function syntax while combining text in a worksheet. 51824
Microsoft Excel 2013: Configure a Workbook for Multiple Users Erin Olsen Microsoft Excel 2013 gives users a variety of ways to share a workbook with multiple users. This includes sharing a workbook so that users cannot overwrite each other's changes. In this video; Erin Olsen demonstrates how to allow editing by multiple users; track changes; configure AutoSave options; and configure conflict management. 51848
Microsoft Excel 2013: Control Recalculate Erin Olsen Microsoft Excel 2013 allows you to control automatic recalculations when entering or changing worksheet data. In this video; Erin Olsen sets the calculation options to manual and demonstrates manual recalculation and update options. 51807
Microsoft Excel 2013: Convert a Table Back to a Normal Range Erin Olsen Microsoft Excel 2013 allows you to easily convert tables back to a normal data range without losing any of the table style formatting. In this video; Erin Olsen demonstrates how to convert an Excel table to a regular range of data in a worksheet. 51815
Microsoft Excel 2013: Copy Word Text to Excel Erin Olsen By identifying certain data in Word documents and copying it into Microsoft Excel 2013; you'll be able to take advantage of the many features and the functionality that Excel provides when structuring and analyzing data. In this video; Erin Olsen demonstrates how to clean up text in a Word document before copying it into an Excel worksheet. 51832
Microsoft Excel 2013: Create a Workbook from a Template Erin Olsen Microsoft Excel 2013's featured worksheet templates offer easy-to-use alternatives to designing fresh worksheet templates. In this video; Erin Olsen introduces Excel 2013's default templates; and demonstrates how to search for; download; and edit a worksheet template. 51805
Microsoft Excel 2013: Create an Advanced Filter Erin Olsen In Microsoft Excel 2013; you can limit the amount of data that you see at one time by using an advanced filter. In this video; Erin Olsen demonstrates how to do an advance filter using criteria you have specified for the data that you wish to view. 51836
Microsoft Excel 2013: Creating a Web Query Lynn Tao In Microsoft Access 2013; the Web query allows you to grab any external data from web pages and web sites in plain text format. In this video; Lynn Tao demonstrates how to create a Web query in Access 2013. 55300
Microsoft Excel 2013: Customizing Display Options for Workbooks and Worksheets Lynn Tao Excel 2013 contains the option to adjust various settings such as; hide the formula bar; the function screen tips; show all comments; hide the scrollbars; the row; and column headers. In this video; Lynn Tao discusses how to customize display options for workbooks and worksheets. 55315
Microsoft Excel 2013: Customizing the List of Recently Opened Workbooks and Folders Lynn Tao Excel 2013; allows you to adjust the display settings for the list of recently opened workbooks or folders. In this video; Lynn Tao discusses how to customize the recently opened workbooks and folders. 55317
Microsoft Excel 2013: Edit Cell Content Erin Olsen Microsoft Excel 2013 enables you to edit cell data by overtyping; adding; and appending data; or by editing data in the Formula bar. In this video; Erin Olsen demonstrates each method and describes its advantages or disadvantages. 51810
Microsoft Excel 2013: Export a SharePoint List to Excel Erin Olsen You can manipulate the data stored in a SharePoint list by exporting the list to Microsoft Excel 2013; which allows you to take advantage of the excellent formatting options and features in Excel without affecting the original SharePoint list. In this video; Erin Olsen demonstrates how to export a SharePoint list to Excel using the list tools in SharePoint. 51831
Microsoft Excel 2013: Fast Convenient Chart Format Tools Erin Olsen In Microsoft Excel 2013; the new chart formatting tools are much easier and convenient to use. In this video; Erin Olsen; demonstrates to use the chart formatting tools to create; format; and modify charts. 51860
Microsoft Excel 2013: Format a Cell Based on Its Value Erin Olsen In Microsoft Excel 2013; you can use conditional formatting to make data stand out; based on its value. In this video; Erin Olsen demonstrates how to format the data in the cells based on the conditions you have stipulated. 51835
Microsoft Excel 2013: Format Data as a Table Erin Olsen Microsoft Excel 2013 provides a useful feature that allows you to format a selected area of data as a table in a couple of easy steps using one of the many predefined table styles. In this video; Erin Olsen demonstrates how to create an Excel table in a worksheet. 51812
Microsoft Excel 2013: Format Tables Using Quick Styles Erin Olsen Microsoft Excel 2013 Quick Styles provide options that let you quickly format your tables with the flexibility of changing the style at any time while retaining your custom formatting. In this video; Erin Olsen demonstrates how to apply Quick Style formatting to tables. 51817
Microsoft Excel 2013: Identify and Select Chart Formatting Tools Erin Olsen Microsoft Excel 2013 gives users a range of formatting tools to customize their charts. In this video; Erin Olsen discusses the difficulties many users have identifying chart elements; such as the X axis; and demonstrates how to use the Current Selection options to do this. 51846
Microsoft Excel 2013: Insert and Delete Rows and Columns Erin Olsen Using spreadsheets in Microsoft Excel 2013 will more than likely require that the worksheet structure be modified from time to time by inserting and deleting rows and columns. In this video; Erin Olsen demonstrates the different techniques that can be used in Excel 2013 to efficiently add rows and columns into a worksheet. 51818
Microsoft Excel 2013: Keep Labels Visible by Freezing Panes Erin Olsen Microsoft Excel 2013's Freeze Panes feature allows you to frame data by selecting which columns or rows remain visible while the rest of your worksheet scrolls. In this video; Erin Olsen demonstrates how to freeze a single column; as well as a column and a row simultaneously. 51802
Microsoft Excel 2013: Let Excel Recommend a Pivot Table Erin Olsen Microsoft Excel 2013 simplifies the creation of pivot tables by analyzing selected data and proposing several pivot tables. Known as the Recommended PivotTables feature; this option saves steps and time; especially when analyzing complex data. In this video; Erin Olsen demonstrates how to select data and use the Recommended PivotTables option to create a suitable pivot table. 51850
Microsoft Excel 2013: Look Up Additional Information from a Known Value Erin Olsen In Microsoft Excel 2013; you can use lookups to find information using a known value. In this video; Erin Olsen uses the VLookup function to find related data from a data source. 51840
Microsoft Excel 2013: Mark a Workbook as Final Erin Olsen Microsoft Excel 2013's Mark as Final feature enables you to mark collaborative documents as final and disable their editing features; thereby rendering them read-only - a status that can be reversed by users with write permissions. In this video; Erin Olsen uses the Mark as Final feature to mark and save a document as final; before re-opening it for editing. 51804
Microsoft Excel 2013: Merge and Center Content Across Columns Erin Olsen The Merge and Center feature in Microsoft Excel 2013 allows you to easily create perfectly centered headings in your worksheets that dynamically change to accommodate any adjustments you might make to the column widths. In this video; Erin Olsen uses the Merge & Center option to create a centered label that spans multiple columns in a worksheet. 51820
Microsoft Excel 2013: Modify a Macro Using VBA Erin Olsen Microsoft Excel 2013 enables you to quickly and easily correct or amend your recorded macros by editing their VBA code in the Microsoft Visual Basic for Applications Editor. In this video; Erin Olsen shows you how to read and edit a macro's VBA code; save it as a Macro-Enabled Workbook; and run it from the DEVELOPER tab on the ribbon. 51857
Microsoft Excel 2013: Modify How Worksheets Print with Page Break Preview Erin Olsen Microsoft Excel 2013 provides users with the ability to modify how worksheets print using the Page Break Preview option. Users can insert their own page breaks; change page break placement; and remove page breaks. In this video; Erin Olsen demonstrates how to work with page breaks so that worksheets print in a way that is clearly readable. 51853
Microsoft Excel 2013: Modify Tables Using Style Options Erin Olsen Microsoft Excel 2013 provides you with the ability to optimally display tabular data by easily modifying an Excel table's appearance. In this video; Erin Olsen demonstrates how to modify the style of an Excel table. 51816
Microsoft Excel 2013: Navigate Through Worksheets and Workbooks Erin Olsen Microsoft Excel 2013 enables you to swiftly and easily navigate increasingly large worksheets by way of shortcut keys. Moreover; should you know the position of a cell; you can use Excel 2013's Go To feature to take you directly there. In this video; Erin Olsen demonstrates how to use shortcut keys and the Go To feature to navigate a worksheet. 51808
Microsoft Excel 2013: Organize Worksheets and Workbooks Erin Olsen Microsoft Excel 2013 allows you to organize your workbook's worksheets quickly and easily by simply dragging and dropping their tabs; before naming and color-coding them. In this video; Erin Olsen demonstrates how to move a worksheet from one workbook to another; format worksheet tabs; and delete worksheets. 51811
Microsoft Excel 2013: Perform Different Calculations Depending on Cell Values Erin Olsen The IF function is one of the most versatile and useful functions in Microsoft Excel 2013 allowing you to test the value of a cell and perform different calculations depending on whether or not a certain criteria is met. In this video; Erin Olsen describes the formula syntax of the IF function and uses to create a conditional formula. 51828
Microsoft Excel 2013: Presenting Online Lynn Tao In Microsoft Excel 2013; you can present your Workbook online by using the Lync Meeting. In this video; Lynn Tao demonstrates how to present an Excel Workbook online through the Lync Meeting. 55320
Microsoft Excel 2013: Printing Tips Erin Olsen Microsoft Excel 2013 provides users with a range of printing options that allow you to print the active worksheet or an entire workbook. There are also several ways to optimize printing. In this video; Erin Olsen gives various printing tips to optimize printing and demonstrates how to print a worksheet; a workbook; and a data selection. 51852
Microsoft Excel 2013: Protect a Workbook Erin Olsen Microsoft Excel 2013 facilitates secure sharing across organizations by enabling you to disable functionalities; partly or completely protecting the structure or screens of your workbooks and their worksheets from change by others. In this video; Erin Olsen demonstrates how to use Excel 2013's Protect Workbook feature to protect your workbooks from accidental overwriting or unintended change. 51855
Microsoft Excel 2013: Record a Simple Macro Erin Olsen Microsoft Excel 2013's macro recorder enables you to record macros; negating the need to perform repetitive actions and allowing you to accomplish complex tasks with the click of a self-designated shortcut button. In this video; Erin Olsen demonstrates how to set up; record; and save a spreadsheet macro formatted for use in a single or multiple workbooks. 51856
Microsoft Excel 2013: Remove Duplicates Erin Olsen In Microsoft Excel 2013; you can now remove duplicate data easily and effortlessly. In this video; Erin Olsen demonstrates how to use the Remove Duplicates feature to specify the criteria for removing duplicate data. 51837
Microsoft Excel 2013: Remove Metadata and Personal Information Erin Olsen Microsoft Excel 2013's Document Inspector enables you to selectively edit a shared document's metadata and allows you to remove personal information from it. In this video; Erin Olsen gives an overview of multiple categories of metadata and uses the Document Inspector to remove personal information from a document. 51803
Microsoft Excel 2013: Resize a Table Erin Olsen Microsoft Excel 2013 provides different methods that you can use to accurately identify a range of table data by manually modifying the size of tables. In this video; Erin Olsen demonstrates how to resize a table and specify a new table data range. 51814
Microsoft Excel 2013: Save Data to a SharePoint Library Erin Olsen Microsoft Excel 2013 allows you to easily save your Excel data directly to a library on a SharePoint site; providing colleagues within your organization with the ability to access the data. In this video; Erin Olsen demonstrates how to save a workbook to a SharePoint library from the Backstage in Excel 2013. 51830
Microsoft Excel 2013: Select Data in Excel Erin Olsen Microsoft Excel 2013 allows you to select worksheet data using navigation shortcut keys in conjunction with the Shift key; as well as with your mouse. In this video; Erin Olsen demonstrates various methods of selecting entire rows and columns; contiguous and discontiguous data selections; and your entire worksheet. 51809
Microsoft Excel 2013: Send a Workbook Using Lync Erin Olsen Microsoft Excel 2013 enables users to send workbooks to other user via Lync. This is the integrated messaging service provided by various Microsoft Office 2013 applications; such as SharePoint. This feature enables workbooks to be shared quickly and in context. In this video; Erin Olsen demonstrates how to send a workbook using instant messaging rather than e-mail. 51849
Microsoft Excel 2013: Simplify Data with an Outline Erin Olsen Microsoft Excel 2013's Auto Outline feature enables you to expand and collapse specific areas of your spreadsheets; containing calculations; for selective data presentation to different audiences - negating any need to maintain multiple versions. In this video; Erin Olsen demonstrates how to best set up; organize; and present multiple collapsible and expandable data levels using Microsoft Excel 2013's Auto Outline feature. 51858
Microsoft Excel 2013: Sort Worksheet Columns Erin Olsen In Microsoft Excel 2013; you can organize data in a number of ways. In this video; Erin Olsen uses the in-column filters in a defined table; as well as the Sort & Filter tool to sort data in worksheet columns. 51838
Microsoft Excel 2013: Split Single Text Entries into Multiple Columns Erin Olsen In Microsoft Excel 2013; you sometimes have to split single text entries into multiple columns. Excel provides a wizard that makes this easy to do. In this video; Erin Olsen demonstrates how to use the Text to Columns wizard to split single columns into multiple columns using a delimiter. 51833
Microsoft Excel 2013: Splitting a Worksheet into Windows Lynn Tao In Excel 2013; splitting a Worksheet into Windows allows you to compare different sections of the worksheet. In this video; Lynn Tao discusses how to Split a worksheet into Windows in Excel 2013. 55316
Microsoft Excel 2013: Summarize Data with Sparklines Erin Olsen Microsoft Excel 2013's Sparklines feature dispenses with elaborate graphs to give your data trends visual clout by enabling you to render custom; multi-cellular spreadsheet data in multiple graphic styles. In this video; Erin Olsen uses the Sparklines feature to show you how to select; define; and format spreadsheet data selections as mini-charts capable of communicating trends with immediate graphic impact. 51859
Microsoft Excel 2013: Summarize Data with Subtotals Erin Olsen Microsoft Excel 2013 gives users the ability to summarize data using subtotals. This method can be used only if there are at least three columns of data; which have been sorted by category. In this video; Erin Olsen demonstrates how to choose a valid Subtotal field; summarize the data; and troubleshoot the process if it doesn't work. 51844
Microsoft Excel 2013: Understand and Use Excel Views Erin Olsen Microsoft Excel 2013's views offer you three different views of your worksheet; each of which offers you different options and lets you format your worksheet according to your needs. In this video; Erin Olsen details the options available in the Normal; Page Layout; and Page Break Preview views. 51806
Microsoft Excel 2013: Understand How Table Calculations Differ Erin Olsen Table calculations in Microsoft Excel 2013 differ from conventional worksheet calculations and with an understanding of how the table calculations work you'll be able to take advantage of the numerous advantages they offer. In this video; Erin Olsen demonstrates how to perform a simple table calculation and describes the benefits of using table calculations. 51813
Microsoft Excel 2013: Use a Timeline to Filter Pivot Tables Erin Olsen Microsoft Excel 2013 enables the user to slice data in various ways using the timeline in a pivot table; if the data contains dates. In this video; Erin Olsen demonstrates how to select data and use the Recommended PivotTables option to create a suitable pivot table. 51851
Microsoft Excel 2013: Use Flash Fill Erin Olsen In Microsoft Excel 2013; you can use Flash Fill to auto-complete data in a column. In this video; Erin Olsen uses Flash Fill to auto-complete a column by comparing text entered into a cell with the data in adjacent columns. 51839
Microsoft Excel 2013: Use Goalseek to Find an Input Erin Olsen In Microsoft Excel 2013; you can calculate what-if type questions quickly; efficiently; and accurately using the Goal Seek feature. In this video; Erin Olsen; demonstrates how to use Goal Seek to calculate the answers you need; without knowing all the inputs required getting to the answer. 51861
Microsoft Excel 2013: Use Quick Analysis Tools Erin Olsen In Microsoft Excel 2013; you can analyse your data even faster and easier using the Quick Analysis tool. In this video; Erin Olsen demonstrates how to use the Quick Analysis tool to analyse your data and create meaningful information. 51834
Microsoft Excel 2013: Use Recommended Charts Erin Olsen Microsoft Excel 2013 gives users the ability to select a chart that suits their data from a list of recommended charts. The Recommended Charts feature presents previews of various charts based on the user's actual data. In this video; Erin Olsen demonstrates how to select a data range and choose a chart that best illustrates that data. 51845
Microsoft Excel 2013: Use the Namebox to Select Cells Erin Olsen In Microsoft Excel 2013; you can easily navigate to cells and worksheets using the Name box. In this video; Erin Olsen; demonstrates how to use the Name box to select cell names and move to the desired location in your worksheets. 53130
Microsoft Excel 2013: Use the Watch Window to Inspect Formulas Erin Olsen In Microsoft Excel 2013; you can use the Watch Window feature to monitor calculations across multiple worksheets while working with data in another worksheet. In this video; Erin Olsen uses the Watch Window to keep track of a calculation on one worksheet while entering data into a different worksheet. 51841
Microsoft Excel 2013: Validate Data Erin Olsen Microsoft Excel 2013 includes a data validation feature that you can use to define restrictions and control the data that users enter into a worksheet; thereby eliminating data entry errors. In this video; Erin Olsen demonstrates how to define a validation rule and provide messages to guide users; ensuring worksheet data integrity. 51823
Microsoft Excel 2013: View Calculation Flow Erin Olsen Microsoft Excel 2013 includes commands that allow you to visually represent the relationship between cells and formulas that can be very useful when contextualizing the flow of calculations as well as providing assistance when checking formulas for reference errors. In this video; Erin Olsen demonstrates how to use the Trace Precedents and Trace Dependents options in Excel. 51829
Lync 2013 (16)
Title Speaker Summary ID
Microsoft Lync 2013: Add or Change Your Picture Erin Olsen Microsoft Lync 2013 allows you to easily add; hide; change; edit; or remove your profile image. In this video; Erin demonstrates how to add; show; and edit your picture; as well as how to hide it from the main Lync interface or remove it altogether. 52301
Microsoft Lync 2013: Contacting Multiple Contacts Lynn Tao Microsoft Lync 2013 is a convenient messaging system that allows you to communicate and collaborate with multiple contacts. In this video; Lynn Tao discusses how to message multiple people in one instant message; email; and even meeting invite. 55328
Microsoft Lync 2013: Create an Ad Hoc Meeting with Meet Now Erin Olsen Microsoft Lync's Meet Now feature allows you to invite contacts; by Instant Messaging (IM); to an ad hoc virtual meeting with audio and video options in your own meeting space. In this video; Erin Olsen uses Meet Now to configure and initiate a meeting with a Microsoft Lync 2013 contact. 52310
Microsoft Lync 2013: Create Groups Erin Olsen Microsoft Lync 2013 allows you to streamline your communications by easily creating; naming; managing; and adding contacts to custom groups of individuals with which you can interact in multiple ways. In this video; Erin Olsen demonstrates how to create a group and configure it for optimally streamlined communication. 52298
Microsoft Lync 2013: Keep Status and Location Current Erin Olsen Microsoft Lync 2013 allows you to integrate with your Outlook calendar to update your online status and location. In addition; you can control how and what information is shown to whom. In this video; Erin Olsen demonstrates how to manually update your status and location from the Lync user interface. 52302
Microsoft Lync 2013: Meeting Space Options Erin Olsen Microsoft Lync 2013 contains multiple tools that enable you to configure your meeting space and set user permissions for once-off or reusable meeting spaces; the settings of which can be saved. In this video; Erin Olsen demonstrates how to configure presenter and attendee settings and permissions. 52307
Microsoft Lync 2013: New Display Options Erin Olsen Microsoft Lync 2013's Options page enables you to view or display your contacts in the manner best fitting your organizational needs - using or omitting images; by name; e-mail address; or differing degrees of availability. In this video; Erin Olsen demonstrates how to customize the Contacts List display. 52300
Microsoft Lync 2013: Organize Lync Meetings with Outlook Erin Olsen Microsoft Lync 2013 virtual meetings; scheduled through Outlook's Calendar view; enable you to set up a meeting and allow your invitees to respond and prepare for the virtual get-together. In this video; Erin Olsen demonstrates how to invite participants; specify a date; time; and subject for the meeting; and send out an invitation. 52309
Microsoft Lync 2013: Quick Lync Bar Erin Olsen Microsoft Lync 2013's new; easily accessible Quick Lync bar enables you to start an Instant Messaging (IM) or Chat session; make a Lync phone or video call; view a person's contact card; send e-mails; schedule meetings; and more. In this video; Erin Olsen demonstrates the Quick Lync bar's features and explains how they can be put to further use. 52297
Microsoft Lync 2013: Review and Use Contact Cards Erin Olsen Microsoft Lync 2013's contact cards contain information essential to your successful use of Lync. Consisting of five tabbed pages; a Quick Lync bar; and actionable links; each contact's card contains a wealth of editable personal; demographic; group; and organizational-relationship data. In this video; Erin Olsen explains Lync 2013 contact card data groups' tabbed pages; their sources; and uses. 52305
Microsoft Lync 2013: Search for Contacts Erin Olsen Microsoft Lync 2013's Find Someone's advanced-capability search feature enables you to search for and locate contacts across multiple integrated applications. In this video; Erin Olsen demonstrates the filtering capabilities of the Find Someone search feature and uses it to locate a contact. 52296
Microsoft Lync 2013: Shared Notes Erin Olsen Microsoft Lync 2013's powerful Shared Notes feature; integrated with Outlook and OneNote 2013; enables you to share; add to; or collaborate on pages or complete notebooks before or during one or more meetings. In this video; Erin Olsen uses the Share with meeting function and Outlook's Calendar mode to detail different ways to share notes. 52306
Microsoft Lync 2013: Sort Contacts Erin Olsen Microsoft Lync 2013's many built-in sorting and organizing options enables you to sort your contacts by group; status; relationship; name; or availability. In this video; Erin Olsen demonstrates how to optimally group and sort Lync contacts. 52299
Microsoft Lync 2013: Start an IM Session Erin Olsen Microsoft Lync 2013's Instant Messaging (IM) or Chat feature enables multiple online functions while protecting against accidently interrupted chats; recording missed calls of all types; and allowing you to filter conversations by user. In this video; Erin Olsen demonstrates how to use the IM or Chat feature. 52303
Microsoft Lync 2013: Tabbed and Pop Out Conversations Erin Olsen Microsoft Lync 2013's single-window; tabbed conversations allow you to maximize screen real estate and easily toggle between multiple chats; each of which can be popped out into its own window; before being popped back in again. In this video; Erin Olsen uses the Lync 2013 Chat feature to demonstrate how to toggle or pop out and in selected conversations. 52304
Microsoft Lync 2013: Use Screen Share to Share Content Erin Olsen Microsoft Lync 2013's screen-sharing capabilities enable you to specify who can view; share; or copy documents and files. Lync's Share option allows you to present information using whiteboards; polls; presentations; applications; and the desktop. In this video; Erin Olsen demonstrates how to share a PowerPoint presentation in Lync as well use the permissions and management tools. 52308
Office 2013 Fundamentals (31)
Title Speaker Summary ID
Microsoft Office 2013 Overview: Excel 2013 Charts Isabel Garcia Microsoft Excel 2013 includes significant improvements to its chart features that will allow you to efficiently and intuitively display your data in easily readable charts and graphs. In this video; Isabel Garcia demonstrates how to use the new and improved chart features in Excel 2013 to graphically represent data. 48052
Microsoft Office 2013 Overview: Excel 2013 Quick Analysis Isabel Garcia Microsoft Excel 2013 includes the new Quick Analysis tool that allows you to easily preview and apply conditional formatting; suggested charts; and tables to a selected range of data. In this video; Isabel Garcia demonstrates how the Quick Analysis options can be used to make fast improvements to Excel spreadsheets and make data analysis a lot easier. 48051
Microsoft Office 2013 Overview: Excel 2013 Templates Isabel Garcia In Microsoft Office 2013; templates are a great resource that can save you a lot of work by providing ready formatted documents. In this video; Isabel Garcia uses Excel 2013 to demonstrate how to access a range of different templates for a variety of uses. 48050
Microsoft Office 2013 Overview: Outlook 2013 Navigation Bar and Views Isabel Garcia Microsoft Outlook 2013 includes a new Navigation Bar at the bottom of the Outlook window; as well as different view options that you can use to tailor the layout of Outlook to your specific needs. In this video; Isabel Garcia demonstrates how to use the Navigation Bar as well as the options in the VIEW tab. 48081
Microsoft Office 2013 Overview: Outlook 2013 Overview Isabel Garcia Microsoft Outlook 2013 offers a new cleaner interface designed for ease of use; providing enhanced features that make communication quicker and help keep your e-mails; contacts; and schedules manageable. In this video; Isabel Garcia highlights the main features of the brand new Outlook 2103 interface. 48080
Microsoft Office 2013 Overview: Outlook 2013 People Isabel Garcia The Contacts section in Microsoft Outlook 2013 has been renamed People. Managing contacts is now easier with the new People Card that contains all the information that you have for a specific contact in one place. In this video; Isabel Garcia demonstrates how to use the features within People view to manage your contacts in Outlook 2013. 48082
Microsoft Office 2013 Overview: Overview Isabel Garcia Microsoft Office 2013 offers a clean new look. The features you already know how to use are still there; and it still offers the ribbon interface. In this video; Isabel Garcia demonstrates some of the new features and changes made to the user interface; starting with Word 2013. 48042
Microsoft Office 2013 Overview: PowerPoint 2013 Formatting and Animations Isabel Garcia Microsoft PowerPoint 2013 provides new features and improvements that make it easier to format images and add motion path animations to objects when enhancing your slide presentation. In this video; Isabel Garcia demonstrates how to use the new formatting options to add an animation to a picture. 48079
Microsoft Office 2013 Overview: PowerPoint 2013 Images and Media Isabel Garcia Microsoft Outlook 2013 allows you to enhance your presentation by inserting images and other media elements such as audio and video; quickly and easily from an online source into your slides. In this video; Isabel Garcia uses the online picture and media options from the ribbon to insert an image; a video; and audio into a PowerPoint presentation. 48083
Microsoft Office 2013 Overview: PowerPoint 2013 Overview Isabel Garcia Microsoft PowerPoint 2013 provides updates that facilitate professional presentations with its new and improved presenter tools and Presenter View; as well as the introduction of variations for the themes that help you achieve the look you're after. In this video; Isabel Garcia demonstrates some of the improvements; and new features in PowerPoint 2013. 48078
Microsoft Office 2013 Overview: SkyDrive Isabel Garcia Microsoft Office 2013's SkyDrive enables you to access; manage; edit; synchronize; and share - from the Windows 8 Start screen of any of your devices - your cloud-based document libraries. In this video; Isabel Garcia introduces you to SkyDrive's cloud-based interface and demonstrates its functions and features. 48039
Microsoft Office 2013 Overview: SkyDrive in Word Isabel Garcia With Microsoft Office 2013; you can create your files and then save them to your SkyDrive. In this video; Isabel Garcia demonstrates how to save a file from Word 2013 to SkyDrive. 48041
Microsoft Office 2013 Overview: SkyDrive Overview Isabel Garcia Microsoft Office 2013's SkyDrive - and its business counterpart; SkyDrive Pro - offers you an immediately accessible; cloud-based storage library that allows you to save; access; and share your synchronized document; photo; and other files from any device. In this video; Isabel Garcia introduces SkyDrive before signing in to a SkyDrive Pro account where she accesses her documents through Internet Explorer. 48038
Microsoft Office 2013 Overview: SkyDrive.com Isabel Garcia You can open and edit files that are stored on SkyDrive.com with Microsoft Office 2013 applications. In this video; Isabel Garcia demonstrates how to open a document using both the Word Web App and the full Word 2013 application. 48040
Microsoft Office 2013 Overview: User Interface File Tab Isabel Garcia In Microsoft Office 2013 applications; the FILE tab offers improvements for saving; opening; and sharing documents. In this video; Isabel Garcia demonstrates the options that are available when you access the FILE tab. 48043
Microsoft Office 2013 Overview: Word 2013 Design Tab Isabel Garcia In Microsoft Word 2013; the new DESIGN tab on the ribbon offers newly streamlined and easily accessible options. In this video; Isabel Garcia reviews the DESIGN tab; focussing mainly on applying and modifying paragraph spacing style sets. 48045
Microsoft Office 2013 Overview: Word 2013 PDFs Isabel Garcia With Microsoft Word 2013; you can now open PDF files and edit the content without having to use Adobe Acrobat or Reader. In this video; Isabel Garcia demonstrates how to create; open; and edit PDF files with Word 2013. 48049
Microsoft Office 2013 Overview: Word 2013 Pictures Isabel Garcia In Microsoft Word 2013; from the INSERT tab; you can insert your own files; or download online pictures and videos to add interest to any document quickly and easily. In this video; Isabel Garcia demonstrates how to add a picture to a document and the various tools that are available to adjust and enhance your image. 48046
Microsoft Office 2013 Overview: Word 2013 Templates Isabel Garcia Microsoft Office 2013 provides you with hundreds of new and improved templates to create documents from. In this video; Isabel Garcia demonstrates the template screen in Word 2013; and how to search for and download new templates. 48044
Microsoft Office 2013 Overview: Word 2013 Tracking Isabel Garcia Microsoft Word 2013 comes with improved tracking options; as well as the new Simple Markup view; which makes your markups; indicators; and comments easier to view and understand. In this video; Isabel Garcia demonstrates some of the tracking options. 48048
Microsoft Office 2013 Overview: Word 2013 Videos Isabel Garcia When you insert a video in Microsoft Word 2013; you'll be able to view and use the video directly in Word. You don't have to launch a browser or media player. In this video; Isabel Garcia demonstrates how to insert a video and edit the video container in your document. 48047
Microsoft Office 2013: Docking OneNote Neal Rowland The Docking option in OneNote 2013 allows you to hold all your notes and all of the material on the notes you took in one single location. In this video; Neal Rowland explains how you can use multiple programs such as PowerPoint; Word; or Excel at one time in OneNote 2013. 50143
Microsoft Office 2013: InfoPath Neal Rowland InfoPath 2013 supports few new changes that you may find useful. In this video; Neal Rowland provides you an overview of the changes made in InfoPath 2013 and how the features are enhanced from InfoPath 2010. 50149
Microsoft Office 2013: OneNote Cool Tricks Neal Rowland A cool feature of OneNote 2013 is that it creates new pages and does math as you type. In this video; Neal Rowland explains you a couple of really cool tricks in OneNote that you may not be familiar with; one is solving a mathematical equation and the other; creating a new page. 50145
Microsoft Office 2013: OneNote Meeting Notes Neal Rowland OneNote 2013 allows you to take notes during a meeting without opening a Word document or a piece of paper. In this video; Neal Rowland explains how OneNote 2013 helps you to create meeting notes; retain a copy; and share it so that everyone in the meeting gets a copy of the notes you took. 50147
Microsoft Office 2013: OneNote Overview Neal Rowland OneNote 2013 is a great application to keep track of all of your notes; your To Do's; your preparation documents or anything else you might want to keep track of. In this video; Neal Rowland explains how you can use OneNote 2013 to create and track your To Do's and even connect it with your Outlook 2013 tasks. 50142
Microsoft Office 2013: Outlook Calendar Neal Rowland Microsoft Office 2013 allows you to view and customize your calendar. In this video; Neal Rowland demonstrates how to maintain and reference your calendar. 50133
Microsoft Office 2013: PowerPoint Templates Neal Rowland PowerPoint 2013 allows you to jump-start your presentation with a collection of new themes. The quick launch screen with thousands of template options helps you to spark your creativity. In this video; Neal Rowland demonstrates how to create a new presentation by selecting different attractive templates and add them to your list. 50137
Microsoft Office 2013: Send to OneNote Neal Rowland Office 2013 allows you to send information to OneNote while using other Office 2013 programs; thus making great strides to be more collaborative and integrated. In this video; Neal Rowland explains how you can send e-mail messages from Outlook 2013 to OneNote 2013 Notebook with an example. 50146
Microsoft Office 2013: Sharing Using Instant Message Neal Rowland In Office 2013; sharing and collaborating is now more integrated; quick; and easy to use. In this video; Neal Rowland explains how you can use Office 2013 to share your documents in PowerPoint; Word; and Excel even over Instant Messaging. 50140
Microsoft Office 2013: Tagging in OneNote Neal Rowland The Tag feature in OneNote 2013 allows you to search and find your notes easily. At a quick glance you can see more information about an item then just the words themselves. In this video; Neal Rowland explains how you can customize your tags and find related notes quickly in OneNote 2013. 50144
One Note 2013 (56)
Title Speaker Summary ID
Microsoft OneNote 2013 - Best Practices Allen Goldberg Following best practices in Microsoft OneNote 2013 will help you handle your work in a timely and organized fashion. In this video; Allen Goldberg demonstrates the four best practices that will help you work more effectively in OneNote 2013. 50794
Microsoft OneNote 2013 - Create a New Notebook Allen Goldberg Microsoft OneNote 2013 makes creating notebooks simple and easy. In this video; Allen Goldberg demonstrates how to create and organize notebooks and format text in OneNote. 50781
Microsoft OneNote 2013 - Exporting Pages; Sections or Notebooks Allen Goldberg Exporting specific pages; sections; and notebooks in Microsoft OneNote 2013 is easy. In this video; Allen Goldberg simulates how to export a particular page in OneNote 2013. 50785
Microsoft OneNote 2013 - Formatting and Editing Allen Goldberg Formatting and editing in Microsoft OneNote 2013 is easy. In this video; Allen Goldberg demonstrates the formatting and editing capability of OneNote 2013. 50782
Microsoft OneNote 2013 - Office 2013 Integration Allen Goldberg The integration of Outlook 2013 into Microsoft OneNote 2013 makes working with OneNote much easier. In this video; Allen Goldberg demonstrates how to use the Screen Clipping; Send to OneNote; and New Quick Note features. 50787
Microsoft OneNote 2013 - Outlook 2013 Integration Allen Goldberg The integration of Microsoft OneNote 2013 with Outlook allows you to work effectively. In this video; Allen Goldberg demonstrates how to keep track of the Outlook tasks; email; and meeting components in OneNote. 50784
Microsoft OneNote 2013 - Searching and Tagging Your Information Allen Goldberg Searching and tagging information in Microsoft OneNote 2013 lets you find data simply and easily. In this video; Allen Goldberg demonstrates how to use the special controls built-in for filtering information and tagging. 50783
Microsoft OneNote 2013 - Sharing Your Notebooks Allen Goldberg Sharing your notebooks in Microsoft OneNote 2013 is easy. In this video; Allen Goldberg demonstrates how to share a notebook using a SkyDrive account. 50786
Microsoft OneNote 2013 - The Draw Tab Allen Goldberg The Draw tab in Microsoft OneNote 2013 allows you to manipulate shapes and draw on text. In this video; Allen Goldberg demonstrates how to draw people's attention to your text by using some unusual functionalities; such as the OCR component. 50790
Microsoft OneNote 2013 - The History Tab Allen Goldberg The History tab in Microsoft OneNote 2013 allows you to view the edit history. In this video; Allen Goldberg demonstrates how to use this capability to search notebooks and how to delete page versions. 50791
Microsoft OneNote 2013 - The Home Tab Allen Goldberg The Home tab in Microsoft OneNote 2013 provides you additional functionality over and above the basic Microsoft Office functions. In this video; Allen Goldberg demonstrates how to take advantage of those functions and how to tag information. 50788
Microsoft OneNote 2013 - The Insert Tab Allen Goldberg The Insert tab in Microsoft OneNote 2013 allows you to add various content and elements to your notebook. In this video; Allen Goldberg demonstrates the functionality of the tab and shows how to select a page template. 50789
Microsoft OneNote 2013 - The Review Tab Allen Goldberg The Review tab in Microsoft OneNote 2013 provides you proofing and translation tools. In this video; Allen Goldberg demonstrates how to convert text from English to other completely different languages. 50792
Microsoft OneNote 2013 - The View Tab Allen Goldberg The View tab in Microsoft OneNote 2013 allows you to view each section of your notebook differently. In this video; Allen Goldberg demonstrates how to take advantage of this particular capability and set a different view for each section. 50793
Microsoft OneNote 2013: Adding Audio and Video Content Pierre Devereux Microsoft OneNote 2013 allows you to record new; or add pre-recorded audio and video clips; to your notebook pages. In this video; Pierre Devereux demonstrates how to embed an existing video clip into a notebook page as a file attachment; as well as how to record a clip directly from the OneNote Ribbon. 64955
Microsoft OneNote 2013: Adding Drawings to Notebooks Pierre Devereux Microsoft OneNote 2013 provides tools that allow you to add freehand drawings or predefined shapes to your notebooks pages. In this video; Pierre Devereux demonstrates how to draw freehand strokes; insert shapes; and manipulate the objects using tools from the OneNote Ribbon's DRAW tab. 64958
Microsoft OneNote 2013: Adding Password Protection Pierre Devereux In Microsoft OneNote 2013; password protection can be applied to sensitive information in pages. In this video; Pierre Devereux demonstrates how to use the password protection options to apply and customize password options on a selected section of a notebook. 64968
Microsoft OneNote 2013: Adding Pictures Pierre Devereux Microsoft OneNote 2013 lends notebook content graphic appeal by facilitating the insertion of screen clippings; Web images; or images stored locally. In this video; Pierre Devereux demonstrates how to insert; place; edit; and manipulate images in OneNote notebooks. 64954
Microsoft OneNote 2013: Attaching Files and Printouts Pierre Devereux Microsoft OneNote 2013 allows you to combine relevant information from other sources in your notebook pages as attachments or printout images of the document or file. In this video; Pierre Devereux demonstrates how to insert a Word document into a notebook page either as a file attachment; or as a printout of the information from the OneNote Ribbon's INSERT tab. 64957
Microsoft OneNote 2013: Changing General and Display Options Pierre Devereux Microsoft OneNote 2013 supports various general and display options that can be configured to suit your needs. These options can change the default behavior of OneNote so they should be handled with caution. In this video; Pierre Devereux provides an overview of the various options and demonstrates some of their effects. 64950
Microsoft OneNote 2013: Checking Spelling Pierre Devereux Microsoft OneNote 2013 allows you to check your spelling as you type. There are a couple of different methods you can implement to do this. In this video; Pierre Devereux demonstrates how to use the spell checker; spelling pane; and dictionary in OneNote. 64965
Microsoft OneNote 2013: Collaborating on Notebooks Pierre Devereux Microsoft OneNote 2013 allows multiple team members to author shared notebooks on the fly while it tracks when and who adds; alters; or deletes content. In this video; Pierre Devereux demonstrates how to create; name; and share a collaboratively authored notebook on a shared drive. 64969
Microsoft OneNote 2013: Conducting Research Pierre Devereux In Microsoft OneNote 2013; research can be performed from inside of OneNote by using the Research command. In this video; Pierre Devereux demonstrates how to use the Research feature to search for spellings; definitions; translations; or synonyms of words. 64966
Microsoft OneNote 2013: Converting a OneNote Table to an Excel Worksheet Pierre Devereux The integration of Microsoft OneNote 2013 and Microsoft Excel allows OneNote tables to have the full functionality of Excel. In this video; Pierre Devereux demonstrates how a OneNote table can be converted into an Excel spreadsheet that can be edited and updated. 64976
Microsoft OneNote 2013: Converting Handwriting to Text Pierre Devereux Microsoft OneNote 2013 allows you to convert digital handwriting to text; which is useful if you constantly take handwritten notes. In this video; Pierre Devereux demonstrates how to convert handwritten notes for use in your notebooks. 64964
Microsoft OneNote 2013: Creating Tables Pierre Devereux Microsoft OneNote 2013 allows you to create tables so you can organize your information more easily. In this video; Pierre Devereux demonstrates how to use the table group to insert tables into your notebooks. 64961
Microsoft OneNote 2013: Customizing the Quick Access Toolbar Pierre Devereux Microsoft OneNote 2013 contains the Quick Access Toolbar which provides a fast way to access commands that you use frequently; making them easier to find rather than having to search through the different menu options. In this video; Pierre Devereux demonstrates how to customize the Quick Access Toolbar in various ways; for example by adding or removing commands. 64949
Microsoft OneNote 2013: Customizing the Ribbon Pierre Devereux In Microsoft OneNote 2013; the Ribbon allows you to access the commands available to you. You can customize the Ribbon to suit your needs by choosing specific tabs; groups; and commands; and you can add or remove options as required. In this video; Pierre Devereux demonstrates how to customize the Ribbon. 64948
Microsoft OneNote 2013: Formatting and Sorting Tables Pierre Devereux In Microsoft OneNote 2013 you can easily format and sort tables; allowing data to be changed in various ways. In this video; Pierre Devereux demonstrates how to format data in a cell; create additional rows; sort columns; and use a variety of shortcut options. 64962
Microsoft OneNote 2013: Formatting Text and Applying Styles Pierre Devereux Microsoft OneNote 2013 allows for the easy formatting and styling of notebook text. In this video; Pierre Devereux demonstrates how to format and style notebook text using drop-down menu and button commands grouped for quick access on the OneNote 2013 ribbon. 64951
Microsoft OneNote 2013: Inserting Excel Workbooks Lynn Tao Microsoft OneNote 2013 allows you to to gather handwritten notes; drawings; or audio clips; and include Excel workbooks. In this video; Lynn Tao discusses how to insert Excel Workbooks in OneNote 2013. 55322
Microsoft OneNote 2013: Inserting Excel Workbooks in OneNote Pierre Devereux In Microsoft OneNote 2013; Microsoft Excel spreadsheets can be embedded directly into pages to provide a preview of the spreadsheet. In this video; Pierre Devereux demonstrates how existing and new Microsoft Excel spreadsheets may be embedded into a OneNote notebook. 64975
Microsoft OneNote 2013: Inserting Links Lynn Tao In Microsoft OneNote 2013; you can include links to websites; files; and even other notebooks. In this video; Lynn Tao discusses how to insert links in OneNote 2013. 55323
Microsoft OneNote 2013: Inserting Word and PowerPoint Files in OneNote Pierre Devereux Microsoft OneNote 2013 integrates seamlessly with other Microsoft applications and it is easy to insert a Word document or a PowerPoint presentation into your notebook pages. In this video; Pierre Devereux demonstrates how a Word document can be embedded into a OneNote notebook page. 64979
Microsoft OneNote 2013: Introducing the OneNote Interface Pierre Devereux Microsoft OneNote 2013 offers anytime; anywhere access to digital notebooks compiled; printed; and shared in a home; school; or business environment. In this video; Pierre Devereux discusses OneNote 2013's interface and navigates its many immediately-accessible features. 64946
Microsoft OneNote 2013: Managing Audio and Video Content Pierre Devereux After embedding audio and video content in your notebook pages; Microsoft OneNote 2013 provides a number of useful features that allow you to control playback and customize how OneNote makes and plays recordings. In this video; Pierre Devereux demonstrates how to manage audio and video content using the options from the PLAYBACK tab in the OneNote Ribbon. 64956
Microsoft OneNote 2013: Managing Meetings with Outlook and OneNote Pierre Devereux In Microsoft OneNote 2013; meeting notes can be provided to other participants who have access to a shared notebook. In this video; Pierre Devereux demonstrates how the Share with Meeting feature allows meeting participants to view; edit; and update meeting notes. 64973
Microsoft OneNote 2013: Notebook Settings and Properties Lynn Tao Microsoft OneNote allows users to work on multiple Notebooks and sync them as necessary. In this video; Lynn Tao introduces the settings and properties in OneNote 2013. 55325
Microsoft OneNote 2013: OneNote 2013 Linked Notes in Word and PowerPoint Pierre Devereux In Microsoft OneNote 2013; you can make research notes which can link back to their original sources by using the Linked Notes feature. In this video; Pierre Devereux demonstrates how OneNote allows you to make research notes which can be linked back to the original source material for ease of reference. 64978
Microsoft OneNote 2013: Outlook Appointments and Tasks in OneNote Pierre Devereux The integration of Microsoft OneNote 2013 with Microsoft Outlook makes it easy to insert Outlook meeting and task details into OneNote note pages. In this video; Pierre Devereux demonstrates how Outlook meetings and tasks can be inserted into OneNote pages. 64974
Microsoft OneNote 2013: Performing Calculations Pierre Devereux Unlike a word processor; OneNote allows users to freely construct calculations in an informal platform. In this video; Pierre Devereux demonstrates how to perform and add calculations to your notebook pages. 64963
Microsoft OneNote 2013: Printing a Notebook Pierre Devereux Microsoft OneNote 2013 supports features that allow you to preview and print your notes in a familiar way. In this video; Pierre Devereux demonstrates how to use the Print and Print Preview and Settings dialog boxes in OneNote to select a printer; configure print settings; and preview the notebook pages as they would appear when printed. 64953
Microsoft OneNote 2013: Saving and Backing up a Notebook Pierre Devereux In addition to saving notes as you work; Microsoft OneNote 2013 provides fail-safe mechanisms that allow you to backup notebooks and protect valuable information. In this video; Pierre Devereux demonstrates how to use the Save & Backup options in the OneNote Options dialog box to set automatic notebook backups and run manual notebook backups as required. 64952
Microsoft OneNote 2013: Sending OneNote Content to Word Pierre Devereux Microsoft OneNote 2013's integration with other Microsoft Office applications enables the formatting of text; pages; or complete notebooks in Microsoft Word without having to copy and paste. In this video; Pierre Devereux demonstrates how to send OneNote text to be formatted in Microsoft Word. 64977
Microsoft OneNote 2013: Sending Outlook Messages to OneNote Pierre Devereux In Microsoft OneNote 2013; you can send Outlook mail messages to OneNote notebook pages. In this video; Pierre Devereux demonstrates how to use the Send to OneNote feature to attach Microsoft Outlook email messages to OneNote pages. 64972
Microsoft OneNote 2013: Syncing OneNote 2013 and OneNote Mobile Pierre Devereux Microsoft OneNote 2013 uses OneNote Mobile to give immediate; streamlined access to notebooks on mobile devices - enabling viewing; editing; and sharing on the move. In this video; Pierre Devereux discusses OneNote Mobile's streamlined interface and explains its many features. 64980
Microsoft OneNote 2013: The File Tab Pierre Devereux Microsoft OneNote 2013 includes the FILE tab; which opens the Backstage view. In this video; Pierre Devereux demonstrates the FILE tab where you can access file management options; such as opening a file; creating a new file; and printing a file. 64947
Microsoft OneNote 2013: Tracking Changes Pierre Devereux In Microsoft OneNote 2013; content added or changed by multiple authors can easily be tracked. In this video; Pierre Devereux demonstrates how new and modified content can be tracked by author or date. 64970
Microsoft OneNote 2013: Using and Creating Templates Pierre Devereux Microsoft OneNote 2013 allows predefined page designs to be applied to notebook pages; adding individual style; consistency; and professional flair. In this video; Pierre Devereux demonstrates how to navigate to OneNote's Templates pane to apply different categories of template to new; blank notebook pages. 64960
Microsoft OneNote 2013: Using QuickNotes Pierre Devereux Microsoft OneNote 2013 Quick Notes is a time-saving feature that allows you to take notes quickly outside the organizational structure of OneNote that can be filed later at a convenient time. In this video; Pierre Devereux demonstrates how to create; manage; review; and pin Quick Notes. 64959
Microsoft OneNote 2013: Using SharePoint to Share Notebooks Pierre Devereux Microsoft OneNote 2013 allows the saving; syncing; and sharing of part or whole notebooks using OneDrive and SharePoint. In this video; Pierre Devereux demonstrates how to save a notebook to a SharePoint site; and how to share it by e-mail or a sharing link. 64967
Microsoft OneNote 2013: Using the Interface Lynn Tao In Microsoft OneNote 2013; you can gather handwritten notes; drawings; and audio clips. You can also access the notes anywhere on any device. In this video; Lynn Tao discusses the interface for Microsoft OneNote 2013. 55321
Microsoft OneNote 2013: Using the Web App Lynn Tao Microsoft OneNote allows users to access notes anywhere and on any device and also on Web apps. In this video; Lynn Tao introduces the OneNote Web app. 55324
Microsoft OneNote 2013: Version Control Options Pierre Devereux In Microsoft OneNote 2013; version control allows you to retrieve earlier versions of a page in a shared notebook that may have been modified by different authors over time. In this video; Pierre Devereux demonstrates how version control allows you to view; restore; copy; and delete earlier versions of a page. 64971
Microsoft OneNote2013: Clipping and Saving Lynn Tao Microsoft OneNote allows you to insert screen clippings and an image from a browser; as well as insert a Quick Note. In this video; Lynn Tao discusses how to clip and save from the desktop; the web; and also insert Quick Notes in OneNote 2013. 55327
Microsoft OneNote2013: Touchscreen Tips Lynn Tao Microsoft OneNote can be accessed anywhere and on any device. And you can gather notes; drawings; and audio clips in OneNote. In this video; Lynn Tao introduces you to Touchscreen basics in OneNote 2013. 55326
Outlook 2013 (33)
Title Speaker Summary ID
Microsoft Outlook 2013: Automatically Accept or Decline Meetings Josh Penzell Microsoft Outlook 2013 has the ability to automatically accept and decline meeting requests; enabling you to better manage your Inbox. In this video; Josh Penzell demonstrates how to change the settings in Outlook 2013 to automatically accept and decline meetings. 51727
Microsoft Outlook 2013: Show Second Time Zone Josh Penzell Working across different time zones is enhanced by the ability to display multiple time zones in the Outlook 2013 calendar. In this video; Josh Penzell demonstrates how to add a second time zone and switch between zones using Outlook 2013. 51728
Microsoft Outlook 2013: Adding the Weather Forecast to Your Calendar Lynn Tao In Microsoft Outlook 2013; you can add the weather forecast to your calendar. In this video; Lynn Tao demonstrates how to add the weather forecast feature to the calendar. 55319
Microsoft Outlook 2013: Additional Customizations Josh Penzell Microsoft Outlook 2013 allows you to customize the colour of messages in your message list as well as the lines that separate them. In this video; Josh Penzell uses conditional formatting to change the font color and bar of unread messages before removing the grid lines from between messages. 51752
Microsoft Outlook 2013: Arranging Calendar Days Lynn Tao In Microsoft Outlook 2013; you can customise the calender to manage different agendas and schedules. In this video; Lynn Tao discusses how to arrange calendar days to suit your schedule. 55266
Microsoft Outlook 2013: Attach File Message Task to E-mail Josh Penzell Using Microsoft Outlook 2013; you can attach Outlook items such as tasks to an e-mail message just as easily as you would any other file attachment. In this video; Josh Penzell demonstrates how to attach a read-only task to an e-mail; as well as how to assign an actual task. 51741
Microsoft Outlook 2013: Autoarchiving Your E-mail Josh Penzell The AutoArchive feature in Microsoft Outlook 2013 enables you to store e-mail items so that you can access them in the future. In this video; Josh Penzell uses Outlook's advanced options to set how frequently AutoArchive runs and to delete expired items and archive old items. 51749
Microsoft Outlook 2013: Automatically Request Read Receipts Josh Penzell In Outlook 2013 you have the option of requesting a delivery or read receipt by default; thus eliminating the need to set these tracking options on an individual message basis. In this video; Josh Penzell demonstrates how to set mail options so that delivery and mail receipts are requested every time a mail is sent. 51729
Microsoft Outlook 2013: Automatically Spellcheck E-mail Josh Penzell Microsoft Outlook 2013's spell check program enables you to automatically spell check e-mails before sending them. In this video; Josh Penzell uses Microsoft Outlook 2013's Spell Check program to configure Outlook to automatically spell check e-mail before it is sent. 51742
Microsoft Outlook 2013: Change the Default Mail List Font Size Josh Penzell Microsoft Outlook 2013 includes advanced view settings for changing the font sizes of e-mail fields appearing in your message list. In this video; Josh Penzell uses conditional formatting in Outlook to set a uniform font size for the message list; before reverting to the default font. 51745
Microsoft Outlook 2013: Changing the To-Do Bar Order Josh Penzell In Microsoft Outlook 2013 you can customize the To-Do Bar by specifying which To-Do Bar items appear in the different Outlook View as well as the order in which they appear. In this video; Josh Penzell demonstrates how to organize the To-Do Bar in the various views. 51740
Microsoft Outlook 2013: Connect Hotmail Account Josh Penzell Microsoft Outlook 2013 makes it easy to connect to your Hotmail or Outlook.com account. You need only your account details; and Outlook 2013 does the rest for you. In this video; Josh Penzell uses the Add New Account feature to connect the Outlook client to a Hotmail e-mail account. 51744
Microsoft Outlook 2013: Creating Search Folders Josh Penzell Microsoft Outlook 2013 lets you create custom; named search folders that enable you to collect e-mails meeting specified criteria; such as attachments; defined words; or senders and recipients. In this video; Josh Penzell explores search folder templates that automatically filter e-mail and display in the Folder list. He also creates a custom search folder named Flagged Meetings. 51751
Microsoft Outlook 2013: Customizing How You Open Your To-Do Bar Josh Penzell There are various ways of opening the To-Do Bar in Outlook 2013; including the ability to customize how it opens for quicker access. In this video; Josh Penzell demonstrates the different methods used for opening the To-Do Bar. 51735
Microsoft Outlook 2013: Disable Inline Reply Josh Penzell The Inline Reply feature in Microsoft Outlook 2013 allows you to reply to a message instantly; but you can disable this feature. In this video; Josh Penzell disables the Inline Reply feature and configures Outlook to automatically open replies and forwards in a new window. 51755
Microsoft Outlook 2013: Display Days Left Josh Penzell Microsoft Outlook 2013's Task view does not include an option for viewing the days left until a task is due. However; this useful information can be added. In this video; Josh Penzell demonstrates how to add an option to the Task list that allows you to see how many days are left until a task is due. 51739
Microsoft Outlook 2013: How Not to Save Sent E-mails Josh Penzell When sending an e-mail message; Microsoft Outlook 2013 allows you to turn off the feature that saves a copy of the sent message. In this video; Josh Penzell demonstrates how to temporarily disable the feature that automatically saves a copy of your sent items. 51737
Microsoft Outlook 2013: Importing and Exporting Josh Penzell In Outlook 2013; the Import and Export Wizard enables you to import or export your mailbox as a PST file. It also lets you test a restore by opening an Outlook data file in your folder list. In this video; Josh Penzell exports and imports a PST data file to and from the desktop. 51753
Microsoft Outlook 2013: Introduction to OWA Josh Penzell Microsoft Outlook 2013 allows you to access your e-mail account in Internet Explorer using the Outlook Web App (OWA). This offers a similar interface and most of the functionality of Outlook on your local machine. In this video; Josh Penzell demonstrates how to use OWA to view an Outlook 2013 e-mail account and highlights visual and functional similarities and capabilities. 51754
Microsoft Outlook 2013: Junk E-mail and Phishing Filter Josh Penzell Outlook 2013 has a built-in junk e-mail and phishing filter that assists you in protecting your e-mail information. In this video; Josh Penzell demonstrates how to enable the e-mail filter and customize it to meet your requirements. 51732
Microsoft Outlook 2013: Linking Contacts Josh Penzell Outlook 2013 lets you link contacts so that multiple contact entries for the same person are up to date and organized in a central location. In this video; Josh Penzell demonstrates how to link contacts across different contact groups in Outlook 2013. 51730
Microsoft Outlook 2013: Mailbox Cleanup Josh Penzell The Mailbox Cleanup utility in Microsoft Outlook 2013 enables you to assess available e-mail storage space; as well as the distribution and size of your mail folders. You can free storage by deleting or archiving e-mails by date or size. In this video; Josh Penzell uses the Mailbox Cleanup to delete unwanted mail. 51748
Microsoft Outlook 2013: Notes in Outlook Josh Penzell Microsoft Outlook 2013 allows you to activate and display notes in the Outlook Folder list. In this video; Josh Penzell demonstrates how to configure Outlook to display notes. 51756
Microsoft Outlook 2013: Organizing Folders Josh Penzell Microsoft Outlook 2013 allows you to easily reorganize your subfolders from the default A to Z sorting; giving you control over how you'd like to organize your Outlook data. In this video; Josh Penzell demonstrates how to move subfolders in Outlook 2013. 51738
Microsoft Outlook 2013: Outlook Custom Forms Josh Penzell Microsoft Outlook 2013's Developer tab; when enabled on the Ribbon; lets you create and publish custom Tasks; Contacts; and Calendar forms; overwriting or adding to the information-gathering capabilities of those available to you. In this video; Josh Penzell uses the Developer tab to create a named custom form for tasks. 51746
Microsoft Outlook 2013: Repair Outlook Data Files Josh Penzell Using Microsoft Office Inbox Repair Tool; you can diagnose and repair corrupt Outlook data files. In this video; Josh Penzell demonstrates how to repair a corrupt Outlook date file and import the repaired file into Outlook 2013. 51731
Microsoft Outlook 2013: RSS Feeds Josh Penzell Microsoft Outlook 2013 allows you to keep up to date with your favourite news sites by subscribing to their RSS feeds and having the information delivered directly to your message list. In this video; Josh Penzell demonstrates how to subscribe to an RSS feed. 51750
Microsoft Outlook 2013: Searching Through Outlook Josh Penzell The search functions in Outlook 2013 allow you to easily search your e-mails; attachments; calendar appointments; and contacts to find information quickly. In this video; Josh Penzell demonstrates how to refine your searches and locate information as efficiently as possible. 51733
Microsoft Outlook 2013: Send/Receive Groups Josh Penzell In Microsoft Outlook 2013; you can customize Send/Receive operations. You can choose to send or receive your accounts' e-mail manually or automatically. In this video; Josh Penzell sets the Send/Receive function to automatically receive mail from all accounts every 30 minutes; while making the Send function a manual operation. 51747
Microsoft Outlook 2013: Setting Flag Reminders Josh Penzell Flag reminders in Microsoft Outlook 2013 ensure you do not forget to attend to e-mails flagged in your To Do list. You can add detailed instructions to these e-mails. In this video; Josh Penzell uses the Add Reminder feature to specify the action required by an e-mail; and the time at which he will be reminded to implement it. 51743
Microsoft Outlook 2013: Showing the Ruler Josh Penzell In Outlook 2013 the ruler is no longer visible when creating an e-mail. However; if your message layout is important; you have the option of showing the ruler in the message window. In this video; Josh Penzell demonstrates how to add the ruler to the Quick Access Toolbar and Ribbon of your message window. 51736
Microsoft Outlook 2013: Translating an E-mail Lynn Tao Microsoft Outlook 2013 is a powerful e-mail management system that helps you translate selected text and entire e-mails into different languages. In this video; Lynn Tao explains how to translate e-mails in Outlook 2013. 55265
Microsoft Outlook 2013: Turn Off Automatic Acceptance of Meetings Josh Penzell Outlook automatically accepts meetings; adding them to your calendar and marking them as tentative. In Outlook 2013; however; you have the option of turning this feature off. In this video; Josh Penzell demonstrates how to disable the feature that automatically accepts meetings. 51734
PowerPoint 2013 (52)
Title Speaker Summary ID
Microsoft PowerPoint 2013: Adjusting Images Josh Penzell Microsoft PowerPoint 2013 includes numerous options that allow you to adjust images either by making corrections to them; or by applying effects for visual standout. In this video; Josh Penzell demonstrates how to adjust images and apply effects to them. 51789
Microsoft PowerPoint 2013: Adjusting the Audio Timing Lynn Tao PowerPoint 2013 gives you the opportunity to incorporate background audio or narration to presentations. In this video; Lynn Tao discusses how you can adjust the settings to play the audio in the background; repeat itself; or play throughout all the slides. 55275
Microsoft PowerPoint 2013: Animation Pane Josh Penzell The Animation Pane in PowerPoint 2013 enables you to add animations to your slides; allowing the creation of vibrant and engaging presentations. In this video; Josh Penzell demonstrates how to add animations to a presentation and customize how they are presented. 51779
Microsoft PowerPoint 2013: Borders on Images Josh Penzell Microsoft PowerPoint 2013's lets you add image borders that can be customized to enhance the pictures in your presentation. In this video; Josh Penzell uses the various picture tools to demonstrate how to add and manipulate image borders. 51788
Microsoft PowerPoint 2013: Change Theme for Specific Slides Josh Penzell In Microsoft PowerPoint 2013 you can apply themes to an entire PowerPoint presentation or to selected slides in a presentation slide deck. In this video; Josh Penzell uses the DESIGN tab to apply a global theme and applies multiple themes to groups of selected slides. 51766
Microsoft PowerPoint 2013: Combining Shapes Josh Penzell The Merge Shapes feature is new to Microsoft PowerPoint 2013 and it allows you to create your own custom shapes. In this video; Josh Penzell demonstrates the various ways you can combine existing shapes to make new ones. 51798
Microsoft PowerPoint 2013: Comments Pane Josh Penzell Microsoft PowerPoint 2013's Comment feature enables you to easily collaborate with your team members on the same PowerPoint presentation by adding; reviewing; or deleting comments. In this video; Josh Penzell activates uses the Comments pane to insert; review; reply to; delete; navigate; and save comments in a PowerPoint presentation. 51765
Microsoft PowerPoint 2013: Compress Multimedia Josh Penzell PowerPoint 2013 enables you to compress multimedia when file size is important; such as when you wish to send a presentation containing audio and video by e-mail. In this video; Josh Penzell demonstrates how to compress media contained in a PowerPoint presentation. 51760
Microsoft PowerPoint 2013: Creating a Custom Background Josh Penzell Microsoft PowerPoint 2013 allows you to create your own custom background for a presentation. You can choose a gradient fill; adjust the transparency; and use various picture and patterns. In this video; Josh Penzell demonstrates how to create a custom background. 51773
Microsoft PowerPoint 2013: Creating a Custom Slide Show Josh Penzell Microsoft PowerPoint 2013 allows you to create custom slide shows within a single presentation. This enables you to modify your presentation by selecting specific slides that suit a particular audience without having to duplicate the entire presentation. In this video; Josh Penzell demonstrates how to create custom slide shows within a single presentation. 51783
Microsoft PowerPoint 2013: Creating a Video from a Presentation Lynn Tao PowerPoint 2013 allows you to create video from your presentations for online; screen; and portable formats. In this video; Lynn Tao discusses how to create a video from a PowerPoint presentation. 55277
Microsoft PowerPoint 2013: Creating Charts from Excel Data Josh Penzell Microsoft PowerPoint 2013 enables you to create charts from imported Excel documents. In this video; Josh Penzell demonstrates how to create a chart and include content from an Excel table in the chart. 51772
Microsoft PowerPoint 2013: Creating Handouts in Word Josh Penzell PowerPoint 2013 allows you to export handouts into Microsoft Word; providing you with more options when supplying your audience with a convenient way to take notes of your presentation. In this video; Josh Penzell demonstrates how to use PowerPoint to automatically create handouts in Word. 51763
Microsoft PowerPoint 2013: Creating Slides from Outlines Josh Penzell You can use the Outline View in Microsoft PowerPoint 2013 to create outlines for your presentations and to import outlines created in Microsoft Word. In this video; Josh Penzell demonstrates how to create an outline in PowerPoint as well as how to import an outline created in Word. 51767
Microsoft PowerPoint 2013: Creating User Interactive Presentations Josh Penzell Microsoft PowerPoint 2013 allows you to build user interactivity into your slides by adding links and hyperlinks that engage the audience and compliment your presentation. In this video; Josh Penzell demonstrates how to add hyperlinks to a PowerPoint slide. 51792
Microsoft PowerPoint 2013: Cropping and Arranging Images Josh Penzell Microsoft PowerPoint 2013 provides tools that allow you to crop and arrange images in your presentation so that they display the way you want your audience to view them. In this video; Josh Penzell demonstrates crop; rotate; flip; show; and hide images. 51787
Microsoft PowerPoint 2013: Custom Motion Animations Josh Penzell Microsoft PowerPoint 2013's new custom motion features allow you to create animations that move objects along straight lines or free-handed motion paths. In this video; Josh Penzell demonstrates how to set; adjust; and preview an object's predetermined path; as well as create straight-line and free-handed motion paths. 51771
Microsoft PowerPoint 2013: Enabling and Using AutoRecover Lynn Tao PowerPoint 2013 has a unique AutoRecover feature. The feature will back up files in any case there's a power outage or system crash. In this video; Lynn Tao discusses this feature and shows you how to recover files. 55273
Microsoft PowerPoint 2013: Exporting Presentations as Videos Josh Penzell Using PowerPoint 2013 you can export your presentations as videos; enabling you to distribute your presentation confidently without knowing your recipient's computer setup. In this video; Josh Penzell demonstrates how to use the export settings in PowerPoint to turn a presentation into a video. 51759
Microsoft PowerPoint 2013: Exporting Slides as Images Josh Penzell PowerPoint 2013 allows you to export your slides as a series of static images or as an image presentation; where editable slides are replaced by pictures. In this video; Josh Penzell demonstrates how to export slides from a PowerPoint presentation as images. 51758
Microsoft PowerPoint 2013: Finding and Replacing Text Lynn Tao PowerPoint 2013 allows you to find and replace text and fonts. In this video; Lynn Tao will show you how to use this tool to not only replace text; but fonts as well. 55274
Microsoft PowerPoint 2013: Formatting Text Josh Penzell The text formatting options that are available in Microsoft PowerPoint 2013 provide you with numerous options when creating visually appealing presentations. In this video; Josh Penzell demonstrates some of the text formatting options available in PowerPoint 2013. 51786
Microsoft PowerPoint 2013: Insert a YouTube Video Josh Penzell Microsoft PowerPoint 2013 enables you to access; search on; and insert YouTube and other online; cloud-based; and local videos directly into your PowerPoint presentations. In this video; Josh Penzell uses the YouTube search feature in PowerPoint to insert a video directly into a PowerPoint presentation. 51764
Microsoft PowerPoint 2013: Inserting and Creating Equations Lynn Tao In PowerPoint 2013 formulas and equations can be incorporated into presentations. In this video; Lynn Tao discusses how to work with formulas and equations in PowerPoint 2013. 55287
Microsoft PowerPoint 2013: Inserting Screenshots Josh Penzell PowerPoint 2013 includes a built in feature that allows you to easily insert screenshots into your presentations which is especially useful; for example when describing a software program. In this video; Josh Penzell demonstrates how to use PowerPoint 2013 to insert a portion of a screenshot into a presentation slide. 51761
Microsoft PowerPoint 2013: Inserting Slides from Other Presentations Josh Penzell Microsoft PowerPoint 2013 makes it easy to reuse slides from other presentations in a variety of ways; saving you from having to redo work. In this video; Josh Penzell demonstrates two methods of inserting slides from other presentations. 51797
Microsoft PowerPoint 2013: Inspecting Presentations Josh Penzell Microsoft PowerPoint 2013 allows you to remove certain information from presentations that you might not want other people to see. In this video; Josh Penzell demonstrates how to use the Document Inspector to remove internal information before sending a presentation to a client. 51796
Microsoft PowerPoint 2013: Numbered and Bulleted Lists Josh Penzell Microsoft PowerPoint 2013 allows you to customize bulleted and numbered lists to enhance the appearance of the slides in your presentation. In this video; Josh Penzell demonstrates how to create default bulleted and numbered lists and to customize them by applying a style and color. 51774
Microsoft PowerPoint 2013: Options Josh Penzell You can customize Microsoft PowerPoint 2013 in a variety of ways to suit your way of working. In this video; Josh Penzell demonstrates some of the preferences available and how they can affect PowerPoint and your workflow within it. 51801
Microsoft PowerPoint 2013: Overview of PowerPoint Views Josh Penzell Microsoft PowerPoint 2013 offers multiple views; each with its own specialized uses. In this video; Josh Penzell gives an overview of PowerPoint's Normal; Slide Sorter; Reading View; Outline View; and Notes Page views. 51769
Microsoft PowerPoint 2013: Packaging and Burning Your Presentation to a CD Lynn Tao PowerPoint 2013 can format and burn one or more presentations on a CD. In this video; Lynn Tao discusses how to package your presentation for CD and burn it onto disk. 55276
Microsoft PowerPoint 2013: Personalize Quick Access Toolbar and Ribbon Josh Penzell In PowerPoint 2103 you can personalize the Quick Access Toolbar and Ribbon depending on your preferences and specific tasks at hand. In this video; Josh Penzell demonstrates how to customize the Quick Access Toolbar and Ribbon in PowerPoint. 51782
Microsoft PowerPoint 2013: Placeholders Lynn Tao PowerPoint 2013 Placeholders help you create customized templates in your presentation. In this video; Lynn Tao discusses how to insert and customize Placeholders. 55278
Microsoft PowerPoint 2013: Playing Audio in the Background of Presentation Josh Penzell A new feature of Microsoft PowerPoint 2013 is that it allows you to set audio to play in the background throughout a presentation. You can set the audio to start automatically or to loop until the presentation is stopped. In this video; Josh Penzell demonstrates how to insert an audio file into a presentation and to set its play options. 51776
Microsoft PowerPoint 2013: Playing with SmartArt Josh Penzell SmartArt in PowerPoint 2013 allows you to choose from different layouts that can be easily customized to visually represent information in your presentation as effectively as possible. In this video; Josh Penzell demonstrates how to customize SmartArt in a presentation. 51781
Microsoft PowerPoint 2013: Printing Handouts and Notes Josh Penzell Microsoft PowerPoint 2013 allows you to easily print handouts of your slides that can be distributed to your audience enabling them to take notes during a presentation. In this video; Josh Penzell uses the printing features in PowerPoint 2013 to demonstrate how you can print handouts and notes of your slides. 51791
Microsoft PowerPoint 2013: Protecting Presentations with a Password Josh Penzell PowerPoint 2013 provides different ways for you to set passwords that protect your presentations by helping to prevent others from opening or modifying them. In this video; Josh Penzell demonstrates how to add a combination of passwords to protect a presentation. 51762
Microsoft PowerPoint 2013: Remove the Background on Images Josh Penzell Microsoft PowerPoint 2013 enables you to remove the background from images; thereby allowing you to present only part of an image. In this video; Josh Penzell uses the Remove Background tool to remove specific parts of an image. 51790
Microsoft PowerPoint 2013: Resume Reading Feature Josh Penzell New to Microsoft PowerPoint 2013 is the Resume Reading feature that allows you to pick up where you left off; whether on your local drive or when accessing a presentation through a web-based application such as SkyDrive. In this video; Josh Penzell demonstrates how to use the Resume Reading feature in PowerPoint. 51784
Microsoft PowerPoint 2013: Save as Read-Only Josh Penzell PowerPoint 2013 enables you to protect a presentation by saving a read-only version of the presentation that is marked as final. This is useful in indicating to others that the presentation cannot be edited further. In this video; Josh Penzell demonstrates how to mark a PowerPoint presentation as final; saving it as read-only. 51757
Microsoft PowerPoint 2013: Saving Chart Templates Josh Penzell PowerPoint 2103 allows you to save your customized charts as chart templates for later use; thereby saving you time when creating and modifying charts in your presentation. In this video; Josh Penzell demonstrates how to save a customized chart as a chart template. 51780
Microsoft PowerPoint 2013: Self Running Presentation Josh Penzell Microsoft PowerPoint 2013 allows you to build a self-running kiosk presentation; which runs in a continuous loop in a kiosk; according to pre-set timings. In this video; Josh Penzell demonstrates how to set up a self-running presentation; and then view it. 51775
Microsoft PowerPoint 2013: Share Presentations Over the Internet Josh Penzell Microsoft PowerPoint 2013 makes it easy for you to share presentations with other users over the Internet. In this video; Josh Penzell demonstrates the options available for sending a presentation to others and for presenting it online to a wider audience. 51799
Microsoft PowerPoint 2013: The New Presenter View Josh Penzell Microsoft PowerPoint 2013's Presenter View allows you to see your notes and upcoming slides; and gives you access to multiple presentation tools - on a single screen. In this video; Josh Penzell demonstrates how to access Presenter View and introduces its navigation; presentation utilities; slide display; zoom; and text-sizing tools. 51770
Microsoft PowerPoint 2013: Transitions Josh Penzell Microsoft PowerPoint 2013 provides a variety of transitions you can apply to slides in your presentations. In this video; Josh Penzell demonstrates how to apply these transitions and the customization features that are available. 51800
Microsoft PowerPoint 2013: Using Animation Painter Josh Penzell Microsoft PowerPoint 2013's Animation Painter enables you to recreate and apply an animation to multiple objects; items; and slides. In this video; Josh Penzell uses the Animation Painter to recreate an animation on a single slide as well as on multiple objects on another slide. 51768
Microsoft PowerPoint 2013: Using Customized or Personal Templates Josh Penzell Microsoft PowerPoint 2013 allows you to easily save and retrieve personal or customized templates for reuse. In this video; Josh Penzell guides you through DESIGN tab options; Custom Office Templates; and Save as types to ensure that you're able to save and retrieve templates to which you've added personal styles; colors; backgrounds and more. 51778
Microsoft PowerPoint 2013: Using Guides and the Grid Josh Penzell Microsoft PowerPoint 2013 provides various features to help with the precise alignment and placement of objects on a slide. In this video; Josh Penzell demonstrates how to use the ruler; gridlines; and guides features to position an item; as well as how to configure the settings of these features. 51794
Microsoft PowerPoint 2013: Using PowerPoint Templates Josh Penzell Microsoft PowerPoint 2013 includes many new; quickly-navigated templates offering easy customization and organization. You can pin or unpin templates to and from your list and you can use custom or suggested searches by category; both on and offline. In this video; Josh Penzell guides you through the various templates and their organizational and search options. 51777
Microsoft PowerPoint 2013: Using Translation Tools Josh Penzell Microsoft PowerPoint 2013 provides translation tools that can help you include words or phrases in other languages in a presentation. In this video; Josh Penzell demonstrates how to use the translation and research features to translate words on a slide. 51795
Microsoft PowerPoint 2013: Web App Overview Josh Penzell You can use the PowerPoint Web App to access your presentations through a web browser. In this video; Josh Penzell uses SkyDrive to demonstrate how the PowerPoint Web App can be used to view; share; and perform quick edits to a presentation through the Internet. 51793
Microsoft PowerPoint 2013: Working with Tables Josh Penzell Microsoft PowerPoint 2013 enables you to add tables to your presentation. You can also easily format these tables to help present complex information in an organized and structured manner. In this video; Josh Penzell demonstrates how to add a table to a slide and then use various table formatting options. 51785
Project 2013 (77)
Title Speaker Summary ID
Microsoft Project 2013: Adding a Resource Pool to Your Plan Ashley Hunt Microsoft Project 2013 enables project managers to work with a shared resource pool and import it into their current project plan to view over-allocations across multiple projects. In this video; Ashley Hunt demonstrates how to import a shared resource pool and identify over-allocations. 53759
Microsoft Project 2013: Adding a Text Column Ashley Hunt In Microsoft Project 2013; there is more than one way to add and name new columns in your project. In this video; Ashley Hunt; uses the Add New Column feature to add and name a new text column. 53800
Microsoft Project 2013: Adding Graphics to a Gantt Chart Ashley Hunt In Microsoft Project 2013; you can easily add and format graphics in a Gantt chart. In this video; Ashley Hunt; uses the Gantt chart formatting tools to add and format arrows and circles to a Gantt chart. 53750
Microsoft Project 2013: Adding Hyperlinks Lynn Tao Microsoft Access 2013 lets you incorporate hyperlinks to any documents; files and even e-mails. In this video; Lynn Tao demonstrates how to to add hyperlinks using Project 2013. 55297
Microsoft Project 2013: Adding Notes to a Project Plan Ashley Hunt In Microsoft Project 2013; you can use the Task Information feature to add notes to a project plan. In this video; Ashley Hunt demonstrates how to create; edit; access; and delete a note for a project task. 53806
Microsoft Project 2013: Adding OT Work for Resources Ashley Hunt In Microsoft Project 2013; you can easily add overtime work to assist you in keeping an effective budget. In this video; Ashley Hunt; uses the Resource Usage view to look at individual resources; their assignments; their assignment duration; and their overtime work duration. 53798
Microsoft Project 2013: Apply Text Formatting to Standard Reports Ashley Hunt In Microsoft Project 2013; formatting text in standard reports has become much quicker and easier. In this video; Ashley Hunt; uses the formatting tools to change the font; color; effects; glow; fill; and rotation of text in a Burndown report. 53749
Microsoft Project 2013: Changing Linked Relationships Across Two Projects Ashley Hunt Microsoft Project 2013 enables you to change the relationship between linked predecessor and successor tasks across projects. In this video; Ashley Hunt changes the relationship type from Finish-to-Start to Start-to-Start between linked predecessor and successor tasks. 53782
Microsoft Project 2013: Create and Format Standard Report Ashley Hunt In Microsoft Project 2013; you can create and format standardized reports. In this video; Ashley Hunt uses the Dashboards feature to create and customize a Project Overview report. 53748
Microsoft Project 2013: Create Resource Pool Ashley Hunt Microsoft Project 2013 enables users to create a shared resource pool to consolidate information on all resources to use across multiple projects; without which human resources can easily be over-allocated. In this video; Ashley Hunt demonstrates how to create a resource pool from a blank project plan and then save it as a shared file on the network. 53758
Microsoft Project 2013: Creating a Combination View Lynn Tao In Microsoft Project 2013; you can create a custom combination view; create copies of it; and adjust it to include other views. In this video; Lynn Tao explains how to create a combination view. 55309
Microsoft Project 2013: Creating a Comparison Report Between Two Project Versions Ashley Hunt Microsoft Project 2013 enables you to quickly create a detailed report that allows you to review the performance of a project over time by highlighting the differences between two versions of the same project. In this video; Ashley Hunt uses the Compare Project Versions utility to review differences between a current version and an earlier version of the same project. 53786
Microsoft Project 2013: Creating a Custom Table Ashley Hunt In Microsoft Project 2013; it is easy to create a custom table and view the table data in different ways. In this video; Ashley Hunt; uses the More Tables list to create new tables and copy built-in tables and adapt them by adding and deleting columns or rows. 53803
Microsoft Project 2013: Creating a Filter Chris Keenan Microsoft Project 2013 lets you create your own filters. In this video Chris Keenan demonstrates how to create a new filter in Microsoft Project 2013. 55291
Microsoft Project 2013: Creating Charts Ashley Hunt Microsoft Project 2013 enables you to quickly and easily create and customize charts that compile the project data in a graphical report that you can use to convey an overview of information in a concise and easy-to-read format. In this video; Ashley Hunt demonstrates how to create a chart report and highlights some of the different formatting options. 53792
Microsoft Project 2013: Creating Custom Views Ashley Hunt Microsoft Project 2013 allows you to create new customized views that represent the project data in a way that is useful to you; and tailored to your specific needs and workflow. In this video; Ashley Hunt demonstrates how to create a custom combination view and use the Organizer to copy it to the Global template in Project 2013. 53794
Microsoft Project 2013: Creating Recurring Tasks Lynn Tao In Microsoft Project 2013; you can create recurring task entries and give start and end dates. In this video; Lynn Tao explains how to create recurring task entries. 55307
Microsoft Project 2013: Creating Visual Report Templates Lynn Tao Microsoft Project 2013 allows users to create pivot tables and diagrams by using Excel and Visio. In this video; Lynn Tao explains how to create a Visual Report template. 55311
Microsoft Project 2013: Custom Blank Reports with Graphics Ashley Hunt Microsoft Project 2013's Custom Report feature enables you to create graphic-rich reports from a blank template formatted to optimally display selected data. In this video; Ashley Hunt customizes a Blank Project 2013 report by adding a table and a chart; and then styling its graphic elements. 53778
Microsoft Project 2013: Custom Calendars and Non-Working Times Ashley Hunt Microsoft Project 2013 enables you to create your own custom calendars and set holidays and other non-working times specific to your company's schedule; which is especially useful when working on international projects. In this video; Ashley Hunt demonstrates how to add non-working times to a new custom calendar and assign the calendar to specific tasks in a project plan. 53790
Microsoft Project 2013: Custom WBS Codes Ashley Hunt Microsoft Project 2013's WBS option enables you to define custom alpha-numeric codes for your Work Breakdown Structure (WBS); customized to meet your project definitions; organizational codes; or customer needs. In this video; Ashley Hunt uses the Task Sheet view's WBS Code Definition feature and Code preview to build a multi-level; alpha-numeric coding structure for a WBS. 53780
Microsoft Project 2013: Customize Fields Ashley Hunt Microsoft Project 2013 enables users to create custom columns for their project plans by creating a custom field. This can be a task or resource field of a particular type; such as text; cost; date or duration. In this video; Ashley Hunt demonstrates how to add a custom field; name it; and insert it into the project plan. 53756
Microsoft Project 2013: Customize Options Ashley Hunt Microsoft Project 2013 enables users to customize the standard Project settings. This includes views; proofing; the schedule; currency; language; and display. In this video; Ashley Hunt explores the various default options that can be changed; and demonstrates how to change the default display; a currency symbol; and the assignment duration units. 53757
Microsoft Project 2013: Customize the Quick Access Toolbar Ashley Hunt Microsoft Project 2013 allows you to customize the Quick Access Toolbar so that it contains the options you most commonly use. Similarly; you can remove options you never use. In this video; Ashley Hunt demonstrates how to customize the options on the Quick Access Toolbar; and change the location of the toolbar. 53754
Microsoft Project 2013: Customize the Ribbon Ashley Hunt Microsoft Project 2013 enables users to customize the ribbon by creating their own tabs. Like the standard ribbon; a custom tab can contain collections of similar commands arranged in groups. In this video; Ashley Hunt demonstrates how to add a new tab containing a group of commands; and how to remove a custom tab. 53755
Microsoft Project 2013: Customizing Resource Calendars Ashley Hunt Microsoft Project 2013 allows you to create resource calendars for the individuals working on a project that you can customize and use to make adjustments to tasks assigned to a particular resource in the project calendar based on the availability of an individual resource. In this video; Ashley Hunt demonstrates how to add vacation dates to a resources calendar. 53791
Microsoft Project 2013: Customizing the List of Recently Opened Projects and Folders Lynn Tao In Microsoft Project 2013; you can customize the number of recently opened projects and folders you want displayed as per your preferences. In this video; Lynn Tao discusses how to customize the list of recently opened projects and folders. 55314
Microsoft Project 2013: Customizing the Quick Access Toolbar Lynn Tao In Microsoft Project 2013; you can customize the Quick Access Toolbar to add and group command that you use often. In this video; Lynn Tao explains how to customize the Quick Access Toolbar. 55304
Microsoft Project 2013: Customizing the Ribbon Lynn Tao In Microsoft Project 2013; you can customize the ribbon. In this video; Lynn Tao demonstrates how to customize the ribbon in Microsoft Project 2013. 55303
Microsoft Project 2013: Delay the Start of an Activity or Project Ashley Hunt Microsoft Project 2013's Update Project feature enables you to delay the start of a project task; automatically rescheduling all tasks affected by the delay. In this video; Ashley Hunt uses the Update Project feature to delay the start of a scheduled task and then reschedules a project using the Move Project feature. 53776
Microsoft Project 2013: Determine Methods for Resources Overallocation Ashley Hunt Microsoft Project 2013 gives users the ability to automatically level resources when there are resource over-allocations. However; you can use various views to make resource-levelling decisions yourself. In this video; Ashley Hunt demonstrates how to use the Team Planner to make informed resource allocation decisions. 53762
Microsoft Project 2013: Disabling Default Save to SkyDrive Lynn Tao Microsoft Project 2013 is by default set to save the documents to the SkyDrive. In this video; Chris Keenan discusses how to disable the default save to SkyDrive and enable local saving in Microsoft Project 2013. 55289
Microsoft Project 2013: Edit Macros Ashley Hunt Sometimes you need to correct errors or make minor adjustments to your recorded macros; and Microsoft Project 2013 allows you to easily edit macros in Visual Basic without needing to re-record them. In this video; Ashley Hunt demonstrates how to edit a macro using Microsoft Visual Basic for Applications (VBA) from within the Macros dialog box in Project 2013. 53788
Microsoft Project 2013: Edit Visual Reports Template Ashley Hunt Microsoft Project 2013 allows you to edit an existing visual report template; saving you the time of having to modify the PivotTable every time you export it to Excel. In this video; Ashley Hunt uses the Visual Reports - Field Picker dialog box in Project 2013 to edit an Excel template by adding and removing fields. 53785
Microsoft Project 2013: Enabling and Using Autorecover Lynn Tao In Microsoft Project 2013; you can use the Auto Recover feature to save your work and recover it after power loss or system crash. In this video; Chris Keenan discusses how to enable and use the Auto Recover feature in Microsoft Project 2013. 55292
Microsoft Project 2013: Entering Progress Using a Daily Timesheet Lynn Tao In Microsoft Project 2013; you can track the progress of the work. You can enter actual work; change the Timescale; and check the balance work. In this video; Lynn Tao discusses how to enter the progress using daily timesheet in Microsoft Project 2013. 55308
Microsoft Project 2013: Exporting Cost Data with a Map Ashley Hunt In Microsoft Project 2013; maps are a great way to export your information into Excel. In this video; Ashley Hunt; uses the Export Wizard and a custom map to export cost data from Project 2013 to Excel. 53801
Microsoft Project 2013: Exporting to Excel Ashley Hunt Microsoft Project 2013's Export Wizard maps Project fields to appropriate export formats; enabling you to share selected Task; Resource; Assignment; and other data by saving it for export to an Excel workbook. In this video; Ashley Hunt saves a project as an Excel workbook; and then steps through Project 2013's Project Export Wizard; mapping and exporting task names as selected data. 53769
Microsoft Project 2013: Filtering Ashley Hunt Microsoft Project 2013 allows you to quickly filter your information so that you can sort through your project details easily. In this video; Ashley Hunt demonstrates how to use the filter function in Microsoft Project 2013. 53767
Microsoft Project 2013: Formatting a Gantt Chart Ashley Hunt In Microsoft Project 2013; you can format your Gantt Chart to make it easier to read; and display task information in different ways. In this video; Ashley Hunt demonstrates how to customize the Gantt Chart color scheme; modify bar styles; and change how tasks display. 53752
Microsoft Project 2013: Grouping Ashley Hunt Microsoft Project 2013 allows you to quickly group your information so that you can sort through your project details easily. In this video; Ashley Hunt demonstrates how to use the grouping function in Microsoft Project 2013. 53766
Microsoft Project 2013: Highlighting with Cell Background Color Lynn Tao Microsoft Project 2013 allows users to change the cell background; so specific information stands out. In this video; Lynn Tao explains to highlight cell background color. 55313
Microsoft Project 2013: Inactive Tasks Ashley Hunt Microsoft Project 2013's Inactivate feature enables you to incorporate tasks and plan for risk events by allowing you to inactivate such tasks without affecting the project plan; the project schedule; resource availability; or other scheduled tasks. In this video; Ashley Hunt uses the Inactivate feature to "inactivate" a task and demonstrates how it has no effect on the project plan. 53775
Microsoft Project 2013: Interim Baselines and Custom Tables for Viewing Ashley Hunt In Microsoft Project 2013; you can create an interim plan to track performance from the baseline date to the current date. In this video; Ashley Hunt demonstrates how to set an interim plan and view the data in a custom table. 53805
Microsoft Project 2013: Leveling Gantt Ashley Hunt Microsoft Project 2013 allows you to use the Leveling Gantt to show the visual impact of the leveling of resources across your project. In this video; Ashley Hunt demonstrates how to use the Leveling Gant in Microsoft Project to judge the most efficient allocation of your resources. 53764
Microsoft Project 2013: Leveling Resources Ashley Hunt Microsoft Project 2013 allows you to reallocate your resources when they become over-allocated. In this video; Ashley Hunt demonstrates how you can use Microsoft Project to level your resources to make your project plan as efficient as possible. 53763
Microsoft Project 2013: Linking Across Projects Ashley Hunt Microsoft Project 2013 enables you to link predecessor and successor tasks across projects. In this video; Ashley Hunt opens two project files and creates a link between predecessor and successor tasks. 53781
Microsoft Project 2013: Master Projects Ashley Hunt Microsoft Project 2013 gives users running multiple individual projects the ability to create a master plan that contains all of them. The individual plans remain linked to the master plan so that updates to the master plan are carried over to the original project plans. In this video; Ashley Hunt demonstrates how to create and maintain a master plan. 53760
Microsoft Project 2013: Modify Tasks Ashley Hunt Microsoft Project 2013 enables you to modify tasks using multiple auto-scheduling methods; from rescheduling tasks by drag and drop; to configuring the many options available in the Task Information dialog box; to manually configuring them from the ribbon. In this video; Ashley Hunt modifies tasks automatically and manually. 53777
Microsoft Project 2013: Organizer Ashley Hunt Microsoft Project 2013's Organizer feature enables you to incorporate project elements such as views; templates; and tables from and to the Global template; thereby allowing full template customization and avoiding duplication. In this video; Ashley Hunt uses the Organizer feature to incorporate several international calendars into a template used worldwide. 53770
Microsoft Project 2013: Outline Codes Ashley Hunt Microsoft Project 2013's Outline Number option enables you; whether you insert or delete items; to use automatic numbering - recognized by Excel - alongside your Work Breakdown Structure (WBS) elements. In this video; Ashley Hunt enables the Task Sheet view and uses the Outline Number option to demonstrate the practical uses of numbering; be it switched on or off. 53779
Microsoft Project 2013: Personalizing Recently Opened Projects Lynn Tao In Microsoft Project 2013; you can use the Recent Projects list to open recently opened projects. In this video; Chris Keenan discusses how to personalize the list of recently opened projects in Microsoft Projects 2013. 55290
Microsoft Project 2013: Printing in Project Ashley Hunt In Microsoft Project 2013; you can navigate the print preview and customize your print settings in one location. In this video; Ashley Hunt uses the Print feature to preview and customize the print settings for a report. 53751
Microsoft Project 2013: Privacy and Security Settings Lynn Tao Microsoft Project 2013 has several options that allow users to protect their project files and computers. In this video; Lynn Tao introduces the privacy and security settings and Trust Center options. 55305
Microsoft Project 2013: Rebaselining Only Unstarted Tasks Lynn Tao In Microsoft Project 2013; you can rebaseline unstarted tasks if major changes occur in the project. In this video; Lynn Tao explains how to rebaseline unstarted tasks in Project 2013. 55312
Microsoft Project 2013: Recording a Macro to Create a Formatted Report Ashley Hunt Microsoft Project 2013 allows you to easily automate frequently repeated formatting tasks by recording macros that can be stored and accessed whenever you need to apply specific formatting steps to a report. In this video; Ashley Hunt demonstrates how to use the macros options to record and run a macro. 53787
Microsoft Project 2013: Recurring Tasks Ashley Hunt Microsoft Project 2013 allows you to easily schedule recurring tasks into your project plan. In this video; Ashley Hunt demonstrates how to accommodate weekly status meetings into your project management plan. 53765
Microsoft Project 2013: Setting Baselines Ashley Hunt In Microsoft Project 2013; you can set a baseline to assist in tracking a project. In this video; Ashley Hunt demonstrates how to create and use a baseline to track a project. 53804
Microsoft Project 2013: Split Screen and Fixed Units for Resources Ashley Hunt In Microsoft Project 2013; you can easily manage the scheduling of resources and the duration of scheduled work. In this video; Ashley Hunt; uses the Task Form to assign resources and change the duration of the resource's scheduled work. 53802
Microsoft Project 2013: Split Screen Views Ashley Hunt Microsoft Project 2013 allows you to split the screen; enabling you to see two different types of project data at the same time; and avoid the inconvenience of switching between screens. In this video; Ashley Hunt uses the split view feature in Project 2013 to combine different views within a project onscreen at the same time. 53793
Microsoft Project 2013: Splitting a Task Ashley Hunt When work needs to be interrupted for an unexpected event; Microsoft Project 2013 allows you to split specific tasks into segments so that part of the task starts later in the schedule. In this video; Ashley Hunt demonstrates how to split a task in the Gantt Chart view before adjusting the duration of the split task. 53797
Microsoft Project 2013: Task Calendars Ashley Hunt Microsoft Project 2013 enables you to assign custom calendars to global tasks; thereby accommodating resources subject to different countries' or organizations' holidays; time zones; or working hours. In this video; Ashley Hunt uses the Task Calendar function to assign a calendar to a resource in another country; thereby ensuring that the project plan tracks tasks correctly. 53771
Microsoft Project 2013: Task Inspector Ashley Hunt The Task Inspector feature in Microsoft Project 2013 helps you to quickly identify tasks causing scheduling problems and provides options on how to resolve the issues. In this video; Ashley Hunt demonstrates how to use the Task Inspector in Project 2013 to draw attention to scheduling issues and to resolve them in your project plan. 53783
Microsoft Project 2013: Team Planner Ashley Hunt Microsoft Project 2013's Team Planner enables project managers to allocate and reallocate their project resources through a visual interface. In this video; Ashley Hunt reschedules the work of overallocated resources; formats Team Planner visual elements; and automatically levels resources using the Prevent Overallocation feature. 53774
Microsoft Project 2013: Templates Ashley Hunt Microsoft Project 2013 enables you to create project templates from existing project documents; negating duplication of effort. Cleaned of project-specific data such as date constraints; error-free templates ensure the success of future projects. In this video; Ashley Hunt saves a Microsoft Project 2013 document as a Project Template; and cleans it further using Project's Save As Template wizard. 53772
Microsoft Project 2013: Tracking Gantt for Baseline and Statistics Box Ashley Hunt In Microsoft Project 2013; you can use the Tracking Gantt feature to compare the baseline to the current project status. In this video; Ashley Hunt demonstrates how to view the baseline statistics and use the Tracking Gantt to see the baseline compared to the current status. 53807
Microsoft Project 2013: Tracking Task Links Ashley Hunt The new task path feature in Microsoft Project 2013 allows you to highlight successors and predecessors in the Gantt Chart; allowing you to see how selected tasks fit into the overall schedule and help unravel large complex project plans. In this video; Ashley Hunt introduces the task path options for Gantt Charts. 53789
Microsoft Project 2013: Updating a Resource Pool Ashley Hunt Microsoft Project 2013 enables users to create resource pools for sharing resources across multiple projects. Updating the project plan automatically updates the resource pool and vice versa. In this video; Ashley Hunt demonstrates how to add and edit resources in the resource pool. 53761
Microsoft Project 2013: Updating Resource Costs Ashley Hunt Microsoft Project 2013 calculates the cost for resources; helping you to track the budgeting of a project by allowing you to update any resource costs that might change throughout the lifetime of a project. In this video; Ashley Hunt demonstrates how to apply a resource cost increase in the cost rate table for an individual resource. 53795
Microsoft Project 2013: Using Cost Rate Tables Ashley Hunt In Microsoft Project 2013; you can easily track your budgeting with Cost Rate Tables. In this video; Ashley Hunt; uses a Cost Rate Table to update overtime at different cost rates for resources and tasks. 53799
Microsoft Project 2013: Using Critical Path Tools Ashley Hunt Microsoft Project 2013's Critical Path tools enable you to determine; graphically and on your Gantt chart; the series of interdependent tasks dictating your project's Finish date. In this video; Ashley Hunt uses Project 2013's Critical Tasks and Slack features to graphically identify critical and noncritical tasks; and explains how delays to critical tasks impact a project's Finish date. 53768
Microsoft Project 2013: Using Highlighting Filters Ashley Hunt The predefined filters and highlights in Microsoft Project 2013 allow you to quickly focus on specific subsets of task and resource data within a project plan by applying color to the filtered data. In this video; Ashley Hunt introduces us to the different built-in highlighting options within the VIEW tab's ribbon interface. 53796
Microsoft Project 2013: Using Page Setup for Print Settings Lynn Tao Microsoft Project 2013 has a variety of printing options that allows you to adjust settings such as orientation; header; footer; and margins. In this video; Lynn Tao demonstrates how to adjust print settings by using the Page Setup. 55310
Microsoft Project 2013: Using Task Notes Lynn Tao In Microsoft Project 2013; you can create notes and link it to files to help you organize your tasks. In this video; Lynn Tao explains how to use task notes. 55306
Microsoft Project 2013: Using the Timeline for Reporting Ashley Hunt Microsoft Project 2013 provides a Timeline feature that gives users an overview of all activities in a project; and how phases stretch across time. In this video; Ashley Hunt demonstrates how to add activities to the timeline; how to format the timeline; and how to copy the timeline into an e-mail and send it out as a reporting tool. 53753
Microsoft Project 2013: Visual Reports Using Excel Ashley Hunt Microsoft Project 2013 allows you to create visual reports of your project's data that can be viewed and manipulated in Excel while providing your recipients with easy access to the data. In this video; Ashley Hunt creates a visual report within Project 2013 that is exported to Excel; before demonstrating how to change the report in the PivotTable. 53784
Microsoft Project 2013: Work Contours Ashley Hunt Microsoft Project 2013's Work Contour option enables you to shape tasks' particular work requirements to your available resources. In this video; Ashley Hunt uses the Work Contour option to shape a task's work requirements to the hours available to the resource. 53773
Publisher 2013 (15)
Title Speaker Summary ID
Microsoft Publisher 2013: Configuring Publisher: The Info Pane Jamie Campbell In Microsoft Publisher 2013; you can configure the Info pane. In this video; Jamie Campbell discusses how to use and configure the Info Pane in Publisher. 55179
Microsoft Publisher 2013: Creating a Cover Page Jamie Campbell In Microsoft Publisher 2013; you can add a cover page to you publication. In this video; Jamie Campbell discusses how to create cover pages in Publisher. 55178
Microsoft Publisher 2013: Creating a New Publisher 2013 Document Jamie Campbell Microsoft Publisher 2013 is a desktop publishing application that can be used to create visually appealing documents. In this video; Jamie Campbell discusses how to create a new Publisher document. 55168
Microsoft Publisher 2013: Getting Started with Microsoft Publisher 2013 Jamie Campbell Microsoft Publisher 2013 can be used to create ads; brochures; and other types of documents that can be distributed electronically or by print. In this video; Jamie Campbell introduces you to Microsoft Publisher 2013 and discusses how best to utilize the templates within to create visually stunning documents. 55166
Microsoft Publisher 2013: Manipulating and Grouping Objects Jamie Campbell In Microsoft Publisher 2013; you can group and manipulate objects like shapes; text; and images in the document. In this video Jamie Campbell discusses how to group and manipulate objects in the Publisher document. 55174
Microsoft Publisher 2013: Printing; Sharing; and Exporting Documents Jamie Campbell In Microsoft Publisher 2013; you can print; share; and export your documents. In this video; Jamie Campbell discusses how to use the Print; Share; and Export options in a Publisher document. 55180
Microsoft Publisher 2013: Publisher 2013 Document Layout Jamie Campbell In Microsoft Publisher 2013; you can create documents like business cards and posters using the Document Layout. In this video; Jamie Campbell discusses Publisher 2013 document layout. 55173
Microsoft Publisher 2013: The Publisher 2013 Interface Jamie Campbell Microsoft Publisher 2013 has various features that can be used to create visually stunning documents. In this video; Jamie Campbell discusses the features of Publisher 2013 interface. He goes through the features available right from creating a document to printing it. 55167
Microsoft Publisher 2013: Working with Building Blocks Jamie Campbell In Microsoft Publisher 2013; you can quickly add pre-designed graphics to your publications. In this video; Jamie Campbell discusses how you can use the Building Blocks feature to add designed graphics in your document. 55175
Microsoft Publisher 2013: Working with Master Pages Jamie Campbell In Microsoft Publisher 2013; you can use the Master Page feature to organize and lay out your publications. In this video; Jamie Campbell discusses Master Pages in Publisher. 55177
Microsoft Publisher 2013: Working with Pictures Jamie Campbell In Microsoft Publisher 2013; you can add images and logos to your document. In this video; Jamie Campbell discusses working with pictures in Publisher 2013. 55170
Microsoft Publisher 2013: Working with Shapes Jamie Campbell In Microsoft Publisher 2013; you can create various types of shapes; lines; arrows; flowcharts and callouts in your document. In this video; Jamie Campbell discusses working with shapes in Publisher. 55172
Microsoft Publisher 2013: Working with Tables Jamie Campbell In Microsoft Publisher 2013; you can create table to organize and display your data. In this video; Jamie Campbell discusses working with tables in Publisher. 55171
Microsoft Publisher 2013: Working with Text Objects Jamie Campbell Microsoft Publisher 2013 is a desktop publishing application that can be used to create visually appealing documents. In this video; Jamie Campbell discusses working with Publisher 2013 text objects. 55169
Microsoft Publisher 2013: Working with the Ruler and Guides Jamie Campbell In Microsoft Publisher 2013; you can use the Rulers and Guides feature to have precision in the document. In this video; Jamie Campbell discusses how to use Guides in a Publisher document. 55176
SharePoint 2013 (31)
Title Speaker Summary ID
Microsoft SharePoint 2013: About Me David Santana About Me in Microsoft SharePoint 2013 allows users to manage their online profiles. In this video; David Santana shows you how to locate and use this social feature in the Newsfeed App. 52133
Microsoft SharePoint 2013: Adding Items to Lists David Santana Microsoft SharePoint 2013 allows users to create lists. In this video; David Santana shows you how to add items to a list. 52137
Microsoft SharePoint 2013: Checking Out and In Documents David Santana The check-out and check-in controls in Microsoft SharePoint 2013 ensure that other users cannot edit your document while you are editing it. In this video; David Santana demonstrates how to check out a document from the library and check back in. 52142
Microsoft SharePoint 2013: Create a Blog Post David Santana Creating a blog post in Microsoft SharePoint 2013 is easy using the Newsfeed section. In this video; David Santana shows you how to create a blog post. 52151
Microsoft SharePoint 2013: Create a List David Santana Microsoft SharePoint 2013 allows users to create lists to structure shared information. In this video; David Santana walks you through how to effectively navigate the apps page and create a list in SharePoint 2013. 52136
Microsoft SharePoint 2013: Create Conversations in Newsfeed David Santana Creating conversations using Newsfeed in Microsoft SharePoint 2013 allows users to discuss topics of interest. In this video; David Santana shows you how to post; edit; and delete a conversation. 52160
Microsoft SharePoint 2013: Create Note on Note Board David Santana Creating notes on Note Board in Microsoft SharePoint 2013 allows users to post comments on specific site pages. In this video; David Santana shows you how to post comments on a specific site page. 52158
Microsoft SharePoint 2013: Creating Alerts David Santana Creating alerts in Microsoft SharePoint 2013 allows you to receive specific email notifications on site pages; search query results; and any list or site page. In this video; David Santana shows you how to set up alerts. 52144
Microsoft SharePoint 2013: Creating Tags David Santana Creating tags in Microsoft SharePoint 2013 allows users to follow specific site pages. In this video; David Santana discusses how tags work and demonstrates how to create a tag. 52157
Microsoft SharePoint 2013: Document Libraries David Santana Microsoft SharePoint 2013 allows you to easily create document libraries. In this video; David Santana demonstrates the various ways in which to create a library and add documents. 52143
Microsoft SharePoint 2013: Enhancements to the User Interface David Santana The user interface in Microsoft SharePoint 2013 has a better look and feel. In this video; David Santana discusses how to use the more user-friendly interface to perform a range of tasks-from content authoring to cross-site publishing. 52187
Microsoft SharePoint 2013: I'm Following List David Santana The I'm Following feature in Microsoft SharePoint 2013 allows users to track followings; trending; tags; and people. In this video; David Santana shows you how to navigate to the People I'm Following page. 52162
Microsoft SharePoint 2013: Improvements to the User Interface David Santana The user interface in Microsoft SharePoint 2013 has been enhanced to offer users a simple and unified navigation experience to their sites and to all additional sub-sites. In this video; David Santana shows you how to use the interface effectively. 52188
Microsoft SharePoint 2013: List Ribbon Interface David Santana Using the ribbon interface in a list in Microsoft SharePoint 2013 allows users to easily access tools; controls; and commands. In this video; David Santana explores the interface and discusses how to use it effectively. 52139
Microsoft SharePoint 2013: Lists David Santana Lists in Microsoft SharePoint 2013 allow users to share information in a structured way. In this video; David Santana discusses the additional uses of this feature in SharePoint 2013. 52135
Microsoft SharePoint 2013: Managing Alerts David Santana Managing alerts in Microsoft SharePoint 2013 can be a hassle if you have created multiple alerts. In this video; David Santana shows you how to manage an alert by navigating to an alert and editing it. 52145
Microsoft SharePoint 2013: Mentioning Members David Santana Mentioning a member in a comment in Microsoft SharePoint 2013 allows users to directly access the member's profile details from the comment. In this video; David Santana demonstrates how to add member information in your comments. 52161
Microsoft SharePoint 2013: Newsfeed Contact Info David Santana Microsoft SharePoint 2013 allows users to access Contact Information through the Newsfeed App. In this video; David Santana shows you how to navigate to the contact card page and locate privacy settings. 52147
Microsoft SharePoint 2013: Newsfeed Details Page David Santana The Details page in the Newsfeed App in Microsoft SharePoint 2013 allows users to add past projects and skills information to their profile. In this video; David Santana shows you how to specify this information and change privacy settings. 52148
Microsoft SharePoint 2013: Overview of Newsfeed Tab David Santana The Newsfeed tab in Microsoft SharePoint 2013 keeps you connected with your co-workers and up-to-date on what is happening. In this video; David Santana talks about how to use the Newsfeed tab effectively by posting and seeking information. 52132
Microsoft SharePoint 2013: Overview of Search Capabilities David Santana Microsoft SharePoint 2013 offers users a very powerful and highly configurable search. In this video; David Santana shows you how to refine your search and set alerts for a specific search. 52175
Microsoft SharePoint 2013: Permissions David Santana Permissions and privileges in Microsoft SharePoint 2013 can be set for groups associated with specific lists and libraries. In this video; David Santana shows you how to manage permission settings. 52189
Microsoft SharePoint 2013: Play Your Media Asset David Santana Playing your media asset in Microsoft SharePoint 2013 is simple. In this video; David Santana shows you how to play an uploaded video. 52190
Microsoft SharePoint 2013: Profile Settings Lynn Tao In Microsoft SharePoint 2013; you can limit the amount of personal information that will be visible to other users by using privacy and profile setting. In this video; Lynn Tao will demonstrate how to set the profile settings for a user. 55285
Microsoft SharePoint 2013: Quick Edit Mode David Santana Quick Edit in Microsoft SharePoint 2013 gives users the ability to edit list items. In this video; David Santana shows you how to use this mode to view and edit items on the list using the spreadsheet format. 52138
Microsoft SharePoint 2013: Quick Launch David Santana Quick Launch in Microsoft SharePoint 2013 allows users to navigate to specific sites; such as the Sales site; and return to the original parent site. In this video; David Santana shows you how to use the functionality to navigate effectively. 52131
Microsoft SharePoint 2013: Setting Alert on Search Results David Santana Microsoft SharePoint 2013 allows you to set alerts on search query results. In this video; David Santana shows you how to create a new alert on a search result for new items in the search result. 52146
Microsoft SharePoint 2013: Skydrive Tab David Santana The SkyDrive tab in Microsoft SharePoint 2013 allows users to access the SkyDrive Pro page. In this video; David Santana shows you how to use the tab to navigate to the SkyDrive Pro functionality. 52134
Microsoft SharePoint 2013: Start a New Discussion David Santana Starting a new discussion in Microsoft SharePoint 2013 is vital. In this video; David Santana shows you how to navigate to a community site and post a discussion. 52164
Microsoft SharePoint 2013: View Tags and Notes David Santana Microsoft SharePoint 2013 allows users to view previous tags and notes. In this video; David Santana shows you how to access older tags and notes. 52159
Microsoft SharePoint 2013: Working with SkyDrive Pro David Santana The SkyDrive Pro page in Microsoft SharePoint 2013 allows users to drag and drop files just like in a document library. In this video; David Santana shows you how to navigate to the SkyDrive Pro page and how to use it. 52149
Skype for Business (35)
Title Speaker Summary ID
Skype for Business - Exercise: Managing Your Profile and Contacts Travis Welton After watching this video; you will be able to configure your presence and location; add contacts; and create a new group. 85768
Skype for Business - Exercise: Scheduling a Meeting in Outlook Travis Welton After watching this video; you will be able to configure a Skype for Business meeting in Outlook. 85781
Skype for Business - Exercise: Sharing Files and Using the Poll Feature Travis Welton After watching this video; you will be able to identify the steps to share a file in an IM conversation; share the whiteboard; and create a poll. 85793
Skype for Business: Adding contacts Travis Welton After watching this video; you will be able to add internal and external contacts. 85764
Skype for Business: Answering Video Calls Travis Welton After watching this video; you will be able to recognize the steps to answer a video call; ignore the call; and use other available options. 85790
Skype for Business: Answering; Transferring; and Forwarding Calls Travis Welton After watching this video; you will be able to identify how to answer a call; transfer a call; and forward calls. 85770
Skype for Business: Attending a Meeting Travis Welton After watching this video; you will be able to identify methods to join a scheduled meeting including using the Meetings option in Skype for Business; from an Outlook meeting request and from a meeting reminder. 85777
Skype for Business: Changing the Skype for Business Picture Travis Welton After watching this video; you will be able to configure picture options including hiding; showing; editing; or removing a picture. 85763
Skype for Business: Configuring an Unscheduled Meeting Travis Welton After watching this video; you will be able to create and configure options for an unscheduled meeting using the Meet Now option. 85776
Skype for Business: Configuring Audio Settings Travis Welton After watching this video; you will be able to complete the steps to configure an audio device and configure audio options. 85794
Skype for Business: Configuring Contact List Options Travis Welton After watching this video; you will be able to configure how the contact list displays; order options; and which information is displayed. 85767
Skype for Business: Configuring Conversation View Options Travis Welton After watching this video; you will be able to configure meeting conversation options including choosing a layout; using full screen; and the pop out and pop in options. 85778
Skype for Business: Configuring Global Instant Message Options Travis Welton After watching this video; you will be able to identify the steps to configure IM options including spelling; copying; tabbed conversations; and font options. 85774
Skype for Business: Configuring Groups Travis Welton After watching this video; you will be able to create a group; add contacts; and delete an existing group. 85765
Skype for Business: Configuring the Video Device Travis Welton After watching this video; you will be able to recognize the steps to set up a video device and access and configure advanced settings. 85788
Skype for Business: Configuring your Presence Travis Welton After watching this video; you will be able to identify the steps to configure presence options. 85761
Skype for Business: Discovering the File Transfer Preview Travis Welton After watching this video; you will be able to recognize the File Transfer Preview feature and the available options. 85760
Skype for Business: Exploring the Location Feature Travis Welton After watching this video; you will be able to recognize and configure the location feature. 85762
Skype for Business: Initiating a Video Meeting and Managing Participants After watching this video; you will be able to describe the steps to start a video meeting and manage participants using participants actions options. 85791
Skype for Business: Making a Video Call and Using Controls Travis Welton After watching this video; you will be able to identify the steps to start a video call and use video controls. 85789
Skype for Business: Making Calls Travis Welton After watching this video; you will be able to identify the steps to make a call and using the call controls. 85769
Skype for Business: Managing Control Options Travis Welton After watching this video; you will be able to identify the steps to give control or take away controls from other users while presenting. 85787
Skype for Business: Managing Download Permissions on Shared Files Travis Welton After watching this video; you will be able to configure who will have access to downloading files that are shared. 85785
Skype for Business: Managing Meeting Participants and Recording Options Travis Welton After watching this video; you will be able to add participants to a meeting; configure participant actions; record a meeting; and manage recordings. 85779
Skype for Business: Scheduling a Skype Meeting Using Outlook Travis Welton After watching this video; you will be able to schedule a Skype for Business meeting using Outlook and configure meeting options. 85775
Skype for Business: Sharing Files and Pictures Travis Welton After watching this video; you will be able to recognize the steps required to share files and pictures in an IM conversation or meeting. 85784
Skype for Business: Sharing Notes Travis Welton After watching this video; you will be able to identify the steps to share OneNote notes; including using existing notes and creating new notes. 85782
Skype for Business: Sharing Whiteboards Travis Welton After watching this video; you will be able to share and use the whiteboard feature. 85783
Skype for Business: Starting IM Conversations with Multiple Contacts Travis Welton After watching this video; you will be able to identify the steps to send instant messages to multiple contacts or groups at once. 85772
Skype for Business: Using Instant Messaging Travis Welton After watching this video; you will be able to recognize the steps to send an IM; including sending a file or image; using emoticons; and configuring the message as high priority. 85771
Skype for Business: Using Instant Messaging Options Travis Welton After watching this video; you will be able to use IM options; including adding audio and video; sharing files; and toggling between conversations. 85773
Skype for Business: Using Sharing Options Travis Welton After watching this video; you will be able to use the present desktop and present programs sharing options and sharing a PowerPoint presentation. 85780
Skype for Business: Using the Contact Cards Travis Welton After watching this video; you will be able to identify the steps to access contact cards and available options. 85766
Skype for Business: Using the Polling Feature Travis Welton After watching this video; you will be able to use the polling feature including creating a poll. 85786
Skype for Business: Using Video with an Instant Message Conversation Travis Welton After watching this video; you will be able to identify the steps to include a video in an instant message conversation and recognize the available options such as "Stop My Video" and "End Video". 85792
Visio 2013 (30)
Title Speaker Summary ID
Microsoft Visio 2013: Adding Background Borders and Titles Isabel Garcia Microsoft Visio 2013 gives users the ability to add backgrounds; borders; and titles to their diagrams. In this video; Isabel Garcia demonstrates how to set a background from a range of predefined backgrounds; and how to add borders and titles on the VBackground page to display them on all pages. 53808
Microsoft Visio 2013: Auto Connect Isabel Garcia The AutoConnect feature in Microsoft Visio 2013 enables users to easily and quickly add; connect; align; and space shapes in a connected drawing such as a flowchart; instead of doing it manually. In this video; Isabel Garcia demonstrates how to use the AutoConnect feature to add and connect shapes instead of dragging and dropping them individually. 53809
Microsoft Visio 2013: Call Outs Isabel Garcia Microsoft Visio 2013 gives users the ability to add callouts to the shapes in their diagrams. In this video; Isabel Garcia demonstrates how to select and add a suitable callout from a range of predefined callouts. She also covers connecting callouts to various sections of a shape. 53810
Microsoft Visio 2013: Change Shapes Isabel Garcia Microsoft Visio 2013 provides the Change Shape feature that enables users to change an existing shape without losing its formatting. In this video; Isabel Garcia demonstrates how to change the shape of an object by choosing a predefined shape from one of the inbuilt shape templates. 53811
Microsoft Visio 2013: Commenting and Authoring Isabel Garcia Microsoft Visio 2013 provides the collaborative Comments feature; which lets multiple people add comments to a diagram at the same time using threads. In this video; Isabel Garcia demonstrates how to add; view and change comments. 53812
Microsoft Visio 2013: Connectors Isabel Garcia Microsoft Visio 2013 provides two new features for connecting shapes more easily - AutoConnect and Dynamic Glue. In this video; Isabel Garcia demonstrates how to enable the Connector and use the Pointer Tool to connect shapes automatically; and change the connection points and connection lines; if required. 53813
Microsoft Visio 2013: Containers Isabel Garcia Microsoft Visio 2013 enables users to place collections of shapes in a container with a visible border. So moving; formatting; or deleting the container will move or delete the shapes it contains. Containers can also be locked so that shapes cannot be added or removed. In this video; Isabel Garcia demonstrates how to work with containers. 53814
Microsoft Visio 2013: Customizing Ribbon and Quick Access Toolbar Isabel Garcia Microsoft Visio 2013 allows you to customize the commands on the Quick Access Toolbar as well as its location on screen. You can also add your own ribbon tabs; containing groups of commonly used commands. In this video; Isabel Garcia demonstrates how to customize the Quick Access Toolbar and add and populate a new ribbon tab. 53815
Microsoft Visio 2013: Defining Your Own Theme Colors Isabel Garcia Microsoft Visio 2013 enables users to choose a theme from a set of predefined themes; or create their own custom themes. Custom themes can contain a range of colors; effects; connectors; and embellishments. In this video; Isabel Garcia demonstrates creating; naming; and customizing a theme. 53816
Microsoft Visio 2013: Diagram Templates Isabel Garcia Microsoft Visio 2013 offers a range of templates that you can use to create diagrams. These include the Basic Diagram template with basic shapes; arrow shapes; decorative shapes; and graph and math shapes. In this video; Isabel Garcia demonstrates how to create a diagram from a more specialized template; the Basic Network Diagram template; using connectors and text labels. 53817
Microsoft Visio 2013: External Data Sources Isabel Garcia In Microsoft Visio 2013; you can visually represent complex information that comes from external sources. In this video; Isabel Garcia; demonstrates how to import data from other external sources; such as Excel or Access; into a diagram. 53818
Microsoft Visio 2013: Flowchart Templates Isabel Garcia In Microsoft Visio 2013; you can use templates to assist you to create basic flowcharts; top-down diagrams; information-tracking diagrams; process-planning diagrams; and structure prediction diagrams. In this video; Isabel Garcia; demonstrates how to create basic flowcharts; cross-functional flowcharts; and work flow diagrams using the Shapes panel; AutoConnect; and pointer tools. 53819
Microsoft Visio 2013: Formatting Isabel Garcia Microsoft Visio 2013 includes several formatting features; such as the Format Shape panel; Format Painter; Effects; and Line Options. In this video; Isabel Garcia; demonstrates how to use these features; to format shapes; text; and connectors. 53820
Microsoft Visio 2013: Interface Overview Isabel Garcia The Microsoft Visio 2013 interface includes new features; such as templates; shapes; themes; and collaborating tools. In this video; Isabel Garcia; demonstrates how to use the new features of Visio 2013 to create diagrams; flowcharts; track comments; and format shapes and diagrams. 53821
Microsoft Visio 2013: New File Format Isabel Garcia Microsoft Visio 2013 has a new four-digit file extension that replaces the previous Visio file format. In this video; Isabel Garcia; uses the Visio 2013 Save As feature to explore the different file formats for drawings; stencils; and templates. 53822
Microsoft Visio 2013: Organizational Chart Templates Isabel Garcia In Microsoft Visio 2013; working with organization charts has become easier with the new features. In this video; Isabel Garcia; demonstrates how to use the organization chart templates to create organization charts with the new shapes; stencils; and improved layouts. 53823
Microsoft Visio 2013: Pictures and Online Pictures Isabel Garcia Microsoft Visio 2013's enables you to quickly and easily insert local or online image files directly into your diagrams; offering you versatile Picture Tools with which to manipulate; arrange; size; or format graphics. In this video; Isabel Garcia inserts images from the Pictures Library as well as from an online location. 53824
Microsoft Visio 2013: Quick Styles Isabel Garcia Microsoft Visio 2013's Quick Styles allow you to format; apply styles to; and customize individual or multiple elements of your themed diagrams or their variants. In this video; Isabel Garcia adopts a theme and applies a Quick Style to a diagram. 53825
Microsoft Visio 2013: Saving Diagrams as Graphics Isabel Garcia Microsoft Visio 2013 allows you to save your diagrams as graphics in multiple image formats; allowing you to work on them in other software applications. In this video; Isabel Garcia names and saves a Microsoft Visio 2013 diagram to the Desktop as a JPEG graphic. 53826
Microsoft Visio 2013: Saving to Skydrive Isabel Garcia Microsoft Visio 2013 enables you to save your diagrams to SkyDrive; giving you access to them from anywhere at any time. SkyDrive lets you work on diagrams offline and share them with others. It also synchronizes your local SkyDrive folder to the Cloud. In this video; Isabel Garcia details the attributes; benefits; and specifications of SkyDrive. 53827
Microsoft Visio 2013: Shape Effects Isabel Garcia Microsoft Visio 2013's Shape Effects enable you to quickly and easily customize and enhance your diagrams and their elements to a high level of professionalism. In this video; Isabel Garcia takes the stencil of a basic shape and turns it into a work of graphic design using manipulation; effects; and formatting. 53828
Microsoft Visio 2013: Shapes Overview Isabel Garcia Microsoft Visio 2013 includes many new shapes within its updated sets of built-in stencils that you use and manipulate to create easy-to-understand; professional looking diagrams. In this video; Isabel Garcia adds shapes to a template and then customizes the shapes using the some of the many options available from the ribbon interface. 53829
Microsoft Visio 2013: Sharing Diagrams via E-Mail Isabel Garcia Microsoft Visio 2013 allows you to easily and efficiently share diagrams by automating the process of attaching them to Outlook messages. In this video; Isabel Garcia uses the Share options in Visio 2103 to automatically generate a new message and convert a diagram to a different file format when attaching it to the message. 53830
Microsoft Visio 2013: Stencils Overview Isabel Garcia Stencils in Microsoft Visio 2013 hold collections of shapes that you can easily access at any time through the Shapes panel. In this video; Isabel Garcia introduces us to stencils in Visio 2013 before demonstrating how you can create custom stencils to manage your favourite shapes and those that you created; as well as how to search for stencils. 53831
Microsoft Visio 2013: Task Panes Isabel Garcia Task panes in Microsoft Visio 2013 are windows that allow you to quickly view the data for a particular shape and move around easily within your drawing. In this video; Isabel Garcia demonstrates how to utilize the four different task panes from within Visio's VIEW tab ribbon interface to easily access the data about any of shapes in a diagram. 53832
Microsoft Visio 2013: Template Overview Isabel Garcia Microsoft Visio 2013 includes many built-in diagram templates that have been updated and improved; allowing you to get started and achieve better results in less time. In this video; Isabel Garcia highlights some of the template updates in Visio 2013 while demonstrating how to use the Templates gallery page to find templates and use them to create a new diagram. 53833
Microsoft Visio 2013: Themes and Variants Isabel Garcia Microsoft Visio 2013 themes have been redesigned with new formatting options; and along with the four variants that each theme offers; you'll be able to create unique; professional-looking diagrams with the least possible effort. In this video; Isabel Garcia demonstrates how to apply a theme to a diagram using variants to fine-tune it. 53834
Microsoft Visio 2013: Using Review Tools Isabel Garcia In Microsoft Visio 2013; you can use the REVIEW tab to access a range of Review Tools. In this video; Isabel Garcia uses the Research; Language; New Comment; Comments Pane; and Shape Reports review tools in a Visio diagram. 53835
Microsoft Visio 2013: Visio Options Isabel Garcia In Microsoft Visio 2013; you can customize your options in the Visio Options dialog box. In this video; Isabel Garcia explores the General; Proofing; Save; Language; Advanced; Customize Ribbon; Quick Access Toolbar; Add-Ins; and Trust Center features in the Visio Options dialog box. 53836
Microsoft Visio 2013: Working with Hyperlinks Isabel Garcia In Microsoft Visio 2013; you can add hyperlinks to a shape. In this video; Isabel Garcia uses hyperlinks to link a shape to a page; as well as a shape to another shape on a different page in the same diagram. 53837
Word 2013 (55)
Title Speaker Summary ID
Microsoft Word 2013: Adding Controls Tiffany Gelbart Microsoft Word 2013 includes a variety of content controls that you can add to your forms; providing end-users with easy-to-use input options while restricting the input to suit your needs. In this video; Tiffany Gelbart demonstrates how to add a date picker control to a form document from within the DEVELOPER tab in Word 2013. 52116
Microsoft Word 2013: Adding WordArt Tiffany Gelbart Microsoft Word 2013's WordArt is a gallery of text styles enabling you to create multiple decorative effects. In this video; Tiffany Gelbart demonstrates how to use WordArt in a document. 52100
Microsoft Word 2013: Apply Document Themes Tiffany Gelbart In Microsoft Word 2013; you can use themes to give your documents a distinctive; reoccurring format. In this video; Tiffany Gelbart demonstrates how to preview and apply a theme to a document. 52106
Microsoft Word 2013: Apply Styles Tiffany Gelbart Microsoft Word 2013 provides a number of predefined style options that can be easily and consistently applied; allowing you to create streamlined documents that stand out. In this video; Tiffany Gelbart applies styles to the headings of a document using the Styles menu in Word 2013. 52071
Microsoft Word 2013: Automate Tasks Using Macros Tiffany Gelbart Microsoft Word 2013 allows you to create macros that can be used to automate repetitive and frequently used tasks. In this video; Tiffany Gelbart records a macro and uses it in a Word document. 52072
Microsoft Word 2013: Changing the Orientation of a Specific Page Lynn Tao In Microsoft Word 2013; you can change the orientation of a single page between landscape and portrait. In this video; Lynn Tao demonstrates how to change the page orientation for a single page. 55283
Microsoft Word 2013: Compare Document Changes Tiffany Gelbart The legal blacklining option in Microsoft Word 2013 allows you to compare document changes while retaining the integrity of the document versions. In this video; Tiffany Gelbart demonstrates how to compare the changes between two documents. 52073
Microsoft Word 2013: Create a Data Source Using Word Tiffany Gelbart Microsoft Word 2013 allows you to create a data source; which is the information that varies when using mail merge to send form letters to multiple recipients. In this video; Tiffany Gelbart uses the mail merge features to create a recipients list. 52074
Microsoft Word 2013: Create a Document Using a Template Tiffany Gelbart Microsoft Word 2013 provides numerous templates that allow you to quickly create stylish and professional looking documents without having to think about formatting. In this video; Tiffany Gelbart uses a letter template in Word 2013 to create a new document. 52075
Microsoft Word 2013: Create a Macro Tiffany Gelbart Microsoft Word 2013 makes it easy to automate commonly repeated tasks by allowing you to create macros that store commands or keystrokes that can be run whenever you need to perform the task. In this video; Tiffany Gelbart records a macro in Word and saves it as a button on the Quick Access Toolbar for easy access. 52076
Microsoft Word 2013: Create a Template Tiffany Gelbart Microsoft Word 2013 lets you save your frequently used documents as templates; thereby saving you time by not having to recreate static content and layout information; as well as maintaining a consistent look to your documents. In this video; Tiffany Gelbart demonstrates how to save a document in Word as a document template. 52077
Microsoft Word 2013: Create and Modify Text Styles Tiffany Gelbart By creating and modifying text styles in Microsoft Word 2013; you can apply a set of customized formatting choices consistently throughout your documents. In this video; Tiffany Gelbart demonstrates how to create and modify a text style in Word 2013 before applying the style to the layout of a document. 52078
Microsoft Word 2013: Create Custom Style Sets and Templates Tiffany Gelbart Microsoft Word 2013 allows you to develop customized style sets; which you can save as templates for faster; more consistent document creation that suits your preferences. In this video; Tiffany Gelbart uses the text format options in Word to create a style set before saving it as a Word template. 52079
Microsoft Word 2013: Create Forms Tiffany Gelbart Microsoft Word 2013 includes content controls for you to use when creating forms that will make data entry more efficient; reduce errors; and ensure consistency. In this video; Tiffany Gelbart uses the content controls in Word 2013 to create a form template. 52080
Microsoft Word 2013: Creating Custom Color Themes Tiffany Gelbart Microsoft Word 2013 allows you to set custom color formatting options within a document and save them as a document theme to be shared across Office programs for a professional; uniform look. In this video; Tiffany Gelbart demonstrates how to apply theme color options to a document before saving it as an Office theme document. 52114
Microsoft Word 2013: Creating Custom Font Themes Tiffany Gelbart Microsoft Word 2013 lets you customize the fonts in themes; including heading and body text fonts; allowing you to easily format documents across Office programs with the same; uniform font choices. In this video; Tiffany Gelbart demonstrates how to create a custom font theme in Word 2013. 52115
Microsoft Word 2013: Customize the Word Interface Tiffany Gelbart Microsoft Word 2013 allows you to customize elements within the interface; thereby letting you create an efficient environment tailored to your specific preferences and workflow. In this video; Tiffany Gelbart demonstrates how to customize the Quick Access Toolbar and manipulate the ribbon in Word 2013. 52081
Microsoft Word 2013: Deleting Building Blocks Tiffany Gelbart Microsoft Word 2013 lets you to maintain your building blocks by allowing you to delete building blocks; for example when you have duplicate items listed. In this video; Tiffany Gelbart uses the Building Blocks Organizer to delete a building block in Word 2013. 52112
Microsoft Word 2013: Deleting Document Draft Versions Tiffany Gelbart Microsoft Word 2013 allows you to easily delete the automatically generated draft versions of your document before sharing it with other people while working within SharePoint. In this video; Tiffany Gelbart demonstrates how to delete draft documents from the Versions menu in the Backstage view. 52108
Microsoft Word 2013: Desktop Publishing with Word Tiffany Gelbart Microsoft Word 2013 includes tools that you can use to enhance your images by applying effects and layout options; giving your desktop-publishing project the polished look you're after. In this video; Tiffany Gelbart uses some of the picture tools in Word 2013 to help create a professional looking a document. 52082
Microsoft Word 2013: Document Properties Tiffany Gelbart In Microsoft Word 2013; you can check your documents to see what types of information are attached to them in the document properties. In this video; Tiffany Gelbart demonstrates how to review and change document properties; and how to clean up documents prior to sharing them. 52102
Microsoft Word 2013: Editing Building Blocks Properties Tiffany Gelbart Microsoft Word 2013 allows you to edit the properties of existing building blocks. In this video; Tiffany Gelbart uses the Building Blocks Organizer in Word 2013 to modify and redefine an existing building block in order to make it part of the Quick Part Gallery. 52110
Microsoft Word 2013: Embedding and Linking Charts and Data Lynn Tao In Microsoft Word 2013; you can embed and link charts from Excel. In this video; Lynn Tao demonstrates how to embed and link charts and data from Excel to a Word document. 55279
Microsoft Word 2013: Enabling AutoRecover Lynn Tao In Microsoft Word 2013; you can recover from power outage or system crash by using the AutoRecovery feature. In this video; Lynn Tao demonstrates how to use and edit the duration for AutoRecovery in a Word document. 55282
Microsoft Word 2013: Envelopes and Labels Tiffany Gelbart By using the mail merge capabilities in Microsoft Word 2013; you can easily produce multiple labels and envelopes when distributing paper-based mail. In this video; Tiffany Gelbart demonstrates how to specify the format and printing options of an envelope before connecting the envelopes to an Outlook contacts list. 52083
Microsoft Word 2013: Finding Hidden Characters Lynn Tao In Microsoft Word 2013; you can display hidden characters and also find and replace the special formatting characters. In this video Lynn Tao demonstrates how to display; find; and replace special hidden characters in a Word document. 55280
Microsoft Word 2013: Formatting with Columns Tiffany Gelbart In Microsoft Word 2013 you can improve the layout of documents such as newsletters; step-by-step training documents; and brochures by using columns to produce a newspaper style format. In this video; Tiffany Gelbart demonstrates how to split a selected section of text into two columns. 52084
Microsoft Word 2013: Header and Footer Tiffany Gelbart In Microsoft Word 2013; you can add headers and footers to maintain a consistent layout to all pages of a document. In this video; Tiffany Gelbart demonstrates how to insert a picture into the header as well as add page numbers to a document. 52103
Microsoft Word 2013: Including the Print Date Lynn Tao In Microsoft Word 2013; the PrintDate feature allows us to record the date and time on any printed document. In this video; Lynn Tao demonstrates how to add PrintDate to a printed Word document. 55281
Microsoft Word 2013: Inserting a Table of Contents Tiffany Gelbart By using the built-in heading styles; Microsoft Word 2013 can automatically generate an updated table of contents that allows you to easily refer to the relevant sections of a document. In this video; Tiffany Gelbart demonstrates how to insert a table of contents into a document. 52085
Microsoft Word 2013: Inserting and Creating Equations Lynn Tao In Microsoft Word 2013; you can insert equations in the document. In this video; Lyn Tao demonstrates how to insert predefined equations and create new equations in Word 2013. 55286
Microsoft Word 2013: Inserting Building Blocks Tiffany Gelbart Microsoft Word 2013 building blocks are predesigned reusable items that can be used as an efficient way of attaining consistency within the layout and content of your documents. In this video; Tiffany Gelbart uses the Building Blocks Organizer to insert a Quick Part into a Word document. 52111
Microsoft Word 2013: Inserting Cover Pages Lynn Tao In Microsoft Word 2013; you can either use predefined Cover Page templates or design custom templates. In this video; Lynn Tao demonstrates how to use the predefined Cover Page templates and create custom Cover Page templates in Microsoft Word 2013. 55284
Microsoft Word 2013: Limiting Authors Tiffany Gelbart Microsoft Word 2013 allows you to protect specific sections of your shared documents when the documents are saved to a Microsoft SharePoint site that supports workspaces. In this video; Tiffany Gelbart uses the Block Authors feature in Word 2013 to prevent authors from making changes to a selected piece of text in a shared document. 52107
Microsoft Word 2013: Manage Document Changes Tiffany Gelbart Microsoft Word 2013's track changes feature marks up all changes to documents and allows you to view; comment on; navigate; and accept or reject such changes. In this video; Tiffany Gelbart reviews a document using track changes. 52086
Microsoft Word 2013: Manage Multiple Documents Tiffany Gelbart Microsoft Word 2013's allows you to manage and work in multiple documents simultaneously. You can switch between layouts and documents from the documents' title bars; the Windows taskbar; and the ribbon. In this video; Tiffany Gelbart demonstrates how to enable Read Mode and use multiple-document layouts. 52087
Microsoft Word 2013: Managing Recipient Lists Tiffany Gelbart Microsoft Word 2013 allows you to manage the list of recipients that will be used in your mail merge by providing options to refine the list as well as add and remove recipients from the merge. In this video; Tiffany Gelbart demonstrates how to manage a recipient list when performing a mail merge in Word 2013. 52113
Microsoft Word 2013: Manipulate Forms Tiffany Gelbart Microsoft Word 2013 allows you to easily manipulate the design; layout; components; and content of already-existing forms. In this video; Tiffany Gelbart uses form properties and Word 2013 design elements to create and configure a new combo box content control. 52088
Microsoft Word 2013: Merge Document Changes Tiffany Gelbart Microsoft Word 2013 allows you to merge and save document changes by multiple reviewers in a single document. In this video; Tiffany Gelbart combines two versions of a reviewed document into one document. 52089
Microsoft Word 2013: Modify Control Properties Tiffany Gelbart Microsoft Word 2013 allows you to modify the properties of the content controls in order to change the format of a particular control to better suit your documents appearance. In this video; Tiffany Gelbart demonstrates how to customize a checkbox in a form by modifying the control properties from the DEVELOPER tab in Word 2013. 52117
Microsoft Word 2013: Modify User Information Tiffany Gelbart Microsoft Word 2013 allows you to view and edit the user information contained in the properties of a Word document. You can also add custom fields; which will then reflect on the Properties page. In this video; Tiffany Gelbart demonstrates how to populate information fields and add a custom field. 52090
Microsoft Word 2013: Page Setup Tiffany Gelbart Microsoft Word 2013 provides users with a variety of page layout options; through which you can manage how the content of a document is displayed. In this video; Tiffany Gelbart demonstrates how to change the margin settings in a document; and how to insert a page break. 52104
Microsoft Word 2013: Prepare a Document for Accessibility Tiffany Gelbart Microsoft Word 2013's Accessibility Checker includes features such as Backstage view; a navigable Print Preview; a Zoom bar; and the ability to customize your ribbon with shortcut keys. In this video; Tiffany Gelbart introduces features designed to assist users with disabilities and adds a new shortcut key to the ribbon. 52091
Microsoft Word 2013: Prepare Documents for Review Tiffany Gelbart Before submitting a Microsoft Word 2013 document for review; it's advisable to run a spelling and grammar check; the Accessibility Checker; and the Compatibility Checker. In this video; Tiffany Gelbart demonstrates how these features ensure your document contains only accurate information; suits users with disabilities; and is compatible with earlier versions of Word. 52092
Microsoft Word 2013: Printing Comments Lynn Tao In Microsoft Word 2013; you can add comments to the documents and print the comments. In this video; LynnTao demonstrates how to add comments to the document and how to print the comments by enabling the Print Markup feature. 55296
Microsoft Word 2013: Restrict Document Access Tiffany Gelbart Microsoft Word 2013 allows you to use case-sensitive password encryption to restrict document access. This prevents others opening or modifying your documents. In this video; Tiffany Gelbart demonstrates how to create a password to protect the document on which she is working. 52093
Microsoft Word 2013: Review Tracked Changes Tiffany Gelbart Microsoft Word 2013 enables you to review tracked changes before accepting or rejecting them. You can accept or reject them individually or collectively. In this video; Tiffany Gelbart demonstrates how to accept changes in a document and turn off the Track Changes feature. 52094
Microsoft Word 2013: Saving Selection as Quick Parts Tiffany Gelbart Microsoft Word 2013 Quick Parts allow you to highlight a selection in your document and save it to the Quick Parts Gallery from where you can reuse it in future documents. In this video; Tiffany Gelbart demonstrates how to save an object in a Word document to the Quick Parts Gallery. 52109
Microsoft Word 2013: Set Formatting and Editing Restrictions Tiffany Gelbart Microsoft Word 2013 enables you to set formatting and editing restrictions; denying certain editing rights to selected users. In this video; Tiffany Gelbart sets formatting and editing restrictions on a document. 52095
Microsoft Word 2013: Share a Document Tiffany Gelbart Microsoft Word 2013 allows you to e-mail Word documents for review as attachments; links; or PDF files. In this video; Tiffany Gelbart demonstrates how to send a document as an attachment to a chosen recipient. 52096
Microsoft Word 2013: Supress Information Tiffany Gelbart Microsoft Word 2013's Document Inspector searches your document; its properties; and metadata for hidden or personal information you do not wish to share. In this video; Tiffany Gelbart demonstrates how to use the Document Inspector to remove organizational or personal information and metadata from a document. 52097
Microsoft Word 2013: The Mail Merge Features Tiffany Gelbart Microsoft Word 2013's Step-by-Step Mail Merge Wizard allows you to generate mass mailings in six easy; configurable steps using a single document and a direct data source. In this video; Tiffany Gelbart uses the wizard to generate a mail merge. 52098
Microsoft Word 2013: Word Options Tiffany Gelbart Microsoft Word 2013 offers a number of different options when it comes to working within your environment. In this video; Tiffany Gelbart demonstrates how to customize the Quick Access Toolbar to allow easy access to tools that are used regularly. 52101
Microsoft Word 2013: Working with PDFs Tiffany Gelbart Microsoft Word 2013 enables you to turn your documents into PDFs; allowing you to share them with users not in possession of Office. In this video; Tiffany Gelbart demonstrates how to convert a Word 2013 document into a non-editable PDF; accessible on a free PDF reader. 52099
Microsoft Word 2013: Working with Tables Tiffany Gelbart Microsoft Word 2013 allows you to manage the data and alter the layout of tables within your documents. In this video; Tiffany Gelbart demonstrates how to add rows to a table; apply various sorting options; and repeat the header rows. 52105