X
 

VLOOKUP vs. MATCH/INDEX in Microsoft Excel

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 Add Office 365 Connectors in Microsoft Teams

How to Add Office 365 Connectors in Microsoft Teams

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.

The Differences Between Office 2019 and Office 365

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? 

How to Manage Meetings in Microsoft Teams

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. 

How to Manage Long Documents in Microsoft Word

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

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.

Essential Skills for SharePoint Administrators and Developers

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.

How to Use VLOOKUP in Microsoft Excel

How to Use VLOOKUP in Microsoft Excel

How often does this situation happen to you? You have 2 spreadsheets full of data and they need to be combined into one. What makes it even more difficult is that both tables are not organized in the same way, leaving you with data all over the place. There's an easy way to fix this.

How to Use Freeze Panes in Microsoft Excel

How to Use Freeze Panes in Microsoft Excel

Having long entries of data is what Excel was made for. However, it can cause confusion when you have large tables of data that can take some time to scroll to find the right information. Freeze Panes helps you keep track of categories as you scroll.

How To Customize Grammar Settings in Microsoft Word

How To Customize Grammar Settings in Microsoft Word

Auto-Correct is a modern marvel that many people use without even knowing it. Combined with spellcheck, lessons on knowing proper grammar have become less frequent. Computers now make those corrections for us. However, our tech is only so smart and sometimes it does not understand phrasing and names that are common in some industries. Speaking specifically for the tech industry, try writing any kind of guide or case study in Microsoft Word without getting that red edit line somewhere.

RSS
12

Theme picker

Categories