Pages

▼
Thursday, January 9, 2014

Top 10 things I learned using Excel for a decade

›
Sometime during the 2nd half of 2013, I finished 10 years of Excel usage.  In the last 10 years, I completed my studies, got my first j...
1 comment:
Thursday, October 17, 2013

42 tips for Excel time travelers

›
Today, let’s travel in time .  Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel! Of course, we are no...
Saturday, October 5, 2013

Formula Forensics No. 035 Average the last 3 values greater than 0

›
A couple of weeks ago  Amanda  asked a question at  Chandoo.org “I need to calculate a moving average of the last 3 months. However, ...
Monday, September 30, 2013

I said your spreadsheet is really FAT, not real PHAT!

›
Howdy folks. Jeff Weir here, borrowing the keys of Chandoo’s blog so I can drive home a serious public service announcement. At Chandoo...
Friday, September 27, 2013

What are best Excel interview questions? [survey]

›
Hello folks… Time for a fun & useful survey. This time lets talk about  Excel Interview Questions . Many of you are silently beco...
Friday, September 20, 2013

7 reasons why you should get cozy with INDEX()

›
Today lets get cozy. Lets start a fling (a very long one). Lets do something that will make you smart, happy and relaxed. Don’t get any ...

How to Solve an Equation in Excel

›
This week at the  Chandoo,org Forums ,  Usman  asked, “ I have a curve. I did its fitting using Excel and got an equation. y = 2E+07x...
Monday, September 16, 2013

Using Array’s To Update Table Columns

›
We are almost daily creating a lot of reports and these reports contain a lot of data which is presented in various styles as per the req...
1 comment: