# Use of Slicer in MS Excel

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[…]

# How to calculate interest rates using VLOOKUP

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.[…]

# How to generate random character strings using formulae in Excel?

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[…]

# Shortcut to insert symbols in MS Word and Excel

*This will work for numeric keypad with NUMLOCK on. For the symbols, Hold down the ALT key and enter the number from the numeric keypad: