This course covers basic skills including basic parts of an Excel window, formatting, alignment, indenting, merging cells; creating a simple spreadsheet with formulas, functions, format painter, absolute reference, freezing columns and rows, split windows, copy & paste, paste special, using multiple windows of the same file, printing options, creating charts and graphs, non-adjacent cells, and mail merges.

Excel Level 1 is a great introductory class for those who are starting their Excel journey or would like to know more. Participants should already know how to find a file given a path, have basic math skills, know how to use a mouse and keyboard. Objectives in Level 1 are formatting, inputting data, creating formulas and functions, format painter, absolute reference, viewing and printing options, comments/notes, creating a template and how to use an Excel database to create a mail merge using Word.

Learn basic programming, maintenance and trouble-shooting PLC based industrial controls using PLC trainers with Allen Bradley/ Rockwell Automation Control-Logix hardware and Allen Bradley/Rockwell Automation RSLogix 5000 and RSLinx software. This will allow you to benefit from vendor training on specific equipment. The central processing unit is an L36 ERM. The basic operating principles of all PLCs, their inputs and outputs (discrete and analog), programming, maintenance, and networking will be covered. Hands on approach to Factory Talk View is also included.

Ken Walsh

Ken Walsh started his career as an Electrical Engineer developing automated sawmill equipment. Ken worked for Rockwell Automation for Nearly 20 years as a field support engineer.

• Experience in Automation Systems, software, System Design, Pneumatics, Electric Motor Drives, Panel Design, logic controllers, HMI project management, startup, troubleshooting and repair with disciplines applied across a multitude of industries.
• Broad knowledge of general automation, networks, motion control, drive systems and process control that spans across multiple control vendors.
• Experience with networks and communications includes: Controlnet, Devicenet, Ethernet, Modbus.

This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas,  protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.

Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.

Students will learn Allen Bradley VFD Powerflex HMI, including lockout procedures for safety. This class includes the following units of instruction; introduction to various types of AC motors, AC motor basics of voltage, speed, power factor, torque, and motor starting methods, VFD Basics, VFD Working Principle and Operation, VFD Control, VFD Installation (hard wiring VFD-cable termination), VFD Start-up, Soft Starter working principle, Drive software start, and Troubleshooting VFD Drives.Also includes introduction to Allen-Bradley PanelView Plus operator interface configuration and complementary ControlLogix programming, using FTView, Studio5000 and RSLinx. Variable frequency drive basics taught are the same for all VFDs regardless of brand. Includes the Laboratory Manual, Final Exam, and Certificate of Completion.

About the Instructor

Ken Walsh started his career as an Electrical Engineer developing automated sawmill equipment. He worked for Rockwell Automation for just under 20 years as a field support engineer where he saw applications everywhere imaginable. Ken is also a proud Vietnam era veteran.

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.

Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.

This program is approved for the Arkansas Workforce Challenge Scholarship.

Basic Eligibility Criteria

An applicant must:

• Be an Arkansas resident
• Be a high school graduate or received high school equivalency
• Not be a current recipient of the Arkansas Academic Challenge Scholarship
• Be accepted for admission in a program of study at an approved institution of higher education that leads to an associate degree or a certificate program in the fields of Industry, Health Care, or Information Technology.

Award Amounts

The Workforce Challenge Award will be the cost of a certificate program or 

This course will increase your knowledge of the Control-Logix 5000 controller capabilitieprogram of study not to exceed $800. 

Apply for the Arkansas Workforce Challenge Scholarship

Course Description:

In this course, you will gain a deeper understanding of project development tasks and applications, learn how to create and organize a RSLogix 5000 project, creating new programs, routines, periodic event tasks and applications. You will also learn to configure Addon instructions, User Defined Data Tables, Producer Consumer Messaging and PID.

Ken Walsh started his career as an Electrical Engineer developing automated sawmill equipment. He worked for Rockwell Automation for just under 20 years as a field support engineer where he saw applications everywhere imaginable. Ken is also a proud Vietnam era veteran.

• Experience in Automation Systems, software, System Design, Pneumatics, Electric Motor Drives, Panel Design, logic controllers, HMI project management, startup, troubleshooting and repair with disciplines applied across a multitude of industries.
• Broad knowledge of general automation, networks, motion control, drive systems and process control that spans across multiple control vendors.
• Experience with networks and communications includes: Controlnet, Devicenet, Ethernet, Modbus.