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.

Objectives are introductory formatting, inputting data, creating simple formulas and functions, format painter, viewing and printing options, comments/notes.

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.

Summary

Escalating your personal or professional development begins withen visioning a brighter and more meaningful future. What do you want to achieve? What do you want to get better at? Individuals who create a personal vision, welcome new challenges and expand their comfort zones are destined for greater things. In addition, everyone benefits when relationships flourish. Taking an introspective look at your interpersonal skills to determine specific ways to work better with others is a first step to ensuring positive interactions. To develop effective business professionalism, this workshop is aimed at equipping individuals with the proper vision and interpersonal skills for success.

Context

Success occurs when a person intentionally defines who they want to be and what they want to achieve. Ambitious people have a clear picture of where they are going and a plan to get there. Part of being our best also involves how we relate with others. Building and nurturing interpersonal relationships often takes an intentional effort to connect with others and manage our interactions with them.

In this workshop, you learn best practices for building professional relationships. Not only will you learn ways to adjust your approach for dealing with others, you will set targets for implementing what you learn so that your relations benefit from incremental improvements and trust. The workshop lays the foundation for success by encouraging you to think big and providing tools and tips to get there.

This training will empower participants to:

• Identify opportunities to improve professional relationships.

• Understand and apply a cycle for growth and change.

• Develop a motivating and achievable vision.

• Adopt best practices for improving interactions with others.

• Create professional connections that can facilitate success.

Competency Categories:

Interpersonal Skills—Consistently builds strong, long-term relationships both inside and outside the organization.

Communication—Practices active listening supported with relevant oral and written information.

Vision—Future oriented. Applies imagination and wisdom to develop a picture of what could and what should be in terms of ultimate success.

Influence—Consistently directs situations andinspires mutual agreement and an all-win outcome.

External Awareness—Sees things from different points of view and recognizes the impact that actions have on others. Keeps up todate with issues and trends that affect areas of responsibility.