Access 2013 First Database - WBT
This course shows how to use a template to build a database quickly.
Access Introduction 2013 - WBT
The course links to a Microsoft tutorial that introduces Access 2013.
Access 2013 Basics Part 1 - WBT
This course covers key terms and concepts, including the first steps in designing and building a database.
Access 2013 Basics Part 2 - WBT
This course addresses table relationships, including the different types of relationships and how to build each one.
Access 2013 Basics Part 3 - WBT
The course addresses queries and their creation, including types of queries, criteria, joins, and intermediate tables.
Access 2013 Read Only Queries - WBT
This course shows you what to do when you can't change the data returned by a query. It addresses the most common causes and solutions to deal with this problem.
Access 2013 Making the Switch to 2013 - WBT
This course covers the differences in Access 2003 and Access 2013, including how to create and manage new files, using files from previous version, etc.
Access 2013 Stop Query - WBT
This course shows you how to make a parameter query stop asking for input. It also addresses the problems found in expressions.
Access 2013 Query Criteria - WBT
This course shows you how to filter your date by using criteria, including adding criteria to queries, using AND and OR logic, logical operators (like IN and BETWEEN), and wildcards.
Access 2013 Parameter Criteria - WBT
This course shows you how to use parameters to filter your query. It also shows you how to add parameters to your queries so they ask for your input before they run.
Access 2013 Update Query - WBT
This course shows you how to change data safely by building update queries.
Access 2013 Date Criteria - WBT
This course covers how to use date criteria in queries, including calculated fields, DateDiff, DateAdd, etc.
Excel 2013 Add Numbers - WBT
In this course you will learn how to add numbers in Excel 2013 with formulas, functions and buttons.
Excel 2013 Add Time - WBT
In this course you will see that in Excel 2013 you can add and subtract time like you do other numbers, allowing the user to track time used in project, etc.
Excel 2013 Advanced IF Functions - WBT
This course teaches how to do complex IF functions in Excel 2013. This includes using IF with AND and OR, and other advanced functions.
Excel 2013 Array Formulas - WBT
This course will introduce you to array formulas which are used to generate single and multiple results in various calculations.
Excel Average Group of Numbers - WBT
This course will show you how to obtain the averages or weighted averages of numbers in column or rows, and show you the functions used to find averages of numbers that are not in columns or rows.
Excel 2013 Basic Math - WBT
In this course you will learn how to add numbers in Excel 2013 with formulas, functions and buttons.
Excel 2013 Create Chart - WBT
In this course you will see how to create charts that will visually better represent your data highlighting different data groups in different ways.
Excel 2013 Create Your 1st Workbook - WBT
This course will introduce you to Excel 2013 and show you how to accomplish everyday tasks.
Excel 2013 Drop Down Lists - WBT
This course will teach you how to use and manage drop down lists within Excel 2013, making your worksheets easier to use by others and more efficient.
Excel 2013 PivotTables - WBT
PivotTables and Pivot Charts are tool that allow you to analyze data in Excel 2013. This course will teach you what they are and how to use them.
Excel 2013 VLOOKUP - WBT
In this course you will learn how to use VLOOKUP to located specific data in a large spreadsheet or in a group of spreadsheets with a workbook.
Excel 2013 Use Auto Fill - WBT
In this course you’ll see how to use auto fill, and a new feature for 2013, Flash Fill to make corrections over the entire spreadsheet, and save a great deal of time and effort.
Excel 2013 Use Conditional Format - WBT
In this course you’ll learn how in Excel you can set conditional formatting to help differentiate data, such as with color.
Excel 2013 Working Macros - WBT
This course will show you how to automate repetitive functions using the Excel macro recorder.
Excel 2010 Basic Chart - WBT
After completing this course you will be able to: create a chart, makes changes to a chart after
you create it, understand basic chart terminology.
Excel 2010 Conditional Formatting - WBT
After completing this course you will be able to: make data stand out by applying conditional formatting
to cells, decide which type of conditional formatting to apply, clear conditional formatting from cells, make your own conditional
Excel 2010 Create Formulas - WBT
Use Excel to add, divide, multiply, or subtract. Learn how to write formulas and use math operators
so that Excel calculates them the right way. Write formulas that can automatically update results when values change, or
when you copy a formula to another location. Know the different types of cell references and when to use them when you copy
formulas: relative, absolute, and mixed. Create formulas with functions to add numbers, calculate monthly payments, and
capitalize proper names.
Excel 2010 Create Macros - WBT
Create a macro by using the Macro Recorder. Run the macro that you recorded. Make some minor changes
to the macro by using the Visual Basic Editor in Excel. Save the macro to your personal macro workbook and assign a button
Excel 2010 Create Spreadsheet - WBT
Create a new spreadsheet. Add, subtract, multiply, and divide in a spreadsheet. Enter and format
column titles. Let Excel fill in some information for you. Add or delete columns, rows, and spreadsheets. Keep column titles
in sight as you scroll down a spreadsheet. Select some printing options.
Excel 2010 If Function - WBT
Use the IF function. Use more than one IF function in a formula.
Excel 2010 Manage Information - WBT
Create tables. Change table format. Sort and filter table data. Use formulas with tables.
Excel 2010 Plan Payments and Savings - WBT
Figure out the monthly payments to pay off a credit card debt. Figure out monthly mortgage payments.
Find out how much to save each month for a dream vacation. Find out long it will take to pay off a personal loan. Figure
out a down payment. See how much your savings will add up to over time.
Excel 2010 Sparkline Data Trends - WBT
Add sparklines to spreadsheet cells. Determine which kind of sparkline to use. Change sparkline styles. Clear sparklines
from spreadsheet cells.
Excel 2010 V Lookup Function - WBT
Enter VLOOKUP arguments in a formula. Use VLOOKUP to find values in Excel lists or tables. Avoid
LOTUS Notes Add an Attachment - WBT
This tutorial shows how to add an attachment to a Lotus Notes document.
LOTUS Notes Add a Calendar - WBT
This course shows how to add a calendar to your Lotus Notes calendar and set display options.
LOTUS Notes Add Graphics - WBT
This tutorial shows how to add graphics into documents, spreadsheets, and presentations.
LOTUS Notes Add a Signature - WBT
This course shows how to add a signature to all of the messages you send.
LOTUS Notes Archive Settings - WBT
This tutorial shows how to change archive settings for Lotus Notes mail.
LOTUS Notes Color Coding Mail - WBT
This tutorial shows how to color-code your mail by sender, to make it easier to scan your inbox.
LOTUS Notes Delegating Access - WBT
This tutorial shows how to let specified people open your mail and read your e-mails, calendar entries,
to do items, and contacts.
LOTUS Notes Delegating a Folder - WBT
This tutorial shows how to delete a folder in Lotus Notes (provided you have sufficient rights.)
LOTUS Notes Display as Conversation - WBT
This tutorial shows how to display e-mails and their replies as conversations.
LOTUS Notes Emptying Trash - WBT
This tutorial shows how to change preferences for emptying trash in Lotus Notes mail.
LOTUS Notes External Calendar - WBT
This tutorial shows how to add external calendar invitations to your Lotus Notes calendar.
LOTUS Notes Inbox - WBT
This tutorial shows how to navigate the Lotus Notes 8 inbox.
LOTUS Notes Introduction to LOTUS Notes 8 - WBT
This tutorial shows features of Lotus Notes 8.
LOTUS Notes Moving a Folder - WBT
This tutorial shows how to move folders in their own mail file or an application.
LOTUS Notes: Notes 101 - WBT
This tutorial shows what Lotus Notes can do for you.
LOTUS Notes Out of Office Messages - WBT
This tutorial shows how to color-code your mail by sender, to make it easier to scan your inbox.
LOTUS Notes Outlook TO LOTUS Notes - WBT
This tutorial introduces Microsoft Outlook users to the Lotus Notes user interface and how to perform
familiar Outlook tasks in Lotus Notes.
LOTUS Notes Previewing E-Mails - WBT
This tutorial shows how to display an e-mail preview in the Notes sidebar.
LOTUS Notes Remove Meeting Invites - WBT
This tutorial shows how to automatically remove meeting invitations from the inbox.
LOTUS Notes Repeating Meeting - WBT
This tutorial shows how to schedule a repeating meeting, and describes the options for when and how
long the meeting will repeat.
LOTUS Notes Schedule a Meeting - WBT
This tutorial walks you through the options you have when scheduling a meeting.
LOTUS Notes Search Tips - WBT
This tutorial shows how to use the search feature in Lotus Notes 8.
LOTUS Notes Separate Windows - WBT
This tutorial shows how to open an e-mail in a new window.
LOTUS Notes Types of Tables - WBT
This tutorial shows how to create different types of tables in Lotus Notes.
Outlook 2010 Automatic Replies - WBT
Create and send automatic replies if you use a Microsoft Exchange Server account. Create and send
automatic Replies if you don't have an Exchange account (you use a services such as Hotmail, Gmail, or your ISP's mail service).
Stop both types of replies (Exchange and other types of accounts). Create rules to help manage incoming messages while you're
Outlook 2010 Best Practices - WBT
Create a system for managing email effectively. Use email and tasks together to plan your work.
Schedule time in your calendar for maintaining your system.
Outlook 2010 Keyboard Shortcuts - WBT
Use the ALT key to access any button or command on the ribbon. Use the ALT key to access buttons,
check boxes, and menus in a dialog box. Use ALT key shortcuts in dialog boxes. Use other kinds of access keys, like F6.
Outlook 2010 Mailbox Management Part 1 - WBT
Switch between the predefined views that Outlook provides. Turn grouping on or off. Add or remove
columns in a view. Create custom views. Start and stop Conversations view. Use the Clean Up and Ignore commands. Undo a
cleanup or ignore operation.
Outlook 2010 Mailbox Management Part 2 - WBT
In this course, you will learn to install any updates needed to run Instant Search, use Instant Search to find messages and items in your mailbox, configure
Instant Search to look through your entire mailbox, use the Instant Search ribbon tab, turn on Search Folders, enter parameters for Search Folders, create a
custom Search Folder, and delete Search Folders.
Outlook 2010 Mailbox Management Part 3 - WBT
Create folders. Use punctuation marks and other characters to control the order of your folders.
Add folders to your Favorites in the Navigation Pane. Move and delete folders Create Outlook Data files (PST files). Create
folders in your PST files
Outlook 2010 RSS Feeds - WBT
Identify web pages and blogs that provide RSS Feeds. Subscribe to an RSS Feed. Synchronize Outlook
with your Feeds. Read RSS items in Outlook. Change settings, such as folder locations, for your Feeds. Use search folders
to filter out unwanted items. Remove an RSS feed from Outlook. Unsubscribe to a feed.
Outlook 2010 Signatures - WBT
Create a basic e-mail signature. Format the text in a signature. Add a hyperlink to a signature.
Add an image such as a corporate logo to a signature. Create signatures in the Outlook Web App. Convert a handwritten signature
into a graphic. Create a signature that uses a two-column layout. Use a signature template.
Outlook 2010 Tame your Inbox - WBT
Create and respond to messages more efficiently. Know at a glance who replied to whom, and when.
Always reply to the most recent message in a conversation. Choose the folder arrangement that works best for the task at
hand. Act on whole conversations at once.
Outlook 2010 Save Time with Templates - WBT
Create, save, and use an email template. Download and customize a readymade email template. Save
appointments or meetings, tasks, and contacts as templates. Share templates with others.
PowerPoint 2013 Using Animation - WBT
This course goes into detail about how to use animations effectively in your presentation.
PowerPoint 2013 Avoid Rebuilding - WBT
This course shows you how to recycle presentations to create unique presentations.
PowerPoint 2013 Create Flow Chart - WBT
This course shows you how to create a flow chart in your presentation.
PowerPoint 2013 Sound Effects - WBT
This course shows you how to add sound effects to the transitions in your presentation.
PowerPoint 2013 Switch 2013 - WBT
This course explains the changes in PowerPoint 2013 from the previous version.
PowerPoint 2013 Slide Show Timing - WBT
This course shows you how to use slide timing to record the time for each slide in your presentation. It covers using the recorded times to advance the slides automatically.
PowerPoint 2013 Trigger Animation - WBT
This course shows you how to create a trigger to control an animated object within your presentation.
PowerPoint 2013 Using Videos - WBT
This course shows you how to embed and play videos in your presentation.
PowerPoint 2013 Watermarks - WBT
This course shows you how to use watermarks in your presentation.
PowerPoint 2013 Insert Bar Chart - WBT
This course shows you how to add and to customize a bar chart in your presentation.
PowerPoint 2013 Customize Slide Masters - WBT
This course explains how to create and to use slide masters to make editing your presentation easier.
PowerPoint 2013 Handouts - WBT
This course goes into detail about how to print effective handouts for your presentation.
PowerPoint 2013 Insert Line Chart - WBT
This course shows you how to add and to customize a line chart in your presentation.
PowerPoint 2013 Handout Masters - WBT
This course shows you how to change the settings for the handout master, which contains the master layout and properties.
PowerPoint 2013 Motion Paths - WBT
This course shows you how to design and to create motion paths within your presentation.
PowerPoint 2013 Insert Pie Chart - WBT
This course shows you how to add and to customize a pie chart in your presentation.
PowerPoint 2013 Print Slides - WBT
This course shows you how to print slides and other basic styles of handouts for your presentation.
PowerPoint 2013 Highlight Text - WBT
This course shows you how to highlight text, use your mouse as a laser pointer, and change the fonts in your presentation.
PowerPoint 2013 Presenter View - WBT
This course explains the basics of Presenter view so you can have a different view than your audience when presenting.
PowerPoint 2013 Animate Pictures - WBT
This course shows you how to animate objects - including text, pictures, shapes, etc. - to enhance your presentation.
PowerPoint 2013 Backgrounds - WBT
This course will help you enhance your presentation by adding color, textures, pictures, etc. to your PowerPoint. It also covers how to customize your colors and use your design elements effectively.
PowerPoint 2013 5 Steps Better PowerPoint - WBT
This course offers 5 simple steps to make your presentation more effective.
PowerPoint 2013 Add Bullets - WBT
This course shows you how to work with bullets, including formatting text, changing font size, spacing, etc.
PowerPoint 2013 Crop Pic - WBT
This course shows you how to use the crop tools to edit your photos and to fit them into a shape.
PowerPoint 2013 First Presentation - WBT
This course will help you learn the basics of this version of PowerPoint.
PowerPoint 2013 Add Headers Footers - WBT
This course shows you how to add information - such as slide numbers, logos, and dates - in the headers and/or footers of your presentation.
PowerPoint 2013 Create Org Chart - WBT
This course shows you how to add an organizational chart to a slide.
PowerPoint 2013 Add Sound to Animation - WBT
This course shows you how to sync sound effects with animation, including adding multiple sounds and timing.
PowerPoint 2013 Create Template - WBT
This course shows you how to create a template from a presentation, so you can update or change information as necessary.
PowerPoint 2013 Apply Theme - WBT
This course shows you how to use themes in your presentation to improve your overall design.
PowerPoint 2013 Apply Transitions - WBT
This course shows you how to apply transitions between slides to enhance your presentation.
PowerPoint 2010 Animations - WBT
Change the timing for an animation using On click, With previous, or After previous. Change the speed
for an animation: speed it up, slow it down, and even delay it. Change the order of the animation using the Animation Pane
(previously known as the Custom Animation Pane). Add a sound to an animation. Add a custom animation using a motion path.
PowerPoint 2010 Animations and Transitions - WBT
Animate text, charts and shapes. Add an animation to all slides in your presentation. Add transitions
(animation effects between slides). Remove animations and transitions.
PowerPoint 2010 Broadcast a Celebration - WBT
Broadcast a presentation to people outside your company. Broadcast a presentation internally, to
your coworkers. See what the broadcast experience is like for the attendees. Identify problems that can arise during a broadcast.
PowerPoint 2010 Create a Presentation - WBT
Create slides and add text. Choose a slide layout, insert a picture, and apply a theme. Change the
size and position of slide elements. Format pictures, shapes, and other slide content. Create speaker notes to use when
you present. Share the presentation file for review. Print handouts and prepare to present.
PowerPoint 2010 Data Charts - WBT
Visualize data with a chart. Compare parts of a whole using a pie chart. Insert a column chart to
show change over time. Define what a data series is. Define what a category is. Select and customize chart components.
PowerPoint 2010 Insert Photos - WBT
Insert a single photo. Create a photo album. Crop a photo. Align, distribute, and rotate a photo.
Apply styles and effects to photos. Manage file size by linking to photos.
PowerPoint 2010 Insert Videos - WBT
Embed a video into a presentation. Manage file size by linking to a video. Size a video frame. Change
the start and end times by trimming the video. Set a video to play full screen. Set a video to play automatically during
a slide show. Insert a video from a website, for example, YouTube.
PowerPoint 2010 Keyboard Shortcuts - WBT
Define the two kinds of keyboard shortcuts available: access keys and key combinations. Access tabs,
buttons, options, and commands using the ALT key. Directly perform tasks by using the CTRL key. Perform a variety of tasks
using the keyboard: from opening and working with files, to starting and stopping a slide show.
PowerPoint 2010 Smart Art Graphics - WBT
Decide which chart or diagram is right for you: SmartArt graphic or data chart. Visualize text by
using SmartArt graphics. Add text and shapes to a SmartArt graphic. Work with text levels to create shapes for any kind
of SmartArt graphic: from process diagrams to organization charts.
PowerPoint 2010 Tips and Tricks - WBT
Open PowerPoint fast by using a keyboard shortcut. Use a template from Office.com. Make a slide
from a single bullet. Crop a picture to a shape. Zoom with your mouse. Reuse a slide from another presentation. Use Slide
Sorter view. Insert a screenshot. Insert a screen clipping. Show or hide the ribbon. Use the Quick Access Toolbar.
Word 2013 Make the Switch - WBT
This course explains the changes in Word 2013 from the previous version.
Word 2013 Mirror Margins - WBT
This course shows you how to set mirror margins, customize page numbers, and create cover pages.
Word 2013 Orientations - WBT
This course shows you how to change your document orientation and how to use both orientations in one document.
Word 2013 Quick Styles – WBT
This course shows you how to use Quick Styles to format your document.
Word 2013 Raise Your Game – WBT
This course shows you several tips for improving your work processes with Word. It illustrates how to use Office Online and the free tools available.
Word 2013 TOC Next Level – WBT
This course shows you how to create a custom automatic table of contents with your own formatting.
Word 2013 Track Changes – WBT
This course shows you how to use the Track Changes tool when drafting, sharing, and editing documents. This tool helps allows you to see and to approve any changes suggested by another person.
Word 2013 Using Styles – WBT
The course shows you the benefits of using Styles to format your documents.
Word 2013 Watermarks – WBT
This course shows you how to create and to use watermarks in your document.
Word 2013 Word Counts – WBT
This course shows you how to track word counts in your document as you are writing.
Word 2010 Accessibility - WBT
Apply heading styles and paragraph formatting to your document. Add alternative text to images, objects
and tables. Structure layout tables for easy navigation. Use other tips and tricks for keeping your documents accessible.
Word 2010 Create Compelling Documents - WBT
Use text effects to apply the same types of formatting that you use for graphics and images directly
to document text. Adjust, correct, and enhance images with picture editing tools. Insert screen clippings and screenshots
into your document. Add and edit SmartArt graphics.
Word 2010 Create a Document - WBT
Create and save a new document. Fix spelling and grammar as you type. Add formatting to your text.
Change page margins.
Word 2010 Create a document Part II - WBT
Move around in the document. Use formatting marks. Move text around in the document. Change line
spacing and alignment.
Word 2010 Keyboard Shortcuts - WBT
Define the two kinds of keyboard shortcuts: access keys and key combinations. Access tabs, buttons,
options, and commands using the ALT key Directly perform tasks by using the CTRL key. Perform a variety of tasks using the
keyboard: from opening and working with documents to selecting and formatting text.
Word 2010 Navigation Pane - WBT
Get a bird’s-eye view of document pages and headings by using the Navigation Pane, and then go to
a specific section or page with one click. Quickly locate, add to, and reorganize content by working with headings in the
Navigation Pane. Find all instances of specific text and other items such as tables without having to scroll for them, as
well as replace text.
Word 2010 Table of Contents - WBT
Generate and update a TOC. Prepare headings so they'll be included in the TOC. Change TOC settings.
Modify TOC styles. Remove a TOC.
Word 10 Tips and Tricks - WBT
Open Word quickly by using a keyboard shortcut. Use a template from Office.com. Convert a list into
a table. Convert a list into a SmartArt graphic. Crop a picture to a shape. Zoom with your mouse. Put a document on SkyDrive.
Find and replace text. Use advanced selection techniques. Show or hide the ribbon. Use the Quick Access Toolbar. Make a
to-do list with checkboxes.