When VLookup doesn’t cut: Try Index/Match

The Index Function is a function that finds a value in a dataset, but it doesn’t care about Unique Identifiers.

Nicole Winn 0 4

If you know the row, it’s a go. If you know the Column, no problem. The Match Function finds Rows and Finds Columns. So, when their powers combine…we find values. Remember the VLookup is a function within Excel that finds a value in a Dataset by looking at a Unique Identifier and then finding the appropriate value in adjacent columns to the right.

In a FLASH!

Watch Excel magic happen with the Flash Fill Data Separation Tool

Nicole Winn 0 5

Flash Fill is a data separation tool that has been packaged with every version of Excel since 2013!  However, it is often overlooked and underutilized.

CLD Corner: Developing a Better Online Presence

Virtual Remote Environments: Tips, Tricks & Signals

Nicole Winn 0 51

With the recent transitions in shifting to a more virtual work environment, it is imperative to show that you have as strong of an online presence as you do a face-to-face presence. All too often, we run into issues with our “home office setup,” and we need to better understand what signals we are providing the people we are conversing with. 

Becoming Mickey Mouse

Achieve extraordinary customer service and leverage your capabilities.

Nicole Winn 0 48

For most businesses, customer service is the difference between success and failure in the marketplace.  With that in mind, Jim Lifter has put together some thoughts that will help you achieve extraordinary customer service and leverage your capabilities.

Don’t Let Your Organization’s Data Get Taken Hostage by Ransomware

Network Security and Ransomware: Learn How To Protect Against Ransomware

Nicole Winn 0 147

Ransomware is big business for cyber criminals. It is estimated ransomware costs will reach $20 billion by 2021! The best way to prevent a ransomware attack is through a comprehensive network security program. In this blog, learn how businesses are investing in skilled IT security workers to protect personal and organizational data.

CLD Corner: The Four Levels of Conversation

CLD Corner with Dr. Jason Pugh

Nicole Winn 0 95

With a Ph.D. in Instructional Management and Leadership from Robert Morris University, Dr. Jason Pugh re-joined the New Horizons team with over 12 years of teaching, training, and educational development experience. 

Jason has a wealth of knowledge with conducting synchronous and asynchronous trainings and developing course materials for both live and online training sessions. He has been a training manager and an instructional coach for the last 3 ½ years, developing teachers and trainers to be successful in their endeavors. 

Password exploitation is a constant threat to a business' bottom line, so how are you prioritizing IT security positions to get ahead of it?

Password Exploitation: 83% of Americans Are at Risk

Nicole Winn 0 75

This blog outlines tips to protect your data and how cybersecurity training with New Horizons can help fill the skills gap when it comes to IT security.

Popular Microsoft Office Shortcuts

Here are some great tips from Marty Shepard! Lists and more lists!

Nicole Winn 0 58

Hello! My name is Marty Shepard from New Horizons Computer Learning Centers of Nebraska. I have been an Applications Instructor with New Horizons now for almost 19 years. (Time flies when you’re having fun!) Although my favorite classes to teach are Microsoft Access and Excel, Crystal Reports and beginning SQL Querying Fundamental classes, I have taught many classes in the other Microsoft Office Suite.

The Case FOR Dual-Axis Charts in Power BI

The ultimate goal of many reports is to help someone make a decision.

Nicole Winn 0 68

An easy way to get that information across is in a graphical representation (a fancy term for a chart). With Microsoft's Power BI, you can easily take all kinds of data and create many different types of charts and display them in an easy-to-understand report to tell a story about it. One quick and easy way to do this is by using a dual-axis chart.

Wasting Hours of Your Life Pulling Data for Reports?

Your search is over! Expert Eric Satterfield to the rescue with POWER BI

Nicole Winn 0 47

If you, like so many others, have been searching for an easier way, a faster way, a better way to work with your data, then read on to discover just three of the reasons why I think you need Power BI, Microsoft’s next-generation data analysis tool, and believe your search is at an end.

Ever feel stressed at the beginning of class? Worry that you’re not going to remember all the material?

Focus and participation are essential if you want to make the most of your learning.

Nicole Winn 0 38

How do you focus and participate when you have so many other things – work, family, reimagining the last season of Game of Thrones – on your mind? Let yourself have fun! Fun is stronger than fear...

RSS

Theme picker

Loader