Sat 29 Apr 2017

Excel Quiz 51

By |Saturday, April 29th, 2017|Categories: Quizzes|Tags: , , , , , , , , , , , |0 Comments

Excel Quiz 51 - A Quiz on Page Layout Tab in Excel

This quiz checks your knowledge on Page Layout tab in Excel.

Sat 22 Apr 2017

Tips & Tricks 159 - Prompted to "Save File" even if I haven't changed anything

By |Saturday, April 22nd, 2017|Categories: Tips and Tricks|Tags: , , , , , , , , , |0 Comments

When you open a workbook and you change something in the workbook and you close the workbook, it will ask you to save the workbook. But sometimes, even if you have not changed anything, still the workbook asks to be saved even if you haven't changed.

Point 1 - Microsoft has provided the answer to this question at following link -


Sat 15 Apr 2017

Downloads 14 - Excel Shortcuts Bible

By |Saturday, April 15th, 2017|Categories: Downloads|Tags: , , , , , , , |0 Comments

This is a mammoth work. Contains all short cut keys published by Microsoft and also all ALT keys which are not published by Microsoft.

Download it from Excel - Shortcuts Bible

Sat 08 Apr 2017

Tips & Tricks 158 - Overcoming column_index_number problem in VLOOKUP when a column is inserted / deleted

By |Saturday, April 08th, 2017|Categories: Tips and Tricks|Tags: , , , , , , , , , |0 Comments

One of the negative points which gets attributed to VLOOKUP is that whenever a column is added / inserted within the range of VLOOKUP, the column index number doesn't change. Hence, it gives wrong result. Let's consider below dataset and for a given Emp ID, I need gender of that person. Hence, for Emp ID, 754761, the formula would be =VLOOKUP(754761,$A:$G,6,0) and answer would be F. Now, let's delete a column and now the answer would be as column_index_number is still 6. Now, add a column and the answer would be Vang as column_index_number is still 6.


Sat 01 Apr 2017

Challenge 61 - Generate Multiplication Table

By |Saturday, April 01st, 2017|Categories: Challenges|Tags: , , , , , , , , , |3 Comments

This time, I want to set a challenge which is not difficult and useful for your kids.

The challenge is to write a formula which can be dragged right and down to generate a multiplication table.


The solution to this challenge will be published after a month i.e. on 1-May-17.