Excel Tips and Tutorials

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. 

Excel Functions And Text Functions

Excel has so many functions that either one of their or their combination can fulfill most of the tasks required in our work places.

Printing Excel Sheets

Whenever you come up with a useful sheet, it is almost always essential to get it printed. Be it a simple sheet or complex business model, we can not deny the importance of a hard printed copy – it is always easier to read and record. 

Total Count  : 191