Articles | Kenny Ng

- Jan 31, 2018
- 1 min read

Use the INDEX() function

Use the INDEX() function to retrieve the value of a particular cell within a matrix of cells.

Technical Resources

4 views

- Dec 31, 2017
- 1 min read

Cell referencing using OFFSET()

Use the offset function to reference a cell or a group of cells in excel. The offset function itself isn't very helpful unless you combine this in application such as modelling straight line deprecation.

Technical Resources

3 views

- Dec 31, 2017
- 1 min read

Use the MATCH() function

Search for values in a series of cells. The result is the position of the 'matched' value in the set.

Technical Resources

2 views

1 2 3

Topics

Pinned

Three "epic fails" nearly wiped me clean.

Three "epic fails" nearly wiped me clean this year. Here are five things I’d learned from these painful lessons: 1) Despair and greed (bo...

The REAL social dilemma

In 1990, a psychologist quoted in the New York Times reported that people “turn on the TV when they feel sad, lonely, upset or worried, a...

First a businessman, then an investor

Good investors are first and formost by nature: business people. They should be entrepreneurs, owners of businesses or have been placed...

My cover letter from 2006

IB isn't only about late nights & number crunching, but also the toxic & condescending environment one has to put up for many years to come.

Forty Takeaways

There’s nothing you should regret in life - all the good things that you have today are a result of everything that has happened. Consist...

Money is a replaceable resource.

Money is the one thing that you can always replace any time or at some point of time in the future - money is just money.

When starting a business...

More than three years since I started out, I discovered a new-found respect for the many areas of businesses which are presumably oblivio...

Rules for living

Learning, knowledge and staying up to date with the news and what's going on in the world is your own personal responsibility. The same g...