UA Fort Smith's IT Team delivers world-class consulting, Instructor-Led Training (ILT) and web-enhanced training, as well as developing
Computer-Based Training (CBT) products.
The Information Technology faculty of the University are all authorized and certified instructors in their areas of expertise and are
all professional educators.
When taking a class from the CBPD's Information Technology team, you will be gaining the most current
and relevant information and certification courses offered in Microsoft Office.
For additional information, please contact Micki Voelkel at 479-788-7771 or by email
Micki Voelkel.
Microsoft Office Credit Classes
WFL 1631 Data Fundamentals Using Microsoft Access (Beginning Access)
Topics for this one-credit hour college level course include database terminology and concepts, exploring an existing Access database, creating a database file, creating and populating tables, creating simple queries, calculating in queries, table relationships, and simple forms and reports.
| CRN | CEU's | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
WFL 2661 Database Standards and Design Using Microsoft Access (Intermediate Access)
This one-credit hour college level course will teach you design and development of relational databases using intermediate-level Microsoft Access. Topics include data normalization and related tables, creation of forms using combo boxes and calculated controls, creation of data-access pages, and creating of reports using calculated controls. Prerequisites for this course are ITA 1201 Computer Database or WFL 1631 Data Fundamentals Using Microsoft Access or consent of the instructor.
| CRN | CEU's | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
WFL 2671 Data Control and Analysis using Microsoft Access (Advanced Access)
Topics for this one-credit hour college level course include parameter and action queries, queries using inner-, outer- and self-joins, forms using tab controls, subforms and option groups, reports using advanced calculations, and macros. Prerequisites for this course are WFL 2661 Database Standards and Design Using Microsoft Access or consent of the instructor.
| CRN | CEU's | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
WFL 1611 Basic Business Calculations Using Microsoft Excel (Beginning Excel)
Learn the fundamentals of spreadsheet designing this one-credit hour college level course. Topics include entering and editing data, simple formulas, the order of mathematical operations, simple functions, absolute cell references, worksheet formatting, page setup and simple charts.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 1425 | Aug. 24-Oct. 12 | Mon. | 4:00-6:00 p.m. | BII 115 | M. Voelkel | $175 |
WFL 2631 Business Data Analysis Using Microsoft Excel (Intermediate Excel)
Topics for this one-credit hour course include creating multi-sheet workbook using 3-D formulas, creating decision-making formulas, calculating payments and future values of investments, and using lists to sort, filter, and subtotal data. Prerequisites for this course are WFL 2603 Integrating Technology with Management, ITA 1251 Computer Spreadsheets or WFL 1611 Basic Business Communications Using Microsoft Excel.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 1426 | Oct. 19-Dec. 7 | Mon. | 4:00-6:00 p.m. | BII 115 | M. Voelkel | $175 |
WFL 2641 Process Improvement Calculations using Microsoft Excel (Advanced Excel)
This one credit-hour course includes advanced spreadsheet calculations for business and industry. Topics are: complex decision-making formulas and functions, pivot tables and charts, worksheet protection and templates, data consolidation, and macros. Prerequisites for this course are WFL 2631 Business Data Analysis Using Microsoft Excel or consent of the instructor.
| CRN | Date | Day | Time | Location | Instructor |
|---|
Please contact
Micki Voelkel for information
WFL 1621 Basic Electronic Presentations Using Microsoft PowerPoint (Beginning PowerPoint)
Topics for this one-credit hour college level course include creating and delivering electronic presentations, working with graphics including graphics files, clip art, word art and drawing tools, charting, animation, and sound.
| CRN | CEU's | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
WFL 2651 Advanced Electronic Presentations Using Microsoft PowerPoint (Advanced PowerPoint)
One-credit hour course that includes creating templates using custom backgrounds, color schemes and slide masters, advanced multimedia including movies, animated GIF's, sound files and animation, creation of interactive presentations using hyperlinks and custom shows. Effective presentation delivery will also be stressed. Prerequisites for this course are WFL 2603 Integrating Technology with Management or ITA 1101 Computer-Presentation Graphics or WFL 1621 Basic Electronic Presentations Using Microsoft PowerPoint.
| CRN | CEU's | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
WFL 1601 Basic Business Communications Using Microsoft Word (Beginning Word)
Basic word-processing skills provided in a business context. Topics in this one-credit hour course include text entry and editing, character formatting, paragraph formatting, tabs, tables, document formatting, and print setup.
| CRN | Date | Day | Time | Location | Instructor |
|---|
Please contact
Micki Voelkel for information
WFL 2611 Electronic Communication using Word (Intermediate Word)
The mechanics of creating business documents using intermediate level Microsoft Word skills. Topics include: documents with multiple sections and multiple document formats, advanced tables, creating of business mailings using mail merge, and document automation using styles, templates and other automation features. Prerequisites for this one-credit hour course are WFL 2603 Integrating Technology with Management , ITA 1051 Computer-Word Processing, or WFL 1601 Basic Business Communications Using Microsoft Word.
| CRN | Date | Day | Time | Location | Instructor |
|---|
Please contact
Micki Voelkel for information
WFL 2621 Process and Policy Documentation Using Microsoft Word (Advanced Word)
Advanced word-processing skills necessary to create process and policy documentation in business and industry. Topics include automatic indexes and tables of contents, advanced graphics, document sharing and change tracking, and Webpage development using Microsoft Word.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Integrating Technology with Management
WFL 2603 Integrating Technology with Management
This three-credit hour course includes instruction and hands-on application using office and enterprise management software to identify, gather, classify, analyze and present information
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Non-credit Microsoft Office Classes
Beginning Access
This 8-hour course covers the basics of database terminology and concepts, creating database files, creating and editing tables, working with table data, creating select queries, creating calculations in queries, creating forms and reports using the wizards.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5014 | Sept. 29 & Oct. 6 | Tues. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Intermediate Access
Covers the basics of database design, including table relationships and normaliation of data. Also includes ways of controlling data entry through table design, queries that include concatenated fields, updatable queries, forms with combo boxes and calculated controls, and reports with calculated controls and manual grouping.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5020 | Oct. 27 & Nov. 3 | Tues. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Beginning Excel
In this course, you'll learn to create and format an Excel worksheet, organize the data in your worksheet so that it's much easier to work with and various other basic tasks. Recommended for new users but will also benefit experienced users of previous versions.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5009 | Sept. 11 & 18 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
| 5026 | Dec. 4 & 11 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Intermediate Excel
This 8-hour course will cover multi-sheet workbooks using 3D formulas and functions, IF functions, Nested IF functions, PMT functions, and working with data lists (sorting, custom lists, subtotaling filtering and Dfunctions).
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5016 | Oct. 9 & 16 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Advanced Excel
Topics in this 8-hour course include lookup tables and lookup functions, pivot tables, customized toolbars, macros, files passwords and protection, sheet and cell protection, data consolidation, solver and goal seek.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5024 | Nov. 10 & 17 | Tues. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Charting in Excel
Learn to turn your numbers into visuals with Excel's charting features. Learn the basics of setting up and formatting charts.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Formulas and Functions in Excel
This course introduces the fundamentals of calculation in Microsoft Excel, touching on simple formulas, basic functions and logical functions using the Insert Function command.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Lists and Pivot Tables in Excel
Use Excel to track data, sort, filter, subtotal and report. This four-hour session focuses on the most useful, fun and practical features of this powerful software.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Visual Basic for Applications Using Excel
Students enrolling in this course should be familiar with Microsoft Excel and creating macros. You will get the most out of this course if your goal is to become proficient in using Visual Basic for Applications (VBA) to create procedures for controlling the behavior and appearance of an Excel worksheet, create procedures that run in response to sepcific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 4027 | Aug. 25 & Sept. 1 | Tues. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Beginning Outlook
Topics covered in this 8-hour course include using the Inbox to read, create, send, and reply to messages; set delivery options and flag messages; using the Contacts folder to manage email addresses; using the Tasks folder to add, edit, and mark tasks; create and organize meetings by using the Calendar.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5022 | Nov. 6 & 13 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Beginning PowerPoint
Master PowerPoint from the beginning with this 8-hour basic course. The course will cover the fundamentals of the newest version of Microsoft PowerPoint. Recommended for new users but will also benefit experienced users.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Intermediate/Advanced PowerPoint
This 8-hour course covers custom backgrounds and templates, inserting new slide and title masters, working with multimedia clips, advanced animation and animation schemes, creating custom shows, linking between shows, using hyperlinks, creating action buttons, and tips for creating effective presentations.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Beginning Project
Topics in this 8-hour course include working with project files, task lists, creating and assigning resources, base calendars, working with views, filtering, grouping, sorting, and finalizing schedules.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Animation and Multimedia in Microsoft PowerPoint
Learn to insert movies, sound and create fun animations in PowerPoint. Focuses on entrance, exit and motion path animation as well as audio and video effects.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
Beginning Word
This basic course is designed to give you easy access to every command and feature of Microsoft Word. New features will make creating, editing and formatting documents much easier. Recommended for new users but will also benefit experienced users of previous versions.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5012 | Sept. 25 & Oct. 2 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Intermediate Word
Covers section breaks, mulitple headers and footers, automatic page numbering, footnotes and endnotes, newspaper columns, mail merges, using existing templates and wizards, creating your own templates, AutoText entries and styles.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
| 5018 | Oct. 23 & 30 | Fri. | 8 a.m.-noon | BII 115 | M. Voelkel | $129 |
Mail Merges in Microsoft Word
This course focuses on ways to create form letters, labels and catalogs using Microsoft Word's mail merge tools.
| CRN | Date | Day | Time | Location | Instructor | Cost |
|---|
Please contact
Micki Voelkel for information
About Us
5210 Grand Ave. • P.O. Box 3649