My Small World

IFERROR funtion

noreply@blogger.com (B Arvind Kumar) — Sun, 11 Dec 2011 15:28:00 +0000

We often tend to encounter instances while using formulae performing day to day operations where...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Turn Off AutoRecover For Individual Workbooks

noreply@blogger.com (B Arvind Kumar) — Mon, 29 Aug 2011 05:21:00 +0000

In Excel 2007 and 2010, there is a feature called AutoRecover that saves your open workbooks at...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

"DATEDIF" function to calculate the number of days/months/years between dates

noreply@blogger.com (B Arvind Kumar) — Fri, 19 Aug 2011 15:14:00 +0000

A simple subtraction between two date values gives you the number of days between the two days....

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Lost in the vicinity...

noreply@blogger.com (B Arvind Kumar) — Sun, 29 May 2011 17:55:00 +0000

TIt has been a while since I've blogged...not because I was too busy but reasons beyond thought!! ...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Changing case of text in a cell

noreply@blogger.com (B Arvind Kumar) — Sat, 12 Mar 2011 05:23:00 +0000

Excel 2007 and 2010 versions allow easy shortcut keys to change the case of the text in any given...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Halla Bol

noreply@blogger.com (B Arvind Kumar) — Wed, 26 Jan 2011 06:11:00 +0000

A sunny welcome to the 62nd Republic Day. Woke up to enjoy the holiday and tuned in to the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Life on Android

noreply@blogger.com (B Arvind Kumar) — Sun, 16 Jan 2011 14:32:00 +0000

Its been over a week since I last connected my system to the net...! Reason: my new android phone!...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Shortcut to AutoFilter

noreply@blogger.com (B Arvind Kumar) — Sun, 26 Dec 2010 10:32:00 +0000

One of the most frequently used feature of Excel is the autofilter. Most power users tend to use...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

"CountIF" or "SumIF" with an extra "S" makes the difference...

noreply@blogger.com (B Arvind Kumar) — Sun, 12 Dec 2010 16:36:00 +0000

Most of the users are very used to formula like "COUNTIF"or "SUMIF"... Excel offers "S" factor...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Finding a perfect match... Tough!

noreply@blogger.com (B Arvind Kumar) — Mon, 15 Nov 2010 19:41:00 +0000

Being single at 30 seems to be such a big crisis to family, friends and well-wishers that I...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Happy Diwali

noreply@blogger.com (B Arvind Kumar) — Fri, 05 Nov 2010 16:24:00 +0000

Diwali Gifts This Diwali has been an occasion of quite enriching experience. It was so that my...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Shortcut to insert current date in a cell

noreply@blogger.com (B Arvind Kumar) — Sun, 26 Sep 2010 13:10:00 +0000

Want to insert the current date in a cell with just a key stroke...? The answer is simple -...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Copy visible cells...

noreply@blogger.com (B Arvind Kumar) — Fri, 06 Aug 2010 14:29:00 +0000

Have you ever tried copying a list where there are multiple hidden rows...? Whats the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

The power of "&" operator in Excel

noreply@blogger.com (B Arvind Kumar) — Thu, 24 Jun 2010 06:53:00 +0000

Have you ever tried combining the contents of two cell... the first thing that comes to mind is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Custom Validation in Excel

noreply@blogger.com (B Arvind Kumar) — Fri, 14 May 2010 06:05:00 +0000

Have you ever tried to create a worksheet where you dont want the user to create duplicate...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Navigation powered by "Ctrl" in Excel

noreply@blogger.com (B Arvind Kumar) — Wed, 14 Apr 2010 21:25:00 +0000

Have you ever wondered the power of the key "Ctrl" while you are navigating in an excel worksheet...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

The missing spark...

noreply@blogger.com (B Arvind Kumar) — Wed, 14 Apr 2010 21:07:00 +0000

It has been quite a while since I've been blogging...! Somehow... the spark seems to be missing all...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

My Name is KHAN...- "Hardwork" facing challenges...!

noreply@blogger.com (B Arvind Kumar) — Fri, 12 Feb 2010 10:48:00 +0000

What is this retaliation for...? Is this a personal battle in the veil of political unrest...? What...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Counting Indian States

noreply@blogger.com (B Arvind Kumar) — Tue, 29 Dec 2009 14:46:00 +0000

I remember my school days when we used to read India comprises of 25 states & 9...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Kolkata - City of Ironical Agitation..

noreply@blogger.com (B Arvind Kumar) — Mon, 30 Nov 2009 05:43:00 +0000

Today is a an agitation with a difference...! "BJP" the so called people's party has raised a voice...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Formula: Round()

noreply@blogger.com (B Arvind Kumar) — Wed, 18 Nov 2009 10:10:00 +0000

Intermediate to advance users of Excel may be quite familiar with the formula "Round()" where one...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Maharashtra - no more a part of India?

noreply@blogger.com (B Arvind Kumar) — Sun, 15 Nov 2009 10:30:00 +0000

I think the MNS brigade is going all out to prove nothing...! What do they want? A country of their...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Blogger at the reception...

noreply@blogger.com (B Arvind Kumar) — Tue, 03 Nov 2009 12:35:00 +0000

I was out to a client's place last week where I had to wait for the client's representative at...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Word: Change case

noreply@blogger.com (B Arvind Kumar) — Thu, 22 Oct 2009 17:57:00 +0000

Oops... typed something in caps where you had to have in small case...?? Dont worry... Word...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Keyboard Shortcut to add/delete rows or columns in Excel

noreply@blogger.com (B Arvind Kumar) — Fri, 16 Oct 2009 09:37:00 +0000

"Ctrl + +" (add rows or columns) and "Ctrl + -" (delete rows or columns) are the easy shortcuts one...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]