-
Keyboard Shortcuts
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.
-
Adding Charts to Reports
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.
-
Apply Conditional Formatting to a Report
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.
-
Compact and Repair a Database
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.
-
Create a Crosstab Query
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.
-
Create a Data Macro
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.
-
Create a Find Duplicates Query
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.
-
Create a Find Unmatched Query
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.
-
Create a Primary Key
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.
-
Create a Subreport
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.
-
Create a Table in Datasheet View
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.
-
Create a Table Index
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.
-
Create a UI Macro
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.
-
Create and Edit Joins
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.
-
Create and Modify a Select Query
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.
-
Create Validation Rules
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.
-
Creating Pivot Tables
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.
-
Customizing Lookup Fields
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.
-
Filter Records
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.
-
Find and Replace Data
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.
-
Importing Data from Office
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.
-
Link to Data in Another Database
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.
-
Optimize a Database with Table Analyzer
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.
-
Refine a Query Using Groupings
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.
-
Secure a Database
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.
-
Secure an Access Database
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.
-
Sort Records
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.
-
Use a Predefined Input Mask for a Table Field
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.
-
Use Object Prefixes
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.
-
Create a Subform
In Access 2010 subforms can be nested within another form. In this video; Steve English will demonstrate how to create subforms in Access.
-
Fixing Text
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.
-
Manipulating Text
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.
-
Useful Math Functions
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.
-
About Range Lookups
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.
-
Add Data Validation Rule
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.
-
Add Drop Down Validation Rule
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.
-
Additional Date Features
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.
-
Additional PivotTable Features
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.
-
Align Text in Cells
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.
-
Analysis ToolPak
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.
-
Apply and Modify Number Formats
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.
-
Apply Conditional Formatting
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.
-
Array Formulas
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.
-
Calculations in Pivot Tables
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.
-
Chart Layout and Formatting
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.
-
Choosing Appropriate Chart Types
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.
-
Cleaning Data and Removing Duplicates
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.
-
Combining Text
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.
-
Consolidating Data in Several Workbooks
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.
-
Copying and Moving Data
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.
-
Copying Cell Formatting
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.
-
Create a Scenario
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.
-
Creating PivotTable Reports
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.
-
Custom Number Formats
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.
-
Elements of an Excel Chart
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.
-
Entering and Understanding Functions
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.
-
Excel Options
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.
-
Fill Series
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.
-
Formula Concepts
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.
-
Goal Seek
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.
-
Graphics and Smart Art
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.
-
Grouping and Subtotals
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.
-
Headers and Footers
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.
-
Import Data from the Web
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.
-
Import Delimited Text Files
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.
-
Inserting and Deleting Rows and Columns
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.
-
Styles and Themes
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.
-
Using Match and Index
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.
-
Using Pivot Charts
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.
-
Using Simple Finance Functions
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.
-
Using Structured References with Tables
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.
-
Using Workspaces for Multiple Workbooks
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.
-
Variable-Sized Range Names
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.
-
Workbook Properties
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.
-
Working with Dates
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.
-
Working with Panes
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.
-
Link Cells from Different Workbooks
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.
-
Making Use of Logical Functions
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.
-
Managing Worksheets
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.
-
Page Layout Options
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.
-
Protect Workbooks
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.
-
Publishing Workbook Data to the Web
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.
-
Recently Used File List Tips
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.
-
Record and Run a Macro
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.
-
Reference Types
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.
-
Replacing Data and Checking Spelling
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.
-
Row and Column Formatting
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.
-
Save Data into Different Formats
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.
-
Send Files Through E-mail
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.
-
Solver
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.
-
Sorting Information
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.
-
Sparklines
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.
-
Tables and Filtering
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.
-
Tracing Precedents
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.
-
Tracking Changes and Merging Workbooks
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.
-
Trend Lines
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.
-
Use Comments
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.
-
Use Names in Formulas
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.
-
Useful Statistical Functions
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.
-
Using Copy and Paste
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.
-
Using Data Tables for What If Analysis
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.
-
Using Lookup Functions
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.
-
Sending Contact Information
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.
-
Sending from a Different Address
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.
-
Setting Security Options Using the Trust Center
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.
-
Setting Up Free/Busy Information
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.
-
Sharing an Account
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.
-
Sharing Your Calendar Info
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.
-
Shortcuts
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.
-
Stationery
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.
-
Subscribing to Calendars
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.
-
Tracking Messages
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.
-
Using and Modifying Forms
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.
-
Using AutoArchive
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.
-
Using Color Categories
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.
-
Using Digital Signatures and Encrypting Email
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.
-
Using Flags with Email Messages
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.
-
Using RSS Feeds
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.
-
Using Signatures
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.
-
Using Symbols; Horizontal Lines and Equations
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.
-
Using Text Messaging in Outlook
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.
-
Using the Journal
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.
-
Working with Google Calendars
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.
-
Working with Google Contacts
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.
-
Working with Google Gmail
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.
-
Working with Graphics
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.
-
Working with LinkedIn
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.
-
Linking to Bookmarks
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.
-
Managing Attachments
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.
-
Managing Meetings
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.
-
Managing Outlook Email Views
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.
-
Manipulating Calendar Views
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.
-
Using Mailbox Cleanup
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.
-
Adding Bcc
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.
-
Always Reply to All
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.
-
Automated Replies
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.
-
Autoreply Thru Rules
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.
-
Backing Up Outlook Items
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.
-
Configuring the Settings for an Outlook Account
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.
-
Contact Groups
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.
-
Controlling Email Message Format
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.
-
Conversation Feature
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.
-
Create an Event
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.
-
Create Custom Rules
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.
-
Creating an Electronic Business Card
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.
-
Creating and Scheduling Meetings
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.
-
Creating Appointments
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.
-
Creating Contacts
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.
-
Creating Notes
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.
-
Creating Quick Steps for Email Messages
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.
-
Creating Rules
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.
-
Creating Tasks
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.
-
Global Address List vs Contacts
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.
-
Homepage
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.
-
Increasing Productivity
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.
-
Junk E-mail
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.
-
Downloading Global Addresses
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.
-
Editing an Attached Document
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.
-
Email Importance and Sensitivity
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.
-
Exporting Contacts
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.
-
Message Templates
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.
-
Note Views
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.
-
Opening Archival Email
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.
-
Organizing RSS Feeds
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.
-
Organizing Tasks
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.
-
Organizing the Inbox
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.
-
Printing in Outlook
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.
-
Quickly Access Functions
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.
-
Recall Sent Messages
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.
-
Responding to Rescheduling Meetings
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.
-
Response Text
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.
-
Scheduling Options with Messages
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.
-
Screen Shots
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.
-
Search Folders
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.
-
Customizing the Outlook User Interface
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.
-
Date Calculator
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.
-
Defer Sending Emails
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.
-
Desktop Alerts
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.
-
Creating Custom Animations
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.
-
Customizing a Slide Show
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.
-
Delivering Presentations
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.
-
Export a Presentation as an Image File
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.
-
Format Painter
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.
-
Handouts in Word
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.
-
Insert Speaker Notes
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.
-
Inserting a Slide from Another Presentation
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.
-
Inserting a Video File
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.
-
Inserting an Audio File
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.
-
Inserting an Excel Spreadsheet
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.
-
Inserting Office Content
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.
-
Interactive PowerPoint
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.
-
Layouts and Slide Setup
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.
-
Making Use of Hyperlinks
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.
-
Making Use of Screenshots
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.
-
Use Animation Painter
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.
-
Using Guides and Precision
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.
-
Using Slide Sections
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.
-
Adding Charts
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.
-
Adding Graphics
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.
-
Advanced Protection
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.
-
Beautifying Text Boxes
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.
-
Bullets and Numbered Lists
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.
-
Choose Presentation Views
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.
-
Combine Shapes
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.
-
Combining and Comparing Presentations
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.
-
Compress Pictures to Save File Size
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.
-
Constructing and Editing Photo Albums
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.
-
Creating a Training Video
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.
-
Making Use of SmartArt
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.
-
Making Use of Themes
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.
-
Making Use of Transitions
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.
-
Managing Views
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.
-
Manipulating Graphics
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.
-
Printing Presentations
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.
-
Protect a PowerPoint Presentation
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.
-
Protect a Presentation From Being Opened
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.
-
Protect a Presentation from Editing
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.
-
Quickly Access Recent Files
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.
-
Recording a Slide Show
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.
-
Remove the Background from an Image
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.
-
Review and Comments Feature
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.
-
Save in a Format with Smaller File Size
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%.
-
Save in a Presentation Format
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.
-
Shapes
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.
-
Share a Presentation Over the Internet
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.
-
Slide Outlines
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.
-
Transitions versus Animations
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.
-
Turn the Mouse into a Laser Pointer
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.
-
Working with Masters
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.
-
Adding Subprojects
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.
-
Applying Work Contours
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.
-
Constraining Tasks
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.
-
Converting an Excel Worksheet into a List
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.
-
Creating a Resource Calendar
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.
-
Creating a Resource Pool
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.
-
Creating Custom WBS Codes
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.
-
Designating Milestones
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.
-
Displaying Project Columns
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.
-
Displaying Visual Reports
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.
-
Entering Material Resources
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.
-
Entering Tasks
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.
-
Entering Work Resources
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.
-
Filtering Project Lists
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.
-
Grouping Project Lists
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.
-
Indicating Lead and Lag Time
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.
-
Leveraging a Resource Pool
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.
-
Modifying Resource Costs
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.
-
Modifying the Timescale
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.
-
Organizing a Task List
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.
-
Performing Simple Sorts
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.
-
Saving Project Templates
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.
-
Selecting a Base Calendar
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.
-
Setting Project Baselines
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.
-
Setting Project Properties
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.
-
Setting Task Dependencies
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.
-
Starting a New Project
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.
-
Updating Project Schedules
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.
-
Using Summary Tasks and Milestones
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.
-
Viewing Project Reports
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.
-
Add Resources in Site Pages
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.
-
Adding SharePoint Functionality to the Windows PowerShell
Microsoft SharePoint 2010 allows you to configure SharePoint functionality within Windows PowerShell. In this video; David Santana demonstrates how to automate SharePoint with Windows PowerShell.
-
Adding SharePoint Snap-In Using Add-pssnapin cmdlet
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.
-
Advanced Settings Document Content Types
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.
-
Audience Targeting
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.
-
Column Level Validation
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.
-
Content Rating
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.
-
Create a Site Collection in a Specific Database
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.
-
Create My Site Web App
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.
-
Create Visio Process Repository
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.
-
Creating User Profile Service App
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.
-
Document ID Services
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.
-
Document Set Settings
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.
-
Editing the Main Default ASPX Page
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.
-
Enable All of the Site Collection Features
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.
-
Explore Basic Team Site
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.
-
Forefront Identity Manager Service
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.
-
Generate a File Plan Report
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.
-
Install Windows PowerShell Integrated Scripting
Microsoft SharePoint 2010 allows you to install Windows PowerShell Integrated Scripting Environment; which is a graphical host application for Windows PowerShell. In this video; David Santana demonstrates how to import the ServerManager module for Windows PowerShell.
-
List Level Validation
Microsoft SharePoint 2010 allows you to validate lists by using formulas. In this video; David Santana demonstrates how to set validation to a list.
-
Login/Logout
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.
-
Manage Content and Structure
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.
-
Metadata Navigation
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.
-
Modify Site Schedule
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.
-
Peoples and Groups
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.
-
Permission Finder
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.
-
Play Your Media Assets
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.
-
Record Declaration Settings
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.
-
Reusable Content
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.
-
Ribbon
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.
-
Shared Documents
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.
-
Site Actions
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.
-
Turn On Versioning and Content Approval
Microsoft SharePoint 2010 allows you to enable versioning and content approval. In this video; David Santana demonstrates how to turn on these two tasks.
-
UI Enhancements
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.
-
Upload Media Assets
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.
-
Use Windows PowerShell to Report Web Properties
Microsoft SharePoint 2010 allows you to use Windows PowerShell to report web properties. In this video; David Santana demonstrates how to copy; paste; and run existing commands to report URLs and their properties.
-
User Profile Sync Service
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.
-
Using the Grid View
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.
-
Validating the Snap-In via SharePoint Management Shell
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.
-
Web Part Properties Options
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.
-
Multi Document Actions
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.
-
Create a Site Collection
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.
-
Create a Group Worksite
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.
-
Create a Publishing Site Page
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.
-
Create a Search Center
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.
-
Create a Document Set
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.
-
Adding Page Breaks
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.
-
Adjust Spacing
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.
-
Apply a Border
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.
-
Apply Page Color
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.
-
Apply Styles to a Table
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.
-
Creating Cross References
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.
-
Crop a Picture
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.
-
AutoCorrect and AutoText Functions
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.
-
Change Autosave Settings
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.
-
Change Footnotes to Endnotes
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.
-
Change Footnotes to Endnotes Separator
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.
-
Change Margins
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.
-
Change the Document View
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.
-
Check Spelling and Grammar
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.
-
Create a Bookmark
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.
-
Create a Cross-Reference to a Bookmark
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.
-
Create a Hyperlink
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.
-
Create a Table
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.
-
Create an Excel Table
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.
-
Create Bulleted Lists
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.
-
Create Numbered Lists
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.
-
Creating a Building Block
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.
-
Customize Footnotes
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.
-
Customize the Ribbon
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.
-
Cut; Copy; and Delete
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.
-
Find and Replace
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.
-
Format the Font
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.
-
Format with the Mini Toolbar
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.
-
Get Help
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.
-
How to Create Paragraph Styles
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.
-
How to Use Mail Merge
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.
-
How to Use Section Breaks
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.
-
How to Use Templates
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.
-
Indent Text
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.
-
Insert a Footnote
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.
-
Insert a Picture
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.
-
Insert an Endnote
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.
-
Insert and Delete Table Rows and Columns
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.
-
Insert Building Blocks
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.
-
Insert Clip Art
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.
-
Insert Columns
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.
-
Insert Headers and Footers
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.
-
Inserting a Table of Contents
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.
-
Link or Embed an Excel Table
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.
-
Merge and Split Table Cells
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.
-
Populating Headers and Footers
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.
-
Print a Document
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.
-
Recording a Macro
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.
-
Restrict Editing
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.
-
Reviewing a Document
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.
-
Save a Word Document
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.
-
Sort a Table
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.
-
Undo and Redo
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.
-
Use the Format Painter
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.
-
Use the Navigation Pane
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.
-
Use Word to Take a Screenshot
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.
-
Wrap Text
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.
-
Zoom In and Out
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.
-
Searching for Contacts
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.
-
Starting An IM Session
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.
-
Updating Status and Location Information
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.
-
Viewing Activity Feeds
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.
-
Adding or Changing our Lync Picture
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.
-
Adding Phone Numbers and Settings
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.
-
Adding to Frequent Contacts
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.
-
Changing Contact Display with Layout Options
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.
-
Changing Privacy Categories for Contacts
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.
-
Creating and Adding Contacts to Groups
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.
-
Exploring the Action Bar
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.
-
Getting Started with Lync 2010
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.
-
Making a Phone Call
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.
-
Reviewing a Contact Card
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.
-
Configure the Administrative Access URL
The Administrator Access URL in Microsoft Lync Server 2010 allows you to have access to the Lync Control Panel. In this video; David Santana demonstrates how to configure administrator access using the Lync Administrative Tools.
-
Create a Common Area Phone
Setting up common area phones in Microsoft Lync Server 2010 will allow you to configure call control behaviour; such as allow call transfers from a lobby. In this video; David Santana demonstrates how to create a common area phone using the cmdlet New-csCommonAreaPhone.
-
Creating a Device Policy
Creating a device policy in Microsoft Lync Server 2010 is quick and easy. In this video; David Santana demonstrates how to integrate a device policy in the Lync Server Management Shell.
-
Deploy and Run the Topology Builder
The Lync Server Topology Builder allows you to deploy Microsoft Lync Server 2010 by publishing your topology. In this video; David Santana demonstrates how to create and configure a new topology for a new site.
-
Editing and Troubleshooting a Device Policy
You can edit and troubleshoot device policies in Microsoft Lync Server 2010. In this video; David Santana demonstrates how to correct an error in the device policy from the Lync Management Shell.
-
Install the Local Configuration Store
Installing the local configuration store in Microsoft Lync Server 2010 allows you to publish your topology and have the Central Management Store in place in your front-end pool. In this video; David Santana demonstrates how to configure the local configuration store.
-
Integrating Exchange Server 2010 SP1 Unified: Associate the Dialplan with Lync Server
Associating your dial plan with the Exchange Server 2010 SP1 Unified Messaging makes it active. In this video; David Santana demonstrates how to add dialing restrictions and associate the dial plan with the server.
-
Integrating Exchange Server 2010 SP1 Unified: Create a Um Auto Attendant
A Unified Messaging auto attendant allows you to automate the answering and routing of your incoming calls. In this video; David Santana demonstrates how to create an auto attendant while integrating the Exchange Server 2010 SP1 Unified Messaging with the Lync Server.
-
Integrating Exchange Server 2010 SP1 Unified: Create and Edit Umdialplan
Integrating the Exchange Server 2010 SP1 Unified Messaging with Microsoft Lync Server 2010 is a key task. In this video; David Santana shows you how to create and configure a UM Dial Plan.
-
Integrating Exchange Server 2010 SP1 Unified: Run the ExchUcUtil
Running the UcUtility and OcsUtility scripts is important for integrating Exchange Unified Messaging with Microsoft Lync Server 2010. In this video; David Santana demonstrates how to run these utilities and allow for the dial plan and auto attendant to be enabled.
-
Integrating Exchange Server 2010 SP1 Unified: Running the Ocs Util
The OCS utility; which allows for permissions; allows you to control both Exchange Server 2010 SP1 Unified Messaging and Lync Server. In this video; David Santana demonstrates how to run the OCS utility by building a new normalization rule and committing the change.
-
Management Shell: Validate the Configuration
The Lync Management Shell in Microsoft Lync Server 2010 enables you to automate administrative tasks. In this video; David Santana demonstrates how to retrieve; format; and update user information at the PowerShell command prompt.
-
Prepare Active Directory for Lync Server
The Lync Server Deployment Wizard in Microsoft Lync Server 2010 helps you deploy the Active Directory. In this video; David Santana demonstrates how to verify system requirements and prepare the Active Directory using the deployment wizard.
-
Request and Assign Certificates
Assigning certificates in Microsoft Lync Server 2010 is essential to have access to specific URLs; such as the Dial-in or Meet URLs. In this video; David Santana walks you through requesting and assigning certificates to services.
-
Set Up Components with the Deployment Wizard
Setting up the Lync Server components is an important task in Microsoft Lync Server 2010. In this video; David Santana demonstrates how to set up the components using the Lync Server Deployment Wizard.
-
Start Lync Server Services
Starting the Lync Server Services in Microsoft Lync Server 2010 is important. In this video; David Santana shows you how to verify on your front-end server that the services are running.
-
Troubleshooting and Logging
Microsoft Lync Server 2010 allows you to troubleshoot and set up login. In this video; David Santana demonstrates how to troubleshoot the Lync line by reviewing log files and enabling login.
-
Using RBAC to Add an Administrator to the CSAdministrator Group
Adding an administrator in Microsoft Lync Server 2010 is a vital task in preparing the Active Directory and deploying the Lync Server. In this video; David Santana demonstrates how to use role-based access control to verify and add a member to the CSAdministrator group.
-
Printing
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.
-
Best Practices
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.
-
Adding Watermarks
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.
-
Sharing a Screen
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.
-
Text Boxes
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.
-
Templates
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.
-
Enable Users
Enabling users in Microsoft Lync Server 2010 is a simple task. In this video; David Santana demonstrates how to configure Internet Explorer security settings and enable multiple users to use the Lync Server services.
-
Handling Errors
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.
-
Working with Graphics
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.
-
Working with Text
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.
-
Create a Site Page
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.
-
Create an Asset Library
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.
-
Creating Charts
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.
-
Explore a Publishing Site
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.
-
Recycle Bin
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.
-
Creating Tables
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.
