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.

Powered by Franklin Covey’s LeaderU platform, ASUN's Leadership 101 provides the tools required to increase one's personal effectiveness and leadership capacity.

The Seven Habits of Highly Effective People serves as the foundational component of the course. Renowned as the world’s premier personal leadership development and training program, The 7 Habits of Highly Effective People aligns timeless principles of personal effectiveness with the relevancy of today’s practices as well as modern technology.

This course is eligible for college credit and is one of the 7 programs required to complete the Manufactruing Essentials program. 

Please contact workforce@asun.edu for more information. 

This 4-hour course is designed to introduce various hand and power tools used in manufacturing. Instruction will include identification, application, safe use, and maintenance of common tools. Students will use various tools to develop understanding of their functions. Competency will be demonstrated through practical application.

Technology is connected with nearly every aspect of our lives. Many tasks like applying for jobs or viewing our paychecks have become digitized. And in the new world of work, basic digital literacy can help job seekers unlock new opportunities and help employees become more engaged

If you are interested in learning more about computers but aren't sure how to get started, then this course is for you. You will learn about the different hardware parts that make up a computer. Explore the fundamentals of working with operating systems and applications, as well as how to keep your computer secure. You will also be introduced to poductivity programs like word processors and spreadsheet tools.  

No previous computing experience required. 

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.

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.

The Forklift Operator course satisfies OSHA training standards for employees who operate forklifts as part of their job. Topics Include forklift basics, types of forklifts, forklift body parts, inspection checks, safe operation, and material handling. The course includes three hours of classroom instruction and a skills demonstration that allows participants to practice the safe operation of a forklift.

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.