IT and Desktop Videos

Download a course collection

Microsoft Office 2010

Expand all | Collapse all

Access 2010 (29)
Title Speaker Summary ID
Microsoft Access 2010: Create And Modify A Select Query Steve English

You can use queries in Microsoft Access 2010 to return related fields from different tables. In this video; Steve English uses the Query Wizard to create and modify a SELECT query to show related human resources fields from three tables.

47869
Microsoft Access 2010: Create Validation Rules Steve English

Validation Rules in Microsoft Access 2010 allows you to set specific formats or ranges for your data fields and guide users when entering data. In this video; Steve English shows you how to create rules to restrict and permit the data entered.

48320
Microsoft Access 2010: Creating Pivot Tables Steve English

A Pivot Table in Microsoft Access 2010 can be used to calculate and display multiple dimensions of query data in an interactive chart. In this video; Steve English creates a Pivot Table and performs operations on it to show a graph of products and calculated sales figures over time; with the results filtered by product category.

47863
Microsoft Access 2010: Customizing Lookup Fields Steve English

In Microsoft Access 2010; you can use lookup fields in a table to allow users to select from any of several values. In this video; Steve English creates a lookup field that allows you to select a computer manufacturer from a list.

47864
Microsoft Access 2010: Filter Records Steve English

The Filter function in Microsoft Access 2010 makes it easy to find specific values; such as products in a database within a cost range. In this video; Steve English shows you how to filter and display only those records that meet your criteria.

48323
Microsoft Access 2010: Find And Replace Data Steve English

Find and Replace is a useful function in Microsoft Access 2010 for searching and replacing data. In this video; Steve English shows you how to restrict your search and keep your data safe from unwanted changes when doing a Replace All.

48325
Microsoft Access 2010: Importing Data From Office Steve English

You can easily import data into Microsoft Access 2010 from a number of different data sources; such as Office documents. In this video; Steve English demonstrates how to import table data from a Microsoft Excel spreadsheet.

47867
Microsoft Access 2010: Link To Data In Another Database Steve English

You can link an Access 2010 database to another Access database so that they share information in tables. In this video; Steve English will demonstrate how to link two Access 2010 databases.

48317
Microsoft Access 2010: Optimize A Database With Table Analyzer Steve English

You can use the Access 2010 Table Analyzer to examine your database for inefficiencies and it will recommend how to restructure the database so that it runs as fast as possible. In this video; Steve English will demonstrate how to use the Access 2010 Table Analyzer to make your databases run more efficiently.

48311
Microsoft Access 2010: Refine A Query Using Groupings Steve English

In Microsoft Access 2010 you can arrange data in a report into groups to make it more meaningful and to provide summary information. In this video; Steve English uses the Grouping feature to group and sort products in a report into their categories; and to provide a calculated total field for each group.

47868
Microsoft Access 2010: Secure A Database Steve English

You can secure an Access 2010 database so that only the people you want to have access to the data have access. In this video; Steve English will demonstrate how to secure an Access 2010 database.

48318
Microsoft Access 2010: Secure An Access Database Steve English

By default; when you open a database in Microsoft Access 2010; you get a security warning to prevent VBA macros from being activated. To avoid this; you can create trusted locations. In this video; Steve English configures a folder on his hard disk as a trusted location to prevent Windows from blocking active content in files that are stored there.

47865
Microsoft Access 2010: Sort Records Steve English

The Sort function in Microsoft Access 2010 allows you to arrange and rearrange table and query records anyway you like. In this video; Steve English demonstrates how to sort a table by single and multiple fields.

48322
Microsoft Access 2010: Use A Predefined Input Mask For A Table Field Steve English

You can create an input mask for table fields in Access 2010 so that users are faced to enter data in a specific format. In this video; Steve English will demonstrate how to create an input mask for table fields in Access 2010.

48314
Microsoft Access 2010: Use Object Prefixes Steve English

In Microsoft Access 2010; following a good naming convention will be  useful for those who inherit the task of maintaining your database and for you when you resume work on it after a while. In this video; Steve English explains how using appropriate prefixes makes the database object type obvious.

48321
Microsoft Access 2010: Adding Charts To Reports Steve English

In Microsoft Access 2010; you can include charts in reports to display table data in a visual format; such as on a graph. In this video; Steve English adds a pie chart to a report to display the proportion and total sales for each product category in a query.

47862
Microsoft Access 2010: Apply Conditional Formatting To A Report Steve English

Conditional Formatting in Microsoft Access 2010 changes the way report elements look when they meet certain criteria or conditions. In this video; Steve English shows you how to instantly draw your reader’s attention to the text you want noticed by configuring and doing conditional formatting on your report.

48324
Microsoft Access 2010: Compact And Repair A Database Steve English

You can use the Compact and Repair feature in Microsoft Access 2010 to reduce the file size of a database. In this video; Steve English uses the Compact and Repair feature to compress a database so that it has a smaller file size.

47871
Microsoft Access 2010: Create A Crosstab Query Steve English

In Access 2010 you can create a Crosstab query that looks and behaves like a spreadsheet. In this video; Steve English will demonstrate how to get data into the spreadsheet format so you can manipulate the data and perform calculations.

48312
Microsoft Access 2010: Create A Data Macro Steve English

You can create data macros in Access 2010 that are triggered by specific events in the database. In this video; Steve English will demonstrate how to create data macros in Access 2010.

48315
Microsoft Access 2010: Create A Find Duplicates Query Steve English

In Microsoft Access 2010; you can use queries to find particular records or types of records in a database. In this video; Steve English creates a Find Duplicates query that counts records that appear more than once in a Sales table to find out how many items have been sold for each product.

47861
Microsoft Access 2010: Create A Find Unmatched Query Steve English

You can use a Find Unmatched query in Microsoft Access 2010 to find records in one table that do not appear in another table. In this video; Steve English uses the Query Wizard to create a Find Unmatched query that finds records in a product table that do not appear in a sales table.

47870
Microsoft Access 2010: Create A Primary Key Steve English

Access 2010 will automatically create a key in a primary table; but you can create your own primary key instead. In this video; Steve English will demonstrate how to create a primary key in Access 2010.

48313
Microsoft Access 2010: Create A Subform Steve English

In Access 2010 subforms can be nested within another form. In this video; Steve English will demonstrate how to create subforms in Access.

48310
Microsoft Access 2010: Create A Subreport Steve English

The Subreport tool in Microsoft Access 2010 allows you to combine information from several different reports into one. In this video; Steve English shows you how to create a contextual subreport using the Subreport Wizard.

48326
Microsoft Access 2010: Create A Table In Datasheet View Steve English

The Datasheet View in Microsoft Access 2010 makes creating a table quicker and easier. In this video; Steve English explains how to do it all—add fields; select data type; and set field properties—without ever switching to the Design View.

48327
Microsoft Access 2010: Create A Table Index Steve English

Microsoft Access 2010 allows you to create a table index to speed up your sorts and searches; such as an index on the phone field in an employee list. In this video; Steve English shows you how to create an index and discusses what data types and index properties to select.

48319
Microsoft Access 2010: Create A Ui Macro Steve English

In Access 2010 you can create a user interface macro that responds to an action taken by a user; such as clicking a button. In this video; Steve English will demonstrate how to create a user interface macro in Access 2010.

48316
Microsoft Access 2010: Create And Edit Joins Steve English

You can use joins in Microsoft Access 2010 to define the relationship between fields in different tables. In this video; Steve English creates and modifies a join between fields in two tables; and explores the effect of different join types on a query.

47866
Excel 2010 (76)
Title Speaker Summary ID
Microsoft Excel 2010: Using Data Tables For What If Analysis Adam Wilcox

In Excel 2010; you can use data tables to show output for a function based on different input values. In this video; Adam Wilcox will demonstrate how to use the What-if Analysis for a data table to calculate values for a single variable — interest rate; and for two variables — interest rate and term.

48030
Microsoft Excel 2010: Using Lookup Functions Adam Wilcox

You can use lookup functions in Microsoft Excel 2010 to look up a value in a table based on another value. In this video; Adam Wilcox demonstrates how to use the VLOOKUP function to look up the region to which each sales rep is assigned and add it to the relevant column in the table.

47828
Microsoft Excel 2010: Using Match And Index Adam Wilcox

Microsoft Excel 2010 provides the MATCH and INDEX functions to find values in an array based on the position of those values. In this video; Adam Wilcox demonstrates two methods of returning the product ID in a table using the year and model number.

47829
Microsoft Excel 2010: Using Pivot Charts Adam Wilcox

In Excel 2010; you can use pivot charts to illustrate large amounts of data in digestible chunks. In this video; Adam Wilcox demonstrates how to create pivot charts from pivot table data.

48033
Microsoft Excel 2010: Using Simple Finance Functions Adam Wilcox

In Excel 2010; there are many financial functions you can use in your worksheets. In this video; Adam Wilcox will demonstrate how to use three of the simple financial functions to calculate future value; present value; and payments.

48028
Microsoft Excel 2010: Using Structured References With Tables Adam Wilcox

Tables are a powerful feature of Excel 2010 and structured references are one of the best things about them. In this video; Adam Wilcox will demonstrate the syntax for referring to table data by structured reference name in formulas.

48037
Microsoft Excel 2010: Using Workspaces For Multiple Workbooks Adam Wilcox

There are several ways of arranging multiple open workbooks in Microsoft Excel 2010. You can also save the configuration as a workspace. In this video; Adam Wilcox demonstrates how to manage your workbooks and workspaces.

48012
Microsoft Excel 2010: Variable-sized Range Names Adam Wilcox

Microsoft Excel 2010 enables you to create names for ranges that could vary in size. You can use the OFFSET function to specify the range based on a starting cell and the number of rows and columns you want to include. In this video; Adam Wilcox uses the OFFSET function to create a variable sized range name for a PivotTable.

47990
Microsoft Excel 2010: Workbook Properties Adam Wilcox

Each Microsoft Excel 2010 workbook has a set of properties that are associated with it as a file. These properties include the title; the author; and keywords. In this video; Adam Wilcox demonstrates how to access and change a workbook’s properties.

48018
Microsoft Excel 2010: Working With Dates Adam Wilcox

Microsoft Excel 2010 stores dates in a sequential way to enable you to perform calculations; such as the amount of time between two dates. In this video; Adam Wilcox demonstrates how to calculate the number of years that an employee has worked at a company.

47827
Microsoft Excel 2010: Working With Panes Adam Wilcox

Using panes and extra windows in Microsoft Excel 2010 allows you to view different parts of a workbook at the same time. In this video; Adam Wilcox demonstrates how to use panes and windows to display more data in a workbook at the same time.

47998
Microsoft Excel 2010: Record And Run A Macro Adam Wilcox

A macro in Microsoft Excel 2010 is a set of instructions you can record and then play back to repeat the same actions on another worksheet or workbook. In this video; Adam Wilcox demonstrates how to record and run a macro.

47988
Microsoft Excel 2010: Reference Types Adam Wilcox

In Microsoft Excel 2010; you can copy formulas containing relative; absolute; or mixed references from one cell to another in your worksheet. Using the correct type of reference ensures the formula works as expected in the cells you copy it to. In this video; Adam Wilcox demonstrates how to apply formulas containing different types of references to a Sales table.

47989
Microsoft Excel 2010: Replacing Data And Checking Spelling Adam Wilcox

In Excel 2010; you can perform some of the same proofing tasks as you would in a word processor including finding and replacing data; spell checking; and using a thesaurus. In this video; Adam Wilcox demonstrates how to find and replace data; check your spelling; find synonyms; and search the Internet for information on a selected item.

48027
Microsoft Excel 2010: Row And Column Formatting Adam Wilcox

Microsoft Excel 2010 has several options available for formatting rows and columns to improve a table’s appearance and to make it easier to view the content of a large worksheet. In this video; Adam Wilcox demonstrates how he formats a large worksheet by hiding columns; as well as splitting the window and freezing panes.

47832
Microsoft Excel 2010: Save Data Into Different Formats Adam Wilcox

Microsoft Excel 2010 allows you to save your workbook in a number of formats if you want to display or import it to another program. Some common formats are web pages and CSV files. In this video; Adam Wilcox demonstrates how to save an Excel workbook as a web page and a CSV file.

47978
Microsoft Excel 2010: Send Files Through E-mail Adam Wilcox

You can send a workbook directly through Excel 2010 as an email attachment or as the body of an email message using your default mail application. In this video; Adam Wilcox will demonstrate how to email a worksheet or a workbook directly through Excel.

48036
Microsoft Excel 2010: Solver Adam Wilcox

Solver is a Microsoft Excel 2010 add-in that lets you set a particular goal for a formula and then work backwards to find the input values that will give you that goal based on rules that you set. In this video; Adam Wilcox demonstrates how to install and use the Solver add-in.

48017
Microsoft Excel 2010: Sorting Information Adam Wilcox

Microsoft Excel 2010 provides various ways you can sort information; such as alphabetically or numerically. You can also create custom sorts or randomize the data. In this video; Adam Wilcox demonstrates the different sort methods in a list of sales employees in various departments as well as their earnings.

47831
Microsoft Excel 2010: Sparklines Adam Wilcox

You can use sparklines to visually represent data in Microsoft Excel 2010. A sparkline is a small in-cell chart that shows the data. In this video; Adam Wilcox demonstrates how to add and format sparklines in a workbook.

48021
Microsoft Excel 2010: Styles And Themes Adam Wilcox

In Excel 2010; you can quickly and easily apply consistent formatting to cells or ranges in your worksheets using themes and styles. In this video; Adam Wilcox will demonstrate how to create; apply; and modify styles as well as to change the theme including the color palette; fonts; and effects.

48024
Microsoft Excel 2010: Tables And Filtering Adam Wilcox

You can use Microsoft Excel 2010 to easily filter data in various ways in a table created from a list of data. In this video; Adam Wilcox demonstrates how he creates a table from a list of data and then filters the content.

47822
Microsoft Excel 2010: Templates Adam Wilcox

Templates are premade forms in Microsoft Excel 2010 that can provide a lot of the labels and formulas you might need without having to set them up. You can create your own or use built-in templates in Excel. In this video; Adam Wilcox demonstrates how to open; save; and modify templates.

47977
Microsoft Excel 2010: Tracing Precedents Adam Wilcox

