If we are analyzing dataset using pivot tables like this: Let suppose there are many values in column selected as filter (here we want to know detail month wise – it has 12 values), so each time selecting value from drop down is little difficult. Slicer can be used to simplify this scenario, as it[…]

We have chart with four rows which actually giving interest rate for 1yrs, 5yrs, 10yrs and 30 yrs. Now from that chart our target is to find out interest rate for any year given as input. Here is the chart given as input. B and C columns hold the given year and corresponding interest rate.[…]

While searching on net, I got this as the best solution for generating random character strings, follow below steps: As =RANDBETWEEN(10,50) gives random number between 10 and 50 try using =CHAR(RANDBETWEEN(65,90)) command, this will generate a uppercase alphabet randomly Depending on how many characters do you want to generate in a cell, add those many & =CHAR(RANDBETWEEN(65,90)). It[…]