-
Working with Master Pages
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.
-
Data Validation
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.
-
Enforcing Referential Integrity
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.
-
Export Data from Access
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.
-
Find Duplicates Query Wizard
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.
-
Find Unmatched Query Wizard
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.
-
Hiding and Freezing Fields
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.
-
Import Data to Access
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.
-
Lookup Fields
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.
-
Multiuser Apps – Locking Splitting
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.
-
Optimize Database – Analyze Performance
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.
-
Optimize Database – Analyze Table
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.
-
Optimize Database - Compact and Repair
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.
-
Optimize Database – Database Documenter
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.
-
Sharing Access Databases
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.
-
Splitting a Database
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.
-
Access and SharePoint
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.
-
Access and SharePoint - Import
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.
-
Access and SharePoint - Moving Data to SharePoint
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.
-
Access Data Email and Outlook – Export
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.
-
Access Data Email and Outlook – Import
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.
-
Access Event Model
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.
-
Action Queries – Append Query
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.
-
Action Queries - Delete
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.
-
Action Queries - Make Table
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.
-
Action Queries - Update
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.
-
Archiving a Table
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.
-
Archiving All Tables
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.
-
Archiving Records
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.
-
Attachments
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.
-
Conditional Formatting
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.
-
Creating a Crosstab Query
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.
-
Creating a Parameter Query
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.
-
Customizing Fields
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.
-
Customizing the Default Format of Datasheets
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.
-
Customizing the List of Recently Opened Databases and Folders
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.
-
Customizing the Ribbon and Quick Access Toolbar
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.
-
SQL Queries
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.
-
Subforms
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.
-
Subreports
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.
-
User Interface Macros
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.
-
VBA in Access
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.
-
Package and Sign Tool
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.
-
Proofing with AutoCorrect and Spelling
Microsoft Access 2013 has features to correct spelling and grammar inaccuracy. In this video; Lynn Tao discusses AutoCorrect; Spell Check and their associated tools.
-
Restricting Changes to the Front-end Database
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.
-
Calculate the Current Date
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.
-
Calculate the Payments on a Loan
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.
-
Change a Cell Entry to Proper Case
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.
-
Change How Zero Values Display
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.
-
Concatenate Text
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.
-
Configure a Workbook for Multiple Users
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.
-
Control Recalculate
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.
-
Convert a Table Back to a Normal Range
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.
-
Copy Word Text to Excel
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.
-
Create a Workbook from a Template
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.
-
Create an Advanced Filter
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.
-
Creating a Web Query
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.
-
Customizing Display Options for Workbooks and Worksheets
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.
-
Customizing the List of Recently Opened Workbooks and Folders
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.
-
Edit Cell Content
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.
-
Add a Calculation Using the Paste Function
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.
-
Add Comments to Cells
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.
-
Add Text to Calculated Values
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.
-
Adjust Row Height and Column Width
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.
-
Allow Editing of Select Cells
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.
-
Calculate Due Dates Based on Work Days
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.
-
Export a SharePoint List to Excel
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.
-
Fast Convenient Chart Format Tools
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.
-
Format a Cell Based on Its Value
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.
-
Format Data as a Table
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.
-
Format Tables Using Quick Styles
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.
-
Identify and Select Chart Formatting Tools
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.
-
Insert and Delete Rows and Columns
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.
-
Keep Labels Visible by Freezing Panes
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.
-
Let Excel Recommend a Pivot Table
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.
-
Look Up Additional Information from a Known Value
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.
-
Mark a Workbook as Final
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.
-
Merge and Center Content Across Columns
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.
-
Modify a Macro Using VBA
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.
-
Modify How Worksheets Print with Page Break Preview
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.
-
Modify Tables Using Style Options
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.
-
Navigate Through Worksheets and Workbooks
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.
-
Organize Worksheets and Workbooks
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.
-
Perform Different Calculations Depending on Cell Values
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.
-
Presenting Online
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.
-
Printing Tips
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.
-
Protect a Workbook
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.
-
Record a Simple Macro
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.
-
Remove Duplicates
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.
-
Remove Metadata and Personal Information
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.
-
Resize a Table
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.
-
Save Data to a SharePoint Library
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.
-
Select Data in Excel
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.
-
Send a Workbook Using Lync
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.
-
Simplify Data with an Outline
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.
-
Sort Worksheet Columns
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.
-
Split Single Text Entries into Multiple Columns
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.
-
Splitting a Worksheet into Windows
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.
-
Summarize Data with Sparklines
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.
-
Summarize Data with Subtotals
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.
-
Understand and Use Excel Views
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.
-
Understand How Table Calculations Differ
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.
-
Use a Timeline to Filter Pivot Tables
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.
-
Use Flash Fill
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.
-
Use Goalseek to Find an Input
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.
-
Use Quick Analysis Tools
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.
-
Use Recommended Charts
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.
-
Use the Namebox to Select Cells
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.
-
Use the Watch Window to Inspect Formulas
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.
-
Validate Data
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.
-
View Calculation Flow
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.
-
Add or Change Your Picture
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.
-
Contacting Multiple Contacts
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.
-
Create an Ad Hoc Meeting with Meet Now
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.
-
Create Groups
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.
-
Keep Status and Location Current
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.
-
Meeting Space Options
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.
-
New Display Options
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.
-
Organize Lync Meetings with Outlook
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.
-
Quick Lync Bar
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.
-
Review and Use Contact Cards
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.
-
Search for Contacts
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.
-
Shared Notes
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.
-
Sort Contacts
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.
-
Start an IM Session
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.
-
Tabbed and Pop Out Conversations
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.
-
Use Screen Share to Share Content
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.
-
Automatically Accept or Decline Meetings
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.
-
Show Second Time Zone
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.
-
Adding the Weather Forecast to Your Calendar
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.
-
Additional Customizations
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.
-
Arranging Calendar Days
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.
-
Attach File Message Task to E-mail
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.
-
Autoarchiving Your E-mail
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.
-
Automatically Request Read Receipts
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.
-
Automatically Spellcheck E-mail
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.
-
Change the Default Mail List Font Size
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.
-
Changing the To-Do Bar Order
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.
-
Connect Hotmail Account
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.
-
Creating Search Folders
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.
-
Customizing How You Open Your To-Do Bar
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.
-
Disable Inline Reply
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.
-
Display Days Left
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.
-
How Not to Save Sent E-mails
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.
-
Importing and Exporting
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.
-
Introduction to OWA
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.
-
Junk E-mail and Phishing Filter
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.
-
Linking Contacts
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.
-
Mailbox Cleanup
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.
-
Notes in Outlook
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.
-
Organizing Folders
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.
-
Outlook Custom Forms
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.
-
Repair Outlook Data Files
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.
-
RSS Feeds
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.
-
Searching Through Outlook
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.
-
Send/Receive Groups
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.
-
Setting Flag Reminders
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.
-
Showing the Ruler
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.
-
Translating an E-mail
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.
-
Turn Off Automatic Acceptance of Meetings
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.
-
Adjusting Images
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.
-
Adjusting the Audio Timing
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.
-
Animation Pane
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.
-
Borders on Images
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.
-
Change Theme for Specific Slides
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.
-
Combining Shapes
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.
-
Comments Pane
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.
-
Creating Charts from Excel Data
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.
-
Creating Handouts in Word
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.
-
Creating Slides from Outlines
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.
-
Creating User Interactive Presentations
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.
-
Cropping and Arranging Images
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.
-
Custom Motion Animations
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.
-
Enabling and Using AutoRecover
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.
-
Exporting Presentations as Videos
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.
-
Exporting Slides as Images
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.
-
Finding and Replacing Text
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.
-
Formatting Text
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.
-
Insert a YouTube Video
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.
-
Inserting and Creating Equations
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.
-
Inserting Screenshots
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.
-
Inserting Slides from Other Presentations
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.
-
Inspecting Presentations
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.
-
Numbered and Bulleted Lists
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.
-
Options
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.
-
Overview of PowerPoint Views
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.
-
Packaging and Burning Your Presentation to a CD
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.
-
Personalize Quick Access Toolbar and Ribbon
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.
-
Placeholders
PowerPoint 2013 Placeholders help you create customized templates in your presentation. In this video; Lynn Tao discusses how to insert and customize Placeholders.
-
Playing Audio in the Background of Presentation
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.
-
Playing with SmartArt
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.
-
Printing Handouts and Notes
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.
-
Protecting Presentations with a Password
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.
-
Remove the Background on Images
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.
-
Resume Reading Feature
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.
-
Save as Read-Only
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.
-
Saving Chart Templates
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.
-
Self Running Presentation
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.
-
Share Presentations Over the Internet
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.
-
The New Presenter View
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.
-
Transitions
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.
-
Using Animation Painter
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.
-
Using Customized or Personal Templates
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.
-
Using Guides and the Grid
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.
-
Using PowerPoint Templates
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.
-
Using Translation Tools
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.
-
Web App Overview
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.
-
Compress Multimedia
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.
-
Creating a Custom Background
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.
-
Creating a Custom Slide Show
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.
-
Creating a Video from a Presentation
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.
-
Adding a Resource Pool to Your Plan
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.
-
Adding a Text Column
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.
-
Adding Graphics to a Gantt Chart
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.
-
Adding Notes to a Project Plan
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.
-
Adding OT Work for Resources
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.
-
Apply Text Formatting to Standard Reports
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.
-
Changing Linked Relationships Across Two Projects
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.
-
Create and Format Standard Report
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.
-
Create Resource Pool
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.
-
Creating a Combination View
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.
-
Creating a Comparison Report Between Two Project Versions
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.
-
Creating a Custom Table
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.
-
Creating a Filter
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.
-
Creating Custom Views
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.
-
Creating Recurring Tasks
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.
-
Creating Visual Report Templates
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.
-
Custom Blank Reports with Graphics
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.
-
Custom Calendars and Non-Working Times
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.
-
Custom WBS Codes
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.
-
Customize Fields
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.
-
Customize Options
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.
-
Customize the Quick Access Toolbar
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.
-
Customizing Resource Calendars
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.
-
Customizing the List of Recently Opened Projects and Folders
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.
-
Customizing the Quick Access Toolbar
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.
-
Delay the Start of an Activity or Project
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.
-
Determine Methods for Resources Overallocation
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.
-
Disabling Default Save to SkyDrive
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.
-
Edit Macros
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.
-
Edit Visual Reports Template
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.
-
Modify Tasks
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.
-
Organizer
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.
-
Outline Codes
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.
-
Personalizing Recently Opened Projects
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.
-
Printing in Project
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.
-
Privacy and Security Settings
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.
-
Rebaselining Only Unstarted Tasks
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.
-
Recording a Macro to Create a Formatted Report
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.
-
Recurring Tasks
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.
-
Setting Baselines
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.
-
Split Screen and Fixed Units for Resources
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.
-
Entering Progress Using a Daily Timesheet
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.
-
Exporting Cost Data with a Map
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.
-
Exporting to Excel
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.
-
Filtering
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.
-
Formatting a Gantt Chart
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.
-
Highlighting with Cell Background Color
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.
-
Inactive Tasks
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.
-
Interim Baselines and Custom Tables for Viewing
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.
-
Leveling Gantt
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.
-
Leveling Resources
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.
-
Linking Across Projects
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.
-
Master Projects
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.
-
Split Screen Views
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.
-
Splitting a Task
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.
-
Task Calendars
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.
-
Task Inspector
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.
-
Team Planner
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.
-
Tracking Gantt for Baseline and Statistics Box
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.
-
Tracking Task Links
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.
-
Updating a Resource Pool
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.
-
Updating Resource Costs
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.
-
Using Cost Rate Tables
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.
-
Using Critical Path Tools
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.
-
Using Highlighting Filters
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.
-
Using Page Setup for Print Settings
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.
-
Using Task Notes
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.
-
Using the Timeline for Reporting
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.
-
Visual Reports Using Excel
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.
-
Work Contours
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.
-
Configuring Publisher: The Info Pane
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.
-
Creating a Cover Page
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.
-
Creating a New Publisher 2013 Document
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.
-
Getting Started with
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.
-
Manipulating and Grouping Objects
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.
-
Printing; Sharing; and Exporting Documents
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.
-
Publisher 2013 Document Layout
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.
-
The Publisher 2013 Interface
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.
-
Working with Building Blocks
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.
-
Working with Pictures
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.
-
Working with Shapes
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.
-
Working with Text Objects
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.
-
Working with the Ruler and Guides
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.
-
About Me
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.
-
Adding Items to Lists
Microsoft SharePoint 2013 allows users to create lists. In this video; David Santana shows you how to add items to a list.
-
Checking Out and In Documents
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.
-
Create a Blog Post
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.
-
Create a List
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.
-
Create Conversations in Newsfeed
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.
-
Create Note on Note Board
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.
-
Creating Tags
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.
-
Document Libraries
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.
-
Enhancements to the User Interface
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.
-
I'm Following List
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.
-
Improvements to the User Interface
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.
-
List Ribbon Interface
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.
-
Managing Alerts
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.
-
Mentioning Members
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.
-
Newsfeed Contact Info
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.
-
Newsfeed Details Page
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.
-
Overview of Newsfeed Tab
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.
-
Overview of Search Capabilities
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.
-
Permissions
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.
-
Play Your Media Asset
Playing your media asset in Microsoft SharePoint 2013 is simple. In this video; David Santana shows you how to play an uploaded video.
-
Profile Settings
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.
-
Quick Edit Mode
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.
-
Quick Launch
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.
-
Setting Alert on Search Results
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.
-
Skydrive Tab
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.
-
Start a New Discussion
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.
-
View Tags and Notes
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.
-
Working with SkyDrive Pro
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.
-
Adding Controls
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.
-
Adding WordArt
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.
-
Apply Document Themes
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.
-
Automate Tasks Using Macros
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.
-
Changing the Orientation of a Specific Page
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.
-
Compare Document Changes
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.
-
Create a Data Source Using Word
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.
-
Create a Document Using a Template
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.
-
Create a Macro
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.
-
Create a Template
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.
-
Create and Modify Text Styles
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.
-
Create Custom Style Sets and Templates
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.
-
Create Forms
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.
-
Inserting Cover Pages
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.
-
Creating Custom Color Themes
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.
-
Creating Custom Font Themes
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.
-
Customize the Word Interface
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.
-
Deleting Building Blocks
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.
-
Deleting Document Draft Versions
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.
-
Desktop Publishing with Word
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.
-
Document Properties
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.
-
Editing Building Blocks Properties
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.
-
Embedding and Linking Charts and Data
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.
-
Enabling AutoRecover
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.
-
Envelopes and Labels
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.
-
Finding Hidden Characters
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.
-
Formatting with Columns
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.
-
Header and Footer
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.
-
Including the Print Date
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.
-
Inserting Building Blocks
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.
-
Limiting Authors
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.
-
Manage Document Changes
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.
-
Manage Multiple Documents
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.
-
Managing Recipient Lists
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.
-
Manipulate Forms
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.
-
Merge Document Changes
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.
-
Modify Control Properties
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.
-
Modify User Information
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.
-
Page Setup
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.
-
Prepare a Document for Accessibility
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.
-
Prepare Documents for Review
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.
-
Printing Comments
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.
-
Restrict Document Access
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.
-
Review Tracked Changes
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.
-
Saving Selection as Quick Parts
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.
-
Set Formatting and Editing Restrictions
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.
-
Share a Document
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.
-
Supress Information
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.
-
The Mail Merge Features
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.
-
Word Options
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.
-
Working with PDFs
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.
-
OneNote Overview
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.
-
Outlook Calendar
Microsoft Office 2013 allows you to view and customize your calendar. In this video; Neal Rowland demonstrates how to maintain and reference your calendar.
-
PowerPoint Templates
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.
-
Send to OneNote
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.
-
Sharing Using Instant Message
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.
-
Tagging in OneNote
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.
-
Docking OneNote
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.
-
InfoPath
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.
-
OneNote Cool Tricks
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.
-
OneNote Meeting Notes
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.
-
Excel 2013 Charts
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.
-
Excel 2013 Quick Analysis
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.
-
Excel 2013 Templates
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.
-
Outlook 2013 Navigation Bar and Views
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.
-
Outlook 2013 Overview
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.
-
Outlook 2013 People
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.
-
PowerPoint 2013 Images and Media
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.
-
PowerPoint 2013 Overview
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.
-
SkyDrive in Word
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.
-
PowerPoint 2013 Formatting and Animations
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.
-
SkyDrive Overview
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.
-
SkyDrive.com
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.
-
User Interface File Tab
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.
-
Word 2013 Design Tab
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.
-
Word 2013 PDFs
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.
-
Word 2013 Pictures
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.
-
Word 2013 Templates
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.
-
Word 2013 Tracking
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.
-
Word 2013 Videos
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.
-
Create a New Notebook
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.
-
Exporting Pages; Sections or Notebooks
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.
-
Formatting and Editing
Formatting and editing in Microsoft OneNote 2013 is easy. In this video; Allen Goldberg demonstrates the formatting and editing capability of OneNote 2013.
-
Office 2013 Integration
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.
-
Outlook 2013 Integration
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.
-
Searching and Tagging Your Information
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.
-
Sharing Your Notebooks
Sharing your notebooks in Microsoft OneNote 2013 is easy. In this video; Allen Goldberg demonstrates how to share a notebook using a SkyDrive account.
-
The Draw Tab
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.
-
The History Tab
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.
-
The Home Tab
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.
-
The Insert Tab
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.
-
The Review Tab
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.
-
The View Tab
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.
-
Adding Audio and Video Content
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.
-
Adding Drawings to Notebooks
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.
-
Adding Pictures
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.
-
Attaching Files and Printouts
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.
-
Changing General and Display Options
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.
-
Checking Spelling
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.
-
Collaborating on Notebooks
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.
-
Conducting Research
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.
-
Converting a OneNote Table to an Excel Worksheet
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.
-
Converting Handwriting to Text
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.
-
Formatting and Sorting Tables
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.
-
Formatting Text and Applying Styles
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.
-
Inserting Excel Workbooks
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.
-
Inserting Excel Workbooks in OneNote
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.
-
Inserting Links
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.
-
Inserting Word and PowerPoint Files in OneNote
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.
-
Introducing the OneNote Interface
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.
-
Managing Audio and Video Content
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.
-
Managing Meetings with Outlook and OneNote
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.
-
Notebook Settings and Properties
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.
-
OneNote 2013 Linked Notes in Word and PowerPoint
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.
-
Outlook Appointments and Tasks in OneNote
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.
-
Performing Calculations
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.
-
Printing a Notebook
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.
-
Saving and Backing up a Notebook
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.
-
Sending OneNote Content to Word
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.
-
Sending Outlook Messages to OneNote
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.
-
Syncing OneNote 2013 and OneNote Mobile
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.
-
The File Tab
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.
-
Tracking Changes
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.
-
Using and Creating Templates
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.
-
Using QuickNotes
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.
-
Using SharePoint to Share Notebooks
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.
-
Using the Interface
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.
-
Using the Web App
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.
-
Version Control Options
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.
-
Clipping and Saving
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.
-
Touchscreen Tips
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.
-
Sharing Files and Pictures
After watching this video; you will be able to recognize the steps required to share files and pictures in an IM conversation or meeting.
-
Sharing Notes
After watching this video; you will be able to identify the steps to share OneNote notes; including using existing notes and creating new notes.
-
Sharing Whiteboards
After watching this video; you will be able to share and use the whiteboard feature.
-
Starting IM Conversations with Multiple Contacts
After watching this video; you will be able to identify the steps to send instant messages to multiple contacts or groups at once.
-
Adding contacts
After watching this video; you will be able to add internal and external contacts.
-
Answering Video Calls
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.
-
Answering; Transferring; and Forwarding Calls
After watching this video; you will be able to identify how to answer a call; transfer a call; and forward calls.
-
Using Instant Messaging
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.
-
Using Instant Messaging Options
After watching this video; you will be able to use IM options; including adding audio and video; sharing files; and toggling between conversations.
-
Using Sharing Options
After watching this video; you will be able to use the present desktop and present programs sharing options and sharing a PowerPoint presentation.
-
Using the Contact Cards
After watching this video; you will be able to identify the steps to access contact cards and available options.
-
Using the Polling Feature
After watching this video; you will be able to use the polling feature including creating a poll.
-
Using Video with an Instant Message Conversation
"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""."
-
Scheduling a Skype Meeting Using Outlook
After watching this video; you will be able to schedule a Skype for Business meeting using Outlook and configure meeting options.
-
Attending a Meeting
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.
-
Changing the Picture
After watching this video; you will be able to configure picture options including hiding; showing; editing; or removing a picture.
-
Configuring an Unscheduled Meeting
After watching this video; you will be able to create and configure options for an unscheduled meeting using the Meet Now option.
-
Configuring Audio Settings
After watching this video; you will be able to complete the steps to configure an audio device and configure audio options.
-
Configuring Contact List Options
After watching this video; you will be able to configure how the contact list displays; order options; and which information is displayed.
-
Configuring Conversation View Options
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.
-
Configuring Global Instant Message Options
After watching this video; you will be able to identify the steps to configure IM options including spelling; copying; tabbed conversations; and font options.
-
Configuring Groups
After watching this video; you will be able to create a group; add contacts; and delete an existing group.
-
Configuring the Video Device
After watching this video; you will be able to recognize the steps to set up a video device and access and configure advanced settings.
-
Configuring your Presence
After watching this video; you will be able to identify the steps to configure presence options.
-
Discovering the File Transfer Preview
After watching this video; you will be able to recognize the File Transfer Preview feature and the available options.
-
Exploring the Location Feature
After watching this video; you will be able to recognize and configure the location feature.
-
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.
-
Making a Video Call and Using Controls
After watching this video; you will be able to identify the steps to start a video call and use video controls.
-
Making Calls
After watching this video; you will be able to identify the steps to make a call and using the call controls.
-
Managing Control Options
After watching this video; you will be able to identify the steps to give control or take away controls from other users while presenting.
-
Managing Download Permissions on Shared Files
After watching this video; you will be able to configure who will have access to downloading files that are shared.
-
Managing Meeting Participants and Recording Options
After watching this video; you will be able to add participants to a meeting; configure participant actions; record a meeting; and manage recordings.
-
Managing Your Profile and Contacts
After watching this video; you will be able to configure your presence and location; add contacts; and create a new group.
-
Scheduling a Meeting in Outlook
After watching this video; you will be able to configure a Skype for Business meeting in Outlook.
-
Sharing Files and Using the Poll Feature
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.
-
Saving an E-mail as a Template
Microsoft Outlook 2013 is a communication tool that helps save time with its predetermined email templates. In this video; Lynn Tao explains how to effectively create and save an email template in Outlook 2013.
-
Customizing the Ribbon
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.
-
Inserting a Table of Contents
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.
-
Adding Hyperlinks
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.
-
Apply Styles
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.
-
Best Practices
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.
-
Customizing the Quick Access Toolbar
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.
-
Creating Tables
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.
-
Customize the Ribbon
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.
-
Joins
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.
-
SkyDrive
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.
-
Templates
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.
-
Working with Tables
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.
-
Creating Charts
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.
-
Working with Tables
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.
-
Lists
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.
-
Enabling and Using AutoRecover
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.
-
Creating Alerts
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.
-
Customizing the Ribbon
In Microsoft Project 2013; you can customize the ribbon. In this video; Lynn Tao demonstrates how to customize the ribbon in Microsoft Project 2013.
-
Overview
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.
-
Grouping
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.
-
Inserting and Creating Equations
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.
-
Working with Tables
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.
-
Security
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.
-
Microsoft Project 2013: Generating Visual Reports in Excel and Visio
After watching this video, you will be able to create visual reports of project data exported from Project 2013 in Excel and Visio.
-
Microsoft Project 2013: Exporting Timelines to E-mail
After watching this video, you will be able to export a timeline to an e-mail using Project 2013.
-
Microsoft Project 2013: Customizing Print Settings
After watching this video, you will be able to customize print settings in Project 2013.
-
Microsoft Project 2013: Sharing a Custom View with Another Project
After watching this video, you will be able to use the Organizer to share a custom view with another project in Project 2013, without adding the view to the Global template.
-
Microsoft Project 2013: Sharing Data with Excel
After watching this video, you will be able to import project data from Excel and export project data to Excel using Project 2013.
-
Microsoft Project 2013: Adding Documents and Links to a Project Plan
After watching this video, you will be able to attach supporting documents and links to a project plan in Project 2013.
-
Microsoft Project 2013: Copying Timelines and Reports to Office Web Apps
After watching this video, you will be able to copy timelines and reports from Project 2013 to other Office Web Apps.
-
Microsoft Project 2013: Highlighting Specific Project Data
After watching this video, you will be able to highlight project data that meets criteria you specify in Project 2013.
-
Microsoft Project 2013: Creating New Custom Tables and Views
After watching this video, you will be able to create new custom tables and views in Project 2013.
-
Microsoft Project 2013: Using the Global Template
After watching this video, you will be able to use the Organizer to add a custom view to the Global template in Project 2013.
-
Microsoft Project 2013: Syncing with a SharePoint Task List
After watching this video, you will be able to use functions in custom fields that contain formulas in Project 2013.
-
Microsoft Project 2013: Using SharePoint to Collect Progress Updates
After watching this video, you will be able to use SharePoint to collect team members' progress updates for a project in Project 2013.
-
Microsoft Project 2013: Customizing Reports and Dashboards
After watching this video, you will be able to customize reports and dashboards in Project 2013.
-
Microsoft Project 2013: Working with Cumulative Fields
After watching this video, you will be able to work with cumulative fields in Project 2013.
-
Microsoft Project 2013: Copying a Report for Pasting into Other Documents
After watching this video, you will be able to copy a report for pasting into other documents in Project 2013.
-
Microsoft Project 2013: Sharing Project Plans Using SharePoint
After watching this video, you will be able to create and use a custom field containing a formula in Project 2013.
-
Microsoft Project 2013: Saving a Project in PDF or XPS Format
After watching this video, you will be able to save a project in the PDF or XPS file format in Project 2013.
-
Microsoft Project 2013: Setting File Password Protection
After watching this video, you will be able to assign a password to protect a project file in Project 2013.
-
Microsoft Project 2013: Using Built-in Reports and Dashboards
After watching this video, you will be able to report progress status in Project 2013.
-
Microsoft Project 2013: Reporting Data for a Given Date Range
After watching this video, you will be able to report on project data for a date range you specify in Project 2013.
-
Microsoft Project 2013: Task Path Highlighting
After watching this video, you will be able to use the Task Path feature in Project 2013.
-
Microsoft Project 2013: Tracking Date, Work, and Cost Variances
After watching this video, you will be able to track date, work, and cost variances by comparing actual progress against baselines in Project 2013.
-
Microsoft Project 2013: Identifying Task Slippage
After watching this video, you will be able to identify potential task slippage using the Tracking Gantt view in Project 2013.
-
Microsoft Project 2013: Views for Tracking Variances
After watching this video, you will be able to use different views to track variances in Project 2013.
-
Microsoft Project 2013: Using the Task Inspector
After watching this video, you will be able to use the Task Inspector to identify and resolve scheduling problems in Project 2013.
-
Microsoft Project 2013: Updating Actual Progress
After watching this video, you will be able to update actual progress information in Project 2013.
-
Microsoft Project 2013: Updating Project Dates
After watching this video, you will be able to update the status date, current date, actual start and actual finish in Project 2013.
-
Microsoft Project 2013: Using Work and Usage Views to Monitor Progress
After watching this video, you will be able to use actual work and usage views to monitor actual progress in Project 2013.
-
Microsoft Project 2013: Rescheduling or Cancelling Tasks
After watching this video, you will be able to reschedule uncompleted work and cancel unnecessary tasks in Project 2013.
-
Microsoft Project 2013: Working with Multiple Baselines
After watching this video, you will be able to create and view multiple baselines for a project in Project 2013.
-
Microsoft Project 2013: Customizing Existing Project Views
After watching this video, you will be able to customize existing views so they show specific types of information in Project 2013.
-
Microsoft Project 2013: Grouping Project Data
After watching this video, you will be able to use predefined and custom groups to group related project data in Project 2013.
-
Microsoft Project 2013: Filtering Tasks and Resources
After watching this video, you will be able to filter tasks and resources using predefined and custom filters, as well as AutoFilters, in Project 2013.
-
Microsoft Project 2013: Sorting Project Data in Views
After watching this video, you will be able to sort project data within existing views in Project 2013.
-
Microsoft Project 2013: Viewing the Critical Path
After watching this video, you will be able to view the critical path for a single project in Project 2013.
-
Microsoft Project 2013: Viewing the Critical Path for a Master Project
After watching this video, you will be able to view the critical path for a master project in Project 2013.
-
Microsoft Project 2013: Viewing Total Slack for a Project
After watching this video, you will be able to view total slack for a project in Project 2013.
-
Microsoft Project 2013: Tracking and Managing Project Progress
After watching this video, you will be able to track and manage the progress of a project in Project 2013.
-
Microsoft Project 2013: Resolving Resource Overallocations
After watching this video, you will be able to identify and resolve resource over-allocations in Project 2013.
-
Microsoft Project 2013: The Effect of the Critical Path
After watching this video, you will be able to recognize how the critical path affects a project's finish date in Project 2013.
-
Microsoft Project 2013: Saving Project Files to OneDrive
After watching this video, you will be able to set general project options in Project 2013.
-
Microsoft Project 2013: Using Templates from Office.com
After watching this video, you will be able to set default task types in Project 2013.
-
Microsoft Project 2013: Using VBA to Automate Routine Operations
After watching this video, you will be able to implement manual or automatic scheduling and recognize the implications of each scheduling mode in Project 2013.
-
Microsoft Project 2013: Communicate and Share Project Data
After watching this video, you will be able to customize a view and export and share project information in Project 2013.
-
Microsoft Project 2013: Adding Apps to Project 2013
After watching this video, you will be able to add graphical indicators to custom fields in Project 2013.
-
Microsoft Project 2013: Leveling Resources
After watching this video, you will be able to describe resource leveling, its benefits, and its limitations in Project 2013.
-
Microsoft Project 2013: The Team Planner View
After watching this video, you will be able to access and navigate the Team Planner view in Project 2013.
-
Microsoft Project 2013: Using Team Planner to Resolve Overallocations
After watching this video, you will be able to use the Team Planner view to manually level resources in Project 2013.
-
Microsoft Project 2013: Modifying Resource Assignments
After watching this video, you will be able to edit resource assignments in Project 2013.
-
Microsoft Project 2013: Monitoring Resource Use
After watching this video, you will be able to use task and resource views to monitor resource use in Project 2013.
-
Microsoft Project 2013: Monitoring Resource Availability Across Projects
After watching this video, you will be able to monitor resource use and availability across multiple projects in Project 2013.
-
Microsoft Project 2013: Changing Resource Assignments
After watching this video, you will be able to change resource assignment information and replace resources in Project 2013.
-
Microsoft Project 2013: Using Task Forms to Assign Resources
After watching this video, you will be able to use task forms to create and modify resource assignments in Project 2013.
-
Microsoft Project 2013: Assigning Multiple Resources to a Single Task
After watching this video, you will be able to assign multiple resources per task in Project 2013.
-
Microsoft Project 2013: Assigning Part-Time Resources
After watching this video, you will be able to assign part-time resources in Project 2013.
-
Microsoft Project 2013: Setting Project Baselines
After watching this video, you will be able to create baselines for a project in Project 2013.
-
Microsoft Project 2013: Updating a Project Baseline
After watching this video, you will be able to update an existing project baseline in Project 2013.
-
Microsoft Project 2013: Setting Fixed Costs
After watching this video, you will be able to assign fixed costs to tasks in Project 2013.
-
Microsoft Project 2013: Using Resource Rate Tables
After watching this video, you will be able to use resource rate tables in Project 2013.
-
Microsoft Project 2013: Configuring Accrual Options
After watching this video, you will be able to add the Accrue At field to a resource view and select appropriate accrual options in Project 2013.
-
Microsoft Project 2013: Manage Resources
After watching this video, you will be able to work with resources in Project 2013.
-
Microsoft Project 2013: Using Team Planner to Assign or Schedule Tasks
After watching this video, you will be able to use the Team Planner view to assign and schedule tasks in Project 2013.
-
Microsoft Project 2013: Using Team Planner to Substitute Resources
After watching this video, you will be able to substitute resources using the Team Planner view in Project 2013.
-
Microsoft Project 2013: Setting Resource Rates
After watching this video, you will be able to assign rate-based costs for resources in Project 2013.
-
Microsoft Project 2013: Setting Per Use Costs for Resources
After watching this video, you will be able to assign costs per use for material and work resources in Project 2013.
-
Microsoft Project 2013: User-Controlled Summary Tasks
After watching this video, you will be able to display and use user-controlled summary tasks in Project 2013.
-
Microsoft Project 2013: Creating a Shared Resource Pool
After watching this video, you will be able to create a shared resource pool in Project 2013.
-
Microsoft Project 2013: Connecting to a Resource Pool
After watching this video, you will be able to connect to a resource pool in Project 2013.
-
Microsoft Project 2013: Creating Project Links and Resolving Conflicts
After watching this video, you will be able to create links between projects and resolve conflicts between linked projects in Project 2013.
-
Microsoft Project 2013: Effort-Driven versus Fixed Duration Tasks
After watching this video, you will be able to distinguish between effort-driven and fixed duration tasks in Project 2013.
-
Microsoft Project 2013: Choosing Task Types
After watching this video, you will be able to set appropriate task types in Project 2013.
-
Microsoft Project 2013: Manually Scheduling Tasks
After watching this video, you will be able to switch from automatic to manual task scheduling and manually enter task scheduling details in Project 2013.
-
Microsoft Project 2013: Using Warnings and Suggestions
After watching this video, you will be able to show or hide warnings and suggestions for manually scheduled tasks in Project 2013.
-
Microsoft Project 2013: Setting Dependencies and Links
After watching this video, you will be able to apply task dependencies and link or unlink tasks in Project 2013.
-
Microsoft Project 2013: Setting up Resource Costs
After watching this video, you will be able to specify the costs and availability of resources in Project 2013.
-
Microsoft Project 2013: Grouping Resources
After watching this video, you will be able to create resource groups in Project 2013.
-
Microsoft Project 2013: Working with Cost Resources
After watching this video, you will be able to create cost resources and recognize their uses in Project 2013.
-
Microsoft Project 2013: Filtering and Highlighting Resources
After watching this video, you will be able to filter and highlight resources in Project 2013.
-
Microsoft Project 2013: Resource Types
After watching this video, you will be able to describe the project resource types used in Project 2013.
-
Microsoft Project 2013: Entering and Editing Resource Information
After watching this video, you will be able to enter and edit appropriate resource information in a project plan in Project 2013.
-
Microsoft Project 2013: Using Resource Sheet View
After watching this video, you will be able to use the Resource Sheet view to add resources to a project in Project 2013.
-
Microsoft Project 2013: Resource Rate Table
After watching this video, you will be able to create a resource rate table in Project 2013.
-
Microsoft Project 2013: Summarizing Data in Master Projects
After watching this video, you will be able to summarize the data in a master project in Project 2013.
-
Microsoft Project 2013: Modify Tasks and Resources
After watching this video, you will be able to modify tasks and resources in Project 2013.
-
Microsoft Project 2013: Using Master Projects and Sub-Projects
After watching this video, you will be able to work with master projects and sub-projects in Project 2013.
-
Microsoft Project 2013: Creating Milestones
After watching this video, you will be able to add project milestones to a project plan in Project 2013.
-
Microsoft Project 2013: Working with Summary Tasks and Subtasks
After watching this video, you will be able to create and modify summary tasks and subtasks, and view an outline of these tasks in Project 2013.
-
Microsoft Project 2013: Adding and Reordering Project Tasks
After watching this video, you will be able to add single and recurring tasks to a project plan and reorder tasks in Project 2013.
-
Microsoft Project 2013: Displaying the Project Summary Task
After watching this video, you will be able to display a project summary task in Project 2013.
-
Microsoft Project 2013: Creating Work Breakdown Structure Codes
After watching this video, you will be able to create work breakdown structure (WBS) codes in Project 2013.
-
Microsoft Project 2013: Overlapping Tasks
After watching this video, you will be able to overlap tasks in Project 2013.
-
Microsoft Project 2013: Inactivating Tasks
After watching this video, you will be able to mark tasks as inactive in Project 2013.
-
Microsoft Project 2013: Manually Scheduling Tasks
After watching this video, you will be able to create manually scheduled tasks in Project 2013.
-
Microsoft Project 2013: Setting Project Properties
After watching this video, you will be able to set project properties in Project 2013.
-
Microsoft Project 2013: Identifying the Project Calendar
After watching this video, you will be able to identify the calendar for a project as part of the project's information in Project 2013.
-
Microsoft Project 2013: Defining the Project Start Date
After watching this video, you will be able to set the start date for a project and recognize what this affects in Project 2013.
-
Microsoft Project 2013: Setting Date Constraints and Deadlines
After watching this video, you will be able to set date constraints and project deadlines in Project 2013.
-
Microsoft Project 2013: Constraint Types
After watching this video, you will be able to identify constraint types in Project 2013.
-
Microsoft Project 2013: Creating a Template From an Excel Workbook
After watching this video, you will be able to create a template from an Excel 2013 workbook in Project 2013.
-
Microsoft Project 2013: Creating a Template From a SharePoint Task List
After watching this video, you will be able to create a template from a SharePoint task list in Project 2013.
-
Microsoft Project 2013: Creating and Working with Task Calendars
After watching this video, you will be able to create and work with task calendars in Project 2013.
-
Microsoft Project 2013: Creating and Working with Resource Calendars
After watching this video, you will be able to create and work with resource calendars in Project 2013.
-
Microsoft Project 2013: Modifying a Project Calendar
After watching this video, you will be able to modify the working times in a project calendar in Project 2013.
-
Microsoft Project 2013: Setting up a Project Calendar
After watching this video, you will be able to choose a base calendar and set it as the project calendar in Project 2013.
-
Microsoft Project 2013: Adding Tasks to a Project Plan
After watching this video, you will be able to add tasks to a project plan in Project 2013.
-
Microsoft Project 2013: Switching Between Projects
After watching this video, you will be able to switch between projects and pin or unpin objects in Project 2013.
-
Microsoft Project 2013: Opening, Saving, and Closing Projects
After watching this video, you will be able to open, save, and close projects in Project 2013.
-
Microsoft Project 2013: Creating a Project From an Existing Project
After watching this video, you will be able to create a project using an existing project in Project 2013.
-
Microsoft Project 2013: Creating a Template From a Project
After watching this video, you will be able to create a template from an existing project in Project 2013.
-
Microsoft Project 2013: Setting Default Task Types
After watching this video, you will be able to set default task types in Project 2013.
-
Microsoft Project 2013: Setting General Project Options
After watching this video, you will be able to set general project options in Project 2013.
-
Microsoft Project 2013: Adding Graphical Indicators to Fields
After watching this video, you will be able to add graphical indicators to custom fields in Project 2013.
-
Microsoft Project 2013: Create and Customize a Project
After watching this video, you will be able to create and edit a new project in Project 2013.
-
Microsoft Project 2013: Customizing the Ribbon and Quick Access Toolbar
After watching this video, you will be able to customize the ribbon and the Quick Access Toolbar in Project 2013.
-
Microsoft Project 2013: Setting Calendar Options
After watching this video, you will be able to set default calendar options in Project 2013.
-
Microsoft Project 2013: Using Manual or Automatic Scheduling
After watching this video, you will be able to implement manual or automatic scheduling and recognize the implications of each scheduling mode in Project 2013.
-
Microsoft Project 2013: Creating Custom Fields with Lookup Tables
After watching this video, you will be able to create a custom field with a lookup table in Project 2013.
-
Microsoft Project 2013: Using Functions in Custom Fields
After watching this video, you will be able to use functions in custom fields that contain formulas in Project 2013.
-
Microsoft Project 2013: Creating Custom Fields with Formulas
After watching this video, you will be able to create and use a custom field containing a formula in Project 2013.
-
Microsoft Project 2013: Creating Custom Task and Resource Fields
After watching this video, you will be able to create custom task and resource fields in Project 2013.
-
Microsoft Project 2013: Creating a Blank Project
After watching this video, you will be able to create and save a new project based on the default template in Project 2013.
-
Microsoft Project 2013: The Ribbon, Toolbars, and Backstage View
After watching this video, you will be able to use the Project 2013 ribbon, toolbars, and Backstage view.
-
Microsoft Project 2013: The Start Screen and Project Workspace
After watching this video, you will be able to recognize elements of the Project 2013 interface.
-
Microsoft Project 2013: Introduction to Project 2013 and Certification
After watching this video, you will be able to distinguish between the different editions of Project 2013.
