How to skip rows in an Excel formula?

There is nothing more frustrating in MS Excel and Google Spreadsheets than their inability to recognize a pattern in referenced cells. For example, if you type 1, 3, 5 and 7 in four cells and then drag them down, Excel knows that the next in series is 9, 11, and 13 etc. However, if you […]

excel skip rows when referencing

Details of the Draft Gold Monetization Scheme

May 20, 2015

The Finance Ministry published a draft on the Gold Monetization Scheme that the finance minister had spoken about during the recent budget. The big idea behind gold monetization is that India produces almost no gold and imports massive amounts of it — up to a thousand tons a year — this leads to a big trade […]

Click to continue →

Indian Trading League (ITL) – Mauka Rs. 1 Crore Jeetne Ka, India Ka Best Trader Banne Ka

May 19, 2015

This post is written by Shiv Kukreja, who is a Certified Financial Planner and runs a financial planning firm, Ojas Capital in Delhi/NCR. He can be reached at skukreja@investitude.co.in It was Amitabh Bachchan who started the trend of rewarding Rs. 1 crore to the individuals winning the most popular game show in the Indian television […]

Click to continue →

Thoughts on the India – China MOUs

May 17, 2015

The China pitstop has perhaps been the most interesting in our globe trotting PM’s itinerary. The beginning wasn’t as exciting for its substance as it was for its selfie opportunities, and even though a couple dozen government to government MOUs were announced, it is hard to get excited about an agreement between Doordarshan and China Central […]

Click to continue →

Warm blooded fish gets tax demands while watching British TV shows

May 16, 2015

Let’s start this week with an excellent article from the Economist on the dawn of artificial intelligence. AI is advancing in leaps and bounds, and there are some prominent people who worry that it might lead to the end of us. A sad state of affairs – CAG assesses that the Indian army will run out […]

Click to continue →

Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY) vs. LIC eTerm Plan, SBI Life eShield Plan, Kotak Preferred e-Term Plan & Max Life Online Term Plan

May 15, 2015

This post is written by Shiv Kukreja, who is a Certified Financial Planner and runs a financial planning firm, Ojas Capital in Delhi/NCR. He can be reached at skukreja@investitude.co.in People have been very excited about the recently launched social security schemes – Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY), Pradhan Mantri Suraksha Bima Yojana (PMSBY) […]

Click to continue →

Can the Black Money Bill affect you directly?

May 14, 2015

Rajya Sabha cleared the Black Money Bill today, which is officially Undisclosed Foreign Income and Assets (Imposition of Tax) Bill, 2015, and this is perhaps the only piece of legislation which the Congress finds itself unable to oppose. The finance minister had first talked about this Bill earlier in the year, and the bill has been introduced […]

Click to continue →

Book Review: Animal Farm

May 13, 2015

I’ve recently finished reading Animal Farm written by George Orwell, and it is quite an extraordinary book. It is a classic and I won’t be surprised if a lot of you have already read it, but if not, please pick it up and give it a read. It is brief, thought provoking and although it […]

Click to continue →

Participating Banks & Insurance Companies Servicing Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY) & Pradhan Mantri Suraksha Bima Yojana (PMSBY)

May 12, 2015

This post is written by Shiv Kukreja, who is a Certified Financial Planner and runs a financial planning firm, Ojas Capital in Delhi/NCR. He can be reached at skukreja@investitude.co.in Prime Minister Mr. Narendra Modi launched three new social security schemes under his government’s Jan Suraksha initiative during his visit to Kolkata on May 9. As […]

Click to continue →

What is the BRICS Bank that K V Kamath just became the president of?

May 11, 2015

Mr. K V Kamath was named the first head of the BRICS Bank or officially the New Development Bank today, and the news was all over today with much excitement and pride (a little misplaced in my opinion). First, a little history on the acronym BRICS, and then a little history on the bank itself. “BRICS […]

Click to continue →

What is full convertibility of the Rupee?

May 10, 2015

The RBI Governor, Dr. Raghuram Rajan has brought up the subject of full convertibility of Rupee again recently, and it will be interesting to see what steps he takes to make it happen in the future. Capital account convertibility of the Rupee means the ability to convert INR into any foreign currency, and the foreign currency […]

Click to continue →