Jan 24 2012

Excel shows Formula’s instead of Values

Category: Excel,Microsoft,Technology — Kamlesh @ 11:28 pm

I have been using Laptop since few months and most of the time I get into trouble by pressing wrong combination of keys.  I am an expert PC keyboard user, but I am still not that fast on a Laptop keyboard.  Today, while updating my Project Status Report in Microsoft Excel 2010, I pressed a secret combination of keys which showed me the below screen:

Excel shows Formula instead of Values

For a moment, I got shocked! Microsoft Excel showed Formula’s instead of the values.  The Date column (Column B) showed me the internal numeric values too. I realized that I must have pressed a combination of reserved keys in Excel.  I could resolve this by pressing CTRL+` key.  Please note that in most of the keyboards, the ` key is located left to the numeric 1 (and below Escape key). As an alternate for Mouse users, you can even use the Office ribbon (Formula’s tab) to access the same option:

Excel 2010 Show Formula's toolbar

For the Keyboard Users, please refer to the complete list of Excel 2010 keyboard shortcuts on the Microsoft website.

 

Jan 01 2012

Wish you a Happy and Prosperous New Year 2012

Category: Events — Kamlesh @ 7:54 am
Wish you a Happy and Prosperous New Year 2012

Wish you a Happy and Prosperous New Year 2012

Dec 31 2011

Donate Old Clothes in Bangalore

Category: Art of Giving,Bangalore — Kamlesh @ 11:57 pm

Drop-box at Sri Rakum School (Donate old clothes in Bangalore)

Sri Rakum School for the BlindYou can donate your Old Clothes, Rice Provisions Toiletries, Old Newspapaper at Sri Rakum School for the Blind.  Its a free school for the visual impaired and under privileged ones.  This school is located at Sri Krishna Temple Road (parallel to CMH Road) Indiranagar.

You can even sponsor on your Birthday / Wedding Anniversary & Festivals by donating at their office.  The best part is that their drop-box is open 24/7.

When I visited their premises 2 days back to donate my son’s old bicycle, I got chance to meet Acharya Shree Rakumjee.  Acharya’ji was having great time with kids in the evening.

Here is the Google Map link of this school.  Please visit their official website to know about other Locations and contact numbers.  They even accept Online donations.

All donations to Sri Rakum School for the Blind are eligible for tax exemption under Section 80G(5) (VI) of the Income Tax Act.

To get directions to us from any place in Bangalore, just SMS “rakum school from <your starting point>” to 90088 90088

Dec 25 2011

Bangalore IT Pro Usergroup Meet (7th Anniversary Celebration)

Category: Bangalore,Events — Kamlesh @ 10:40 am

Bangalore IT ProComing January 2012, Bangalore IT Pro User Group will turn 7 years. On this occasion, this User Group is conducting a full day event at Jayanagar on 07-Jan-2012.  If you are a IT Professional and want to learn about the upcoming Microsoft stack for IT Pro’s, then you should not miss this event.  Below is the agenda of this event:

Agenda (Saturday January 7, 2012):

09:00AM - 09:30AM - Registration & Welcome
09:30AM - 10:00AM - Keynote (Pradipta Sharma)
10:00AM - 10:45AM - Windows 7 SP1 Deployment using MDT2012 Beta2 (Saravanan Rajappa)
10:45AM - 11:30AM - Exchange 2010 SP2 Overview (Ismail Mohammed)
11:30AM - 11:45AM - Tea Break
11:45AM - 12:30PM - Top 5 Free Desktop Deployment and Planning Tools for Every IT Professional (Aviraj)
12:30PM - 01:15PM - PowerShell 3.0 features in Windows 8 and Windows 8 Server (Ravikanth Chaganti)
01:15PM - 02:00PM - Lunch Break
02:00PM - 02:45PM - Private Cloud Architecture Design & Demos (Anand MS)
02:45PM - 03:30PM - Windows Server 8 Preview (Gaurav Anand)
03:30PM - 04:00PM - Tea Break
04:00PM - 04:45PM - Microsoft Indic in Windows 7 and Windows 8 (Dr.Pavanaja)
04:55PM - 05:30PM - Community Award ceremony & Closing Note

