LiveSlider

Microsoft%20Training
Career%20Solutions
PowerHour%20Atlanta
New%20Horizons%20GoNow%20Videos
Azure%20training%20%5Bnh%3Acity%5D
Leadership%20Development

Leadership & Development - NEW!

NHGO NOW - NEW!

Microsoft Office Training

Microsoft Technical Training

CompTIA Training

Cisco Training

Adobe Training

ITIL Training

Cybersecurity Training

VMware Training

Business Professional Training

Other Training and Certification

Power Hour Training

Custom Training Options

Employee Productivity

computer training classes for employees

Business employees are most productive when they are confident in their skills.

With the availability of different computer training delivery methods, your employees can now acquire or develop their IT and business skills in a way that is convenient for them and for your business.

Broad Spectrum of Training
Flexible Delivery Methods

Contact Us Now

Center for Leadership and Development

Build Your IT Career

Launch or develop your career with training from New Horizons.

The field of Information Technology is filled with opportunities.

You can launch or build up your career with computer training classes from New Horizons at your own pace, with expert guidance from our counselors and instructors.

Career Paths
Great Opportunities for:

Right Side Square Buttons

Computer training classes catalog

Computer Training Events Webinars

Computer Classes Online Atlanta

Computer classes schedule

A Great Training Experience

A Great Experience

My class was  a great experience!

My SharePoint class from New Horizons was a great experience. My instructor, Mary, was incredibly knowledgable, and gave us usable examples along with teaching the concepts. I’ve already put my new skills to work.

Corrie, Austin TX

 

Latest Blog Article

28 Dec 2017

Copy first and last names into separate cells without retyping (Excel 2016/2013/2010)

Copy first and last names into separate cells without retyping (Excel 2016/2013/2010)

If you have a spreadsheet containing a list of people’s names, and each first and last name is in a single cell, you can break the first and last names into separate cells without having to retype each name yourself. If your list is long, you’ll not only save time but also reduce the very likely possibility of introducing errors.

To start, open a worksheet that contains a list of first and last names in Column A. Ensure that Column B and Column C are empty. Make Row 1 a header row labeled Name. Label cell B1 First Name and cell C1 Last Name.

Let’s say A2 contains the name Janet O’Neal. Click in B2, then type =LEFT(A2,FIND(" ",A2)-1) in the Formula Bar and press [Enter]. To place the last name in C2, click in that cell and then type =RIGHT(A2,LEN(A2)-FIND(" ",A2)). To copy the formulas for every name on the list, select cells B2:C2 and drag the selection box in the lower-right corner of the cells to the end of the list of names.

If your list of names follows a Lastname, Firstname format (such as O’Neal, Janet), you’ll need to reformat the names to Firstname Lastname format (Janet O’Neal) before you follow the instruction above. To do this, insert a column to the right of your names. Assuming the name you wish to transpose is in A3, click in B3 and then type =MID(A3,FIND(",",A3)+2,LEN(A3)) & " " & LEFT(A3,FIND(",",A3)-1).

Click here to sign-up for more Etips: http://bit.ly/newhorizonsetips

Print

Number of views (1866)      Comments (0)

J Purifoy J Purifoy

Other posts by J Purifoy
Contact author

Name:
Email:
Subject:
Message:
x

Floating Mock Two Thirds Image

Upcoming Webinars

Control Without Being Controlling: Change Management for DevOps

Jun 05, 2018 | 9:00 am PDT / 12:00 pm EDT / 4:00 pm GMT Register Now

This session explores innovative ways to create a flexible Change Management process that adapts to the scope and risk of various types of changes. The session will help attendees seek a “minimum viable process” approach that seeks the right level of control based on the governance, risk and compliance requirements of the customer and organization. Topics to be covered - Nurturing a culture of change - How much is “just enough” change control? - Empowering decision authorities including peer reviews - The power of the Standard Change and risk models - Using automation and CI/CD to lower risk and provide compliance evidence - Building a bridge between Dev/Ops and Change Management through Agile Service Management.

Effective Job Search Strategy

Jun 08, 2018 | 8:00 am PDT / 11:00 am EDT / 3:00 pm GMT Register Now

Your goal is to land that job and you need an effective and assertive plan to do so! All hiring happens at the front of the line when you get to talk with the hiring manager, not at the end of the line when you apply for a job. This workshop teaches you how to get to the front of the line and helps you map out your action plan to be successful in your job search.

You will:

    • Transform any job search frustration into action items
    • Discover what components make up a successful strategy
    • Understand the difference between a "Hidden Job" and an "Open Job"
    • Learn how to use LinkedIn to connect with the right people

Past attendees report gaining insights allowing them to be more proactive and confident during the hiring and interview process. Take your activity to the next level, become a more effective and desired candidate by attending this workshop!

Check out the full webinar schedule here

Vendor Spotlight

Computer Training - Azure

New Horizons is the world’s largest independent computer training company

2018 Learning Catalog

Computer Training Classes Catalog Download Now  

Our career and corporate computer training solutions turn ambitions into marketable skills and business goals into tangible results—with learning methods for virtually every schedule and style, plus the most powerful vendor-authorized learning tools and expert instruction. We’ve trained more than 30 million people to make the most of technology, and we’re just getting started.

Best-in-Class Computer Training and Measurable ROI

New Horizons is ranked in the top 5% in the industry for training quality and customer satisfaction as reported by an independent third-party learning and quality assurance company, Knowledge Advisors. Plus research shows that New Horizons training yields a 4:1 benefit-to-cost ratio, based on manager surveys of the improved performance and productivity of their employees immediately following New Horizons training.

2018 Computer Training Class Catalog

Download this valuable resource for descriptions of full course offerings, certification information and more!