Category: Advanced

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...