Microsoft Excel Keyboard Shortcuts

Shortcut	Description
F2	Edit the selected cell.
F5	Goto a specific cell. For example, C6.
F7	Spell check selected text and/or document.
F11	Create chart.
Ctrl + A	Select all.
Ctrl + B	Bold.
Ctrl + C	Copy.
Ctrl + F	Find (same as Shift + F5).
Ctrl + G	Go To.
Ctrl + H	Replace.
Ctrl + I	Italic.
Ctrl + K	Insert link.
Ctrl + N	New Workbook.
Ctrl + O	Open Workbook.
Ctrl + P	Print dialog.
Ctrl + S	Save.
Ctrl + U	Underline.
Ctrl + V	Paste.
Ctrl + Z	Undo.
Ctrl + Y	Redo.
Ctrl + X	Cut.
Ctrl + 5	Strikethrough text.
Ctrl + F3	Define Name.
Ctrl + F4	Exit Excel.
Ctrl + F6	Switch between open workbooks.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize current window.
Shift + F1	Activate Help on Item.
Shift + F2	Insert Comments
Shift + F3	Insert Function.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Ctrl + Page down	Move to next worksheet.
Ctrl + Page up	Move to previous worksheet.
Ctrl + Shift + #	Number Format: Date
Ctrl + Shift + @	Number Format: Time.
Ctrl + Shift + !	Number Format: Commas.
Ctrl + Shift + $	Number Format: Currency
Ctrl + Shift + %	Number Format: Percentage
Ctrl + Shift + ^	Number Format: Scientific.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.
Ctrl + (Arrow key)	Move to next section.

Microsoft Excel World Champion

A 15 years old British schoolgirl is the new "Microsoft Excel World Champion"

A 15 years old British school girl Rebecca Rickwood has won a global competition to find the best user of Microsoft’s Excel 2007. 

Rebecca, who is 15, was one of 228,000 competitors from 57 countries. She beat 78 students in the final round. Competitors were required to perform timed tests to demonstrate their skill at making spreadsheets. Rebecca was presented with her $5000 prize last week at a ceremony in San Diego, California.

Competitors performed timed tests to demonstrate their skill at making spreadsheets, reports the BBC, and Rebecca Rickwood, 15, clinched the $5,000 (around £3,000) prize in the Excel 2007 category of the Microsoft Office World Championships without making a single mistake.

She said: “I heard my name read out in first place and I just couldn’t believe it. I’m ecstatic, I just can’t believe I won and now I’m world champion. It’s a day I’ll never forget.”

Rebecca is a pupil at Sawtry Community College, Cambridgeshire, a specialist maths and computing secondary school.

How to Make Windows XP Shut Down Faster

One of the biggest annoyances in Windows XP is to take a long time to Shut Down.
If you want shut it down faster, Please follow these steps:

1. Go to "StartStart Menu" then select "RUN"

2. Type "regedit" and click "OK"




3. Find "HKEY_CURRENT_USER\Control Panel\Desktop"

4. Select "HungAppTimeout"

5. Right click and select modify

6. Change the value to 5000 to 1000.

7. Now scroll down to

"WaitToKillAppTimeout"

8. Change the value to 20000 to 1000.






9. Now Find "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control"  

10. Select "WaitToKillAppTimeout"

11. Change the value to 1000

12. Now Find "HKEY_USERS\DEFAULT\Control Panel\Desktop"

13. Change "HungAppTimeout" value to 1000

14. At last scroll down and change "WaitToKillAppTimeout" value to 1000

15. Close Registry Editor and Restart Windows.

Now Watch Bollywood movies for free

Yahoo to offer Bollywood movies for free

According to a report by market research leader ComScore, the Indian audience is currently spending over 9.1 billion minutes watching online videos each month with entertainment as the leading category in online video content consumption ahead of news and sports content.

Yahoo has launched Movieplex, which will bring thousands of licensed Bollywood movies to the users. It'll also promote a piracy-free quality entertainment space.

