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
Price-Volume-Mix Analysis
171
1
This set of tools, methods and techniques will help you calculate and depict variances. A special focus is made on…
Measuring and Modelling Seasonality
286
0
Many businesses are affected by seasonal demand changes. They cause their revenues, expenses and resource requirements change through the year.…
Interim Budgeting (Reforecasting)
564
1
Virtually every company develops its annual budgets. The budgets are compiled before the beginning of the financial year of a…
Profit Distribution and Carried Interest Waterfall
561
0
This template describes real-world mechanisms of distributing profits between project participants. It starts with modeling a distribution to a preferred…
Descriptive statistics for grouped (weighted) data
996
83
Excel has a powerful set of tools to perform statistical analysis, but they apply only to ungrouped data. As an…
Dates and Timelines in Excel
1,906
182
In this post we will look at: a) Extending or shortening time schedules b) Modelling interest expense c) Planning orders,…
See All