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.
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.
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?
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.
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.
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.
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 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.
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.
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.