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.

10000+ Copies Already Downloaded

All posts by Puneet

Sum Values Between Two Dates

how to sum values between two dates in excel

Let’s say, you are working in a trading company and your boss tells you to get the total sales amount for last 15 days. In this case, you need to sum sales amount from the current date to 15 days prior. Here, you have a range of dates which actually includes total 15 dates and […]

Check it out now

Get Last Day of a Month

how to get last day of a month

Sometimes you need to use the last day of a month in a calculation as a completion date, due date, or as a target date. You can easily add a month’s last date manually but there are some formulas which can help you calculate it. And, the best way to calculate it by using EOMONTH […]

Check it out now

Create a Step Chart in Excel

how to create a step chart in excel

A step chart is perfect to use when you want to show the changes happened on irregular intervals. It can help you to present the trend as well as the actual time of a change. In real, a step chart is an extended version of a line chart. Unlike line chart, it doesn’t connect data […]

Check it out now

Get Month from a Date

how to get month from a date in excel

Dates are an important part of data. It can help you to capture your data in a better way and it’s easy to use dates in further analysis. And, the best part is you can also modify dates as well and use them in your own way. Normal dates, when you are working in excel […]

Check it out now

Dynamic Drop Down List

quickly create a dynamic drop down list in excel featured image

Drop down list is a powerful tool. It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data. While using it, one thing always gave me nuts that you need to update it’s data source whenever you add a […]

Check it out now
1 3 4 5 6 7 25