Office Solutions

How to Search for Values via HLOOKUP or VLOOKUP Functions in Your Excel Worksheet

We will introduce HLOOKUP function which will return the cell value in a column whose column header matches a specific criterion. We will also compare it with VLOOKUP, another similar function but searching vertically. HLOOKUP function is a seldom mentioned Excel function. Actually this function is a variant of the standard LOOKUP function, and “H” means horizontal. Given a range of tabular data, the function will search in the top row with the specific criterion, and return the value...

Read more »

How to Append Disclaimer to Outgoing Emails in Exchange

In this article, we are going to look into the procedural format for creating Disclaimers for all outgoing or selected outgoing emails in Exchange server 2013. Introduction: Now-a-days business world Disclaimers, legal agreements or Terms of usage have become an integral part for any form of communication. Example, a Tele-calling representative will provide disclaimers verbally. So in email communication, contents of that email, intended recipients etc., may or may not suitable for everyone....

Read more »

6 Types of Exchange Clients and Their Protocols (Part II)

This article is the continuation of the "6 Types of Exchange Clients and Their Protocols (Part I)", this article will help us to understand the clients that are used for Non-Conventional systems. Introduction: Microsoft Exchange Systems has protocols in-built for the client connectivity of non-windows based systems like Apple Mac etc. Now let’s continue with Clients & Protocols. Outlook 2011: Outlook 2011 was exclusively introduced for Apple Computers running MAC OS. Outlook 2011...

Read more »