Category: Advanced

Displaying Errors and Comments

  Do you think that error values look awful when printed? Do you want to display comments on printed sheets? Worry not! There is an...

Web Query

  Are you copying data to excel from some web pages everyday? Why bother when you have web query tool in your arsenal? With web...

Watch Window

Are you having difficulty in keeping track of changes in certain cells in your workbooks while you are editing other areas? Constantly turning back perhaps?...

Goal Seek

Are  you curious about how many years do you need to work until retirement? Or are you trying to figure how many workers do you...

Incell Chart

  Do you know that there exist another way of having micro charts in one cell. This is called an incell chart. It is neat,...

Vlookup Function

Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...