Getting Started with MicroStrategy Desktop
In this video, I show how how to get started with MicroStrategy Desktop. MicroStrategy is one of the leading Business Intelligence tool, and the MicroStrategy Desktop application is available for free. https://youtu.be/e0PcgU1buc0 You can download MicroStrategy...
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...