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

Category Archives for Formulas

Use Wildcards with VLOOKUP

Using wildcards with VLOOKUP can be super useful for you. It can help you to look up for a value using a partial match. Let’s say you have data like below table where you have students full name in one column and their marks in another column. Now from this data, you want to lookup […]

➲ Continue Reading

How to Count Unique Values in Excel

Let’s say you have a list of values where each value is entered more than once.And now, you want to count unique values from that list so that you can get the actual numbers of values which are there.For this, you need to use a method which will count a value only one time and […]

➲ Continue Reading

Sum Values Between Two Dates Using SUMIFS

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 i.e. between two dates.Which formula would you use?No idea?Well, if you ask me, SUMIFS is […]

➲ Continue Reading

Get End of the Month Date

Sometimes we need to get an end of the month date to use as a completion date, due date, as a target date or sometimes we need it to calculate the days between two dates.Without any efforts, we can easily add it manually, but there are some formulas which can help us to calculate it.The […]

➲ Continue Reading

How to Get Month from a Date in Excel

Dates are an important part of data.There are few times when we need to use only a part from a date. Take an example of the month.Sometimes you only need a month from a date.A month is one of the useful components of a date which you can use to summarize data and when it […]

➲ Continue Reading