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.
How to Use Rules to Manage Your Outlook Inbox
Is your inbox full of emails that you still need to address? When you are out of the office for a day or two, do you wind up deleting a lot of emails or moving them to a folder because they are just not that important? Email is a very easy and quick way to communicate, but your inbox can become unmanageable at times. Outlook has some great built-in tools to help you manage your email. This article will show you how to setup the Outlook Rules feature to better manage your overflowing inbox.
How to Add Office 365 Connectors in Microsoft Teams
Microsoft Teams is now used by more than 500,000 organizations only two years after launch. As a tool available in Office 365, Teams has been able to piggyback on the meteoric rise in usage that Office 365 has experienced over the last several years. Microsoft continues to add features to Teams in order to entice customers away from other collaboration and messaging tools. Office 365 Connectors expands the capability of Teams even further.
How to Manage Meetings in Microsoft Teams
Midway through 2018 Microsoft made the decision to offer a free version of Teams to take on their competitor Slack. That decision has led to a huge increase in adoption. So much so that Microsoft named Teams their ‘fastest growing business app ever. Not bad.
Microsoft Teams is a chat-centered workspace in Office 365 that helps team members achieve more together. Aside from chats, Teams also supports video calls and meetings to enable teams to meet live, whether on-demand, or scheduled. This is a quick tutorial on how you can easily manage your meetings in Microsoft Teams.
How to Manage Long Documents in Microsoft Word
When writing long documents in Microsoft Word it may be necessary to include a cover page or a table of contents. You may also want to include a manual page break at certain points in your document. This entry in our Productivity Series will show you how to manage long documents more effectively.
How to Manage Junk Mail in Outlook 2016
It’s another day at the office and you’re still receiving email ads from a company that you’ve unsubscribed to numerous times. It’s time to add their address to the Blocked Senders List so Outlook can divert the incoming emails to your Junk Email folder. You also noticed that you’re not receiving emails from a business associate and you want to add the email to the Safe Senders List.
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.
How to Use AutoFill in Microsoft Excel
Do you use Excel frequently? Are you looking for a way to shorten the time you spend on your spreadsheets? Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern or that is based on data in other cells.
Easily Create Templates with Slide Master
With the new year coming, many people will be presenting the numbers of last year and creating goals for next. This means a lot of presentations. Whether it's an end of the year address or a New Year boost meeting, you can easily create template presentations by using Slide Master in Microsoft PowerPoint.
How to Create More Effective PowerPoint Presentations
There's nothing worse than having to sit through a boring presentation. Unless, of course, you're the one presenting. Many presenters use Microsoft PowerPoint to share information and data more easily. But are these presentations engaging with the desired audience?
There are simple ways to pump up a PowerPoint, like adding relevant images, themes, and better organization. Making sure your PowerPoint presentation is more engaging can even help you feel more confident in your presenting skills. Here are some easy ways to help make that happen: