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
Hotel Acquisition Financial Model
284
0
This is a detailed, well-structured and transparent cash flow model for an acquisition of a hotel. The model includes the…
Hotel Development Financial Model
319
1
This is a detailed, well-structured and transparent cash flow model for the development of a hotel. The model includes the…
Rent Roll Analysis and Stacking Plan
1,889
2
I. RENT ROLLA rent roll is a table listing the tenants of a real estate asset, showing how much area…
Complete Three-Statement Quarterly Budget
1,968
1
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Quarterly Budget with Scenarios
1,722
4
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Monthly Budget
1,653
0
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
See All