Beat Excel! Get to next level in Excel!

Joining Text in Excel

Have you ever needed to join two or more text values into one? Yes, excel has a built-in function for that too. But it is...

Iferror Function

What do you do when your formulas return error values for your calculations, your reports are filled with error values and dependent formulas messed up?...

Incell Chart

  Do you know that there exist another way of having micro charts in one cell. This is called an incell chart. It is neat,...

Formula Arrows

When there is too much stuff in your workbook and you start to lose which formula uses which cells, formula arrows will set you into...

Sumifs Function

Are you tired of creating helper columns to be able to fetch data with sumif function? If you need to sum of a list of...

Vlookup Function

Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...