10 Useful Excel Tips and Tricks

1. Wrapping texts in a single cell.
You can wrap texts in a cell. Doing this, it will display multiple lines with in the
cell. You can wrap texts in a cell by pressing ALT + Enter in the cell. Or you can go to
Format –> Cells –> Alignment and select Wrap Text.

2. use of Enter key
When you hit the ENTER key in Excel, you will automatically drop down to the
cell just below it. But you can change this default and change this feature.
a. Go to Tools -> Option
b. Select the Edit Tab
c. Under Move Selection after Enter, you can either select a different
Direction for the drop down box, or remove the check in front of the option according to your need.
Note: If uncheck it, the ENTER key will not move
you to another cell rather you’ll need to use the arrow keys to move around.

3. Current date or time
You can use the following formula to get current date with time in excel.
=NOW() ?shows both, current date and time.
=TODAY() ?shows only today’s date.

In bonus with this trick, =Time(hours, minutes, seconds) value gives you the time you entered in specific format.

For example: =TIME(1,2,3) outputs, 1:02 AM
=TIME(21,2,3) outputs, 9:02 AM

4. Shading the rows alternately
This tips can be helpful if you most of the time gets confused on the rows you are watching. Applying shades as you have seen in most of the graphical representation papers around you helps you to avoid confusion.

To do this,
• Highlight the range of cells or rows or columns that you want to format by left clicking and dragging the area.
• Go to Format–>Conditional Formatting

• In the Conditional Formatting dialogue box, select Formula Is from the first drop-down list box, and enter =MOD(ROW(),2)=0 in the second box.

• Click the Format button to bring up the Format Cells dialog box.
• Select the Patterns tab and specify a color for the shaded rows.

• Click OK twice to return to your worksheet.

5. Change the color of sheet names:

Right click on sheet you want to change the color of and select “Tab color” option to change the worksheet tab colors. Group them with similar colors if you have lot of sheets, it lets you to easily recognize the specific sheet.

Transform your Windows XP in to Windows 7

  If you are using Windows XP and want to experience Windows 7 without installing then here is Seven Remix XP transformation pack to transform Windows XP to Windows 7.With this simple app you can make your XP look like Windows 7 in just few clicks. It supports Windows XP, Windows 2003, Windows Media Center Edition and some other flavors of XP. Will work with only 32 bit edition of Windows.

Just download it and install .
Download Seven Remix XP and transform your windows xp .

ALL YOUR GOOGLE SERVICES AT ONE PLACE

ALL YOUR GOOGLE SERVICES AT ONE PLACE

As many of you know, Google has grown from just a search engine to a company which offers various internet services. There are many services that Google offer. But, the question arises, How do you maintain and stay in touch with the services offered by google? 

Yes, you have got a service for that too. Gpanion, is a Global Google dashboard which provides quick access to all your Google services. Gpanion also helps you to customize apps depending on your app usage. You can open any service by just click on it. Each service opens in a new tab, making a way for multi-tasking.

Gpanion looks simple and elegant. Overall it's a nice place to quickly access all your Google services.

Visit Gpanion

Create A Mosaic Pattern Using Your Facebook Friend’s Photos

Create A Mosaic Pattern Using Your Facebook Friend’s Photos

   By using Photoshop techniques we can create mosaic pattern of the our photos.But this takes some time and need some photoshop skill to develop it.But can u ever imagined of creating the mosaic pattern using your (Twitter/Facebook, Myspace) Friends,one such tool is provided by Frintr.com

It doest needs any signup/registration,you can simply log in Using your (Twitter/Facebook, Myspace) Account. And upload your photos and start creating new mosaic pattern wallpapers and posters

Start Creating Mosaic patterns:visit  http://frintr.com

Copy Firefox passwords to new os Backup firefox password file

All firefox passwords are stored in three files

signons.txt, signons2.txt, key3.db

These files are stored in your firefox profile folder.

In Windows XP firefox profile is at:

c:Documents and SettingsWindowsUsernameApplication DataMozillaFirefoxProfilesprofilename

Copy these three files and save them where ever you want and if you want these passwords in your other os also then just replace these three files.

How to view saved passwords in Mozilla Firefox

How to view saved passwords in Mozilla Firefox  

Many times it happens that you store a password in your desktop PC and next time when you need to type that password again to use somewhere else you don’t remember it. Instead of asking for a new password you can simply find out your old password from Firefox. Just follow the steps given below. I will be using the Firefox 4 for this. Same can be done in older versions as well.

1. Click on the Firefox button (Left-top) .
2. Select Options -> Options. 
3. An options window will pop up. In this click on security tab and under this click on “Saved Passwords” button. 
4. Find the site name and the username you are looking for using the search box and click on the “Show Passwords” button and you can see the previously stored password.

Use MozBackup to easily backup your Mozilla firefox and thunder bird

Use MozBackup to easily backup your Mozilla firefox and thunder bird  

You never know when your PC gets infected or corrupted and you might have to format your system. So it is always good to keep backup of all your important things ready. MozBackup is one of the tools which you can use to create backup of your Mozilla apps e.g. Firefox, Thunderbird, SeaMonkey, Netscape etc.

   Using this freeware you can easily backup your browser data, bookmarks, cookies and  many other things with only few clicks of your mouse and all from a single window. Which makes your task much more easier.

    After downloading and installing the software it will scan your PC for all the supported products and list them. Select mozilla firefox from the list and click next. Select the profile you want to create backup for. If you have only one profile then select default and click next. You can select the options from the list which you intend to create backup for.   It also allows you to set a password for the backup created using this software.

  This app allows you to backup your Firefox in easiest way. This app is available for Windows operating systems only. You can download this freeware from the link below.

Download MozBackup - MozBackup-1.5.1-EN.exe

Source: Tips form Geek

Easily synchronize your office documents with Google Docs

Easily synchronize your office documents with Google Docs

Google Docs is one of the most amusing and most useful service available on the net. If you are a frequent user of Google Docs or you always want to have your worksheets or office documents available then SyncDocs is for you.

SyncDocs is a free program which allows you to synchronize files between your computer and your Google docs account. It is similar to what DropBox is for your other files. Whenever you make changes to files on your local disk the same changes will reflect in your google docs file if you are using SyncDocs.

SyncDocs automates the task of downloading files from your Google Docs account. You will not have to download each and every file manually from your account. When you add a new file to your Google docs account or syncdocs folder it is instantly synchronized with one another.If you have syncdocs installed on some other machine then it will also be in sync with the same account so in this way you can sync your files between multiple computers as well.

After downloading and installing Syncdocs from the link given below it will ask you for your google account username and password which you want to sync using syncdocs. Once you provide your account info it will automatically sync all your google docs file. You can also change your preferences as shown in the image above. Syncdocs can be used for taking backup of all your important documents as well. This smart tool is available for windows users only. You can download it from the link given below.

Download Syncdocs [2 MB]

How to get back ‘Save and Quit’ in your Firefox 4

How to get back ‘Save and Quit’ in your Firefox 4

If you have been using the latest Firefox 4 then by now you might have noticed that the ‘Save and Quit’ option is missing when you try to close your Firefox with multiple tabs open. If you are missing this display message just like me then here is a small “how to” to get it back in your FF4. Follow the simple steps below.

1. Open your Firefox 4.
2. In the address bar (where you type tipsfromgeek.com) type “about:config” without quotes and press enter.
3. In the next page it will warn you and ask you to promise that you’ll be careful. Click on the button and go to the next page.
4. In the next page type browser.showQuitWarning and double click on the filtered entry to change its value to true.
5. Now click on the close button of your FF4 to see if it is showing you the ‘Save and Quit’ message box and you are done.

CALCULATE CALORIES BY PHOTOS

CALCULATE CALORIES OF YOUR MEAL  

  Want to know the calories of your food...Just take the snapshot of you meal and goto the below mentioned link and upload....And wait for while then you will get the detailed nutrition report of you Meal...

LINK: CALORIES CALCULATOR

FREE FONTS DOWNLOAD WEBSITES

FREE FONTS DOWNLOAD WEBSITES

   If you were going to try the installation of latest version of fonts...Then browse the below sites you can get thousands of fonts for free...

1. Dafont

   download fonts for designing work in photosho, and for preparing slideshows..Dafo0nt contains more that 11,0000 free fonts it has got a wider variety of fonts like Fancy, Foreign Look, Techno, Bitmap, Gothic, Basic, Script, Dingbats and Holiday fonts,

2. Abstract Fonts

  Currently there are 13.098 free fonts on Bstract fonts. And about 1 million unique downloads every month. You can easily view the fonts in many ways like latest, by category, by designer, by recent popularity, popularity climbers and sliders, similarity, best and worst rated, and more.

 Each of the fonts has a customizable string preview, character map, member comments, similar fonts as well as a font info tab with all kinds of helpful information about the font.

3. Urban Fonts

Urban fonts got amazing collection of free fonts and free dingbats. It has got more than 8,00 freeware fonts to download and install it.

 

4. Font Space

Font space contains 13,000+ fonts that have been shared by designers around the world. You can find wider range of cool fonts in font space.

5. Fawnt

Fawnt is a resource for designers, developers, and anyone that loves free fonts. Fawnt lists beautiful fonts in nice speech bubbles coupled with a scrollable interface to make browing easy Fownt got more than 10,000 free fonts.

How to Install a font?

Unzip the files you have downloaded,

Windows 7/Vista: Right-click on the font files and click “Install”

Windows XP: Put the font files into C:\Windows\Fonts

Mac OS X: Double-click the font file  and click “Install font” button

Listen to the music stored in your Dropbox using droptunes

      Just log on to droptunes  and sign in with your dropbox username and password. It will automatically find all the music files stored in your dropbox folder and will list them in the music player.

    And for Google chrome there is an extension available for the same. So no matter where you are, you can listen to your favorite song at any point of time with this cool service.
LINK: DROPTUN

SOME GOOGLE SERVICES YOU MIGHT BE NOT KNOWING

SOME GOOGLE SERVICES YOU MIGHT BE NOT KNOWING
Google Moderator :Google moderator is based on a simple idea of sparking a discussion and collecting opinions from different people on a certain issue. You can share the question with others. You can also embed google moderator question on your blog or site.
Google Hot pot: Location based service where you can rate places as well as find places of your choice suggested by other users or your friends.This service is power by Google places.

Google Knol: Is a google project aims at user written articles in various categories. Knol is basically a knowledge sharing platform where users can connect with each other to share their view on a particular thing.

Google Fusion tables: It is service aimed at data management. Here data from various organization, people are available in the form of tables or excel sheets. Users can download the information from this site.

Google Health: This service from google allows you to keep track of your health. You can even record your health habits. Like how much you work out or walk daily. You can even share your health info online. Track your progress.

PORTABLE DICTIONARY ALLOWS YOU TO KNOW THE MEANING OF A WORD ANY WHERE

Quicktionary TS Premium offers a portable dictionary that does more than just provide meanings 



            The Quicktionary TS Premium is also more than capable of scanning printed text and transferring it over to a PC for future or later reference. According to Wizcom Technologies, their products are developed using unique expertise in linguistics and image processing. This has led them to achieve ‘best-of-breed’ milestones in the fields of microelectronics, electro-optics and Optical Character Recognition (OCR) algorithm engines, hence leading to the birth of the Quicktionary TS Premium.

    The Quicktionary TS Premium itself can be customized using the Wizcard, which in essence is an extension card that enables additional content to be added to the Pen, including dictionaries, OCR languages and text-to-speech components. If you so desire, you can easily switch between the Wizcard and original flash card in order to take advantage of the wide range of content that are available.
FOR MORE INFO: CLICK HERE

Instant Messages From 30,000 Feet

InFlight Messenger – Instant Messages From 30,000 Feet

InFlight Labs, LLC has deployed a powerful new online service called InFlight Messenger which leverages the aircraft's Wi-Fi connection to make it quick and easy for passengers to have single or group two-way text message conversations with their business associates, family and friends while in flight.

This proprietary technology combines the best features of instant messaging and text messaging to offer a new “Advanced Real-Time Communication” experience for its subscribers.

LINK: INFLIGHT MESSENGER

Free Webcam Softwares

Free Webcam Softwares

Are you looking for the best free webcam software for having a video chat or to discuss business with someone in a different country? Here we have listed 4 free webcam software

ManyCam

It lets you use your webcam on different applications on your system simultaneously. You can add text and exciting animations to the video. You can even add live CGI graphics. With effects, you can show as if you are underwater or show as if it is raining or snowing inside your house. It only works with Windows and Mac systems and is completely free from spyware and adware.
Download ManyCam

My WebCam Broadcaster

It is a very good webcam app if you are looking for an app that can do home and business monitoring. The application is also available for various platforms like Java, Android, iPhone, etc. It is a free application brings to you password security and private controls. The application can be used on desktop and laptops that run on Windows and Mac.
Download My Webcam Broadcaster

Webcam XP

WebcamXP is also a good and free webcam software that allows you to connect up to six webcams. Not only this, it even lets you stream live webcam video over the internet. If your webcam supports features like Pan and Tilt, then Webcam XP will allow you to make the most of it. It constantly checks to find out whether anyone is trying to view your webcam without your consent and show up information such as IP address and location. Currently, it can only be used with Windows OS.
WebcamXP

Vitamin D

The name may not make you feel like it is a webcam app, however it is one of most easy to use free webcam apps that come with good features. It can be used for surveillance purpose as it can easily detect humans in video and it can even distinguish humans from other objects. If anyone tries to view your webcam without your knowledge, you will receive a notification mail. It also lets you video scan lengthy videos within seconds.
Download Vitamin D

The Projecting Camcorder

