Home
Job Seekers
State Employees
HR Professionals
About Us / Divisions

Training - Computer/Software Courses

Collapse All
Expand All

Access
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.

Adobe
Adobe PS Adjust Colors - WBT
Adobe PS Brightness Contrast - WBT
Adobe PS Crop an Image - WBT
Adobe PS Developing Raw Photographs - WBT
Adobe Photoshop Getting Photos - WBT
Adobe PS Resize an Image - WBT
Adobe PS Retouch Blemishes - WBT
Adobe PS Select Portions of Images - WBT
Adobe PS Sharpen Details - WBT
Adobe PS Working with Layers - WBT
Excel
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 formatting rules.

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 to it.

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 VLOOKUP errors.

Lotus
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
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 gone.

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
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
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.