Microsoft Excel 2010 includes auditing tools for tracing the relationships between formulas in the cells of your workbook. You can check which cells feed formulas and which cells depend on the results of formulas. In this video; Adam Wilcox uses the Trace Precedents and Trace Dependents features to trace relationships between cells in a workbook.

48006
Microsoft Excel 2010: Tracking Changes And Merging Workbooks Adam Wilcox

When you share a workbook in Microsoft Excel 2010; you can track changes you and others have made to the workbook. You can also merge several versions of a shared workbook into one workbook. In this video; Adam Wilcox demonstrates how to use the Track Changes feature and merge different versions of a shared workbook.

48020
Microsoft Excel 2010: Trend Lines Adam Wilcox

Trendlines in Microsoft Excel 2010 are a way to look at the data in your charts to see where it’s heading. There are different types of trendlines you can use and you can format them in a range of ways. In this video; Adam Wilcox demonstrates how to add a trendline to a chart and modify it.

48011
Microsoft Excel 2010: Use Comments Adam Wilcox

In Microsoft Excel 2010; you can add comments to cells or ranges to mark-up a worksheet if you want to convey extra information about the data. In this video; Adam Wilcox uses the Comments feature to add; format; and edit comments.

48007
Microsoft Excel 2010: Use Names In Formulas Adam Wilcox

In Microsoft Excel 2010; you can name ranges and particular values in cells to make formulas and functions more understandable and easier to manage. In this video; Adam Wilcox demonstrates how to use named cells and ranges in formulas in a worksheet.

47994
Microsoft Excel 2010: Useful Statistical Functions Adam Wilcox

In Excel 2010; you can perform some simple statistical functions based on your data and one or more conditions that you want to test. In this video; Adam Wilcox will demonstrate how to perform several useful statistical functions on spreadsheet data.

48023
Microsoft Excel 2010: Using Copy And Paste Adam Wilcox

The Paste function in Microsoft Excel 2010 allows you to paste content according to your needs. For example; you might want to paste a piece of text without its formatting; or a number without its formula. In this video; Adam Wilcox demonstrates how to paste content in various ways.

47830
Microsoft Excel 2010: Recently Used File List Tips Adam Wilcox

The Recently Used file list in Excel 2010 is a way you can access the worksheets you use most often. In this video; Adam Wilcox will demonstrate how the Recently Used file list works and how to control the way it behaves.

48035
Microsoft Excel 2010: Fill Series Adam Wilcox

In Microsoft Excel 2010; you can use the fill handle to easily enter a series of data; such as sequential numbers or dates; down a column or across a row. In this video; Adam Wilcox demonstrates how to create series of numbers; text; and dates in a worksheet.

48008
Microsoft Excel 2010: Formula Concepts Adam Wilcox

You can perform calculations in Microsoft Excel 2010 using formulas. Formulas always start with an equal sign and then use combinations of operators; references; and constants to get a result. In this video; Adam Wilcox demonstrates the components of basic formulas as well as the order in which Excel evaluates the operations in a formula.

48009
Microsoft Excel 2010: Goal Seek Adam Wilcox

In Microsoft Excel 2010; you can perform What-If analysis using tools such as Goal Seek. Goal Seek lets you set a target value to determine what input values will help you reach that target. For more complex analysis; you can use Solver; which is an Excel add-in. In this video; Adam Wilcox demonstrates how to use Goal Seek and Solver.

47985
Microsoft Excel 2010: Graphics And Smart Art Adam Wilcox

Microsoft Excel 2010 has several tools for adding simple and effective graphics; such as pictures; shapes; and SmartArt; to a workbook. In this video; Adam Wilcox demonstrates how to add and format graphics in Excel.

48015
Microsoft Excel 2010: Grouping And Subtotals Adam Wilcox

In Excel 2010; you can organize large amounts of data in a worksheet into groups and then subtotal the groups for a higher-level view of the data. In this video; Adam Wilcox demonstrates how to organize a large worksheet containing sales data into groups and create subtotals for these groups.

47995
Microsoft Excel 2010: Handling Errors Adam Wilcox

Microsoft Excel 2010 makes it easy to find and fix errors in your workbooks using the Data Validation; Error Checking; Trace Error; and Evaluate Formula features. In addition; you can use functions to test for errors. In this video; Adam Wilcox demonstrates how to find; resolve; and test for errors in a workbook.

48004
Microsoft Excel 2010: Headers And Footers Adam Wilcox

Microsoft Excel 2010 lets you add headers and footers to a worksheet that is being printed. You can add the title or page number to the header or footer on each page. In this video; Adam Wilcox demonstrates how to add headers and footers to a worksheet.

48010
Microsoft Excel 2010: Import Data From The Web Adam Wilcox

The Web Query feature in Microsoft Excel 2010 lets you create and maintain a live connection between your workbook and data on the Web. In this video; Adam Wilcox demonstrates how to add a live currency conversion table to a workbook.

48019
Microsoft Excel 2010: Import Delimited Text Files Adam Wilcox

Microsoft Excel 2010 has some useful tools for parsing data from different kinds of files; such as a text file or a Word document; into Excel worksheets. In this video; Adam Wilcox demonstrates how to bring external data into Excel and display it in columns.

47986
Microsoft Excel 2010: Inserting And Deleting Rows And Columns Adam Wilcox

Microsoft Excel 2010 allows you to easily insert and delete data in the middle of a worksheet. However; you need be aware of how insertions or deletions affect the surrounding data. In this video; Adam Wilcox demonstrates how to add and remove data from a worksheet.

48000
Microsoft Excel 2010: Keyboard Shortcuts Adam Wilcox

To use Excel 2010 well and efficiently; you should consider using keyboard shortcuts. Using the keyboard shortcuts allows you to keep your hands on the keyboard instead of having to reach for the mouse constantly. In this video; Adam Wilcox will demonstrate how to use several keyboard shortcuts to improve your efficiency.

48034
Microsoft Excel 2010: Link Cells From Different Workbooks Adam Wilcox

In Microsoft Excel 2010; you can connect information in different worksheets or workbooks by using links. In this video; Adam Wilcox demonstrates how to create links to connect data in separate workbooks.

47983
Microsoft Excel 2010: Making Use Of Logical Functions Adam Wilcox

Logical functions are some of the most powerful functions in Microsoft Excel 2010 because they make decisions before doing calculations. For example; Excel can perform different calculations; depending on whether a condition is true or not. In this video; Adam Wilcox demonstrates how to use logical functions to calculate whether employees qualify for goal bonuses; category bonuses; or club membership.

47826
Microsoft Excel 2010: Managing Worksheets Adam Wilcox

In Microsoft Excel 2010; workbooks usually contain several worksheets. You can add; delete; and move them as you need. In this video; Adam Wilcox demonstrates the different ways to manage worksheets in a workbook.

48014
Microsoft Excel 2010: Page Layout Options Adam Wilcox

Microsoft Excel 2010 enables you to change the page layout of a workbook before printing it. You can use the Page Layout options to change the page orientation; fit data on one page; and set print titles to repeat headings on multiple pages. In this video; Adam Wilcox demonstrates how to change the page layout of a large worksheet.

48002
Microsoft Excel 2010: Printing Adam Wilcox

Microsoft Excel 2010 enables you to print your entire workbook or only a portion of the data in it. You can use the Print options to specify which data you want to print and set the page layout before printing it. In this video; Adam Wilcox demonstrates how to print a portion of the data in a Sales workbook.

48003
Microsoft Excel 2010: Protect Workbooks Adam Wilcox

Microsoft Excel 2010 offers workbook protection; which allows you to add passwords and control what changes other people can make. In this video; Adam Wilcox demonstrates how to add different levels of protection to a workbook; and to the cells within a workbook.

47987
Microsoft Excel 2010: Publishing Workbook Data To The Web Adam Wilcox

Microsoft Excel 2010 allows you to save your workbook as a web page. You can also maintain a connection between the workbook and the web page. In this video; Adam Wilcox demonstrates how to save a worksheet as a web page and keep the connection to the published page.

48022
Microsoft Excel 2010: Entering And Understanding Functions Adam Wilcox

Microsoft Excel 2010 includes a built-in library of calculations; known as functions. You can use functions to perform various calculations; such as adding numbers or calculating interest payments. In this video; Adam Wilcox uses the SUM; AVERAGE; and SUMIF functions to calculate the total and average sales; as well as the sales per region in a worksheet.

47992
Microsoft Excel 2010: Excel Options Adam Wilcox

The Excel Options dialog box allows you to configure how the Microsoft Excel 2010 environment behaves. You can change the default font; the tabs on the Ribbon; the options for saving and proofing workbooks; as well as the way formulas work. In this video; Adam Wilcox demonstrates how to configure some of these options.

48016
Microsoft Excel 2010: Add Drop Down Validation Rule Adam Wilcox

You can add drop-down lists to Microsoft Excel 2010 workbooks using validation rules. This allows you to select a value for each cell from a defined list. In this video; Adam Wilcox demonstrates how to add a list-based validation rule to a workbook.

47980
Microsoft Excel 2010: Additional Date Features Adam Wilcox

Microsoft Excel 2010 has some handy functions that you can use when you work with dates. In this video; Adam Wilcox demonstrates how he calculates a date based on a number of days; the number of workdays between two dates; and how to display the month; day; or year as text or as a number.

47823
Microsoft Excel 2010: Additional Pivottable Features Adam Wilcox

Microsoft Excel 2010 provides additional PivotTable features making it easier for you to view data and garner information from spreadsheets. In this video; Adam Wilcox uses the additional PivotTable features to view data by date; summarize data by second; minute; hour; month; day; quarter; or year; view data by subtotals; and filter the data using slicers.

47820
Microsoft Excel 2010: Align Text In Cells Adam Wilcox

Microsoft Excel 2010 has several alignment options for altering the way text displays in a cell. For example; you can center; rotate; or wrap text. In this video; Adam Wilcox demonstrates how to use the various alignment features to modify the appearance of text in a worksheet.

48001
Microsoft Excel 2010: Analysis Toolpak Adam Wilcox

In Microsoft Excel 2010; you can load add-ins such as the Analysis ToolPak to perform statistical analysis on your data. Some common analysis tools are correlation; sampling; and histograms. In this video; Adam Wilcox demonstrates how to load the Analysis ToolPak and use some of its tools to analyze data.

47981
Microsoft Excel 2010: Apply And Modify Number Formats Adam Wilcox

Microsoft Excel 2010 provides several number formats. You can easily format numbers as currency; dates; or phone numbers. In this video; Adam Wilcox demonstrates how to apply various formats to numbers.

47999
Microsoft Excel 2010: Apply Conditional Formatting Adam Wilcox

In Microsoft Excel 2010; you can use conditional formatting to apply formats based on a condition to cells in a worksheet. You can use preset conditional formatting; such as highlighting cells; data bars; or icon sets. Alternatively you can create your own formatting rules. In this video; Adam Wilcox demonstrates how to use preset rules and create your own rules.

47982
Microsoft Excel 2010: Array Formulas Adam Wilcox

In Excel 2010 you can use arrays to perform some very sophisticated calculations. In this video; Adam Wilcox defines what an array is and then demonstrates how to enter an array and use it to perform calculations.

48031
Microsoft Excel 2010: Calculations In Pivot Tables Adam Wilcox

In Excel 2010; you can control the calculations on the values in a pivot table. In this video; Adam Wilcox demonstrates how to show values and summarize values on the data in a pivot table.

48032
Microsoft Excel 2010: Chart Layout And Formatting Adam Wilcox

Microsoft Excel 2010 includes several tools for formatting charts to improve their appearance and the information they convey. You can change the chart type; select a style; and insert labels and titles. In this video; Adam Wilcox demonstrates how to format the style and data labels of a pie chart.

47996
Microsoft Excel 2010: Choosing Appropriate Chart Types Adam Wilcox

In Excel 2010; there is a wide range of chart types you can use to illustrate your data. In this video; Adam Wilcox will demonstrate how to select the appropriate chart type to illustrate your data.

48029
Microsoft Excel 2010: Cleaning Data And Removing Duplicates Adam Wilcox

If you receive data from a source other than an Excel worksheet; you might need to clean up the data to use in Excel 2010. In this video; Adam Wilcox demonstrates how to clean the data including removing extra characters; converting text to numbers; and removing duplicate values.

48026
Microsoft Excel 2010: Combining Text Adam Wilcox

Microsoft Excel 2010 includes functions for manipulating text. You can combine text from different cells into one cell or you can separate parts of a string into different cells. In this video; Adam Wilcox demonstrates how to use the CONCATENATE; LEFT; RIGHT; and MID functions to manipulate text.

47825
Microsoft Excel 2010: Consolidating Data In Several Workbooks Adam Wilcox

The Consolidate command in Microsoft Excel 2010 allows you to take information from several similar workbooks and combine it in one workbook. In this video; Adam Wilcox demonstrates how to consolidate data.

48013
Microsoft Excel 2010: Copying And Moving Data Adam Wilcox

In Microsoft Excel 2010; you can copy or move data in a worksheet from one location to another. In this video; Adam Wilcox demonstrates several methods of copying and pasting data as well as moving data from one cell to another in a worksheet.

47993
Microsoft Excel 2010: Copying Cell Formatting Adam Wilcox

In Microsoft Excel 2010; you can copy the formatting in a cell or cell range to another location in your workbook; using the Paste options or Format Painter. In this video; Adam Wilcox demonstrates how to copy formatting to a single cell and a range of cells in a workbook.

48005
Microsoft Excel 2010: Create A Scenario Adam Wilcox

In Microsoft Excel 2010; you can create scenarios as a way to look at different combinations of values in your workbook. In this video; Adam Wilcox demonstrates how to use the Scenario Manager to create and switch between different sets of data in the same worksheet.

47984
Microsoft Excel 2010: Creating Pivottable Reports Adam Wilcox

In Microsoft Excel 2010; PivotTables are an incredibly useful tool. They allow you to generate useful information from large amounts of data. In this video; Adam Wilcox demonstrates how to create and modify a PivotTable report.

47821
Microsoft Excel 2010: Custom Number Formats Adam Wilcox

Microsoft Excel 2010 enables you to customize number formats in various ways. You can customize positive numbers; negative numbers; zeroes; and text. In this video; Adam Wilcox demonstrates how to customize various number formats.

