X

Excel

How to use IF and nested IF function in Excel with examples

Many friends requested me to write about if function and it’s use with practical example. So this Sunday, I gather…

How to split data into multiple worksheets based on column in excel

Sometimes you need to separate data into different worksheets from the table based on some condition over data in the…

What is Pivot table Slicer and How to use it effectively?

  Hey friends, this blog is in continuation of the blog series of Accelerate your analysis with pivot table. If…

How to Change pivot table report layout?

After inserting a pivot table and relevant fields for analyses, you may require to change pivot table report layout as…

How to convert dates into months/ quarters/ years in pivot table

Analyses with pivot tables becomes much easier and can save a lot of your time as it presents data into…

This website uses cookies.