Overview

In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching text or numbers and extracting corresponding values from neighbouring columns, querying specific data, aggregating the amounts based on certain condition or a number of criteria, making lists and summaries, doing statistical analysis based on these criteria etc.

This will help to analyse data at the investment due diligence stage or to make the management reports more informative.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Due Diligence Tools and Methods
311
1
A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…
Van Westendorp’s Pricing Method
499
0
Introduced in 1976, this method has now become one of the most popular approaches to perform pricing analysis. The method…
Cap Table with Investor Returns and Charts
760
2
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Array Formulas in Excel
1,567
195
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Price Position Analysis
2,159
2
Every business needs to know how the prices of its products or services stand against the competition. Comparing prices of…
Inventory Analysis and Management
1,849
0
In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of…
See All