Center for Financial Training - North Central States Courses
Search Computer Skills
Accounting and Finance
Business Skills
Compliance and Law
Computer Skills
Financial Planning and Trust
General Banking
Lending
Management
Sales and Marketing
Small Business
Instructor-Led Schedule Instructor-Led Schedule Icon
Register Now!
CFT has made PC software training both accessible and affordable for financial institutions. Thanks to the partnership that we have established with INACOM, we are able to bring to you cost-effective computer training.

INACOM provides instructor-led training in all Microsoft programs (Access, Powerpoint, Word, Excel, Windows, etc.). Courses on internet and web applications are also available.

REGISTRATION
To register for an INACOM computer training course complete the CFT Registration Form and fax it to the CFT office at: 414-332-6478. In order to receive the discounted rate, course enrollments must be processed through the CFT office in Milwaukee.

PRICING
Full day training sessions are only $165.00 per student.

NEED YOUR ENTIRE STAFF TRAINED?
Classes can be conducted onsite for your added convenience. With a minimum number of 10 participants, CFT & INACOM can deliver the course to your institution for a very special price of $1,000.00. That's only $100.00 per person for a full day's training and it's on-site at the times you specify.

Deploying MS Office 2003 Level 1 Instructor-Led Icon  
The goal of this course is provide information technology (IT)-support professionals who are responsible for desktop software and hardware deployments with the skills necessary to successfully deploy and configure Microsoft Office 2003. This includes migration strategies from previous versions on Microsoft Windows® 9x, Windows 2000, or Windows XP operating system platforms.

Course Duration: 2 Days

Microsoft Access 2000: Advanced Online Self-Paced Icon  
This computer program course covers more advanced Access topics including complex query techniques, table joins, and more efficient forms and reports,. In addition, it covers how macros can enhance you database and user input interfaces.

After completing this course, students will be able to:
  • Create parameter queries
  • Create action queries
  • Join tables and work with join properties
  • Create cross-tab queries
  • Use functions to control data entry
  • Use a form as the user interface
  • Create a form that contains a subform
  • Create and use macros
  • Attach a macro to a command button
  • Use macros to provide user interaction and automate data entry
Required Software: Shockwave 8.0.1 or higher

Microsoft Access 2000: Level 1 Online Self-Paced Icon  
This computer program course provides the basic skills necessary to begin using Access 2000 including the design and creation of databases, tables, queries, forms, and reports.

After completing this course, students will be able to:
  • Describe the key steps in database planning and design
  • Create and work with tables
  • Find and edit records
  • Sort and filter records
  • Create a query
  • Create and use forms
  • Create and use reports
Required Software: Shockwave 8.0.1 or higher

Microsoft Access 2000: Level 2 Online Self-Paced Icon  
This computer program course focuses on more advanced database management skills, including analysis, data validation, and multi-table queries.

After completing this course, students will be able to:
  • Query multiple tables for data used in customized forms and reports
  • Analyze table relationships
  • Establish and test referential integrity
  • Use data validation techniques
  • Use indexing techniques
  • Customize form designs by performing calculations and adding combo boxes
  • Create data access pages
Required Software: Shockwave 8.0.1 or higher

Microsoft Excel 2000: Advanced Online Self-Paced Icon  
Microsoft Excel 2000: Advanced covers the more features of Excel 2000 and various advanced techniques for analyzing and manipulating data in Excel. The topics include customizing the work area, advanced formula construction, pivot tables, multiple worksheets, and macros.

After completing this course, students will be able to:
  • Work with built-in and custom toolbars
  • Create and use styles and templates
  • Construct and use more advanced formulas like IF and VLOOKUP
  • Link cells in different worksheets
  • Protect workbooks
  • Create and use macros
  • View and edit VBA code
  • Save an Excel worksheet as a web document
Microsoft Excel 2000: Level 1 Online Self-Paced Icon  
This course will provide the basic skills needed to work with an Excel spreadsheet. The procedures you will learn include navigating, entering data, using formulas, moving and copying data, and formatting and printing a worksheet.

After completing this course, students will be able to:
  • Navigate around an Excel spreadsheet
  • Enter and correct data
  • Create and enter formulas
  • Work with ranges and functions
  • Move and copy data
  • Format and print a worksheet
Required Software: Shockwave 8.0.1 or higher

Microsoft Excel 2000: Level 2 Online Self-Paced Icon  
Microsoft Excel 2000: Level 2 covers the use of electronic charts, chart items, and graphics to enhance worksheet data reports in Excel. It covers procedures for creating, modifying and formatting charts, adding graphic objects to charts, and sorting and filtering data.

