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
Loan Schedule
307
2
This template will help you calculate loan and interest balances, accrued interest at any point in time on loans granted or issued.…
Capex Budget
522
1
 Any company which uses fixed assets in its operations needs to know:   Investment cash flow related to new fixed…
Payroll Budget
779
0
Payroll expenses and employee costs in general form an important and material part of a company’s budget. This template built on the highest…
Travel Budget
703
0
Travel expenses make up an important and material part of a company’s budget. This template built on the highest professional financial modeling…
HR Analytics and Dashboard
1,398
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
2,175
186
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
See All