Offset in excel

How to create dynamic graphs – Change graph based on values in drop down

by

Hello all. Fancy dynamic graphs that changes based on selected inputs part of drop down list? Like the below: Let’s look at the steps in creating this dynamic graphs. We would be performing the following steps to achieve this: Convert the data set to a table Create a simple graph based on the table Create … Read more

Using “OFFSET” in Excel

by

Hello All. Offset is a cool, built in function of Excel that is used to return a specific value or a range that is a specified number of rows and columns from a reference cell.  Might sound confusing – but let’s look at few examples which will help us to understand. First, the syntax: =Offset(Reference, … Read more