Arun Tadanki, managing director, Yahoo said" Over 30 million internet users consume 1.7 billion videos every month across India. With the increasing demand for online video, both consumers and content providers are looking for a trusted destination where quality content can be consumed in a piracy-free environment at their leisure."

To watch the movies without any commercial break! log onto www.movies.yahoo.in/movieplex.

Gmail Calling Now Supports Multiple Calls and Call Waiting

Remember those old multi-line phones with all the buttons across the bottom? They gave you access to more than one line at a time, a feature now available in Google‘s Gmail.

According to the official Gmail Blog, this new multi-call capability

will let you put callers on hold with Gmail’s phone service, picking

up another call at the same time. Too bad there’s no music on

hold to entertain that first caller.

Whether you make a second call or not, you can now put any call on

 hold — useful in case you need to talk to someone in the room or grab something off the stove. Just press the “Hold” button and

 then “Resume” to start talking again.

This feature works across all call types (voice, video, and phone); the only restriction is that a maximum of two outgoing calls to

physical phones can be placed at once.

Best of all, U.S. and Canada calls using the Gmail phone and video system will be free through 2011, and all these new

multi-line features work with Gmail’s phone, voice and video calls.

Nokia, Siemens stumble in latest telecom venture hurdle

Nokia and Siemens are moving to restructure a joint venture in telecommunications networking equipment after failing to acquire a controlling stake in it.

Telecom giant Nokia and conglomerate Siemens are moving to restructure a joint venture in telecom networking equipment after failing to acquire a controlling stake in it.

The Wall Street Journal reports that four-year-old Nokia Siemens Networks, which is unprofitable and lost almost $1 billion last year, may instead require the infusion of more cash by both companies.

A quick play-by-play:
One private-equity group, which included Kohlberg Kravis Roberts & Co. and TPG Capital, dropped out of the auction awhile back. 
 
Attempts to sell a controlling stake to a consortium that includes Gores Group and Platinum Equity are stalling. 
 
Nokia Siemens seems wary of striking a deal because the latter firms are known for investing in distressed assets.

It’s an even 50-50 split in the venture between Nokia and Siemens, but the former has four of the seven board seats.

The issue? The $3 billion business has been an albatross on Nokia’s back for the better part of a year, adding to its known smartphone woes. Despite solid revenue figures for three straight quarters, the venture has posted significant operating losses – €686 million last year, €1.6 billion the year prior.

It’s also facing considerable competition from Ericsson. Meanwhile, an impatient Siemens is waiting in the wings and could very well take control of the venture to get things moving.

www.eroztech.in

India starts blocking file storage websites in a move against piracy

Widely used file storage websites such as Megaupload, Rapidshare, Mediafire and Putlocker are being reported as blocked by users in India.

File storage websites such as Megaupload, Putlocker, Rapidshare are being blocked in India.
A thread started on a popular online forum focused on developments in Indian broadband has furious and surprised users sharing a list of websites blocked by their Internet service providers. Going through the thread and my Twitter interactions, India’s Department of Telecommunication is behind the block.
Some users say they are not able to browse the file uploading websites, others say they can access and download content. A screenshot shared by Sunny Chahal on Twitter confirms that the block is in effect. Some other users are seeing the same notice. The error message:

Users of popular Internet Service Providers MTNL, BSNL
and Airtel have confirmed seeing the same error while visiting some or all of the following websites:






Megaupload.com
Mediafire.com
Megavideo.com
VideoBB.com
Novamov.com
Movshare.net
Rapidshare.com
Putlocker.com
Hotfile.com
Fileserve.com
Filesonic.com
Filesonic.in
Depositfiles.com
Wupload.com
The decision behind banning the websites looks like piracy. Most of these websites are widely used to  share content production houses and record labels would want users to pay for. Users are comparing the ban to Internet rules in China. The Department of Homeland Security in the US also made definitive moves against piracy by seizing domains of websites hosting pirated content.

As of now there is no official word from the DoT, the story will be updated as we get more

Google+ Tips & Tricks

Google+ has added 20 million users in just 3 weeks from its launch.Google+ has tried to address all the issues like privacy,interface,navigation which users faced in facebook. They have been regularly removing fake profiles as well as spam to keep it clean.If you are already on Google+ then you should know these tips and tricks as they will help you to easily use this social networking site.

• By writing text between * it gets bold.If you write *word* it will become word
• By writing text between _ it gets underlined.If you write _word_ it will become word
• By writing text between - it gets strikethrough.If you write –word- it will become word
• Google+ supports Drag and Drop,so you can share things like links,photos,videos by directly dropping them into Share box
• To mention someone in your comments use + or @ before writing their name.
• Google+ doesn’t have private messages but you can share a post with only specific friends and don’t forget to disable Reshare
• To get permalink of any post click on the timestamp of that post.
• Public and Private posts are differenced by colors; Green = Public, Blue = Limited to circles
• In one of my earlier posts I mentioned about Facebook Shortcut Keys .Here are Google+ Hotkeys

1. Space=Scroll Down
2. Shift+Space=Scroll up
3. J=Single Post Down Scroll
4. K=Single Post Up Scroll
5. Q=Jump to Chat
6. Return=Start Comment

• You can Like any post by clicking on +1 button and unlike it by again clicking on +1button

If you know any other trick that has not been shared here then Do share it by posting a comment.Also Like or +1 this post to share these cool Google+ tricks with your friends.

Facebook Shortcuts

If you spend a lot of time on facebook then why not spend it more efficiently. There are a lot of browser specific keyboard shortcuts for facebook.

Google Chrome Facebook Shortcuts

Alt+1: View your News Feed
Alt+2: View your own Profile
Alt+3: View pop-up of friend requests
Alt+4: View pop-up of messages
Alt+5: View pop-up of notifications
Alt+6: View Account Settings
Alt+7: View Privacy Settings
                                                                                    Alt+8: View Facebook’s own profile
                                                                                    Alt+9: Read latest Terms of Service agreement.
                                                                                    Alt+?: Search
                                                                                    Alt+m: Compose a new message

If you are using Internet Explorer then you you can use the Facebook shortcuts of Google chrome,but you have to press ENTER after each shortcut.

Firefox Facebook Shortcuts

Shift+Alt+1: View your News Feed
Shift+Alt+2: View your own Profile
Shift+Alt+3: View pop-up of friend requests
Shift+Alt+4: View pop-up of messages
Shift+Alt+5: View pop-up of notifications
Shift+Alt+6: View Account Settings
Shift+Alt+7: View Privacy Settings
Shift+Alt+8: View Facebook’s own profile
Shift+Alt+9: Read latest Terms of Service agreement.
Shift+Alt+0: Open Facebook Help Center
Shift+Alt+?: Search
Shift+Alt+m: Compose a new message

How to make internet 20% faster in Windows XP ??

1. Open Run in the Start Menu and type “gpedit.msc“.

2. Click Administrative Templates folder under Computer Configuration in the left side of windows panel.

3. Click folder Network on the right side

4. Double click Qos Packet Scheduler folder.

5. Double click Limit Reservable Bandwidth and click Enabled option button and set the Bandwidth Limit (%) to 0 in the text box and click OK to finish.

How to Block Friends from The Facebook Chat

Would you like to block annoying Facebook friends from the Facebook Chat and have no idea how to do it? Here is an easy way to block so-called friends.

Follow these easy steps to block people who keep messaging you via Facebook chat:

1. Open Facebook chat.

2. Click on the Friend List, located on the top, left of the chat window.

3. In empty field write ‘Blocked’ and then hit enter button.

4. Now simply drag and drop friends to an empty dotted field you have just created, displaying on the top.

5. Once you have moved all people you would like to block in an upper window, click go offline button.

6. Your online status is now hidden and your friends have been now blocked from the Facebook chat, and can no longer see when you are online or either offline.