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

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

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

How To Group Dates in a Pivot Table in Excel

group dates with in pivot table in excel

When it comes to summarizing data, pivot table is everyone’s first choice. It doesn’t matter how big your data is, it has no problem to handle it. You can instantly create insightful and ready to present reports with a pivot table. And the best is, it is dynamic, flexible and powerful. Grouping dates is one […]

Check it out now

COUNTIFS and COUNTIF With OR Logic

how to use or logic with countif and countifs

Two days back I wrote about how you can use OR logic in SUMIFS and SUMIF. And today, I want to show, that you can also use the same OR logic and multiple conditions in COUNIFS and COUNIF. Even you can create dynamic criteria for OR logic in COUNIFS and COUNIF. Have you ever faced a […]

Check it out now