Excel in Excel

Many friends requested me to write about if function and it’s use with practical example. So this Sunday, I gather all my thoughts together and wrote about if function. I hope, you would love it. Whether you are student or… Continue Reading →

Sometimes you need to separate data into different worksheets from the table based on some condition over data in the columns. For e.g. You need to print the sales report monthly, quarterly and get it signed. You need separate sales… Continue Reading →

Hey friends, this blog is in continuation of the blog series of Accelerate your analysis with pivot table. If you are beginner to the pivot tables, I would suggest looking over to How to insert a Pivot table first…. Continue Reading →

After inserting a pivot table and relevant fields for analyses, you may require to change pivot table report layout as per your requirement. A better layout can boost your analysis power. “Forget better, I want best.” So, what is the… Continue Reading →

Analyses with pivot tables becomes much easier and can save a lot of your time as it presents data into a summarize way. Pivot tables remove all duplicate label. Still the data can be bulky enough in pivot table which… Continue Reading →

Why I started writing on excel

Knowing all the functions of excel wouldn't make you productive but knowing where to use and how to use. So Kaival Patel created Simplified Excel to provide knowledge on how various functions of excel can be used for data analysis. Using the best option will not only save your time but your efforts also.