This class is currently open as waitlist only while we work toward the minimum enrollment needed to run the session. Once enough participants have joined or approximately one week before class, we’ll convert waitlist spots into active registrations and send invoices.

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 class is currently open as waitlist only while we work toward the minimum enrollment needed to run the session. Once enough participants have joined or approximately one week before class, we’ll convert waitlist spots into active registrations and send invoices.

Power BI (Business Intelligence) works with many data sources (Excel, Access, SQL Server, and etc.) todevelop an interactive data visualization, or dashboard, giving valuable insights for business reviews and decisions. Those who work with data from multiple sources, to create reports regarding data analysis, marketing, sales, inventory control, production, education, and etc. will benefit most from this course.Requires experience with Excel or other computer applications dealing with data, and different database type software. You should be comfortable developing reports such as PivotTables and charts in Excel.

$1600

To register - Email: bethany_clark@asun.edu
Invoices will be sent out after the first day of class

Course Description:

This 4 day training program will provide the student with the knowledge and skills to identify, install, configure and troubleshoot a closed loop motion control system in the Studio5000 architecture. In addition, students will learn specific programming instructions used for motion control in Studio5000 ladder logic programs. Students will also learn how to interface Studio5000 systems with the Kinetix 5500 Servo Drives, as well as an overview of the Kinetix 5700 Servo Drives. " Overview of Motion Control Concepts " Hardware Description & Wiring Connections of Kinetix 5500/5700 Servo Drives " Adding Drives and Configuring Axes for Integrated Motion on an CIP EtherNet/IP Network " Tuning and Testing an Axis " Motion Instructions Control Structures " Basic Motion Instructions (MSO, MSF, MASD, MASR, MAFR, MAH, MAS, MAJ, MRP, MAG) " Advanced (Camming) Motion Instructions (MCD, MCCP, MAPC) " System Troubleshooting Prequisite: Students should have attended the AMTI Level 1 PLC course (or equivalent experience). It is strongly recommended that the student has also attended the AMTI VFD course (or equivalent experience).

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.

$1600

To register - Email: bethany_clark@asun.edu
 
Invoices will be sent out after the first day of class

Course Description:

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.