Venue:

JSS Auditorium
1st Main, Jayanagar VII Block, Kanakapura Road
Jayanagar VII Block
Bangalore 560011

For those who are unfamiliar with the location, here is the Bing Map and Google Map.

Click here to register for this event.

Dec 18 2011

Free Software based GPS Sensor for your Desktop PC / Laptop

Category: Mobiles,Technology,Windows 7,Windows 8 — Kamlesh @ 10:53 pm

Today, I discovered a great Free tool for Windows 7 users who was to detect their location without GPS hardware on the Desktop PC/Laptop.  I have just tried this on my Desktop PC and found amazing results. You would require a Windows 7 operating system to try the below steps.  Also, please note that “Location and sensors support” option will be present in “Home Premium” and above editions of Windows 7. This means that you cannot try this if you are using Start or Home Basic editions of Windows 7.

  • Visit Geosense Location Sensor website and download the free tool (Geosense_1.2_x86.msi ~4mb). It has both 32-bit and 64-bit version of this tool.
  • Run the setup file. During the setup, it will prompt for confirmation to install a Device Driver named from “The Within Network, LLC“.
  • After the setup completes, go to Control Panel -> Locations and Other Sensors, and enable the Geosense Location Sensor.
Location and Other Sensors (Windows 7)

Location and Other Sensors (Windows 7)

  • Tip: Use the “View location activity” link on left to add the snap-in into the Microsoft Management Console (MMC).  This will help you to review the “Location Activity” log, which will give you details like FriendlyName, ImagePath, PID, Username, SID.

Once the above setup is over, you can use the following applications to test your Location:

  • Weather Gadget of Windows 7
  • Small Test Application – “Location enabled Google Maps client” (developed by Geosense team) – GoogleMapsDemo_1.0.zip ~60kb

Bingo! The Test Application gave me very accurate result on my Desktop PC.

More Information on this Topic and related area:

Now, I eagerly look forward to try this on a Laptop and share my result.

 Update: 24-Dec-2011

During the week, I experimented this tool with my Laptop going around the places.  I am happy to notice that the tool returns almost accurate results, provided you are using the right Internet Connection. It makes use of your IP address to find your location  In some cases, if you are in a Corporate Network/VPN, then there are some chances that you may be seen in some other Country! During one of my Test Result via VPN, I was seen at Japan :-)

Another update, that I want to share is that this software works well in Windows 8 Developers Preview too.

Dec 18 2011

How to check Serial Number of HTC Touch Viva?

Category: Mobiles — Kamlesh @ 8:36 pm

Find HTC Touch Viva Serial NumberRecently, I faced a problem with my HTC Touch Viva phone.  I visited their Support Website to raise a Ticket for getting assistance.  During this process, the online form asked me the Serial Number of my phone (this was a Mandatory field to fill).  But they didn’t explain how to get the Serial Number! This added an additional effort to visit a Search Engine and find the answer.

I have also seen some other Support Websites, which provides user-friendly Tips (on the Online Form)to locate the Serial Number easily. I wish the same was available on HTC website too!

Coming back to the answer to this blog post, there are two “universal” ways to find the Serial Number.  Your mobile device serial number, is also available as part of the IMEI (International Mobile Equipment Identity) Number. Check this Wiki page to get an in-depth knowledge on IMEI numbers.

  • Available on the little sticker under your battery (requires to switch off your phone).
  • Dial *#06# into your dial-pad will give you the IMEI number.

A friendly note – the above procedure will remain same for all the Mobile Phones (Nokia, Samsung, LG…) across the world!

Dec 15 2011

Windows Phone Camp at Pune and Chennai (December 2011)

Category: Events,Microsoft,WP7 — Kamlesh @ 10:02 am

Windows Phone 7.5 MangoIf you dream of apps, then this is for you! This very first edition of the brand new Microsoft Windows Phone Camps is coming to your city in India.  The event promises to be an in-depth learning experience, where developers and designers can directly interact with domain experts.

Agenda:

