How to build an Interactive Chart

The concept of an interactive chart is aim at making Excel dashboard more flexible for users to choose whatever they wanted to see by changing the selection in the drop down menus to drive automatic chart updates in their report. I will show the simplest way to build an interactive chart once. This will allow[…]

Shares 0

VLOOKUP and its Application

VLOOKUP Function is one of the powerful Excel Formula that does a lot of magic for me. Interestingly, it enables me to carry out hundreds of calculations and analysis in minutes. Though the golden rule is to search vertically (top to bottom) of the left column (usually leftmost) of the lookup table until it established[…]

Shares 0