47991
Microsoft Excel 2010: Elements Of An Excel Chart Adam Wilcox

Charts are visual representations of data. In Microsoft Excel 2010; you can easily create various types of charts from an existing data source. In this video; Adam Wilcox demonstrates how to create and modify an Excel chart.

47997
Microsoft Excel 2010 – Fixing Text Adam Wilcox

Microsoft Excel 2010 allows you to extract information from strings and fix text to appear the way you want. In this video; Adam Wilcox demonstrates how to concatenate two strings and to change the case of the text.

50738
Microsoft Excel 2010 – Manipulating Text Adam Wilcox

Microsoft Excel 2010 allows you to manipulate strings that comprise text; numbers; and special characters; such as Product IDs. In this video; Adam Wilcox demonstrates how to apply text functions to return the length of a string; the position of characters within the string; and the prefix; suffix; and number from the string.

47824
Microsoft Excel 2010: Useful Math Functions Adam Wilcox

Excel 2010 includes many math functions including ones to find integers; to round a number; to find greatest common denominator; to find the circumference and area of a circle; and many more. In this video; Adam Wilcox will demonstrate how to use some useful math functions.

48025
Microsoft Excel 2010: About Range Lookups Adam Wilcox

In Microsoft Excel 2010; range lookups allow you to return values even if the information you’re looking up isn’t precisely within the lookup range. The Range Lookup function can be used to return all the sales figures below a certain value in a table. In this video; Adam Wilcox uses the Range argument of the VLOOKUP function to find and return data from a worksheet.

47819
Microsoft Excel 2010: Add Data Validation Rule Adam Wilcox

Data validation is a means to check that the data entered in a workbook conforms to certain rules. You can specify the validation criteria for a cell range; and use messages to communicate to users what the rules are. In this video; Adam Wilcox demonstrates how to add data validation rules to a workbook.

47979
Lync 2010 (15)
Title Speaker Summary ID
Microsoft Lync 2010: Searching For Contacts Erin Olsen

The advanced search capabilities of Microsoft Lync 2010 allow us to effectively search and locate the contact we need to communicate with. In this video; Erin Olsen demonstrates how to search with different types of contact information and narrow down the results.

48417
Microsoft Lync 2010: Sharing A Screen Erin Olsen

Microsoft Lync 2010 allows you to collaborate and share information with your contacts. In this video; Erin Olsen demonstrates how to do screen sharing and give true control to your contact group.

48407
Microsoft Lync 2010: Starting An Im Session Erin Olsen

Instant messaging on Microsoft Lync 2010 allows you to hold online conversations with contacts and groups such as your project team. In this video; Erin Olsen demonstrates how to start and run a conversation efficiently.

48406
Microsoft Lync 2010: Updating Status And Location Information Erin Olsen

Microsoft Lync 2010 allows you to indicate whether you are available and where you physically are. In this video; Erin Olsen demonstrates how to automatically and manually update your presence indicators to best communicate your presence at a given time.

48404
Microsoft Lync 2010: Viewing Activity Feeds Erin Olsen

Activity Feeds on Microsoft Lync 2010 allows you to share information by leaving notes for your contacts instead of sending emails. In this video; Erin Olsen demonstrates how to configure activity feeds and track and keep up-to-date with what people have to say.

48414
Microsoft Lync 2010: Reviewing A Contact Card Erin Olsen

Contact cards in Microsoft Lync 2010 are important to start communications with our contacts. In this video; Erin Olsen demonstrates how to use contact cards for reviewing and understanding someone’s personal information as well as of the organization.

48413
Microsoft Lync 2010: Adding Or Changing Our Lync Picture Erin Olsen

Microsoft Lync 2010 allows you to customize your personal contact information and enhance your presence online. In this video; Erin Olsen demonstrates how to replace the generic picture in your contact information with a real picture.

48405
Microsoft Lync 2010: Adding Phone Numbers And Settings Erin Olsen

Microsoft Lync 2010 allows you to add phone numbers to your contact card and change settings. In this video; Erin Olsen demonstrates how to configure phone settings appropriate to the work environment.

48408
Microsoft Lync 2010: Adding To Frequent Contacts Erin Olsen

Frequent Contacts in Microsoft Lync 2010 is a tool that assists with organizing and finding your contacts. In this video; Erin Olsen demonstrates how to add and remove contacts from the frequent contacts list.

48418
Microsoft Lync 2010: Changing Contact Display With Layout Options Erin Olsen

The layout options in Microsoft Lync 2010 allow you to access and change the way your contact information is displayed. In this video; Erin Olsen demonstrates how to customize these simple options to customize Lync to work the way you need it to.

48416
Microsoft Lync 2010: Changing Privacy Categories For Contacts Erin Olsen

Microsoft Lync 2010 allows you to restrict the information accessed about you by your contacts. In this video; Erin Olsen demonstrates how to control who has access to your phone numbers; email address; meeting details; and can interrupt the Do Not Disturb status.

48410
Microsoft Lync 2010: Creating And Adding Contacts To Groups Erin Olsen

Creating and adding contacts to groups in Microsoft Lync 2010 helps you get contacts to work quickly because they are arranged into logical groups that make sense. In this video; Erin Olsen demonstrates how to organize contacts into groups for a specific project or task.

48412
Microsoft Lync 2010: Exploring The Action Bar Erin Olsen

The Action bar is designed to allow you to use the real-time services in Microsoft Lync 2010. In this video; Erin Olsen demonstrates how to use this simple application to get presence information and communication options for a particular contact.

48411
Microsoft Lync 2010: Getting Started With Lync 2010 Erin Olsen

Microsoft Lync 2010 allows you to communicate in a variety of ways all from within one application. In this video; Erin Olsen demonstrates how to configure Lync and optimize the way you communicate with others.

48415
Microsoft Lync 2010: Making A Phone Call Erin Olsen

Using the telephony capabilities of Microsoft Lync 2010; you can place calls to any one inside or outside the organization. In this video; Erin Olsen demonstrates how to find a contact and initiate a Lync call.

48409
Outlook 2010 (76)
Title Speaker Summary ID
Microsoft Outlook 2010: Working With Graphics Josh Penzell

In Microsoft Outlook 2010; you can embed or attach images to your e-mails. You can also manipulate images that you’ve added to the body of a message. In this video; Josh Penzell demonstrates how to add an image to an e-mail and make any necessary adjustments.

48174
Microsoft Outlook 2010: Working With Linkedin Josh Penzell

You can integrate Microsoft Outlook 2010 with the social network; LinkedIn; using the LinkedIn connector. Once integrated; you can invite your contacts join your LinkedIn group. In this video; Josh Penzell demonstrates how to connect Outlook to LinkedIn.

48214
Microsoft Outlook 2010: Setting Up Free/busy Information Adam Wilcox

In Microsoft Outlook 2010; your work calendar allows you to get the most out of your work day by letting people know when you are; or are not; available. In this video; Adam Wilcox uses the features of his work calendar to show you how to schedule meetings with your coworkers; regardless of their time zone or geography.

47847
Microsoft Outlook 2010: Sharing An Account Josh Penzell

You can share your Microsoft Outlook 2010 account with other users and grant them permission to view your mail; as well as edit and send items on your behalf. In this video; Josh Penzell demonstrates how to share an Outlook account with another person.

48211
Microsoft Outlook 2010: Sharing Your Calendar Info Josh Penzell

In Microsoft Outlook 2010; you can share calendar events; meetings; and appointments with your contacts. In this video; Josh Penzell demonstrates how to share calendars and set calendar permissions.

48166
Microsoft Outlook 2010: Shortcuts Josh Penzell

If you often visit the same web pages; go to the same folders; or open other programs while using Microsoft Outlook 2010; you can add shortcuts to the Navigation pane. In this video; Josh Penzell demonstrates how to add shortcuts to the Navigation pane.

48189
Microsoft Outlook 2010: Stationery Josh Penzell

In Microsoft Outlook 2010; you can customize the appearance of your e-mails to make them more appealing. You can use themes and stationery to customize the font; style; and color; and apply it once or to every outgoing e-mail. In this video; Josh Penzell demonstrates how to create custom themes and stationery for outgoing e-mails.

48201
Microsoft Outlook 2010: Subscribing To Calendars Josh Penzell

In Microsoft Outlook 2010; you can subscribe to online calendars; such as a Google calendar. You can’t customize or synchronize the calendar; but you can view it or share it with other people. In this video; Josh Penzell demonstrates how to add a calendar to Outlook from the Internet.

48165
Microsoft Outlook 2010: Tracking Messages Josh Penzell

Microsoft Outlook 2010 allows you to track messages and embed them with certain features. For example; you can use voting buttons to poll the recipients of an e-mail; and track whether or not recipients have received or read messages you sent. In this video; Josh Penzell demonstrates how to add voting and tracking options to your e-mails.

48185
Microsoft Outlook 2010: Using And Modifying Forms Josh Penzell

In Microsoft Outlook 2010; you can easily create and use custom forms; such as a contact or task form. In this video; Josh Penzell demonstrates how to design a custom contact form.

48200
Microsoft Outlook 2010: Using Autoarchive Josh Penzell

In Microsoft Outlook 2010; you can automatically archive old e-mails to make room for new messages; but still have the old information readily available. In this video; Josh Penzell demonstrates how to use the AutoArchive settings to store old messages.

48197
Microsoft Outlook 2010: Using Color Categories Josh Penzell

Microsoft Outlook 2010 lets you organize your e-mails; contacts; tasks; and calendar events in a visual way using categories; such as Personal or Work. You can also assign a color to each category. In this video; Josh Penzell demonstrates how to create and assign categories to various items in Outlook.

48203
Microsoft Outlook 2010: Using Digital Signatures And Encrypting Email Josh Penzell

In Microsoft Outlook 2010; you can use digital signatures and encryption to maintain the integrity and confidentiality of your e-mails. In this video; Josh Penzell demonstrates how to use the security settings in Outlook to digitally sign or encrypt an e-mail.

48170
Microsoft Outlook 2010: Using Flags With Email Messages Josh Penzell

You can use the flag features provided by Microsoft Outlook 2010 to make sure that you follow up on important messages. Outlook also integrates the flag features with tasks by adding flagged messages to your task list. In this video; Josh Penzell demonstrates how to add flags to e-mail messages.

48183
Microsoft Outlook 2010: Using Rss Feeds Josh Penzell

In Microsoft Outlook 2010; you can download RSS feeds from any web site; such as news and technology web sites; that support RSS content. You can use the RSS Feeds feature to download RSS feeds directly to a folder in Outlook. In this video; Josh Penzell demonstrates how to add RSS feeds in Outlook.

48207
Microsoft Outlook 2010: Using Signatures Adam Wilcox

In Microsoft Outlook 2010; you can use signatures to inform the recipients of your messages about who you are and how to contact you. In this video; Adam Wilcox demonstrates how to create and format e-mail signatures.

47860
Microsoft Outlook 2010: Using Symbols; Horizontal Lines And Equations Josh Penzell

Microsoft Outlook 2010 allows you to add complex equations and special symbols to your e-mails. You can also add horizontal lines to differentiate areas of your e-mails. In this video; Josh Penzell demonstrates how to add an equation; horizontal line; and symbol to an e-mail.

48208
Microsoft Outlook 2010: Using Text Messaging In Outlook Josh Penzell

In Microsoft Outlook 2010; you can send text messages without using your cell phone by subscribing to an Internet service; or through Unified Messaging and Exchange. In this video; Josh Penzell demonstrates how to set up a text messaging account in Outlook.

48196
Microsoft Outlook 2010: Using The Journal Josh Penzell

The journal in Microsoft Outlook 2010 let’s you keep a log of conversations; meetings; messages; and phone calls you’ve had with certain people. In this video; Josh Penzell demonstrates how to set up and use the journal.

48192
Microsoft Outlook 2010: Working With Google Calendars Josh Penzell

In Microsoft Outlook 2010; you can synchronize your Google Outlook calendar with your Outlook calendar using the Google Sync application In this video; Josh Penzell demonstrates how to integrate the Outlook and Google calendars.

48216
Microsoft Outlook 2010: Working With Google Contacts Josh Penzell

In Microsoft Outlook 2010; you can synchronize your Gmail contacts with your Outlook contacts; using the GO Contact Sync open-source application. In this video; Josh Penzell demonstrates how to use GO Contact Sync to synchronize contacts between Outlook and Gmail.

48217
Microsoft Outlook 2010: Working With Google Gmail Josh Penzell

In Microsoft Outlook 2010; you can integrate Gmail to automatically download new messages to your computer. You can also configure Outlook to send messages using the Gmail account. In this video; Josh Penzell demonstrates how to set up Gmail in Outlook.

48215
Microsoft Outlook 2010: Managing Outlook Email Views Josh Penzell

Microsoft Outlook 2010 displays the Navigation; Content; Reading; and To-Do Panes by default. There are several ways to customize the default e-mail view. For example; you can minimize the To-Do and Navigation Panes; or remove the Tasks list from the To-Do Pane. In this video; Josh Penzell demonstrates how to customize the default e-mail view.

48175
Microsoft Outlook 2010: Manipulating Calendar Views Josh Penzell

In Microsoft Outlook 2010; there are a number of ways you can view the scheduling information in your calendar. You can arrange your calendar by day; week; or month. You can also display holidays and add a second time zone. In this video; Josh Penzell demonstrates how to view your calendar to best suit your needs.

48164
Microsoft Outlook 2010: Message Templates Josh Penzell

You can create a message template in Microsoft Outlook 2010. This is useful for when you often send the same message several times. In this video; Josh Penzell demonstrates how to create a message template; save it; and send it.

48182
Microsoft Outlook 2010: Note Views Josh Penzell

You can effectively organize and view notes you’ve created in Microsoft Outlook 2010. In this video; Josh Penzell demonstrates how to customize the way you view notes.

48205
Microsoft Outlook 2010: Opening Archival Email Josh Penzell

In Microsoft Outlook 2010; you can keep an archive of all your e-mails and then access these e-mails at a later date from your Outlook account settings. In this video; Josh Penzell demonstrates how to access and navigate through an archived data file.

48167
Microsoft Outlook 2010: Organizing Rss Feeds Josh Penzell

