Excel Tips and Tutorials

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

More On Printing Options – Making Things More Reading In Excel

In our last post we have discussed various printing options – in this post we will continue with this the same topic and explore few more options that can help manage our printing tasks. 

Total Count  : 144