This article is about LOOKUPVALUE function, which assigns values from another table. There doesn’t have to be a relationship between these tables. How to use it? In this example, we need to connect data from these two tables. One of them contains info about sales, but we miss the prices of items. The prices are Read More
Category: Microsoft Office
Dynamics 365 vs. Dynamics NAV: Which is Right for You?
As Microsoft partners and clients, we can tell you one thing we’ve learned over the years; it’s hard to predict where Microsoft will go next. By now, we have grown used to Microsoft making major adjustments in a matter of weeks. This includes changing product names, licensing options, etc. The Dynamics product line is no Read More
Understand Different CSV Formats
by Allen Wyatt Bruce often has to save his Excel worksheets in CSV format for use with other programs. When performing the Save As operation, he noted that there are several different CSV formats listed as possibilities. Bruce is curious about the differences between these CSV formats. For those unfamiliar with the acronym, CSV is short Read More
Tag People to Get Your Message Noticed in Microsoft Teams
@Mentions call attention to your message. In a chat or channel conversation, type @, followed by your teammate’s name or email address, and select them. They’ll get a notification in their Activity feed about the conversation. Desktop To get someone’s attention in a channel conversation or a chat, @mention them. Just type @ before their name and Read More
Microsoft Teams vs Slack: Which Collaboration App Is Better?
And with the COVID-19 situation leading to a major shift towards remote work, collaboration and chat tools are more important than ever. Businesses are rushing to implement collaboration software to keep their productivity high in these uncertain times. As you probably already know, besides the alternatives the two clear market leaders in the sector are Slack and Microsoft Teams. It’s Read More
How to Insert a Table of Contents in Word
For Word for Office 365 and Word for Microsoft 365. A table of contents in Word is based on the headings in your document. Click the below link to watch an intro video. https://www.microsoft.com/en-us/videoplayer/embed/RE1TwVJ?pid=ocpVideo0-innerdiv-oneplayer&jsapi=true&postJsllMsg=true&maskLevel=20&market=en-us Create the table of contents Put your cursor where you want to add the table of contents. Go to References > Table of Contents. and Read More