In Microsoft Outlook 2010; you can organize your RSS feeds to save you time. You can categorize; flag; or share them with other contacts. You can also use search folders to locate specific content in the RSS feeds. In this video; Josh Penzell demonstrates how to view; share; and search RSS feeds.

48219
Microsoft Outlook 2010: Organizing Tasks Josh Penzell

Microsoft Office 2010 provides you with a number of ways to organize and manage your tasks. In this video; Josh Penzell demonstrates some of the task management features.

48194
Microsoft Outlook 2010: Organizing The Inbox Adam Wilcox

There are many ways you can organize your Microsoft Outlook 2010 inbox. In this video; Adam Wilcox demonstrates a few of those that are particularly useful; such as flagging for follow-up; marking as read or unread; sorting messages; and using folders.

47859
Microsoft Outlook 2010: Printing In Outlook Josh Penzell

In Microsoft Outlook 2010; you can print your e-mails; contacts; calendar; tasks; and notes in several formats; such as a memo or table. In this video; Josh Penzell uses the Print feature to print messages; contacts; calendars; tasks; and notes using various print styles.

48202
Microsoft Outlook 2010: Quickly Access Functions Josh Penzell

Many Microsoft Outlook 2010 functions can be accessed without even opening the program. In this video; Josh Penzell demonstrates how to access Outlook functions using the jump list feature and taskbar options.

48206
Microsoft Outlook 2010: Recall Sent Messages Josh Penzell

Microsoft Outlook 2010 allows you to recall a message after you sent it; recall and replace a message; and resend a message. In this video; Josh Penzell demonstrates how to use the recall and resend functions.

48181
Microsoft Outlook 2010: Responding To Rescheduling Meetings Josh Penzell

In Microsoft Outlook 2010; you can easily accept or deny a meeting invitation sent to you. In this video; Josh Penzell uses the Outlook interface to demonstrate the options available for responding to a meeting request.

48163
Microsoft Outlook 2010: Response Text Josh Penzell

When you respond to; or forward; e-mails in Microsoft Outlook 2010; the original e-mail is usually below the current e-mail you’re writing. You can customize how the original e-mail is resent along with your response. In this video; Josh Penzell uses the Mail options to customize how the original e-mail appears when replying to and forwarding mail.

48178
Microsoft Outlook 2010: Scheduling Options With Messages Josh Penzell

Microsoft Outlook 2010 offers flexibility with the scheduling and delivery of e-mails. You can set messages to be delivered to different recipients and schedule an e-mail to be sent later or to expire after a certain time. In this video; Josh Penzell demonstrates how to set delivery and expiration dates and times for e-mails.

48186
Microsoft Outlook 2010: Screen Shots Josh Penzell

Microsoft Outlook 2010 includes the Screenshot and Screen Clipping features for taking a screenshot of a window you have open or clipping a part of the screen; and including it in your e-mail. In this video; Josh Penzell demonstrates how to add screenshots and screen clippings to a message.

48199
Microsoft Outlook 2010: Search Folders Josh Penzell

You can create search folders in Microsoft Outlook 2010 to easily organize e-mails according to conditions you set for the file to be searched. For example; you can create a search folder for a particular category. In this video; Josh Penzell demonstrates how to create a new search folder to organize categorized e-mails.

48190
Microsoft Outlook 2010: Sending Contact Information Josh Penzell

In Microsoft Outlook 2010; you can easily send contact information to friends and colleagues via e-mail; using the Mail and Contact features. In this video; Josh Penzell demonstrates how to forward contact information as a business card; an Outlook contact; and an attachment.

48172
Microsoft Outlook 2010: Sending From A Different Address Josh Penzell

In Microsoft Outlook 2010; you can send messages from different accounts and addresses. In this video; Josh Penzell demonstrates how to use an alias address when sending an e-mail.

48220
Microsoft Outlook 2010: Setting Security Options Using The Trust Center Josh Penzell

In Microsoft Outlook 2010; you can configure the security and privacy options in the Trust Center to help keep your data secure and your computer safe from potential threats on the Internet. In this video; Josh Penzell demonstrates how to configure settings in the Trust Center to make your system more secure.

48169
Microsoft Outlook 2010: Managing Meetings Adam Wilcox

In Microsoft Outlook 2010; meetings are calendar items that involve other people or resources; such as meeting rooms or equipment. In this video; Adam Wilcox demonstrates how to schedule a meeting and how to respond to a meeting request.

47857
Microsoft Outlook 2010: Creating Appointments Adam Wilcox

In Microsoft Outlook 2010 your work calendar allows you to schedule appointments and set reminders when you have to do something or be somewhere. In this video; Adam Wilcox uses the features of his work calendar to create a monthly recurring appointment; as well as create an appointment from an e-mail.

47848
Microsoft Outlook 2010: Creating Contacts Josh Penzell

Microsoft Outlook 2010 provides several ways to create new contacts easily. In this video; Josh Penzell demonstrates how to create a new contact from scratch and from existing information.

48159
Microsoft Outlook 2010: Creating Notes Josh Penzell

Microsoft Outlook 2010 lets you store all your quick notes electronically. You can create; edit; and categorize notes; as well as add them to your contacts. In this video; Josh Penzell demonstrates how to use notes in Outlook.

48204
Microsoft Outlook 2010: Creating Quick Steps For Email Messages Josh Penzell

Quick steps are a great time-saving feature in Microsoft Outlook 2010. They allow you to link together several steps into one overall button. In this video; Josh Penzell demonstrates how to create a new quick step for sending and moving e-mails.

48187
Microsoft Outlook 2010: Creating Rules Adam Wilcox

In Microsoft Outlook 2010; you can set rules to manage messages in a particular way based on whether they come from a specific person or have a particular piece of text in the subject line. In this video; Adam Wilcox uses the rules feature to set actions on selected messages based on various criteria.

47854
Microsoft Outlook 2010: Creating Tasks Josh Penzell

Microsoft Outlook 2010 provides several options for creating tasks. You can set start and due dates as well as the priority of the task. You can also assign tasks to other people and send out status reports. In this video; Josh Penzell demonstrates how to create tasks and assign them to other people.

48193
Microsoft Outlook 2010: Customizing The Outlook User Interface Josh Penzell

You can customize the Microsoft Outlook 2010 interface to fit your style of working. For example; you can customize the Quick Access Toolbar; which gives you quick access to functions you use often; and the Ribbon; which changes based on what navigation you’re using. In this video; Josh Penzell demonstrates how to customize the Quick Access Toolbar and the Ribbon.

48176
Microsoft Outlook 2010: Date Calculator Josh Penzell

Microsoft Outlook 2010 provides a built-in Date Calculator; which determines a future date based on the number of days you specify. You can use this feature for setting the due date for tasks. In this video; Josh Penzell demonstrates how to use the Date Calculator to calculate the end dates of tasks and appointments.

48180
Microsoft Outlook 2010: Defer Sending Emails Josh Penzell

In Microsoft Outlook 2010; you can create a rule to defer the sending an e-mail for a period of time after you hit the Send button. This allows you time to make any quick corrections before the message is sent. In this video; Josh Penzell demonstrates how to create a rule to defer delivery of an e-mail.

48188
Microsoft Outlook 2010: Desktop Alerts Josh Penzell

When messages arrive in Microsoft Outlook 2010; you receive a notification; such as a sound plays; the mouse pointer or icon changes; or a desktop alert displays. You can customize the desktop alert settings. In this video; Josh Penzell configures desktop alerts.

48209
Microsoft Outlook 2010: Downloading Global Addresses Josh Penzell

If you use a Global Address List that’s stored on a Microsoft Exchange server; you might not be able to access it when you travel. Using Microsoft Outlook 2010; you can download the list to your laptop to avoid this. In this video Josh Penzell demonstrates how to download the Global Address List.

48213
Microsoft Outlook 2010: Editing An Attached Document Josh Penzell

When a document is sent back and forth in Microsoft Outlook 2010 between two mail recipients; it can create a number of versions of the file; some of which might be out of date. In this video Josh Penzell demonstrates how to edit an attached document to avoid version control issues.

48212
Microsoft Outlook 2010: Email Importance And Sensitivity Josh Penzell

In Microsoft Outlook 2010; you can make messages stand out by assigning different importance and sensitivity levels to them. In this video; Josh Penzell demonstrates how to apply importance and sensitivity settings to e-mail messages.

48210
Microsoft Outlook 2010: Exporting Contacts Adam Wilcox

Contacts are very useful in Microsoft Outlook 2010; but they are also useful outside of Outlook. You can add your contacts to an Access database or an Excel file; or upload them to a newsletter service to forward a newsletter to selected contacts. In this video; Adam Wilcox demonstrates how to export contacts for use in a newsletter service.

47855
Microsoft Outlook 2010: Global Address List Vs Contacts Josh Penzell

In Microsoft Outlook 2010; all the organization’s contacts are stored in the Global Address List; whereas personal contacts are stored in a separate list. You can easily move contacts from the Global Address List to the personal contacts list. In this video; Josh Penzell will demonstrate how to move a contact from the Global Address List to your personal contacts list.

48160
Microsoft Outlook 2010: Homepage Josh Penzell

In Microsoft Outlook 2010 you can set the home page; which displays when the program launches. A popular home page is Outlook Today; which shows your calendar items and tasks; and has several customizable features. In this video; Josh Penzell demonstrates how to change the home page.

48218
Microsoft Outlook 2010: Increasing Productivity Josh Penzell

Microsoft Outlook 2010 is a useful tool for improving productivity. You can delete unnecessary messages; categorize important e-mails; and use search folders. In this video; Josh Penzell demonstrates how to use Outlook efficiently to increase your productivity.

48168
Microsoft Outlook 2010: Junk E-mail Adam Wilcox

Microsoft Outlook 2010 has a junk e-mail feature to prevent you from receiving any e-mail you are not interested in; such as advertising and other types of spam messages. In this video; Adam Wilcox uses the junk e-mail feature to classify particular e-mail addresses or domains as not safe or blocked content.

47856
Microsoft Outlook 2010: Linking To Bookmarks Josh Penzell

Microsoft Outlook 2010 lets you add bookmarks to long e-mails; making them easier to navigate. You can insert bookmarks into sections of an e-mail message and then create hyperlinks that point to the bookmarked sections. In this video; Josh Penzell uses the Bookmarks feature to insert bookmarks into an e-mail.

48179
Microsoft Outlook 2010: Managing Attachments Adam Wilcox

In Microsoft Outlook 2010; you can attach additional information to your e-mails in the form of attachments. These attachments can include Excel documents; PDF files; or images. In this video; Adam Wilcox demonstrates how to preview; save; open; and remove an attachment from an e-mail.

47849
Microsoft Outlook 2010: Using Mailbox Cleanup Josh Penzell

In Microsoft Outlook 2010; you can use the Mailbox Cleanup features to automate the process of removing unwanted and unnecessary messages from your mailbox. This can help to manage your e-mails and free up storage space. In this video; Josh Penzell demonstrates how to remove old and redundant messages.

48198
Microsoft Outlook 2010: Adding Bcc Josh Penzell

In Microsoft Outlook 2010; blind carbon copy; or Bcc; is useful when you want to send someone a copy of an e-mail; but you don’t want everyone else to see who received a copy of the e-mail. In this video; Josh Penzell demonstrates how to enable and disable the Bcc feature.

48161
Microsoft Outlook 2010: Always Reply To All Josh Penzell

When you send messages to multiple people and you want to make sure that everyone replies to all; you can use the Tags tracking function built into Microsoft Outlook 2010. In this video; Josh Penzell demonstrates how to use this function to make sure that everyone included on an mail replies to all.

48184
Microsoft Outlook 2010: Automated Replies Adam Wilcox

In Microsoft Outlook 2010; you can set up automated replies for when you are out of the office. You can also set rules to automatically forward messages you receive to another person. In this video; Adam Wilcox uses the automated reply function to set up replies and to define rules for automated responses.

47850
Microsoft Outlook 2010: Autoreply Thru Rules Josh Penzell

In Microsoft Outlook 2010; the Rules feature gives you greater flexibility than using the Automatic Replies feature when you’re out of the office. In this video; Josh Penzell demonstrates how to create a new rule that will send an automatic response whenever a message comes in.

48195
Microsoft Outlook 2010: Backing Up Outlook Items Josh Penzell

In Microsoft Outlook 2010; it’s always a good idea to back up your work to prevent loss of information from unexpected events such as power surges. You can back up and restore Outlook data using the Import and Export wizard. In this video; Josh Penzell demonstrates how to back up and restore your Outlook information.

48171
Microsoft Outlook 2010: Configuring The Settings For An Outlook Account Josh Penzell

In Microsoft Outlook 2010; you can configure message settings in your Outlook account to suit your needs. You can configure options for creating; replying; forwarding; sending; tracking; and formatting messages. In this video; Josh Penzell demonstrates how to configure the message settings for an Outlook account.

48177
Microsoft Outlook 2010: Contact Groups Adam Wilcox

In Microsoft Outlook 2010; you can create contact groups. This allows you to send messages to a number of people at once; or invite the same group of people to a meeting. In this video; Adam Wilcox demonstrates how to set up and populate a contact group; and send messages to a contact group.

47851
Microsoft Outlook 2010: Controlling Email Message Format Adam Wilcox

Microsoft Outlook 2010 allows you to control the format of the messages you send so they display the way you want them to. In this video; Adam Wilcox demonstrates how to change the way your messages display; and how to change the default message format in Outlook.

47858
Microsoft Outlook 2010: Conversation Feature Adam Wilcox

In Microsoft Outlook 2010; the Conversations feature allows you to see all conversations that took place within an e-mail thread and in the order in which the conversations came in. In this video; Adam Wilcox demonstrates how to use the conversations feature to make your inbox more manageable.

47852
Microsoft Outlook 2010: Create An Event Adam Wilcox

In Microsoft Outlook 2010; an event is a type of appointment on your calendar that takes up a whole day; or even multiple days. In this video; Adam Wilcox uses the features of his work calendar to create single and recurring events.

47853
Microsoft Outlook 2010: Create Custom Rules Josh Penzell

Microsoft Outlook 2010 offers many templates for rules; which run on incoming and outgoing messages. In addition to these; you can create custom rules. You can also import or export the rules you create in Outlook. In this video; Josh Penzell demonstrates how to create a new rule; as well as export and import rules.

