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
Cap Table with Investor Returns and Charts
58
0
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Array Formulas in Excel
578
57
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Price Position Analysis
1,237
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,105
0
In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of…
Price-Volume-Mix Analysis
1,522
2
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Measuring and Modelling Seasonality
1,361
1
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses, inventory and resource requirements change through the…
See All