NH Learning Solutions Blog
VLOOKUP vs. MATCH/INDEX in Microsoft Excel
If you need to get data from one data range into another, most people rely on the VLOOKUP function. But did you know there is another alternative with the combination of the MATCH and INDEX functions? This blog will cover both options, explain the differences, and when you might want to use one vs. the other.
Top 3 Reasons to Run the Network Troubleshooter in Windows 10
Guest Author: Scott Thibodeau, Technical Instructor
I regularly communicate with many IT support and helpdesk staff and am surprised at the number of them that don't take advantage of the built-in Network Troubleshooter in Windows 10. As a trainer and helpdesk veteran, one of the things I promote in my classes is that we have a special power, almost a super power so to speak. What is that super power? The ability to lessen the amount of time a user is unproductive because they're staring at a system that isn't running properly.
What is Microsoft 365?
Microsoft has long dominated the productivity software space with its flagship application suite, Microsoft Office. In recent years, however, much of their focus has been on Office 365, which now has more than 120 million commercial monthly users. However, some enterprise customers are still wary of migrating to Office 365 due to its use of cloud storage and the fact that security concerns are at an all-time high. Businesses have traditionally struggled to secure their Office 365 applications and integrate them with other device management and compliance tools. To address those concerns, Microsoft introduced Microsoft 365 in August of 2017.
The Differences Between Office 2019 and Office 365
Microsoft Office is the standard enterprise office productivity suite used by most companies around the world. You probably have a version of it already, but which one? Have you moved to cloud based Office 365 or are you still utilizing a locally installed version? Now that Office 2019 is available that question becomes more important than ever. Understanding the differences between Microsoft Office 2019 and Microsoft 365 will help you make a more informed purchasing decision if you are looking to upgrade.
Top 20 Technical & Application Courses of 2018
2018 is nearly in the rearview mirror and it has been another great year at New Horizons. In 2018 we delivered over 12,000 classes to students in all formats, including: Private Group Training, Instructor Led Training (ILT), and Online LIVE classes (OLL).
How to Set Up a Skype Meeting in Outlook Using the Scheduling Assistant
How many times have you gotten a Skype meeting request in Outlook from a coworker for a time that was already booked on your calendar? I bet more than once. Or – how about those group emails that go back-and-forth asking what times everyone is available for a Skype call? Those are especially fun, right?
There’s a simple solution to send a request through Outlook for a Skype meeting during a time that works for all attendees: Utilize the wonderful tool known as the Scheduling Assistant.
Connecting Google Analytics with Microsoft Power BI
Capturing, managing and analyzing the slew of information entering multiple systems every day is challenging for companies of any size. And every piece of user data that goes untracked is a lost insight that could put your business one step ahead of competitors.
Essential Skills for SharePoint Administrators and Developers
Microsoft SharePoint centralizes document storage and collaboration to help companies organize, manage, and share documents. Today, it’s one of the top business collaboration platforms, as two out of three enterprise employees use SharePoint.
As more businesses migrate to SharePoint (Microsoft claims that it's adding 20,000 users every day), the demand for experienced SharePoint administrators and developers will increase. Companies need to ensure their IT teams have the skills to manage and customize the highly technical SharePoint platform.
The Next Evolution of the Cloud:
Q&A with Kailash Sawant, Enterprise Cloud Architect at Microsoft
Cloud technology has altered nearly every aspect of the IT industry, along with the way we work and the way we live. But what’s next? We sat down with Kailash Sawant, Enterprise Cloud Architect with Microsoft, to discuss the next evolution of the Cloud, the future of Digital Transformation, and how predictability and automation will further shape our world.
Writing Web Applications that Access SQL Databases
Guest Author: Rob Foulkrod, Technical Instructor
I was recently asked a question by a prospective student, who was just beginning to get into web app development, and while emailing my response, I thought that the information would also be valuable to many professionals out there who are interested to learn more about what's covered in some of our popular Microsoft Visual Studio courses. Below is the question, followed by my response.