48191
Microsoft Outlook 2010: Creating An Electronic Business Card Josh Penzell

In Microsoft Outlook 2010; you can create electronic business cards to pass on to clients and colleagues via e-mail. You can add a picture and a background color to the business card; as well as edit the information it contains. In this video; Josh Penzell uses the Contacts feature to create an electronic business card from existing contact details.

48173
Microsoft Outlook 2010: Creating And Scheduling Meetings Josh Penzell

In Microsoft Outlook 2010; you can easily organize and schedule meetings. When setting up a meeting; you use the Appointment feature to specify the time and location of the meeting and the Scheduling Assistant to specify the attendees. In this video; Josh Penzell demonstrates how to set up a meeting.

48162
PowerPoint 2010 (56)
Title Speaker Summary ID
Microsoft Powerpoint 2010: Recording A Slide Show Josh Penzell

In PowerPoint 2010; you can rehearse your slide show and record the time you spend on each slide. This then allows you to present without needing to change slides using a mouse or keyboard. In this video; Josh Penzell demonstrates how you automate a presentation that advances through the slides without needing user action.

48128
Microsoft Powerpoint 2010: Remove The Background From An Image Steve English

Microsoft PowerPoint 2010 allows you to remove the background from an image and keep only that which you want to show your audience. In this video; Steve English demonstrates how to remove the unwanted parts and tweak an image and also discusses tips and tricks to make imperfections such as shadows and undefined edges less noticeable.

48154
Microsoft Powerpoint 2010: Review And Comments Feature Steve English

The Review and Comments feature in Microsoft PowerPoint 2010 is a very useful tool. It enables you to mark up your suggestions without changing the presentation itself. In this video; Steve English uses the Review and Comments feature to create; view; and remove comments in a presentation.

47839
Microsoft Powerpoint 2010: Save In A Format With Smaller File Size Steve English

Sharing a PowerPoint presentation in a network or sending it in e-mail often becomes difficult because of its large file size. Microsoft PowerPoint 2010 allows you to reduce the file size in many ways. In this video; Steve English demonstrates the different options you can use to reduce the file size even by more than 90%.

48146
Microsoft Powerpoint 2010: Save In A Presentation Format Steve English

Microsoft PowerPoint 2010 allows you to save a file in more than two dozen formats; some of which are specifically tailored for doing presentations. In this video; Steve English demonstrates how you can save a PowerPoint presentation in several editable file formats; such as .ppt; .ppsx; and .odp.

48144
Microsoft Powerpoint 2010: Shapes Josh Penzell

Microsoft PowerPoint 2010 lets you add shapes to your presentation. Using the Drawing feature; you can draw various shapes and link them using connectors. In this video; Josh Penzell demonstrates how to add a rectangle; oval; square; and circle to a slide and link them with elbow and curved connectors.

48117
Microsoft Powerpoint 2010: Share A Presentation Over The Internet Steve English

Microsoft PowerPoint 2010 enables you to broadcast your PowerPoint presentation to remote audience over the Internet in real time. In this video; Steve English demonstrates the steps to be followed for broadcasting a live slideshow over the Internet; so that users all over the world can watch it.

48152
Microsoft Powerpoint 2010: Slide Outlines Josh Penzell

In PowerPoint 2010; you can plan presentations by using the Outline feature. While creating the outline; you are also building the basic presentation. In this video; Josh Penzell demonstrates how you create an outline for a PowerPoint presentation.

48132
Microsoft Powerpoint 2010: Text Boxes Josh Penzell

Microsoft PowerPoint 2010 includes two types of text boxes. Text boxes can have a specific width and wrap text automatically; or they can automatically adjust their width as you enter text. In this video; Josh Penzell demonstrates how to create text boxes and change the text layout and appearance.

48124
Microsoft Powerpoint 2010: Transitions Versus Animations Josh Penzell

In Microsoft PowerPoint 2010; you can use animations instead of transitions to add effects to your presentation. With animations; you can add multiple effects to images on a single slide and control how the effects display. In this video; Josh Penzell demonstrates how to add and control animation effects on a single slide.

48116
Microsoft Powerpoint 2010: Turn The Mouse Into A Laser Pointer Steve English

Laser Pointer in Microsoft PowerPoint 2010 allows you to show specific items on the screen to your audience. In this video; Steve English shows you how to change the mouse on your computer into a laser pointer and highlight specific elements during your presentation.

48155
Microsoft Powerpoint 2010: Use Animation Painter Steve English

Animation Painter in Microsoft PowerPoint 2010 allows you to copy animation sequences from one slide to another without reprogramming. In this video; Steve English shows you how to copy-paste wipes; triggers; delays; and durations all with a single stroke of the paint brush.

48156
Microsoft Powerpoint 2010: Using Guides And Precision Josh Penzell

You can use gridlines and guides in Microsoft PowerPoint 2010 to align text and images to each other and to margins. In this video; Josh Penzell uses guides to align the objects on a slide.

48139
Microsoft Powerpoint 2010: Using Slide Sections Josh Penzell

In PowerPoint 2010; you can use slide sections to make it easier to manage groups of slides. In this video; Josh Penzell uses two slide sections to group slides and organize content in the slides.

48141
Microsoft Powerpoint 2010: Working With Graphics Josh Penzell

In Microsoft PowerPoint 2010; you can organize several images on a single slide. You can use the Arrange feature to change the order of images; and group images in a configuration. In this video; Josh Penzell uses the Arrange feature to organize images on a slide.

48113
Microsoft Powerpoint 2010: Working With Masters Josh Penzell

In Microsoft PowerPoint 2010; every presentation layout is associated with a master slide; which contains the default formatting; such as the font and bullet points. Any changes to the master slide are automatically applied to all the slides in the presentation. In this video; Josh Penzell demonstrates how to modify a master slide to make universal changes to a presentation.

48120
Microsoft Powerpoint 2010: Working With Text Josh Penzell

Microsoft PowerPoint 2010 includes a number of formatting options to emphasize headings and other text in a presentation. In this video; Josh Penzell demonstrates how to make text more presentable by using formatting such as character spacing and WordArt.

48125
Microsoft Powerpoint 2010: Quickly Access Recent Files Josh Penzell

There are various ways you can quickly access the presentations that were recently opened in PowerPoint 2010. In this video; Josh Penzell shows how to access recent presentations using the Start menu; a Windows 7 jump list; and PowerPoint’s File menu.

48135
Microsoft Powerpoint 2010: Insert Speaker Notes Steve English

Microsoft PowerPoint 2010 allows you to insert speaker notes below every slide and keep it hidden from the audience. In this video; Steve English discusses how to use speaker notes to talk to a live audience.

48142
Microsoft Powerpoint 2010: Inserting A Slide From Another Presentation Steve English

Microsoft PowerPoint 2010 enables you to move slides from one presentation to another; and the new slides automatically adopt the appearance of the presentation they’re moved to. In this video; Steve English uses two methods to insert slides from another presentation into his presentation.

47835
Microsoft Powerpoint 2010: Inserting A Video File Steve English

In Microsoft PowerPoint 2010; you can add various multimedia elements to a presentation. You can add a video file and then edit it by adjusting the color; for example. In this video; Steve English demonstrates how to add a video file to a slide and resize the video window.

47846
Microsoft Powerpoint 2010: Inserting An Audio File Steve English

Microsoft PowerPoint 2010 enables you to add sound to a presentation. You can add an audio clip; such as applause; to a slide and set the playback options. In this video; Steve English inserts an audio file and sets it to play automatically when the slide displays in the slide show.

47845
Microsoft Powerpoint 2010: Inserting An Excel Spreadsheet Steve English

In Microsoft PowerPoint 2010; you can insert Excel spreadsheets into a presentation in order to perform calculations. You can also customize the appearance of a spreadsheet on a slide. In this video; Steve English demonstrates how to add an Excel spreadsheet to a presentation.

47836
Microsoft Powerpoint 2010: Inserting Office Content Steve English

In Microsoft PowerPoint 2010; you can insert content from other Office applications; such as Word or Excel; into presentations either by linking or embedding. Linked content updates when the linked file changes; whereas embedded content remains static. In this video; Steve English uses the insert functions to link and embed content in a presentation.

47838
Microsoft Powerpoint 2010: Interactive Powerpoint Josh Penzell

You can add interactivity to a Microsoft PowerPoint 2010 presentation to make it more engaging for your attendees. In this video; Josh Penzell uses actions to add interactivity to a presentation.

48134
Microsoft Powerpoint 2010: Layouts And Slide Setup Josh Penzell

It’s a good idea to set up your slide deck before you create a presentation. Microsoft PowerPoint 2010 provides several slide layouts; depending on the content. You can also modify the size and orientation of a slide. In this video; Josh Penzell demonstrates how to choose slide layouts and modify the size and orientation of the slides in a presentation.

48123
Microsoft Powerpoint 2010: Making Use Of Hyperlinks Steve English

In Microsoft PowerPoint 2010 you can add hyperlinks to a presentation. You can use hyperlinks to navigate to slides in the same presentation; navigate to other files; or open web sites. In this video; Steve English demonstrates how to create a hyperlink and a Return action button to navigate between slides.

47834
Microsoft Powerpoint 2010: Making Use Of Screenshots Steve English

In Microsoft PowerPoint 2010; you can capture specific areas of your screen and add them to your presentation. You can use the Screenshot tool to capture another application; such as a Word document; or a portion of the current screen. In this video; Steve English uses the Screenshot tool to add a screenshot and a screen clipping to his presentation.

47840
Microsoft Powerpoint 2010: Making Use Of Smartart Steve English

You can use the SmartArt feature in Microsoft PowerPoint 2010 to visually convey concepts; such as hierarchies; processes; or cycles. In this video; Steve English demonstrates how to create a cycle graphic and add an animation.

47841
Microsoft Powerpoint 2010: Making Use Of Themes Steve English

Using themes in Microsoft PowerPoint 2010; you can add a set of fonts; colors; and backgrounds to give a presentation a professional appearance. You can choose from a selection of default themes; or you can create your own. In this video; Steve English applies a default theme to a basic presentation.

47844
Microsoft Powerpoint 2010: Making Use Of Transitions Steve English

Microsoft PowerPoint 2010 enables you to add various transitions and effects to slides to enhance a presentation. In this video; Steve English uses the Transition feature to add a transition to the first slide in a presentation.

47843
Microsoft Powerpoint 2010: Managing Views Josh Penzell

When you work with more than one presentation in Microsoft PowerPoint 2010; you can arrange the presentations side by side. There are also several ways in which you can view a presentation. In this video; Josh Penzell demonstrates how to manage windows and presentation views.

48122
Microsoft Powerpoint 2010: Manipulating Graphics Josh Penzell

In Microsoft PowerPoint 2010; you can manipulate images on slides to make them look their best. You can modify the color; brightness; saturation; and background; as well as the size and angle of an image. In this video; Josh Penzell uses the Format tools to manipulate an image on a slide.

48114
Microsoft Powerpoint 2010: Printing Presentations Josh Penzell

In PowerPoint 2010; you can print a slide deck in various formats and use these as hard copy notes or handouts. In this video; Josh Penzell demonstrates how you use printing options to specify which slides to print and how they should be printed.

48130
Microsoft Powerpoint 2010: Protect A Powerpoint Presentation Josh Penzell

You can protect a PowerPoint 2010 presentation from being changed or copied by unauthorized users. In this video; Josh Penzell demonstrates how you protect a presentation.

48129
Microsoft Powerpoint 2010: Protect A Presentation From Being Opened Steve English

Microsoft PowerPoint 2010 allows you to configure your PowerPoint presentation with password protection so that only users that you give the password to can open and read it. In this video; Steve English demonstrates how to choose a secure passphrase as your password and apply it to your presentation to prevent any unauthorized access.

48151
Microsoft Powerpoint 2010: Protect A Presentation From Editing Steve English

Microsoft PowerPoint 2010 allows you to configure your PowerPoint presentation so that users can open it and read it; but prevent them from editing it or making any changes to it. In this video; Steve English demonstrates how you can restrict other users edit or change your presentation by applying a password protection.

48150
Microsoft Powerpoint 2010: Handouts In Word Josh Penzell

Microsoft PowerPoint 2010 lets you send your presentation to Microsoft Word if you want to edit it before sharing it via printing or e-mailing. In this video; Josh Penzell demonstrates how to send a presentation to Word and then edit it.

48121
Microsoft Powerpoint 2010: Adding Charts Steve English

Microsoft PowerPoint 2010 enables you to display information in a visual format by adding charts to a presentation. In this video; Steve English demonstrates how to use the Insert Chart function to add a Column chart; enter chart data; and customize the appearance of the chart.

47833
Microsoft Powerpoint 2010: Adding Graphics Steve English

In Microsoft PowerPoint 2010; you can add graphics to a presentation to enhance it visually. In this video; Steve English demonstrates how to use the picture functions to insert a photo in a slide.

47837
Microsoft Powerpoint 2010: Advanced Protection Josh Penzell

You can use the advanced protection features of Microsoft PowerPoint 2010 to protect a presentation with a password and to certify yourself as the author. In this video; Josh Penzell password protects and certifies a presentation.

48140
Microsoft Powerpoint 2010: Beautifying Text Boxes Josh Penzell

Text boxes in PowerPoint 2010 can be customized and made into exciting visuals. For example; you can change the border and shape or use preset effects. In this video; Josh Penzell demonstrates how to customize a text box to help make a presentation stand out.

48127
Microsoft Powerpoint 2010: Best Practices Josh Penzell

There are various best practices available for making PowerPoint 2010 presentations more engaging and effective. In this video; Josh Penzell explains some basic rules to help avoid poor presentations.

48136
Microsoft Powerpoint 2010: Bullets And Numbered Lists Josh Penzell

In Microsoft PowerPoint 2010; you can use bulleted and numbered lists to present information concisely. You can customize bullet points by changing the bullet color and design; as well as using images. In this video; Josh Penzell demonstrates how to customize a bulleted list.

48126
Microsoft Powerpoint 2010: Choose Presentation Views Steve English

Microsoft PowerPoint 2010 allows you to choose from several different views for your presentation. In this video; Steve English discusses how to choose an appropriate view and navigate between slides and views.

48143
Microsoft Powerpoint 2010: Combine Shapes Steve English

