Adobe Captivate

Ø      Adobe Captivate 3.0 (8 hrs.) - Learn how to create video training materials to publish on a CD, network, or aWebsite. Learn how to use Adobe Captivate to record screen activity in a variety of modes ; Enhance Captivate content with images, text boxes, buttons, highlight boxes and rollover captions; Import content from PowerPoint into Captivate. Learn how to create a variety of interactive questions slides for evaluation purposes.

Microsoft Office 2007

Ø      What's New in Microsoft Office 2007 (1-2 hrs.) – Learn about the new features available in most of the Microsoft Office 2007 applications such as the Ribbon, Quick Access Toolbar, Mini Toolbar, SmartArt graphics, new file formats, and many others.

Ø      What's New in Microsoft Word 2007 (1-2 hrs.) – Learn about the new features that are specific to Microsoft Word 2007 such as Style Galleries; converting documents to PDF format, contextual spelling, Quick Parts and many others.

Ø      What's New in Microsoft Excel 2007 (1-2 hrs.) – Learn about the new features that are specific to Microsoft Excel 2007 such as rich conditional formatting, improved sorting and filtering, table enhancements, and many others.

Ø      What's New in Microsoft Powerpoint 2007 (1-2 hrs.) – Learn about the new features that are specific to Microsoft PowerPoint 2007 such as new themes, layouts, Quick Styles, new improved formatting effects, new text options, new charting, and many others.

Computer Basics

Ø      Basic Computer Skills (1- 2 hrs.) – Learn how to use a mouse; start & shut down a computer; identify parts of the computer; open, restore, resize, close windows; use the keyboard; open and close applications.

Crystal Reports

Ø      Crystal Reports Level I (1- 8 hrs.) – Customize your class choosing from the following topics: Create a Standard Report including adding fields; adding tables; preview a report; move objects; change format of number fields; use templates; save a report; find data; sort data; filter data; manipulate groups; use summaries; format a group header; building formulas; add parameter fields; format reports; modify format based on data value; conditionally suppress data; hide report objects; distribute data to Excel or Access; create a report definition.

Ø      Crystal Reports Level II (1- 8 hrs.) – Customize your class choosing from the following topics: Create Running Totals; create and edit crosstab reports; add subreports; use a SQL command to build a report; group data on the server; chart data; reporting on Excel data; report alerts; custom functions; create a report with multiple columns; change data source location.

GroupWise

Ø     GroupWise Basics  (3-4 hrs.) – Creating/Reading/Sending email; Opening and saving attachments; Using the Quick Viewer; Mail formatting; creating Signatures; Using the Address Book & Contacts; Using the Calendar and scheduling meetings and tasks; creating folders; Deleting mail and folders; Check spelling; Using Notes and Checklists.

 Internet Explorer

Ø      Internet Explorer Basics (1 hr.) –- Use the browser to save and organize Favorites; use History; Set Home page; set internet options; move forward and back to other pages or websites and basic searching.

Ø      Internet Advanced Searching (1 hr.) – Learn how Search engines work and how to narrow your search to find what you want in less time!

Microsoft Access

Ø      Microsoft Access End User (2 hrs) –- Designed for the person using an already developed database.  You will learn how to enter data, filter, find, sort, etc.

Ø      Microsoft Access Basics (4+ hours) – Learn how to create Tables, Forms, Queries, and Reports.

Ø      Microsoft Access Tables and Relationships (2-3 hrs) – Learn how to create and edit tables, including setting the correct data types and field properties. Set primary keys and establish relationships between tables. Learn how to filter and sort records in Datasheet view.

Ø      Access Forms (3 hrs) – Learn how to create Forms along with subforms, switchboards, command buttons, calendar controls, and conditional formatting. Learn how to set the properties of various controls.

Ø      Access Queries(3 hrs) – Learn how to create various queries such as Select queries, Parameter queries, Make Table queries, Append queries, Find Unmatched queries, and Crosstab queries. Also learn how to perform calculations in a query.

Microsoft Excel

Ø      Excel Basics (1- 6 hours) – Customize your class by choosing from any of the following topics: Create a new workbook; Enter and delete data; Undo/Redo; Move data; Check Spelling; Save a workbook; Open existing workbook; Change views; Format cells (Alignment, Orientation, Wrap text, Shrink to fit, Merge & Center, Number options, Font, Borders, Patterns); Printing; Page Set Up Features (Margins, Gridlines, Page Orientation, Scaling, Header/Footer, Print Area, Print titles), Send to mail feature; Fill data; Sort data; Add/Delete worksheets; Select data; Copy/Paste; Find/Replace; Freeze Panes; AutoCorrect; Move worksheet.

Ø      Excel Query (2 hours) – Use Excel to query data from your internal database.  Export the data to Excel.  (Requires ODBC driver installed prior to training)

Ø      Excel Advanced Formatting (1 hour) – Learn how to use AutoFormat tool; custom/special number formatting; Format Painter; Conditional Formatting; and Transpose Rows to Columns.

Ø      Excel Formulas / Functions (3 hr) –- Learn to create basic and advanced formulas in cells; learn to use AutoCalculate; learn how to use AutoSum. Learn how to use Subtotal and Nested Subtotals, If Statements, Concatenate and VLOOKUP / HLOOKUP.

Ø      Excel Creating & Editing Charts (2 hours) – Learn how to create & edit various types of charts from Excel data.

Ø     Excel Sort, Text to Columns, & Comments (1-1½ hrs) – Sort data, take data from one column and convert to multiple columns, insert comments related to a specific cell.  Edit, delete and format comments in a cell.

Ø      Excel Print (2 hrs) – Setting Up a Worksheet for Proper Printing - Add a Header/Footer; Page Setup Options (scaling, print titles, gridlines, etc.); Print Area; Page Break Preview; insert page breaks; Print Preview.

Ø      Excel Forms (1 ½ hrs) – Learn how to create electronic forms with check boxes, radio buttons, drop-down boxes, data validation, protection, and lock cells.

Ø      Excel Macros (1 hr) –You'll want to take this class if you perform a task repeatedly in Excel.  This task can be automated by recording a macro.  Once you record a macro, Excel stores information about each step you take as you perform a series of commands.  You then run the macro to repeat, or "play back," the commands.

Ø      Excel Filtering (1 – 1 ½ hrs.) –- Learn how to filter out the data you want to see from a worksheet.  Learn how to use all the features of Autofilter and Advanced Filter, including filtering the Top 10.

Ø      Excel Linking Data (2 hrs) – Link data within the same workbook; link data to another workbook; insert formula links; control how links are updated; break links, and reconnect a broken link. Learn how to use Hyperlinks to quickly jump to another file or web page; insert screen tips; and deactivate hyperlinks.

Ø      Excel PivotTables Basic – (1 ½ hrs)  Learn how to create a PivotTable to summarize data; change the layout; change how data is summarized; group items; format a PivotTable; and refresh data in a PivotTable.

Ø      Excel Pivot Tables Advanced (1 ½ hrs.) – Learn how to use formulas in PivotTables and display results as percentages.  Show the Top Ten.  Learn how to create a “Static” chart and a PivotTable chart.

Lotus Notes

Ø      Lotus Notes Basics (2 hrs.) – Create, send, read, delete mail; Managing bookmarks; Attachments; User Options; Search options; Address book

Ø      Lotus Notes Calendar/Schedule (1-2 hrs) – Create calendar and meeting entries; Create “To Do” tasks

Microsoft Outlook

Ø      Outlook – Mail (1- 6 hrs.) – Create; Send; View; Preview; Forward; Reply; Delete; Drafts; Manage attachments; Print; Sort Messages; Create folders; Change message format; color code email; delete email; use stationery; flag messages; use the “Find” option; create contact list; create distribution list.

Ø      Outlook – Mai Advanced (1 hrs.) – Create an email signature using text, email addresses and graphics, use auto responders, recall and replace sent messages, insert hyperlinks to text, logos and web pages, send a blind carbon copy of email, tips to email etiquette.

Ø       Outlook – Calendar, Meetings, Tasks & Notes (1- 3 hrs.) – Using the Calendar; Scheduling Meetings; Using the Task list; Calendar Print options; using Notes; using Help and Outlook Today.

Ø      Outlook – Contacts (4 - 5 hrs) – Add contacts manually and from emails, assign two addresses, phone numbers and email addresses, locate and delete contacts, add, delete and apply categories to contacts, view contacts in different ways, flag contact for follow up activity and complete the activity, email a contact.

Ø      Outlook – Contacts Advanced (2-3 hrs) - Modify a pre-defined view, group contacts, add a field to the contacts information, create personalize email using categories and mail merge, create mailing labels from contacts

Ø      Outlook – Options (1-1.5 hrs) Use Permissions to share your email and appointments with others, Access other’s email inbox, reply on behalf of other’s email account, remove permissions.

Ø      Outlook Archive  (1 hr.) – How to Archive Mail and Retrieve Archived Mail.

Microsoft Publisher

Ø      Publisher Basics (2 hrs) - Create a flyer using wizards, learn parts of the Publisher screen, modify, move and resize graphics, customize personal information, save, retrieve and print the flyer

Ø      Publisher Free Form (2-4 hrs) - Create a flyer from scratch, insert, resize and align text boxes, insert graphics, lines and logos, work with lines, shapes and borders, use layout guides, create and modify bulleted lists, insert symbols, change text color and add text effects, use WordArt, create hyperlinks and email the publication

