Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

All posts by Puneet

10 Advanced Excel Charts

10 advanced excel charts

Charts are one of the most important parts of Microsoft Excel. It helps us to present our data in an understandable manner.In Excel, we have different kind of charts to present our data in different ways. Even there are lot of advanced charts which we can create in Excel by making small amendments in default charts.The […]

Check it out now

Pivot Table Timeline

Learn About Pivot Table Timeline

Using Pivot Table Timeline is not only save your ton of hard work but it will also a good habit of using it in our dashboards. Please follow me & learn how this Pivot Table Timeline will change your life. So here is the complete detail about Pivot Table Timeline.

Check it out now

Calculate Ratio

how to calculate ratio in excel

A ratio is one of the common methods to compare two values with each other. It can help you to compare variation between those two values. Even in our daily life, we use this word RATIO to define the comparison between two different things.When it comes to Excel, we don’t have any specific single function which can […]

Check it out now

Add Leading Zeros

how to add leading zeros in excel featured image

There are few default rules in Excel which can annoy you. And, one of those rules is you can’t add a zero before a number.The reason behind this is, a zero before a number makes no sense and no value to the number itself.Whenever you try to insert a zero before a number, Excel removes […]

Check it out now

Pivot Table Using Multiple Files

A pivot table is one of the best ways to summarize data. You can create a summary report within seconds from thousands of rows of data.It’s a perfect tool.But while working with data in the real world not everything is perfect. And today, I want to share with you a common problem which we all […]

Check it out now