Measuring Your Success with Microsoft Power BI (Power Pivot)

Practical Problem Solving with Microsoft Power BI: Measuring Your Success   How well is your business doing? You can probably provide a general answer (“excellent,” “could be better,” “needs some help,” “growing quickly,” etc.) but how do you know? How do you measure success? Do the business tools you are using providing the answers in […]

Read More
Free Excel Help – Index and Match Functions

For this free Excel help article, for our example let us assume we have a table of sales data for a year for 6 salespersons in a company. Now let us see how using match we can pull out sales data from this table when a month and a salesperson’s name is provided. The format […]

Read More