Excel Tips and Tutorials

Retriving Quotation Rates For Two Parties With Excel

When using Excel for Procurement, it is common to use it for making quotations. 

SUMPRDOUCT Function In Excel

SUMPRODUCT is yet another function that comes to rescue, whether we want to validate a criteria or want to sum against a list of requirements

Using COUNTIF To Count!

COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.

Converting Text To Numbers In Excel

With Excel, it is not quite a rare case that numbers starts behaving like text. 

Removing Duplicates In Excel

We frequently encounter data while working with lists. It is a common problem caused by human error as well as duplication of data due to common practices – copy and paste procedure for consolidation of data.

Excel Vlookup

One of the most versatile and highly used functions is VLOOKUP. Whenever we have a table and want to quickly retrieve a value, we have to revert to VLOOKUP. Let’s take a quick dive into its use and how we can get maximum out of its use.

Using Index-Match Combination To Ease Up Lookup Process

Most of the time when we are stuck with lookup and return something process, we revert to VLOOKUP() and occasionally HLOOKUP(), according to the situation

Total Count  : 145