10:00am to 10:45am – The Windows Phone Opportunity
10:45am to 11:30am – Getting Starting – Tools & Marketplace
11:30am to 12:15pm – Designing Applications for Windows Phone
12:15pm to 01:00pm – Developing Applications for Windows Phone
02:00pm to 02:45pm – Making your Application Submission Ready

 

Event at Pune:

Date: Tuesday 20th December 2011 – 9:00am to 3:00pm
Venue: Le Meridian, Raja Bahadur Mill Road, Pune.
Registration: No Registration Fee – Click here to Register Now.

Event at Chennai:

Date: Thursday 22nd December 2011 – 9:00am to 3:00pm
Venue: Savera Hotel, 146, Dr. Radhakrishnan Road, Chennai.
Registration: No Registration Fee – Click here to Register Now.

 

Nov 13 2011

Annual Garden Fair 11-20 Nov 2011

Category: Bangalore,Nature — Kamlesh @ 10:01 pm

APD Annual Garden Fair Nov 2011The Association of People with Disability presents 15th Annual Garden Fair (11 to 20 November 2011).

A 10 day sale of exotic ornamental plants, medicinal plants and herbs.

Venue:

Horticulture Training Center,
9th B Main, 10th Cross, LIC Colony,
Jeevanbima Nagar, HAL 3rd Stage,
Bangalore – 560075
Phone: 25288672
Time: 9:30am to 6:00pm

Official Website: www.apd-india.org

Help us avoid using plastic. Please bring your own bags.

Nov 03 2011

Windows Phone SDK 7.1 ISO Offline Installer

Category: Mobiles,Windows Update,WP7 — Kamlesh @ 11:55 pm

Here is the ISO direct download link of Windows Phone Software Development Kit (SDK) 7.1. This ISO file(WPSDKv71_en1.iso) size is around 730MB and is compatible with the final version of Visual Studio 2010 SP1. It was released on 25-Sep-2011.

You can develop apps and games that target Windows Phone OS 7.1 and Windows Phone OS 7.0 with this software. The Windows Phone SDK was previously named Windows Phone Developer Tools.

A word of caution:

  • If a pre-release version of the Windows Phone SDK 7.1 (Beta or RC) is installed on the machine, please uninstall it before installing this product.
  • Virtual machines are not supported.

For more details, here is the official link from Microsoft website.

Nov 02 2011

My Mobile Phones

Category: Mobiles,Uncategorized — Kamlesh @ 1:45 pm

Devices! Devices! Devices! These are the mobile phones, I(my family) have used so far:

Nokia 5110, Nokia 3110, Nokia 3115, Nokia 6300, HTC Touch Viva, Nokia 1280

  1. Nokia 5110 was my first Mobile Phone (Year 1999), which was a rough &amp; tough model. (Colleagues nick named it as Hammer!)  [Status - Lost]
  2. I have been fan of the Nokia Navi key. The 2nd Phone was again Nokia model – Nokia 3315. And yes, this phone is still available as backup phone! [Status - Available]
  3. Nokia 3110 – Two things I got for the first time (1) Color display (2) Camera. This phone is now used by my wife :) [Status - Available]
  4. I loved the metallic touch and keypad of Nokia 6300. Mine was red color. Writing text message used to be fun with its keypad. [Status - Exchanged]
  5. Finally arrived the Windows Phone – HTC Touch Viva, which is a Touch Screen with stylus. I am using this phone currently. [Status - Available]
  6. Nokia 1280 – Purchased a very basic black & white phone for my Mother recently (via Flipkart) [Status - Available]
  7. Hidden Update – I also own LG Optimus P500 few months back, which is still running its Trial Run on a separate BSNL 3G SIM.  I am yet to completely migrate from HTC Touch Viva to LG P500. [Status - Available]
  8. Whats next??? Technology is advancing day by day.  As I see the new upcoming models – I get tempted to upgrade my phone.  This time I decided to wait and watch the Competition, and then decide upon a new phone based on my requirement.  [Status - Unknown]

I keep changing my Mobile at least once in every two years. How many mobile phones have you used so far? At the time of writing this Blog Post, I have committed to myself that I will not upgrade my phone again in 2011 ;-)

Next Page »