Ø      Publisher Postcards (2-4 hrs) - Create a postcard using wizards, examine pages, create a list of names and addresses in Publisher, merge the names onto the postcard, customize the delivery address and return address, sort and filter the postcards, apply categories to the list.

Microsoft PowerPoint

Ø      PowerPoint Basics (3 hrs.) – Create a new presentation; use slide sorter, outline, and slide show views; use various slide designs; create a chart or table; change the background; save a presentation; insert graphics; hide slides; change line spacing; basic animation; apply transitions.

Ø      PowerPoint Intermediate (3 hrs.) – Using the Slide Master; using the Title Master; Using Excel Charts in PowerPoint; Custom Animation; Summary Slide; Customizing your slide show; using the Pack and Go Wizard.

Ø      PowerPoint Intermediate/Advanced  (4 hrs.) – Using the Slide Master; using the Title Master; Using Excel Charts in PowerPoint; Custom Animation; Summary Slide; Customizing your slide show; using the Pack and Go Wizard; Creating Hyperlinks; embedding files; inserting sounds or music.

Microsoft Windows

Ø      Windows Basics  (4 hours) – Customize the task bar, start menu. Move/copy/delete files. Screensavers; Change mouse pointers / system resolution; Manage folders; Resize windows; view multiple windows concurrently. Edit “Power” options. View system properties. Arrange desktop icons. Run disk defragmenter.

Ø      Where's My Data?  (2 hours) – Create folders; move/organize files using Windows Explorer; use the search tool to find files, various methods for opening files; create shortcuts.

Microsoft Word

Ø      Word Basics (1- 6 hours) – Customize your class by choosing from any of the following topics: Create a new document; Format text; Copy/Paste text; Check Spelling & Grammar; Page Setup; Preview a document; Print Options; Save a document; Open an existing document; Use Help; Change views; Navigation methods (Thumbnails & Document Map); Menus & Toolbars; Line & Paragraph spacing; Pagination; Hyphenation; Insert page numbers; Change case; Use the Thesaurus; Find & Replace; Insert pictures; Insert page break; Create a drop cap; Highlighter; Use “Go To”; Word Templates; Options; Printing Envelopes and Labels; Using Bullets & Numbering; Paragraph Alignment; Reveal Formatting task pane; Show/Hide; Use the Drawing toolbar.

Ø      Word Track Changes (1 hr.) – Learn how to edit documents, show who made the suggested changes, and what changes were made.  Learn how to accept or reject changes.

Ø      Word Mail Merge (1-2 hrs.) – Learn how to use Mail Merge for labels or letters.  Merge your list of names and addresses to labels, envelopes or documents.

Ø      Word Managing Auto-features (2 hrs.)  – Learn how to use AutoText, AutoComplete, AutoCorrect, and AutoFormat.

Ø      Word Tabs (1 hr.) – Learn how to set various types of tabs including decimal, center, right aligned, and bar tabs.  Learn how to create leaders between tabs.  Learn how to select vertical data.  Learn how to set tabs within a table.

Ø      Word Tables (2 hours) – Create and edit tables, customize tables, format Tables, merge cells, split cells, repeat headings, number cells within a table, split a table, perform calculations within a table.

Ø      Word Forms (1- 1 ½ hr.) – Create forms with check boxes, drop-down boxes, and calculated fields.  Protect form and set up field validation and error notification.

Ø      Word Labels & Envelopes (1 hr.) – Create and print individual labels and envelopes.

Ø      Word Headers and Footers (1.5 hrs.) – Learn how to easily insert page numbers and other information into headers and footers. Create different headers and footers by sections or create a different first page header or footer.

Ø      Word Columns (2 hrs) - Build a newsletter using columns, add titles, pictures, text boxes and lines to newsletters, insert section breaks, drop caps, and hyperlinks, email the newsletter.

Ø      Word Macros (1 hr) - Build macro, run a macro using the keyboard and menu options, select and customize tools to run macros.

Working With Photos

Ø      Digital Cameras (2 hrs) - Understand the parts of the digital camera, take photos, change settings, download photos into the computer, view photos in different ways, examine photo resolution and file size.

Ø      Microsoft Paint (1 hr) - Modify Photos, use the Image Menu to explore special effects, use the drawing toolbar, add a text box, clone a portion of the image, save the photo.

Microsoft Business Contact Manager

Ø      Microsoft Business Contact Manager (3 hrs) - Learn how to work with Business Contacts, Business Projects, and Business Accounts. Learn to create project tasks and track activities. Run, print, export, and save reports through Business Contact Manager.

Microsoft Sharepoint 2007

Ø      Microsoft Sharepoint 2007 (2 hrs) - This course is an introduction to Sharepoint 2007. Learn how to work with Sharepoint Document Libraries and Calendars. Learn how to post announcments in Sharepoint and create hyperlinks to websites from Sharepoint.