Category: Advanced

Watch Window

(adsbygoogle = window.adsbygoogle || []).push({}); Are you having difficulty in keeping track of changes in certain cells in your workbooks while you are editing other...

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

Excel Slicers

With Excel 2010, we have a very cool tool named Excel Slicers for filtering pivot tables and pivot charts dynamically with one click. Your reports...

Pivot Chart

  Pivot chart is a powerful side product of renowned pivot table. It has all the filters that are present on source pivot table. That...