The Combine Shapes tool in PowerPoint brings advanced graphics editing capabilities and enables you to create various interesting shapes. In this video; Steve English shows how you can insert different shapes on a PowerPoint slide and customize the way that shapes interact with each other using the Combine Shapes tool.

48153
Microsoft Powerpoint 2010: Combining And Comparing Presentations Josh Penzell

Microsoft PowerPoint 2010 lets you compare the changes that were made in copies of the original presentation. In this video; Josh Penzell demonstrates how to use the Compare feature to compare the changes made in a copy of a presentation.

48119
Microsoft Powerpoint 2010: Compress Pictures To Save File Size Steve English

Microsoft PowerPoint 2010 allows you to compress the images in a PowerPoint presentation to make the file size smaller and manageable. In this video; Steve English demonstrates how you can reduce the file size of a presentation containing a large number of slides; or images; or any other elements on the slides by compressing the pictures in it.

48145
Microsoft Powerpoint 2010: Constructing And Editing Photo Albums Josh Penzell

In PowerPoint 2010; the Photo Album feature is a time-saving way of converting a large number of image files into a presentation. Each image is placed on a separate slide by default. In this video; Josh Penzell demonstrates how you use this feature to create a presentation full of images.

48131
Microsoft Powerpoint 2010: Creating A Training Video Josh Penzell

You can export a PowerPoint 2010 presentation as a video so that audiences without PowerPoint can also view it. In this video; Josh Penzell saves a presentation as a training video.

48138
Microsoft Powerpoint 2010: Creating Custom Animations Josh Penzell

Using Microsoft PowerPoint 2010; you can create custom animations in your presentation. The advanced animation options allow you to stack animations together; alter the duration of an animation; and set an animation to repeat. In this video; Josh Penzell demonstrates how to combine animations and set the timing.

48115
Microsoft Powerpoint 2010: Creating Tables Steve English

You can add tables in Microsoft PowerPoint 2010 to visually organize data in a presentation. In this video; Steve English demonstrates how to create and modify a simple table.

47842
Microsoft Powerpoint 2010: Customizing A Slide Show Josh Penzell

You often need to adapt existing PowerPoint 2010 presentations for different audiences. Although you can do this by making multiple presentation files; it’s better to customize one file. In this video; Josh Penzell customizes a presentation without editing its slide deck.

48137
Microsoft Powerpoint 2010: Delivering Presentations Josh Penzell

In Microsoft PowerPoint 2010; you can use the Slide Show feature to set up and deliver presentations. You can set up the presentation to show full screen or in a window; depending on how you’re going to present the information. In this video; Josh Penzell demonstrates how to set up and deliver a presentation.

48118
Microsoft Powerpoint 2010: Export A Presentation As An Image File Steve English

Microsoft PowerPoint 2010 allows you to export the individual slides of a presentation to any of several graphic file formats. In this video; Steve English demonstrates how you can convert one or more slides of a PowerPoint presentation to image files such as JPEGs or TIFFs and create a new file without changing the original PowerPoint file.

48147
Microsoft Powerpoint 2010: Format Painter Josh Penzell

You can use the Format Painter to quickly apply a set of formatting options to a number of objects in Microsoft PowerPoint 2010. In this video; Josh Penzell uses the Format Painter to apply formatting to several slides.

48133
Project 2010 (30)
Title Speaker Summary ID
Microsoft Project 2010: Selecting A Base Calendar Erin Olsen

When creating accurate project schedules; you need to use calendars to specify the working hours. Microsoft Project 2010 provides various project calendar options; depending on whether the operating hours are 24/7; nightshift; or the traditional 9 to 5. In this video; Erin Olsen demonstrates how to set the calendar for a project.

48358
Microsoft Project 2010: Setting Project Baselines Erin Olsen

In Microsoft Project 2010; you can set baselines to assess whether projects are on time and on budget. You can create a baseline at the start of a project and create interim plans if the baseline has shifted. In this video; Erin Olsen demonstrates how to set the baseline and view a snapshot of the project’s current status.

48340
Microsoft Project 2010: Setting Project Properties Erin Olsen

In Microsoft Project 2010; you can set the project properties to create an accurate plan. You can specify whether you’re scheduling from the start or finish date; what that date is; and whether it’s based on a standard; 24-hour; or night shift calendar. In this video; Erin Olsen uses the project information to set the project start date.

48331
Microsoft Project 2010: Setting Task Dependencies Erin Olsen

Microsoft Project 2010 enables you to set task dependencies to show the relationship between tasks. You can set linked tasks to happen sequentially or concurrently; and add lag or lead time between linked tasks. In this video; Erin Olsen demonstrates how to set the Finish-to-Finish task dependency to show that two linked tasks must finish on the same day.

48336
Microsoft Project 2010: Starting A New Project Erin Olsen

In Microsoft Project 2010; you can use a blank project file; an existing project file; or a template to start a new project. You can use your own templates; or download a template from the Office web site. In this video; Erin Olsen demonstrates how to download a template to track an office move.

48329
Microsoft Project 2010: Updating Project Schedules Erin Olsen

Microsoft Project 2010 provides several tools you can use to update your projects as work is being done. This enables you to track progress and keep the schedule up to date. In this video; Erin Olsen demonstrates how to update a project.

48341
Microsoft Project 2010: Using Summary Tasks And Milestones Erin Olsen

Microsoft Project 2010 enables you to outline a task list to make it more manageable. You can create subtasks and milestones for each phase; and a project summary task to show a project’s total duration. In this video; Erin Olsen demonstrates how to create subtasks; a milestone for the first phase of the project; and a project summary task.

48334
Microsoft Project 2010: Viewing Project Reports Erin Olsen

Microsoft Project 2010 lets you create hard copy reports to communicate and document project information. This is useful if you want to share information with stakeholders; for example. In this video; Erin Olsen demonstrates how to locate and display some reports.

48343
Microsoft Project 2010: Converting An Excel Worksheet Into A List Erin Olsen

Microsoft Project 2010 enables you to import data from another data source; such as an Excel workbook; to an existing Project file. You use the Import wizard to map the data to the fields in the Project file. In this video; Erin Olsen uses the Import wizard to import data from an Excel workbook to a resource sheet.

48330
Microsoft Project 2010: Creating A Resource Calendar Erin Olsen

Microsoft Project 2010 enables you to create resource calendars; so that Project can calculate when resources will be available to complete tasks. You can create a new base calendar or adapt an existing calendar for a resource; such as a part-time employee. In this video; Erin Olsen uses the Resource Calendar feature to create a resource calendar for the Marketing Department.

48332
Microsoft Project 2010: Creating A Resource Pool Erin Olsen

Microsoft Project 2010 lets you create a resource pool; which is a standalone Project file that captures all the resources involved in a project. When you create a new project using the same resources; you don’t have to re-enter all the information. In this video; Erin Olsen demonstrates how to create a resource pool.

48345
Microsoft Project 2010: Creating Custom Wbs Codes Erin Olsen

In Microsoft Project 2010; you can define work breakdown structure (WBS) codes to create a customized numbering scheme. WBS codes are applied at a project level and can be displayed in the Gantt view. In this video; Erin Olsen uses the WBS code feature to create custom WBS codes for each of the tasks of a task list.

48335
Microsoft Project 2010: Designating Milestones Erin Olsen

Microsoft Project 2010 lets you add milestones to your projects to identify when a specific deliverable is complete or when the end of a phase has been reached. In this video; Erin Olsen demonstrates two ways of adding milestones to a project.

48346
Microsoft Project 2010: Displaying Project Columns Erin Olsen

In Microsoft Project 2010; a project includes numerous fields; such as start date and finish date; which are not automatically displayed in Gantt Chart view. In this video; Erin Olsen demonstrates how to display more fields in Project.

48347
Microsoft Project 2010: Displaying Visual Reports Erin Olsen

Microsoft Project 2010 lets you create charts and graphs of your project information to share the content in a manner that’s easily understandable. You can launch visual Excel or Visio reports from within Project. In this video; Erin Olsen demonstrates how she creates an Excel PivotChart to visually represent her Project information.

48348
Microsoft Project 2010: Entering Material Resources Erin Olsen

When setting up a project; you need to specify material resources; such as supplies and ingredients. In Microsoft Project 2010; you can keep track of the cost of the material resources; when they should be purchased; and when they will be used. In this video; Erin Olsen demonstrates how to insert material resources into the resource sheet of a project.

48349
Microsoft Project 2010: Entering Tasks Erin Olsen

One of the first activities required when creating a new project is to enter tasks. Microsoft Project 2010 provides various ways for you to quickly and easily enter task information into a Project file. In this case; Erin Olsen demonstrates two ways to enter tasks and their durations into a Project file.

48350
Microsoft Project 2010: Entering Work Resources Erin Olsen

Resources; such as people or equipment; are what you need to complete the tasks in a project. In this video; Erin Olsen demonstrates how to enter information in Microsoft Project 2010 to properly allocate resources; as well as scheduling and costing the project.

48351
Microsoft Project 2010: Filtering Project Lists Erin Olsen

Filtering information is one of the most useful ways of managing data so that you can work with information that’s relevant at a time. In this video; Erin Olsen demonstrates how to manage information in Microsoft Project 2010 using the in-column and Ribbon filters.

48352
Microsoft Project 2010: Grouping Project Lists Erin Olsen

Grouping in Microsoft Project 2010 allows you to group related data and expand and collapse entries as you require. It also summarizes entries to make it easier to analyze project information. In this video; Erin Olsen demonstrates how the Group feature works for simplifying a list of resource entries.

48353
Microsoft Project 2010: Indicating Lead And Lag Time Erin Olsen

Lead and lag times are important for designating delays between tasks in a project schedule. Using this option in Microsoft Project 2010; you can indicate whether a successor task can start only before or after the completion of a predecessor task. In this video; Erin Olsen demonstrates how to add lag time to a project schedule.

48354
Microsoft Project 2010: Leveraging A Resource Pool Erin Olsen

Resource pools in Microsoft Project 2010 enable you to share a set of resources between projects. You can use an existing file as a resource pool; and link the resource pool file and your new file. In this video; Erin Olsen uses the Share Resources feature to leverage a resource pool and link the resource file to a new file.

48338
Microsoft Project 2010: Modifying Resource Costs Erin Olsen

It’s important to keep the resource costs in Microsoft Project 2010 up to date. You can use cost tables to modify cost variations; such as overtime rates or rates for different types of work. In this video; Erin Olsen demonstrates how to create cost tables and apply them to a resource.

48339
Microsoft Project 2010: Modifying The Timescale Erin Olsen

Microsoft Project 2010’s timescale determines how a project timeline displays; from very detailed to an overview. In this video; Erin Olsen demonstrates the various tools you can use to change the timescale so it shows exactly the amount of detail required.

48355
Microsoft Project 2010: Organizing A Task List Erin Olsen

To create an accurate schedule in Microsoft Project 2010; you need to organize the tasks in terms of how long each task is going to take and how they relate to one another. In this video; Erin Olsen demonstrates how to set the task durations; order tasks; and link related tasks in a project.

48333
Microsoft Project 2010: Performing Simple Sorts Erin Olsen

Microsoft Project 2010 allows you to easily sort tasks and resources without making any permanent changes to the project. In this video; Erin Olsen demonstrates how to perform simple sorts using in-column drop-downs and the Ribbon.

48356
Microsoft Project 2010: Saving Project Templates Erin Olsen

If you tend to do similar types of projects repeatedly; you can create a project template to reuse a lot of the same information for subsequent projects. In this video; Erin Olsen demonstrates how to create a project template in Microsoft Project 2010 and how to access it again.

48357
Microsoft Project 2010: Constraining Tasks Erin Olsen

In Microsoft Project 2010; you can apply constraints to tasks; such as specifying that tasks can’t be done after a certain date. You can apply flexible or inflexible constraints and view conflicts created in the schedule. In this video; Erin Olsen demonstrates how to apply a constraint to ensure a task is finalized no later than a given date.

48337
Microsoft Project 2010: Adding Subprojects Erin Olsen

Microsoft Project 2010 lets you create a master project when you work with a complex project consisting of multiple resources; locations; or departments. A master project consists of several subprojects; which are standalone Project files. In this video; Erin Olsen demonstrates how to add subprojects to a master project.

48344
Microsoft Project 2010: Applying Work Contours Erin Olsen

Microsoft Project 2010 provides the Work Contour feature to enable you to schedule more accurately by varying the number of hours per day assigned to a particular task over the duration of the task. In this video; Erin Olsen demonstrates how to use the Contour feature to change the default even distribution of work over time.

48342
SharePoint 2010 (47)
Title Speaker Summary ID
Microsoft Sharepoint 2010: Play Your Media Assets David Santana

Microsoft SharePoint 2010 allows you to play media assets from the asset library. In this video; David Santana demonstrates how to correct content type and play media files.

48278
Microsoft Sharepoint 2010: Record Declaration Settings David Santana

Record declaration settings in Microsoft SharePoint 2010 allow you control over where items can be declared as records. In this video; David Santana demonstrates how to configure record declaration settings and allow users to manually declare items as records.

48303
Microsoft Sharepoint 2010: Recycle Bin David Santana

The Recycle Bin in Microsoft SharePoint 2010 allows you to recover documents accidentally deleted. In this video; David Santana demonstrates how to view and restore deleted items.

48274
Microsoft Sharepoint 2010: Reusable Content David Santana

Reusable Content in Microsoft SharePoint 2010 allows you to configure and reuse specific content in site pages. In this video; David Santana demonstrates how to add an item to the Reusable Content list and then add it to a page.

50640
Microsoft Sharepoint 2010: Ribbon David Santana

The Ribbon; the new user interface in Microsoft SharePoint 2010; allows you easy access to the most commonly used tools; controls; and commands. In this video; David Santana demonstrates how to edit a page by going to the specific Ribbon.

48269
Microsoft Sharepoint 2010: Shared Documents David Santana

Shared Documents in Microsoft SharePoint 2010 allow you to create; upload; and share documents with your team. In this video; David Santana shows how to use the Office Web Apps to create a new document and where to find cool features such as RSS Feed and SharePoint Designer.

48271
Microsoft Sharepoint 2010: Site Actions David Santana

Site Actions in Microsoft SharePoint 2010 allows you different options for the site. In this video; David Santana discusses the new options available in SharePoint 2010 and what each option does.