After completing this course, students will be able to:
  • Create a chart sheet
  • Add and delete chart items
  • Move and size chart items
  • Format labels and chart text
  • Sort data at both single and multiple levels
  • Filter lists
Required Software: Shockwave 8.0.1 or higher

Microsoft Outlook 2000: Advanced Online Self-Paced Icon  
Microsoft Outlook 2000: Advanced covers the more advanced features of Outlook 2000, including integrating Outlook components, creating custom forms, importing and exporting data, and creating messages in HTML mail format.

After completing this course, students will be able to:
  • Sort, find, and filter messages
  • Set rules using the Rule Wizard
  • Share contact information
  • Create custom forms
  • Create public folders and set permissions
  • Import and export data
Required Software: Shockwave 8.0.1 or higher

Microsoft Outlook 2000: Introduction Online Self-Paced Icon  
Microsoft Outlook 2000: Introduction covers the fundamentals of using Outlook 2000 to coordinate mail, appointments, events, meetings, tasks, and contacts.

After completing this course, students will be able to:
  • Send and receive e-mail
  • Schedule appointments
  • Insert events
  • Schedule meetings
  • Create and manage tasks
  • Organize contacts
Required Software: Shockwave 8.0.1 or higher

Microsoft PowerPoint 2000: Advanced Online Self-Paced Icon  
Microsoft PowerPoint 2000: Advanced covers the more advanced features of PowerPoint 2000, including customizing templates and the PowerPoint environment, and making a presentation interactive by using hyperlinks and action buttons. It also demonstrates how to enhance a presentation by using custom clip art, animation, and movies, and how to work with embedded and imported objects using Microsoft applications.

After completing this course, students will be able to:
  • Insert graphics and multimedia into a Powerpoint presentation
  • Insert Office objects
  • Customize Powerpoint Presentations
  • Automate slide production
  • Use AutoCorrect and Style Checker
  • Create hyperlinks and interactive objects
  • Select the most appropriate slide show option
Required Software: Shockwave 8.0.1 or higher

Microsoft PowerPoint 2000: Introduction Online Self-Paced Icon  
Microsoft PowerPoint 2000: Introduction provides an introduction to the Powerpoint tool including bullet slides, PowerPoint's drawing tools, the use of clip art and WordArt, organization charts, and creating and editing charts with Microsoft Graph.

After completing this course, students will be able to:
  • Create and format slide text and bullet lists
  • Use the Powerpoint Drawing tool
  • Insert clipart, tables, and word art
  • Create an organization chart
  • Create and use a template and Slide Master
  • Use slide shows and other presentation options
  • Save a presentation as a web page
Required Software: Shockwave 8.0.1 or higher

Microsoft Word 2000: Advanced Online Self-Paced Icon  
Microsoft Word 2000: Advanced covers the more advanced features of Word 2000. It demonstrates how to apply styles, create forms, use form fields, add graphics, work with large documents, share documents, and prepare documents as intranet web pages.

After completing this course, students will be able to:
  • Create and use a form template
  • Add graphics to a Word document
  • Create a table of contents
  • Create footnotes, endnotes, bookmarks and cross-references
  • Use a concordance file to index
  • Track, compare, and merge documents
  • Insert highlights and comments
  • Create hyperlinks
  • Insert multimedia elements into a Web page
Required Software: Shockwave 8.0.1 or higher

Microsoft Word 2000: Level 1 Online Self-Paced Icon  
Microsoft Word 2000: Level 1 covers the intermediate features of Word 2000 including the creation and control of section breaks, tables, merges, styles, templates, macros, and web pages.

After completing this course, students will be able to:
  • Navigate through a Word document
  • Select, move, and copy text
  • Format characters and paragraphs
  • Use indents, bullets, and numbered lists
  • Set margins and page breaks
  • Create headers and footers
Required Software: Shockwave 8.0.1 or higher

Microsoft Word 2000: Level 2 Online Self-Paced Icon  
Microsoft Word 2000: Level 2 covers the intermediate features of Word 2000 including the creation and control of section breaks, tables, merges, styles, templates, macros, and web pages.

After completing this course, students will be able to:
  • Create and format sections
  • Format text into newspaper columns
  • Create a mail merge document and perform a mail merge
  • Create and apply styles
  • Create a template
  • Record and run a macro
  • Create a web page
Required Software: Shockwave 8.0.1 or higher

