Mapping relationships between people using interactive network chart
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people.
Demo of interactive network chart in Excel
First take a look at what we are trying to build.
Looks interesting? Then read on to learn how to create this.
Calculating average of every nth value [Formula tips]
Lets say you have a large list of numbers, and you want to calculate the average of every nth value. Not the average of all numbers, but just every nth number.
That is what we will learn in next few minutes.
Formula Forensics 024. Is this number a Prime Number ?
Is my number a Prime Number?
What is a Prime Number?
Today in Formula Forensics we answer both questions.
Formula Forensics 022. Sum the Odd Numbers between 1 and 100
How can we Add Up the Odd numbers between 1 and 100 ?
Formula Forensics No. 005 – Zebras and Checker-Boards
Zebra Stripes and Checker Boards
This week in Formula Forensics I’m taking a break from Array Formulas to have a look at some Zebra Stripes and Checker Boards.
No, I haven’t gone crazy, although some may argue that point.
More specifically were going to take a look at, Zebra Stripes and Checker-Board Conditional Formatting.
Formula Forensics No.004 – Fred’s Problem
.
.
.
.
.
.
.
This is the Forth post in Chandoo’s, Formula Forensics series.
Last week Luke showed us how to extract a sorted list according to a criteria from a larger list
and he analysed a formula to solve this problem
This week we look at Fred’s Problem…
How do I simplify a very long formula?
Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]
You take an apartment on rent at $1000 per month and the owner puts an escalation clause saying 10% increment each 3 years. How do you model this in excel? In this tutorial we understand how escalations at certain frequency can be implemented using the mod function in excel. What is the mod() function Simply […]