48268
Microsoft Sharepoint 2010: Turn On Versioning And Content Approval David Santana

Microsoft SharePoint 2010 allows you to enable versioning and content approval. In this video; David Santana demonstrates how to turn on these two tasks.

48293
Microsoft Sharepoint 2010: Ui Enhancements David Santana

User interface enhancements have made Microsoft SharePoint 2010 more accessible to users. In this video; David Santana explains the various options on the interface and how to use them.

48270
Microsoft Sharepoint 2010: Upload Media Assets David Santana

Microsoft SharePoint 2010 allows you to upload media assets. In this video; David Santana demonstrates how to drag and drop media files from the Desktop and upload to the media asset library.

48277
Microsoft Sharepoint 2010: User Profile Sync Service David Santana

The User Profile Synchronization Service in Microsoft SharePoint 2010 enables synchronization of user and group data. In this video; David Santana demonstrates how to start; check progress; and complete enabling the service.

48300
Microsoft Sharepoint 2010: Using The Grid View David Santana

The grid view in Microsoft SharePoint 2010 allows you to display all site-related data within a site collection. In this video; David Santana demonstrates how to easily insert a command to report in grid view.

48298
Microsoft Sharepoint 2010: Validating The Snap-in Via Sharepoint Management Shell David Santana

Validating the Snap-in via SharePoint Management Shell is integral to Microsoft SharePoint 2010. In this video; David Santana demonstrates how to add the PSSnapin to the SharePoint Management Shell.

48292
Microsoft Sharepoint 2010: Web Part Properties Options David Santana

Web Part Properties; a new feature in Microsoft SharePoint 2010; allows you to edit and customize web parts quickly and easily. In this video; David Santana demonstrates how to enhance the user experience with the AJAX options.

48272
Microsoft Sharepoint 2010: Permission Finder David Santana

Microsoft SharePoint 2010 allows you to find the permission levels assigned to users or groups. In this video; David Santana demonstrates how to set up and verify permissions for a document.

48304
Microsoft Sharepoint 2010: Multi Document Actions David Santana

Microsoft SharePoint 2010 allows you to perform multi-document actions. In this video; David Santana demonstrates how to manage a document set by creating specific set actions.

48280
Microsoft Sharepoint 2010: Peoples And Groups David Santana

Users and groups in Microsoft SharePoint 2010 are defined at the site collection. In this video; David Santana shows you how to find users and groups and review permissions.

48273
Microsoft Sharepoint 2010: Create An Asset Library David Santana

The asset library in Microsoft SharePoint 2010 allows you to upload and share media-rich content. In this video; David Santana demonstrates how to create an asset library to store media.

48276
Microsoft Sharepoint 2010: Create My Site Web App David Santana

Creating a My Site web app; a social networking feature; in Microsoft SharePoint 2010 is an important task. In this video; David Santana demonstrates how to log into a configuration store and set up a My Site application.

50682
Microsoft Sharepoint 2010: Create Visio Process Repository David Santana

A Visio Process Repository in Microsoft SharePoint 2010 allows you to make your process diagrams available for collaboration and quick updating. In this video; David Santana demonstrates how to set up a Visio Repository for a Visio file.

48307
Microsoft Sharepoint 2010: Creating User Profile Service App David Santana

The User Profile Service app in Microsoft SharePoint 2010 provides a central location for configuring and managing the personalization settings. In this video; David Santana demonstrates how to configure the User Profile Service application.

48299
Microsoft Sharepoint 2010: Document Id Services David Santana

The document ID feature in Microsoft SharePoint 2010 allows you to assign document IDs. In this video; David Santana demonstrates how to create and reset document IDs in the site collection.

48288
Microsoft Sharepoint 2010: Document Set Settings David Santana

Document set settings in Microsoft SharePoint 2010 allow you to manage content as a single unit. In this video; David Santana demonstrates how to configure new advanced settings.

48282
Microsoft Sharepoint 2010: Editing The Main Default Aspx Page David Santana

Microsoft SharePoint 2010 allows you to edit the main default ASPX page. In this video; David Santana demonstrates how to edit and publish your Adventure Works site page.

50639
Microsoft Sharepoint 2010: Enable All Of The Site Collection Features David Santana

Microsoft SharePoint 2010 allows a power user to activate features to allow for list and documents sets to be created. In this video; David Santana demonstrates how to enable specific features.

48279
Microsoft Sharepoint 2010: Explore A Publishing Site David Santana

Publishing a publishing site in Microsoft SharePoint 2010 is an important task. In this video; David Santana demonstrates how to explore a publishing site and explains how it is different from an intranet corporate site.

48308
Microsoft Sharepoint 2010: Explore Basic Team Site David Santana

Exploring the basic team site in Microsoft SharePoint 2010 helps you in creating a site collection. In this video; David Santana demonstrates how to explore a basic team site to understand its layout and content.

48266
Microsoft Sharepoint 2010: Forefront Identity Manager Service David Santana

The Forefront Identity Manager Service in Microsoft SharePoint 2010 allows you to manage users’ digital identities; credentials; and groupings throughout the lifecycle of their membership of an enterprise computer system. In this video; David Santana demonstrates how to verify that the service is installed.

48301
Microsoft Sharepoint 2010: Generate A File Plan Report David Santana

Generating a file plan report in Microsoft SharePoint 2010 allows you to list the records in your organization and show the purpose; use; and subject content of the records. In this video; David Santana demonstrates how to create a file plan report for your organization.

48302
Microsoft Sharepoint 2010: List Level Validation David Santana

Microsoft SharePoint 2010 allows you to validate lists by using formulas. In this video; David Santana demonstrates how to set validation to a list.

48285
Microsoft Sharepoint 2010: Login/logout David Santana

The login and logout functions in Microsoft SharePoint 2010 allow you to sign in and out of your site. In this video; David Santana shows you where to find the login logout function in SharePoint 2010 and how to sign in as a different user.

48275
Microsoft Sharepoint 2010: Manage Content And Structure David Santana

Managing content and structure in Microsoft SharePoint 2010 is an important task. In this video; David Santana demonstrates how to access the useful features in a publishing site collection.

48309
Microsoft Sharepoint 2010: Metadata Navigation David Santana

Navigating metadata in Microsoft SharePoint 2010 is useful for filtering and finding content. In this video; David Santana demonstrates how to create metadata navigation and use hierarchy to filter the list of items displayed.

48295
Microsoft Sharepoint 2010: Modify Site Schedule David Santana

Microsoft SharePoint 2010 allows you to modify the schedule of your sites. In this video; David Santana demonstrates how to configure the publishing date and time of a site.

50641
Microsoft Sharepoint 2010: Create A Site Page David Santana

Microsoft SharePoint 2010 allows you to create and edit site pages. In this video; David Santana demonstrates how to create a new page in the SharePoint Team Site.

48267
Microsoft Sharepoint 2010: Add Resources In Site Pages David Santana

Adding resources in site pages in Microsoft SharePoint 2010 allows site users to see the resource availability when they visit the page. In this video; David Santana demonstrates how to create a resource configuration.

48306
Microsoft Sharepoint 2010: Adding Sharepoint Snap-in Using Add-pssnapin Cmdlet David Santana

Microsoft SharePoint 2010 allows you to add cmdlets to the SharePoint Snap-In and extend the PowerShell. In this video; David Santana demonstrates how to add to Snap-In using the add-PSSnapin cmdlet.

48291
Microsoft Sharepoint 2010: Advanced Settings Document Content Types David Santana

Microsoft SharePoint 2010 allows you to configure document set settings in a document set content type and apply advanced settings. In this video; David Santana demonstrates how to provision a new document content type legal set through advanced settings.

48283
Microsoft Sharepoint 2010: Audience Targeting David Santana

Microsoft SharePoint 2010 allows you to define audiences and content relevant to a user or a group. In this video; David Santana demonstrates how to define audience for a specific group.

48287
Microsoft Sharepoint 2010: Column Level Validation David Santana

Microsoft SharePoint 2010 allows you to easily enforce column-level validation. In this video; David Santana demonstrates how to apply a validation formula at the column level.

48284
Microsoft Sharepoint 2010: Content Rating David Santana

Microsoft SharePoint 2010 allows you to enable content rating and assist users determine the quality of content. In this video; David Santana demonstrates how to add star ratings column to a list.

48286
Microsoft Sharepoint 2010: Create A Document Set David Santana

Microsoft SharePoint 2010 allows you to create and configure the document set content type. In this video; David Santana demonstrates how to create new site content type.

48281
Microsoft Sharepoint 2010: Create A Group Worksite David Santana

A group worksite in Microsoft SharePoint 2010 allows you to track people and resources. In this video; David Santana demonstrates how to set up a group worksite.

48305
Microsoft Sharepoint 2010: Create A Publishing Site Page David Santana

Creating a publishing site page in Microsoft SharePoint 2010 is an integral part in the content of the site. In this video; David Santana demonstrates how to publish a site page in site collections.

48294
Microsoft Sharepoint 2010: Create A Search Center David Santana

A search center in Microsoft SharePoint 2010 allows you an interface to submit search queries and view search results. In this video; David Santana demonstrates how to create a search center site using the Enterprise Search Center template.

50683
Microsoft Sharepoint 2010: Create A Site Collection David Santana

Creating a site collection in Microsoft SharePoint 2010 is a prerequisite to creating a site. In this video; David Santana demonstrates how to create a new top-level website for your team.

48265
Microsoft Sharepoint 2010: Create A Site Collection In A Specific Database David Santana

Microsoft SharePoint 2010 allows you to create a site collection in a specific database and share data with other site users. In this video; David Santana demonstrates how to create a team site with its own content database.

48289
Visio 2010 (8)
Title Speaker Summary ID
Microsoft Visio: Simplifying Organization Chart Creation With The Org. Chart Wizard Erin Olsen

Microsoft Visio 2010 provides the Org. Chart Wizard to enable you to quickly and easily create an organizational chart. The wizard automates and simplifies the process. In this video; Erin Olsen demonstrates how to use the Org. Chart Wizard to create an organizational chart from an Excel worksheet.

48419
Microsoft Visio: Using Visio’s Reviewing Tools Erin Olsen

The Review tab in Microsoft Visio 2010 provides several helpful review functions to help you collaborate with others on a document. You can annotate comments and suggestions directly in the document; keeping everything in one location. In this video; Erin Olsen demonstrates how to use the comments and markup features.

48423
Microsoft Visio: Working With Hyperlinks Erin Olsen

Microsoft Visio 2010 allows you to create hyperlinks to easily navigate to information. You can add a hyperlink to a web site; an external file; or another shape in the same diagram. In this video; Erin Olsen demonstrates how to create a hyperlink to an Excel file.

48422
Microsoft Visio: Creating Shapes And Stencils Erin Olsen

In Microsoft Visio 2010; you can create custom shapes; add them to custom stencils; and save them for reuse; so that you don’t have to create them from scratch each time. In this video; Erin Olsen demonstrates how to create a custom stencil using a custom shape.

49300
Microsoft Visio: Customizing Theme Effects Erin Olsen

Microsoft Visio 2010 lets you customize theme colors; fonts; and special effects and apply them to a diagram. In this video; Erin Olsen demonstrates how to customize the effects in a diagram.

48421
Microsoft Visio: Formatting And Customizing Diagrams Erin Olsen

You can use built-in themes and other design elements provided by Microsoft Visio 2010 to create professional diagrams that suit your business or personal requirements. In this video; Erin Olsen demonstrates how to use Visio’s design elements to add a theme; background; and title to a diagram.

48420
Microsoft Visio: Saving Visio Diagrams As Graphics Erin Olsen

You can convert your Microsoft Visio 2010 drawings into graphics for a more usable format. You can convert drawings; or sections of a drawing; into different graphics formats; such as scalable vector graphics; AutoCAD drawings; GIFs; JPEGs; and PNGs. In this video; Erin Olsen demonstrates how to convert a drawing into JPEG and PNG graphics.

48425
Microsoft Visio: Sharing Visio Diagrams Via E-mail Erin Olsen

You can use the Save and Send options in Microsoft Visio 2010 to share your files via e-mail. In this video; Erin Olsen demonstrates how to send a Visio diagram in various formats via e-mail.

48424
Word 2010 (60)
Title Speaker Summary ID
Microsoft Word 2010: Use Word To Take A Screenshot Steve English

The Screenshot function in Microsoft Word 2010 allows you to define and capture an area of the screen and place it in your document as an image. In this video; Steve English shows how this feature can save you time on typing and formatting the information you find on the web; such as the contact information of your company.

47914
Microsoft Word 2010: Wrap Text Steve English

The Wrap Text function in Microsoft Word 2010 allows you to decide how you want the text to flow around a picture in the document. In this video; Steve English demonstrates how to insert and wrap text around a picture and use the various wrap text options.

47895
Microsoft Word 2010: Zoom In And Out Steve English

In Microsoft Word 2010; you can modify the zoom magnification that displays on-screen. Zooming in shows the page elements in greater detail and zooming out shows a lot of pages at once. In this video; Steve English shows how you can resize your document using Zoom In or Zoom Out.

47905
Microsoft Word 2010: Insert An Endnote Steve English

Microsoft Word 2010 allows you to insert footnotes and endnotes in a document to hold notes or citations that are referred to in the text. In this video; Steve English discusses both citation styles and shows how to insert an endnote in your document.

47899
Microsoft Word 2010: Insert And Delete Table Rows And Columns Steve English

Adding and deleting columns and rows is easy in Microsoft Word 2010. In this video; Steve English demonstrates how to work with the right-click context menu when doing multiple additions and deletions.

47880
Microsoft Word 2010: Insert Building Blocks Steve English

Building Blocks in Microsoft Word 2010 allows you to pre-save Word elements; such as snippets of text and images. In this video; Steve English shows you how to pull a building block from the Building Blocks library and apply to a document.

47912
Microsoft Word 2010: Insert Clip Art Steve English

Clip Art in Microsoft Word 2010 allows you to make your documents visually appealing by inserting illustrations; photographs; or other media. In this video; Steve English shows you how to use Clip Art to draw the reader’s eye to specific information.

47916
Microsoft Word 2010: Insert Columns Steve English