PROJECTING CAMCORDER
   This is the HD camcorder that lets you instantly share videos by projecting them at up to 65" diagonal. A press of a button switches on a built-in projector that uses a 12-lumen lamp to display super-sized renditions of videos and images on a wall in a darkened room at 640x480 resolution. The camcorder's 5 MP sensor captures video at up to 1280x720 HD resolution and still images at up to 8 MP. Its fixed focus lens, 5X digital zoom and a built-in LED light assure optimal results in any setting with point-and-shoot ease.

 Footage is stored on a microSD card up to 32 GB (4 GB microSD card sold below holds up to five hours of video). Content can also be previewed on the camcorder's 2.4" LCD screen, uploaded to a computer via USB (cable included), or viewed on a standard TV (composite AV cable included) or an HD TV (requires HDMI cable). A four-hour charge from the included AC adapter provides two hours of operation. 5" H x 2 1/4" W x 3/4" D.
 Source: CLICK HERE

TURN YOUR WEBCAM INTO SURVEILLANCE CAMERA

TURN YOUR WEBCAM INTO SUVEILLANCE CAMERA
There are many situations in which you require to monitor your work area or your home.Here we have few free softwares which can turn your webcam into a surveillance camera.
1.Rise Sun:

Rise Sun is a free windows based video security software.Which uses a webcam for motion detection.In case of any movement detection is automatically takes a snapshot and saves it on your hard disk.It can ring an alarm if any movement is detected.You can read more about this software and download it from here.

2. TeboCam:

TeboCam does the same job as Rise Sun. But it can send you emails also in case of any activity. TeboCam can generate snapshots at regular intervals and if any movement is found it can create emails and send the snapshots to you via mail or it can directly upload it on the website. To know all the features of it just download it and use it  . Here is the download link. TeboCam

3. Prog’z WebCamSpy:

Prog’z WebCamSpy is not as good as the previous two softwares mentioned here. But it can be used to make your webcam a spy cam. It is a lightweight software. Does not require much resources to work. It just sits silently and takes snapshots using webcam at regular interval and saves them on your computer. It also can zoom on particular portion while recording so you can use it for monitoring specific areas. Download Prog’z WebCamSpy

Google Chrome is your new free PDF reader

Google Chrome is your new free PDF reader

Many of you might not be aware of this but you can use your favorite web browser Google Chrome as a free PDF viewer. No need to  install any additional softwares just to read a PDF document.  Google Chrome comes with a built in plugin named  ”Chrome PDF Reader” which allows the users to open and read PDF documents inside the browser.

To open a PDF file using Chrome just right click on the document you want to open and select “Open with” and then select Google Chrome from the list of programs.

If in case it does not work then make sure that your Chrome plugin is enabled. To do so type about:plugins in your address bar and press enter. There look out for Chrome PDF Reader plugin and enable it if its disabled.



Real time disasters and accidents monitoring website

REAL TIME DISASTERS MONITORING  SITE   
   Technology at its best. These real time monitoring website allows you to see the disasters as they happen. Though it of no use, it is still fascinating.

  Various incidents like vehicle accidents, volcanic eruptions, earthquakes, Tsunamis, environmental pollution, airplane accidents and terror strikes are represented using various ICONS. By clicking on the ICON you get the exact details of the incident. 
SOURCE: CLICK HERE

GMAIL NOW SUPPORTS 12 NEW FILE FORMATS VIA GOOGLE DOCS

Gmail Now Supports 12 New File Format Previews Via Google Docs Viewer Including Microsoft Excel, Adobe Illustrator, Adobe Photoshop And Autodesk AutoCad

   Thanks to Google Docs Viewer users can now view 12 new file-formats apart from existing PDF, Microsoft Word documents and PowerPoint presentations - the new supported formats are Microsoft Excel (.XLS and .XLSX, Microsoft PowerPoint 2007 / 2010 (.PPTX), Apple Pages (.PAGES), Adobe Illustrator (.AI), Adobe Photoshop (.PSD), Autodesk AutoCad (.DXF), Scalable Vector Graphics (.SVG), PostScript (.EPS, .PS), TrueType (.TTF)and XML Paper Specification (.XPS).

Users will be able to view these file-types using the “View” link in their Gmail attachments, users can also use the Google Docs Viewer service directly to make use of the viewer separately.

Best Facebook Games to Kill Time

Best Facebook Games to Kill Time

   Do you get bored really easy? You should try playing one of these games, Millions of users play it every single day, For me this is one of the reason I keep coming back to facebook.

Here are the top facebook games popular around the world :

Rank	Game	Active Users	Developer
1	Cityville	95,025,706	Zyanga
2	Farmville	51,000,384	Zyanga
3	Texas Holdem Poker	38,161,049	Zyanga
4	FrontierVille	20,356,964	Zyanga
5	Café World	15,433,951	Zyanga
6	Mafia Wars Game	13,838,140	Zyanga
7	Millionaire City	12,166,847	Digital Chocoloate
8	Treasure Isle: The Adventure Game	11,814,102	Zyanga
9	Pet Society	11,266,231	Electronic Arts (EA)
10	Bejeweled Blitz	10,814,441	POPCAP Games

Source:Computer Tips