Home » Ways to Increase Your Excel Knowledge: Tips, Tricks and Exercises

# Ways to Increase Your Excel Knowledge: Tips, Tricks and Exercises

SUMIF – If you have a list that is made up of specific values, you can use SUMIF to see the total of that list. You can use SUMIF if you want to see how much revenue a certain customer has generated for your business.

COUNTIF – COUNTIF is similar to SUMIF, but it will only return the number of times a specific value appears in a list. This is useful if you want to see how many people in a list have completed a specific action.

AVERAGEIF – Similar to COUNTIF, AVERAGEIF will only return the average of a list of values. You can use this to see how many times a certain action occurs in a list.

IFERROR – Excel’s IFERROR function will return the value if a list doesn’t have data. This is useful to see if your data is valid, or if you have an error in your spreadsheet.

INDEX and MATCH – Excel’s INDEX and MATCH functions can be used to find the exact match of a value in a list. You can use INDEX and MATCH to find out which countries, states, or cities are the most important to your business.

Rank – Excel’s rank function will find the rank of a value in a list. You can use rank to see which countries, states, or cities are the most important to your business. You can use these results to adjust your landing pages or your overall marketing strategy.

## Things you can do with data in Excel with free hand

Now that you understand how to use Excel, let’s look at some of the things you can do with data in Excel. – Create custom lists – Use INDEX and MATCH to create custom lists of your own. Use VLookup to see where those custom lists come from, and use rank to see who is on those lists. You can use these custom lists to help you understand your customer base more clearly, and better target offers and content to them. – Track your progress – Track your progress with Google Spreadsheets and Excel.