MS Access 2003 Level 1 Instructor-Led Icon  
You will be introduced to the features of the Microsoft® Office Access 2003 application.

Upon successful completion of this course, students will be able to:
  • examine the Microsoft® Office Access 2003 database application.
  • manage the data in a database.
  • examine existing table relationships.
  • query the database.
  • design simple forms.
  • create and modify Access reports.
MS Access 2003 Level 2 Instructor-Led Icon  
This course is a hands-on instruction book that will introduce students the skills needed for creating, revising, and customizing the design of tables, queries, forms, reports, and data access pages. This course is also for those pursuing core-level Microsoft Office Specialist (MOS) certification in Access 2002

Students will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages.

Course Duration: 1 Day

MS Excel 2002 Level 1 Instructor-Led Icon  
Students will create, edit, format and print basic worksheets and charts in Excel.

Topics include:
  • Getting Started
  • Editing your worksheet
  • Performing Calculations
  • Formatting
  • Working with multiple worksheets
  • Creating and Modifying Charts
  • Setting Page Display and printing options
Course Pre-Requisites: Windows 2000: Introduction.

MS Excel 2002(XP)/2003: Level 1 Instructor-Led Icon  
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Upon successful completion of this course, students will be able to:
  • create a basic worksheet.
  • modify a worksheet.
  • perform calculations.
  • format a worksheet.
  • develop a workbook.
  • print the contents of a workbook.
  • customize the layout of the Excel window.
Course Duration: 1 Day

MS Office 2003 Transition from 2000 Level 1 Instructor-Led Icon  
Welcome to Microsoft® Office 2003, the newest suite of information productivity applications. Since you use Office in your job, you'll want to learn the new features of Office 2003 that will help to streamline your work. In this course, you'll learn the new features of Word, Excel, PowerPoint, Access, and Outlook.

Course Duration: 1 Day

MS Outlook 2003 Level 1 Instructor-Led Icon  
This course is the first in a series of three Microsoft® Office Outlook® courses. It will provide you with the skills you need to start sending and responding to email in Microsoft® Outlook® 2003, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes.

Topics Include:
  • Getting Started with outlook
  • Composing a message and Managing Mail
  • Scheduling appointments and meetings
  • Managing Contacts and Task
  • Using Notes
Course Duration: 1 Day

MS PowerPoint 2002/2003 Level 1 Instructor-Led Icon  
Students will create effective basic presentation for delivery in front of an audience.

Topics Include:
  • An orientation to PowerPoint
  • Beginning a presentation
  • Formatting text slides
  • Adding tables to a presentation
  • Charting Data
  • Modifying Objects
  • Adding Images
  • Preparing to deliver a presentation
Course Duration: 1 day

MS Publisher 2003 Level 1 Instructor-Led Icon  
You're starting Microsoft® Publisher 2003, which is an easy to use, flexible program for creating newsletters, brochures, business cards, postcards, flyers, among others for print, email, and the Web. In this course, you will look at how to create a publication from scratch or use one of the hundreds of business and personal designs available in Publisher.

Course Duration: 1 Day

MS Visio 2003 Level 1 Instructor-Led Icon  
In this course, you'll learn fundamental skills while creating several types of diagrams using Microsoft® Office Visio® Professional. You will create a directional map, a block diagram, a basic and a cross-functional flowchart, an organization chart, and an office layout. As you create these drawings, you will learn techniques to drag and manipulate Visio master shapes, create connections between shapes, and apply styles to shapes, text, and pages. You will generate an organization chart from imported data and edit custom properties to store additional information in your diagrams. You will learn shortcuts to enhance your productivity and use unique tools designed for each type of drawing. When you've completed the course, you will have a firm grasp of all of the skills needed to create any kind of diagram using Visio.

Course Duration: 1 Day
MS Word 2002/2003 Level 1 Instructor-Led Icon  
Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft® Office Word 2002/2003 courses. It will provide you with the basic concepts required to produce basic business documents.

Topics Include:
  • Creating a basic document
  • editing a document
  • formatting text
  • formatting paragraphs
  • proofing a document
  • adding tables
  • inserting graphic elements
  • controlling page appearances
Course Duration: 1 Day

Legend:
Instructor-Led Icon Instructor-Led Online Instructor-Led Icon Online Instructor-Led
Online Self-Paced Icon Online Self-Paced Independent Study Icon Independent Study


HOME     177 E. Silver Spring Drive, Suite 201     Whitefish Bay, WI 53218-4703         TEL: 414.332.6468     FAX: 414.332.6478         info@cftncs.org