Excel SumIf CountIf and AverageIf formulas

Using Sum(), Count() and Average() formulas in Excel might be enough for many situations, but sometimes you might have a more complex question you're trying to answer.  For example, if you had the following data, and you wanted to know how much each customer bought,...

Excel Basic Formulas: Sum, Average, Count, Max, Min

Using Excel basic formulas can help simplify your life by doing sums, averages, counts, maxs, and mins of many numbers at the same time. To follow along, go to the following link to download the Efficient Analyst Data Validation List Drop-Down Exercise Workbook:...

Creating an Excel Drop-down list using Data Validation List

Adding an Excel Drop-down list is a great way to make data entry faster, more efficient, and also more accurate.  There are a few ways they can be done, and in this article we show how to do them using the Data Validation lists. To follow along, go to the following...

Using the Excel VLOOKUP function

Using the Excel VLOOKUP function makes it easy to link two excel tables together, and can be a great time saver. To follow along, go to the following link to download the Efficient Analyst VLOOKUP Exercise Workbook: Efficient Analyst VLOOKUP Exercise Workbook...