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.

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Dates and Timelines in Excel
519
31
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
Charts and Dashboards in Excel (full version)
594
1
The attached file: - defines key chart elements and explains how to edit them - demonstrates how to deal with…
Charts and Dashboards in Excel (short version)
614
67
This is an introductory part to creating professional charts which:   - defines key chart elements and explains how to…
Analysing sensitivities with indifference curves (unlocked)
537
1
This is an unlocked version of the same utility published on my page. In this version you can access and…
Analysing sensitivities with indifference curves
523
53
Indifference curves depict sensitivity of an output to the two inputs. Each curve corresponds to a fixed output amount and…
Portfolio Analysis and Sales Forecasting
959
2
The attached template provides the basis for product portfolio analysis as follows: - key statistics: total, average, median, standard deviation (total…
See All