Category: Tables

VLOOKUP 2nd Version (Advanced)

Formulas, Tables, Arrays

Hi there,


As promissed, VLOOKUP 2nd version (advanced features) is out. 

Download working file here, VLOOKUP and HLOOKUP.xlsx

Alternative Link to the video VLOOKUP 2nd Version


Full story »

4 Ways to Colour Alternative Rows (with no time)

Formulas, CF, Tables, Fill Handle Tricks

Hi there,


I am sure, many of you are familiar about Table feature in Excel. Some time, while working on the data we feel like filling colour to an alternative rows to showcase them nicely to the management. We can achieve this using four different methods. I bet you will atleast like one of them. These tips are much easier and can save lots of time rather colouring it manually. Let us go ahead now:

Colour alternative rows using four options using excel

There are four different ways to colour alternative rows in Excel:

1. Using Conditional Formatting (more here)

2. Using Table 

3. Using Auto Fill Option

4. Using Banded Rows.

Let me explain each of them:

Full story »

Excel Data Tables Are Awesome..!

Formulas, Tables

Hi there,



One of the most amazing features of Excel is Tables. As you all know I have compared Excel Tables functionality with Human Lungs of the human body. To know more check How Human Parts Resembles Excel Features. Tables are really a good feature to work with rather than just a range of data. There are many reasons which supports my statement here. Few of them are:

Full story »

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.