Assigning Macros to Drop Down Lists in Excel
Assigning macros to Form Controls is easy and to Active X controls is easier because they expose themselves to a[…]
Read moreAssigning macros to Form Controls is easy and to Active X controls is easier because they expose themselves to a[…]
Read more“ROW” function returns a table with a single row containing values that result from the expressions given to each column.[…]
Read moreExcel 2016 introduced the TEXTJOIN function which is a much improved version of CONCATENATE function. I always found CONCATENATE quite[…]
Read moreA Range Bar Chart looks like this and is very useful for displaying change between 2 points in time I[…]
Read moreMicrosoft Excel automatically truncates the VALUE Axis or X-Axis of charts when the variance between the lowest and highest values[…]
Read moreINDIRECT is a Powerful function in Excel. In this post I am going to show you how INDIRECT can be[…]
Read moreOne important feature of FILTER function in DAX is that it can establish a relationship between two tables when no[…]
Read more“All that glitters is not GOLD” Similarly “All Cool Looking Charts are not necessarily Informative Charts” An Informative Chart is[…]
Read moreWho was better? Federer or Djokovic.. Nadal or Murray ATP uses following Dashboard to compare statistics between the players Although[…]
Read moreIn my earlier post, I showed you how to create Excel Dashboards that interact when a cell is CLICKED or[…]
Read more