Inserting columns in Microsoft Word 2010 allows your page to look more like a newspaper or magazine article while adding more white space and making it easier for readers to track. In this video; Steve English shows you how to create columns on a page with a banner headline.

47913
Microsoft Word 2010: Insert Headers And Footers Steve English

Microsoft Word 2010 allows you to insert headers and footers in your document to display repetitive information; such as chapter titles and page numbers. In this video; Steve English demonstrates how to use the header and footer tools to have a different first page and also different odd and even pages; such as in a book.

47911
Microsoft Word 2010: Inserting A Table Of Contents Steve English

In Microsoft Word 2010; you can add a table of contents to a document that has headings and subheadings; and then update and customize it as required. In this video; Steve English demonstrates how he adds a table of contents to a document.

47806
Microsoft Word 2010: Link Or Embed An Excel Table Steve English

Microsoft Word 2010 allows you to import an Excel table in two ways: linking and embedding. In this video; Steve English explains the difference between these two methods and shows how to link an Excel table to a Word document and keep the information updated.

47884
Microsoft Word 2010: Merge And Split Table Cells Steve English

Merging and splitting cells in Microsoft Word 2010 allows you to enhance the format of a table and accurately represent the data in it. In this video; Steve English shows how to change the structure of a table by merging and splitting cells.

47881
Microsoft Word 2010: Populating Headers And Footers Steve English

Microsoft Word 2010 allows you to add headers and footers to documents. You can customize their appearance by applying a design style as well as including graphics and page numbers. In this video; Steve English demonstrates how to add and format a header and footer.

47809
Microsoft Word 2010: Print A Document Steve English

Microsoft Word 2010 allows you to choose and select from a range of print properties and settings. In this video; Steve English explores each of them and shows how to preview the results before you print.

47897
Microsoft Word 2010: Recording A Macro Steve English

Microsoft Word 2010 lets you record macros for actions you perform regularly. Macros allow you to link a set of commands to a shortcut key so that you can simply enter the shortcut key when you need to perform the set of commands. In this video; Steve English demonstrates how to record a macro.

47810
Microsoft Word 2010: Restrict Editing Steve English

Microsoft Word 2010 allows you to set restrictions on the types of edits that other users can perform on your document. In this video; Steve English shows you how to restrict editing in a document so that the reviewers can read it but can’t change it.

47903
Microsoft Word 2010: Reviewing A Document Steve English

When you’re reviewing a document; Microsoft Word 2010 enables you to mark up your edits using track changes and to insert comments. In this video; Steve English uses the Track Changes feature to review text; and the Comments feature to add and delete a comment in a document.

47814
Microsoft Word 2010: Save A Word Document Steve English

The Save As feature of Microsoft Word 2010 allows you to save your files in the format and location that you want. In this video; Steve English explores the various formats available and the purpose each one serves.

47877
Microsoft Word 2010: Sort A Table Steve English

The Sort function in Microsoft Word 2010 allows you to sort content by columns and in ascending and descending orders. In this video; Steve English shows how to sort a table with a header row.

47882
Microsoft Word 2010: Undo And Redo Steve English

The Undo and Redo commands in the Quick Access Toolbar of Microsoft Word 2010 are useful for correcting the mistakes you make while editing your document. In this video; Steve English explains how you can use these commands to step back and forth through a series of changes.

47873
Microsoft Word 2010: Use The Format Painter Steve English

The Format Painter in Microsoft Word 2010 allows you to copy a text format and apply it in multiple places in a document. In this video; Steve English demonstrates how the Format Painter can apply numerous formatting changes spread across various groups in the Home and Page Layout tabs with a single stroke.

47915
Microsoft Word 2010: Use The Navigation Pane Steve English

The Navigation Pane in Microsoft Word 2010 allows you to move around in your document and locate Word objects and document elements. In this video; Steve English explains how to use this feature to display all instances that match your search and navigate directly to a particular instance.

47874
Microsoft Word 2010: Insert A Picture Steve English

Microsoft Word 2010 allows you to insert pictures into your document to compliment the text and make your document more visually appealing. In this video; Steve English demonstrates how to add a picture and reconfigure it to fit your space and needs.

47893
Microsoft Word 2010: Create An Excel Table Steve English

Creating an Excel table in Microsoft Word 2010 allows you to bring Excel’s power of complicated computing to your Word document. In this video; Steve English demonstrates how to insert an Excel table in a Word document without ever exiting Word.

47883
Microsoft Word 2010: Create Bulleted Lists Steve English

Microsoft Word 2010 allows you to bullet list items to show that they are all of the same weight and importance. In this video; Steve English explains how bulleting is different from numbering and shows how to bullet; preview bullet styles; and check for appropriateness of the format.

47910
Microsoft Word 2010: Create Numbered Lists Steve English

Microsoft Word 2010 makes creating and formatting numbered lists easy. Numbered lists are useful when you want to itemize and set off text. In this video; Steve English shows how to create a list with levels and choose a suitable number format and style.

47909
Microsoft Word 2010: Creating A Building Block Steve English

Building blocks in Microsoft Word 2010 are a convenient way to re-use saved blocks of text or graphics in multiple documents. In this video; Steve English demonstrates how to create a building block of his company logo and then to use it.

47804
Microsoft Word 2010: Creating Charts Steve English

Charts in Microsoft Word 2010 are useful for showing table data in a visual format; such as a graph. In this video; Steve English uses the Chart feature to create a bar chart from a table of data and edit the appearance of the bar chart using different layouts.

47805
Microsoft Word 2010: Creating Cross References Steve English

The cross reference tool provided by Microsoft Word 2010 allows you to replace text that may change; such as figures or bookmarks; with a field that is easy to update. In this video; Steve English demonstrates how he creates a cross reference for a figure in a document.

47807
Microsoft Word 2010: Crop A Picture Steve English

The Crop function in Microsoft Word 2010 allows you to trim off areas of a picture that you do not need; such as the expanse of the sky. In this video; Steve English demonstrates how to remove unwanted details from a picture to focus the reader’s eye more on the subject.

47894
Microsoft Word 2010: Customize Footnotes Steve English

Microsoft Word 2010 allows you to customize the way footnotes are numbered in a document. In this video; Steve English discusses the various ways in which footnotes can be referenced and provides an overview of the number formats; numbering schemes; and apply changes to options available.

47900
Microsoft Word 2010: Customize The Ribbon Steve English

In Microsoft Word 2010; you can customize the tabs and groups on the Ribbon to suit your requirements. You can hide default tabs on the Ribbon; or add and delete commands on the Ribbon and Quick Access toolbar. In this video; Steve English demonstrates how he customizes the Ribbon and Quick Access toolbar by hiding and adding items.

47808
Microsoft Word 2010: Cut; Copy; And Delete Steve English

The Cut; Copy; and Delete commands in Microsoft Word 2010 allow you to move or remove content. In this video; Steve English explains how each is different from the other and is useful in moving content within and across documents.

47872
Microsoft Word 2010: Find And Replace Steve English

Find and Replace in Microsoft Word 2010 is useful for finding and replacing specific strings of text. In this video; Steve English shows you how to do a find and replace and how to undo any unwanted changes both from the Navigation Pane and from the Ribbon.

47875
Microsoft Word 2010: Format The Font Steve English

Understanding the various text font options offered by Microsoft Word 2010 helps you apply them effectively. In this video; Steve English demonstrates how to preview; customize; and create your own text font specifications.

47885
Microsoft Word 2010: Format With The Mini Toolbar Steve English

The Mini Toolbar in Microsoft Word 2010 saves you time on navigating around format buttons. In this video; Steve English shows how to use the Mini Toolbar to set font size and color; indent; align; and highlight your text from any place in the document.

47892
Microsoft Word 2010: Get Help Steve English

The Help function in Microsoft Word 2010 is useful in finding information on specific features and operations. In this video; Steve English explains how to use this feature to draw on the vast store of resources available on your computer and on numerous online resources.

47876
Microsoft Word 2010: How To Create Paragraph Styles Steve English

Microsoft Word 2010 includes a collection of style sets designed to work together to achieve the same look and feel in a document. You can use styles sets to quickly format paragraphs. In this video; Steve English demonstrates how to apply a style set to a title; subtitle; and heading; modify a default style; and create a new style.

47816
Microsoft Word 2010: How To Use Mail Merge Steve English

Microsoft Word 2010 enables you to create a large number of documents that are mostly identical but include some unique information. You can use the Mail Merge feature to import information from a data source into a document. In this video; Steve English personalizes a letter; by importing each client’s name and contact information from an Excel worksheet.

47812
Microsoft Word 2010: How To Use Section Breaks Steve English

In Microsoft Word 2010; you can add section breaks to apply different formatting to different sections of a document. In this video; Steve English uses the Section Break feature to create sections; alter the header and page number on the Table of Contents page; and add a field to the header to automatically display the heading for each section.

47815
Microsoft Word 2010: How To Use Templates Steve English

Microsoft Word 2010 includes templates that are formatted for a specific task. Some templates are installed on your hard-drive when you install Word; and others are available from the Office web site. You can use these templates as the basis for new documents. In this video; Steve English uses a template to create and modify a fax cover sheet.

47817
Microsoft Word 2010: Indent Text Steve English

Inserting indents in Microsoft Word 2010 is useful for setting the edges of a paragraph differently from the edges of the page margin; such as in a bibliography. In this video; Steve English demonstrates how to insert indents from the Ruler; from the Paragraph group in the Home tab; and from the Paragraph dialog box.

47887
Microsoft Word 2010: Insert A Footnote Steve English

Microsoft Word 2010 allows you to insert footnotes and endnotes in a document to hold notes or citations that are referred to in the text. In this video; Steve English discusses both citation styles and shows how to insert a footnote in your document.

47898
Microsoft Word 2010: Adding Page Breaks Steve English

In Microsoft Word 2010; you can add page breaks to ensure that elements; such as headings; appear consistently at the top of the next page in a document. In this video; Steve English inserts a page break between the Table of Contents and the heading of the next paragraph; and includes a page break in a heading style.

47813
Microsoft Word 2010: Adding Watermarks Steve English

The Watermark feature in Microsoft Word 2010 enables you to display transparent text or graphics behind the printed text in a document. You can have it appear on the background of every page or in specific sections. In this video; Steve English uses the Watermark feature to add a watermark to a draft copy of a document.

47818
Microsoft Word 2010: Adjust Spacing Steve English

Microsoft Word 2010 allows you to adjust the spacing for a paragraph not just within the paragraph but also between paragraphs. In this video; Steve English demonstrates how to apply space change to several paragraphs and have precise control.

47896
Microsoft Word 2010: Apply A Border Steve English

In Microsoft Word 2010; you can apply a page border to your document and make it more visually appealing. In this video; Steve English demonstrates how you can apply different styles; add color; and set the thickness of page borders in a document.

47907
Microsoft Word 2010: Apply Page Color Steve English

Microsoft Word 2010 enables you to apply color to your pages and make them look pleasant and attractive. This feature is very useful when you’re designing a brochure or a flyer. In this video; Steve English demonstrates how you can apply colors to a page to give your document a color background.

47908
Microsoft Word 2010: Apply Styles To A Table Steve English

Applying styles to tables in Microsoft Word 2010 saves you time and effort on formatting. In this video; Steve English uses predefined styles to give an unimaginative black and white table a visually appealing design.

47879
Microsoft Word 2010: Autocorrect And Autotext Functions Steve English

Microsoft Word 2010 provides the AutoCorrect feature; which automatically corrects your spelling errors as you type. You can also modify AutoCorrect to suit your needs. In this video; Steve English demonstrates how to add a propriety term to AutoCorrect.

47811
Microsoft Word 2010: Change Autosave Settings Steve English

Microsoft Word 2010 creates an automatic backup of your documents and also allows you to configure the AutoSave options. In this video; Steve English shows how you can change the AutoSave settings and set the AutoSave Interval to avoid the risk of losing your work.

47906
Microsoft Word 2010: Change Footnotes To Endnotes Steve English

Microsoft Word 2010 allows you to quickly and easily change your citation style. You can reposition your notes from the foot of a page to the end of the document and vice-versa. In this video; Steve English demonstrates how to convert footnotes to endnotes and endnotes to footnotes using the right-click menu.

47901
Microsoft Word 2010: Change Footnotes To Endnotes Separator Steve English

Microsoft Word 2010 inserts a default 2-inch separator line while inserting footnotes or endnotes in a document. You can delete this separator line or alter it into a longer line; double-line; or shape. In this video; Steve English demonstrates how to access the separator line; change the document view; and make modifications to it.

47902
Microsoft Word 2010: Change Margins Steve English

Microsoft Word 2010 allows you to change the size of the white space around your text. In this video; Steve English shows how to change margins across the document and how to restrict margin changes to document sections.

47886
Microsoft Word 2010: Change The Document View Steve English

In Microsoft Word 2010; a document can be viewed in several different views and each view has its own advantages over the others. In this video; Steve English demonstrates how you can change the view of a document and choose and apply different views available in Microsoft Word according to your requirements.

47904
Microsoft Word 2010: Check Spelling And Grammar Steve English

The spell check function in Microsoft Word 2010 is useful for correcting common errors in your text; such as misspellings; grammar issues; and misused words. In this video; Steve English demonstrates how to use this feature to clean up text and generate readability statistics.

47888
Microsoft Word 2010: Create A Bookmark Steve English

Bookmarks in Microsoft Word 2010 have two main uses: easy navigation back to your place in the document and link for creating cross-references. In this video; Steve English shows how to create a bookmark and discusses the rules about naming and how to select a name that can be referenced later.

47890
Microsoft Word 2010: Create A Cross-reference To A Bookmark Steve English

Microsoft Word 2010 allows you to cross-reference to a specific set of Word objects; such as headings; numbered items; figures; and tables. In this video; Steve English shows how to cross-reference with bookmarks when none of the other Word objects apply.

47891
Microsoft Word 2010: Create A Hyperlink Steve English

Microsoft Word 2010 allows you to create a hyperlink right inside your document to link to an existing file or webpage; an existing place in the document; a new document; or an email address. In this video; Steve English shows you how to create a hyperlink that opens another document.

47889
Microsoft Word 2010: Create A Table Steve English

Tables in Microsoft Word 2010 help you display information in a tabular format. In this video; Steve English explains how to create and design a table that will stand out better from the surrounding text.

47878