Excel Formulas You Should Definitely Know:-

1. SUM

Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)
The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.

The above shows you different examples. You can have numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.


2. COUNT

Formula: =COUNT(A1:A10)

The count formula counts the number of cells in a range that have numbers in them.

This formula only works with numbers though:-

It only counts the cells where there are numbers.

3. COUNTA

Formula: =COUNTA(A1:A10)
Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them.
The COUNTA Formula works with all data types.

It counts the number of non-empty cells no matter the data type.


4. LEN

Formula: =LEN(A1)
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.

Notice the difference in the formula results: 10 characters without spaces in between the words, 12 with spaces between the words.


5. TRIM

Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words. I’ve found this formula to be extremely useful because I’ve often run into situations where you pull data from a database and for some reason extra spaces are put in behind or in front of legitimate data. This can wreak havoc if you are trying to compare using IF statements or VLOOKUP’s.

I added in an extra space behind “I Love Excel”. The TRIM formula removes that extra space. Check out the character count difference with and without the TRIM formula.

6. RIGHT, LEFT, MID

Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).
(Note: In all of these formulas, wherever it says “text” you can use a cell reference as well)
These formulas return the specified number of characters from a text string. RIGHT gives you the number of characters from the right of the text string,
LEFT gives you the number of characters from the left, and MID gives you the specified number of characters from the middle of the word. You tell the MID formula
where to start with the start_number and then it grabs the specified number of characters to the right of the start_number.

I used the LEFT formula to get the first word. I had it look in cell A1 and grab only the 1st character from the left. This gave us the word “I” from “I love Excel”
I used the MID formula to get the middle word. I had it look in cell A1, start at character 3, and grab 5 characters after that. This gives us just the word “love” from “I love Excel”
I used the RIGHT formula to get the last word. I had it look at cell A1 and grab the first 6 characters from the right. This gives us “Excel” from “I love Excel”


7. VLOOKUP

Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
By far my most used formula. The official description of what it does: “Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify…”. (See the full explanation of VLOOKUP) Basically, you define a value (the lookup_value) for the formula to look for. It looks for this value in the leftmost column of a table (the table_array).
Note: If at all possible use a number for the lookup_value. This makes it a lot easier to make sure the data you are getting back is a correct match.
If it finds a match of the “lookup_value” in the left column of the “table_array” it will return the value in the column you specify using the “index_num”. The “index_num” is relative to the left most column. So, if you have the table_index look in column A and you want what is returned to be what’s in column B the “index_num” would be 2 because the leftmost column, column A in this case, is the 1st column in the table array and column B is the 2nd column (hence the 2 for the index number). If you want what is in column C to be returned you’d put 3 for the index_num. The “range_lookup” is a TRUE or FALSE value. If you put TRUE it will give you the closest match. If you put FALSE it will only give you an exact match. I only use FALSE when using the VLOOKUP formula.

You have 2 lists: 1 with a sales person’s ID and the sales revenue for the quarter. Another with the sales person’s ID and the sales person’s name. You want to match up the sales person’s name to the sales person’s revenue numbers for the quarter. They are all jumbled around so to manually match this, even for a small number of salesmen would leave room for a high margin of error and take a lot of time.
The first list goes from A1 to B13. The 2nd list goes from D1 to E25.
In cell C1 I would put the formula =VLOOKUP(B18, $A$1:$B$13, 2, FALSE)
B18 = the lookup_value (the sales person’s ID. This is a number that appears on both lists.)
$A$1:$B$13 = the “table_array”. This is the area I want the formula to search the leftmost column (column E in this case) for the “lookup_value”. I went to F because if it finds match in column E, I want it to return what’s in column F. (The money signs are there so that the table_array will stay the same no matter where the formula is moved or copied to. This is called an absolute reference.)

2 = the index_num. This tells the formula the number of columns away from the left most column to return in case of match. So, if you find a match between the lookup_value and the leftmost column of the table array, return what’s in the same row in the 2nd column of the table (the 1st column is always the leftmost column. It starts at 1, not 0).
FALSE= tells the formula I want it to only return the value if it’s an exact match.
I would then copy and paste that formula along all the cells in column C next to the first list. This would give me a perfectly aligned list with the sales person’s ID, sales person’s revenue for the quarter, and the sales person’s name.

In order to get a nice neat list of Sales Person ID, Sales Person Name, and Sales Person Revenue all next to each other I used the VLOOKUP formula to compare 1 list to another.

This is a complicated formula, but an extremely useful one. Check out some other 


8. IF Statements

Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
When you’re doing an analysis of a lot of data in Excel there are a lot of scenarios you could be trying to discover and the data has to react differently based on a different situation.
Continuing with the sales example: Let’s say a salesperson has a quota to meet. You used VLOOKUP to put the revenue next to the name. Now you can use an IF statement that says: “IF the salesperson met their quota, say “Met quota”, if not say “Did not meet quota” (Tip: saying it in a statement like this can make it a lot easier to create the formula, especially when you get to more complicated things like Nested IF Statements in Excel).
It would look like this:
In the example with the VLOOKUP we had the revenue in column B and the person’s name in column C (brought in with the VLOOKUP). We could put their quota in column D and then we’d put the following formula in cell E1:
=IF(C3>D3, “Met Quota”, “Did Not Meet Quota”)
This IF statement will tell us if the first salesperson met their quota or not. We would then copy and paste this formula along all the entries in the list. It would change for each sales person.

Having the result right there from the IF statement is a lot easier than manually figuring this out.


9. SUMIF, COUNTIF, AVERAGEIF

Formulas: =SUMIF(range, criteria, sum_range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average_range)
These formulas all do their respective functions (SUM, COUNT, AVERAGE) IF the criteria are met. There are also the formulas: SUMIFS, COUNTIFS, AVERAGEIFS where they will do their respective functions based on multiple criteria you give the formula.

I use these formulas in our example to see the average revenue (AVERAGEIF) if a person met their quota, Total revenue (SUMIF) for the just the sales people who met their quota, and the count of sales people who met their quota (COUNTIF)


10. CONCATENATE

A fancy word for combining data in 2 (or more) different cells into one cell. This can be done with the Concatenate excel formula or it can be done by simply putting the & symbol in between the two cells. If I have “Steve” in cell A1 and “Quatrani” in cell B1 I could put this formula: =A1&” “&B1 and it would give me “Steve Quatrani”. (The “ “ puts a space in between what you are combining with the &). I can use =concatenate(A1, “ “, B1) and it will give me the same thing: “Steve Quatrani”

Finding The Right Excel Formulas For The Job
There are 316 built in functions in Excel. You’re not going to sit there and memorize what all of them do (or at least I hope not!). Luckily Excel has a built in wizard that helps you find the correct formula for what you’re looking to do (if there is one).
Click the “fx” next to the formula bar in Excel

This brings up a menu and in there you can type in a description of what you are trying to do and it will bring up the correct excel formula:

I typed in “remove extra spaces” and it returned the TRIM formula that we went over earlier.

Sky kish

Excel :- Cool Conditional Formatting With Formulas :~

One of the tools that I think people just don’t use often enough is Conditional Formatting. With the use of formulas, rules, or just a few really simple settings, you can transform a spreadsheet into an automated dashboard that shows you a lot about the information in the spreadsheet at just a glance. 
To get to Conditional Formatting, you just click on the Home tab, and click on the “Conditional Formatting” toolbar icon.

Under conditional formatting, there are a bunch of options. Most of these are beyond the scope of this particular article, but the majority of them are about highlighting, coloring or shading cells based on the data within that cell. This is probably the most common use of conditional formatting – doing things like turning a cell red using logical less-than or greater-than formulas.

One of the lesser used – or known about – conditional formatting tools is the icon sets option, which provides you with a great set of icons you can use to turn an Excel data cell into a dashboard display icon.

I discovered this once I upgraded to Office 2013 and used conditional formatting in Excel 2013. I checked out the icon sets and saw these cool LED indicator lights that I had only really seen before in some of the factory automation displays I’ve programmed. When you click on “Manage rules”, it’ll take you to the Conditional Formatting Rules Manager. Depending on the data you selected before choosing the icon set, you’ll see the cell indicated in the Manager window, with the icon set you just chose.

When you click on “Edit Rule…”, you see the dialog where the magic happens. This is where you can create the logical formula and equations that will display the dashboard icon you want. In my example, I monitor time spent on different tasks versus my budgeted time. If I’ve gone over half my budget, I want a yellow light to display, and if I’m over budget, I want it to go red.

 

As you can see, I’m not really budgeting my time too well. Almost half of my time is spent way over what I’ve budgeted.

Look Up Items With the VLookup Function :~
Okay, maybe that isn’t crazy enough for you. Maybe you aren’t so excited about simple logical formulas turning lights on and off. Fine – if you’re an old-school Excel fiend and you like using more advanced Excel functions, then I’ve gone another one for you.
You are probably familiar with the VLookup function, which lets you search through a list for a particular item in one column, and return the data from a different column in the same row as that item. Unfortunately, the function requires that the item you’re searching for in the list is in the left column, and the data that you’re looking for is on the right, but what if they’re switched?
In the example below, what if I want to find the Task that I performed on 6/25/2013 from the following data?

In this case, your searching through values on the right, and you want to return the corresponding value on the left – opposite how VLookup normally works. If you read Excel pro-user forums you’ll find a lot of people saying this isn’t possible with VLookup and that you have to use a combination of Index and Match functions to do this. That’s not entirely true.
You can get VLookup to work this way by nesting a CHOOSE function into it. In this case, the formula would look like this:
“=VLOOKUP(DATE(2013,6,25),CHOOSE({1,2},E2:E8,A2:A8),2,0)”
What this function means in simple English is that you want to find the date 6/25/2013 in the lookup list, and then return the corresponding value from the column index. In this case, you’ll notice that the column index is “2″, but as you can see the column in the table above is actually 1, right?

That’s true, but what you’re doing with the “CHOOSE” function is manipulating the two fields. You’re assigning reference “index” numbers to ranges of data – assigning the dates to index number 1 and the tasks to index number two. So, when you type “2″ in the VLookup function, you’re actually referring to Index number 2 in the CHOOSE function. Crazy, eh?

So now the VLookup uses the Date column and returns the data from the Task column, even though Task is on the left. Now that you know this little tidbit, just imagine what you can do!
Insane Nested Formulas to Parse Strings

As you can see, I’m trying to get a little crazier as we go, because I know there are always some of you out there that go, “…well that’s not crazy at ALL!!” I know, your standards are high and I’m trying to live up to them. If I’ve failed with my last two attempts, I bet I can appeal to your need for crazy with this particular formula.
There may be cases where you either import data into Excel from an outside source that is made up of a string separated by delimiters within the field itself. Once you bring in the data, you want to parse that data out into the individual components.

Here’s how this is done (see if you can mentally follow along with this insanity):
For the first field, to extract the leftmost item (the person’s name), you would simply use a LEFT function in the formula.
“=LEFT(A2,FIND(“;”,A2,1)-1)”
This searches the text string from A2, finds the “;” delimiter symbol, subtracts one for the proper location of the end of that string section, and then grabs the leftmost text to that point. In this case, that’s “Ryan”. Mission accomplished.
But what about the other sections? Well, to extract the parts on the right, you need to nest multiple RIGHT functions to grab the section of text up until that first “;” symbol, and perform the LEFT function on it again. Here’s what that looks like to extract the street number part of the address.
“=LEFT((RIGHT(A2,LEN(A2)-FIND(“;”,A2))),FIND(“;”,(RIGHT(A2,LEN(A2)-FIND(“;”,A2))),1)-1)”
It looks crazy, but it’s not hard to piece together. All I did is took this function:
“RIGHT(A2,LEN(A2)-FIND(“;”,A2))”
And inserted it into every place in the LEFT function above where there’s an “A2″. This correctly extracts the second section of the string.
Each subsequent section of the string needs another nest created. So now you just take the crazy “RIGHT” equation you had created for the last section, and then past that into a new RIGHT formula with the previous RIGHT formula pasted into itself wherever you see “A2″. Here’s what that looks like.
“(RIGHT((RIGHT(A2,LEN(A2)-FIND(“;”,A2))),LEN((RIGHT(A2,LEN(A2)-FIND(“;”,A2))))-FIND(“;”,(RIGHT(A2,LEN(A2)-FIND(“;”,A2))))))”
Then you take THAT formula, and place it into the original LEFT formula wherever there’s an “A2″. The final mind-bending formula looks like this:
“=LEFT((RIGHT((RIGHT(A2,LEN(A2)-FIND(“;”,A2))),LEN((RIGHT(A2,LEN(A2)-FIND(“;”,A2))))-FIND(“;”,(RIGHT(A2,LEN(A2)-FIND(“;”,A2)))))),FIND(“;”,(RIGHT((RIGHT(A2,LEN(A2)-FIND(“;”,A2))),LEN((RIGHT(A2,LEN(A2)-FIND(“;”,A2))))-FIND(“;”,(RIGHT(A2,LEN(A2)-FIND(“;”,A2)))))),1)-1)”
That formula correctly extracts “Portland, ME 04076″ out of the original string.

 To extract the next section, repeat the above process all over again. Your formulas can get really loopy, but all you’re doing is cutting and pasting long formulas into itself, make long nests that work really well!
Conclusion

So there you have it. Were these formulas and techniques wild enough? Do you have any amazing formula tricks of your own that make up your Excel super-user toolbox? Share your input and feedback in the comments section below!

sky kish

HOW TO CONVERT TO SMALL LETTERS TO BIG LETTERS BY USING FORMULA: ~

For Example:-

Skykish (Or) type Any Sentence 

 Using this below formula

And You will get Output like below

CREATE AN EMPLOYEE SALARY SHEET WITH USING FORMULAS:~
ID	NAME	DEPT	DES	BASIC	DA	HRA	GRO	LOAN	PF	DEDU	NET SAL
KS-1	A	ACCOUNTS	CLERK	10000	5000	6000	21000	900	1200	2100	18900
KS-2	B	COMPUTER	JM	25000	12500	15000	52500	876	3000	3876	48624
KS-3	C	LEGAL	DGM	20000	10000	12000	42000	875	2400	3275	38725
KS-4	D	REVENUE	GM	30000	15000	18000	63000	600	3600	4200	58800
KS-5	E	MARKTNG	SM	25000	12500	15000	52500	650	3000	3650	48850
KS-6	F	ELECLE	AM	15000	7500	9000	31500	980	1800	2780	28720
KS-7	G	FINANCE	JM	20000	10000	12000	42000	452	2400	2852	39148
KS-8	H	HR	MD	35000	17500	21000	73500	360	4200	4560	68940
KS-9	I	COMMERCE	ACC	15000	7500	9000	31500	540	1800	2340	29160
KS-10	J	REVENUE	TYST	5000	2500	3000	10500	850	600	1450	9050
KS-11	K	DE OP	TYST	5600	2800	3360	11760	850	672	1522	10238
		NOTE :-
		FORMULAS :
		DA=BASIC*50/100
		HRA=BASIC*60/100
		GROSS=BASIC+DA+HRA
		PF=BASIC*12/100
		DEDUCTION=PF+LOAN
		NET SALARY=GROSS-DEDUCTION
									Prepared By :-
									Sky kish

The Top 25 Fun Google Tricks :~

Maybe to help dispel the wacky notion that geeks are boring, or maybe to prove that Search isn’t all work and no play and Sergei and Larry are by no means dull boys, Google every-once-in-a-Google-Moon leavens their spam-fighting and user experience-enhancing with some honest-to-goodness, good clean Fun Google Tricks. You probably know a few of these memes already — passed around the intarwebz ad infinitum as they often are — those quirky little tricks and pranks you never thought you’d see from such a serious search engine. Occasionally, we searchers stumble upon some quietly placed “Google Easter Egg,” or sometimes Google’s PR peeps publicize some brand spanking new Fun Google trick that spices up the user experience as much as it enhances it. Whichever it is, these Google Tricks are fun darnit, so have fun with them. Meme junkies and time-wasters that we are here at Google Tricks, we’ve had our fair share of good times. And because we’re not greedy, and because we like to organize as a way to procrastinate, we’ve done the heavy lifting of gathering what we consider to be the Top 25 Fun Google tricks right here in one glorious and easy-to-read location on this page. If you like the cut of our jib, perhaps you’d be so kind as to like us on the you- know-what-book, or add a one to our G+ thingie. We’d be so happy and thankful if you did. funny google gravity trick

1. Google Gravity :~

Quite simply, this is Earth-bound physics “infused” into Google’s interface: with “gravity,” the visual elements you commonly find on the interface, such as the search bar, the “I’m feeing lucky” button, and everything else  fall down like a stack of bricks on the bottom of the browser. You can even “pick up” and “throw” the search results at the “walls” or just simply mess with them. This is no longer implemented on Google, but you can still see how it worked through the link below.

2. Let me Google that for you 
LMGTFY or Let Me Google That for You is a somewhat tongue-in-cheek service made for those of us who are too lazy to use Google. Upon entering a search query, instead of results, you get a link that you can then mail to your lazy recipient. Clicking on the link launches the actual search: thus, in this perigrinatory manner, you have Googled it for them. All they have to do is click the link. A beautiful example of technology making things more complicated for us.

3. Google Chuck Norris :~
There was a time when the internet raged with all imaginable Chuck Norris jokes. So naturally, Google itself dipped its hand in the meme with the Chuck Norris Google Trick. Search “Chuck Norris,” and Google returns a familiar Chuck Norris joke: “Google won’t search for Chuck Norris because it knows you don’t find Chuck Norris, he finds you.”

4. God on Google Earth
Sometime in 2010, people around the world went “God crazy” when Google Earth supposedly had taken a “snapshot” of “divine beings” while crossing a mountain zone in Switzerland. There’s no definite answer, of course, but the buzz it created was testament to how the entire online community could get excited over a blurry photo, like they do with pictures of cats.

5. Google Pac-man :~
A treasure-trove of fun Google tricks won’t be complete without mentioning Google’s Pac-Man doodle. On May 22, 2010, the 30th anniversary of the classic game, people around the world woke up to a search engine sporting an actually playable mini-version of Pac-Man. And naturally, hundreds of millions of people spent hours playing the game, basically slowing down productivity to a halt.

6. Google Mirror :~
This fun Google trick simply displays a mirror image of everything you might see when doing a search on Google.

7. Google Hacker :~
Those who are familiar with the so-called language of hackers (1337 5p3@k or “leet speak”) may love using this Google trick to amuse haxor pals or confound the squares. Sure, the trick isn’t much trickier than  swapping letters for moderately analogous numbers or ASCII characters — e.g. “G” becomes “6″, “E” becomes “3″, “N” becomes “||”, etc — But it’s still fun symbol-play, and still somehow feels like a secret language, despite that we all now w00t every time we are overcome with joy.

8. Google Barrel Roll :~
A Fun Google trick that is still accessible today, the barrel roll means exactly as it says: make Google do a barrel roll. Simply type “Do a barrel roll” into the search bar and Google dutifully obeys. Warning: This Especially Fun Google Trick is known to make babies cry and grown men squeal with delight.

9. Google Rainbow
Like a handful of the other Fun Google Tricks included in this list, this third-party website that has no official affiliation with Google but only offers its two cents in letting people experience the search engine in a delightful way. If you like colors, this site delivers it—although it may remind you more of the internet circa early-1990s, with all its animated GIFs.

10. Google Sphere :~
Google Sphere turns every little element you commonly see on Google’s homepage into a swirling “sphere.” It’s pretty cool, but it’s no longer implemented on Google. To see how it once worked, just visit the link below.

11. Google Spam :~
Probably not an actual Google trick but more a manifestation of how Google offers users related information. In the folders in your Gmail account, you usually see a one-line text advertisement from Adsense. But in the Spam folder, what you’ll see is a real Spam recipe—yes, it’s a recipe for something you can actually eat.

12. Google Tilt or Askew :~

Typing the word “tilt” or “askew” on Google (specifically if you’re using the Chrome or Safari browser) commands the search engine to “tilt” the whole screen slightly to the right.

13. Dragon Slayer :~

Those who use Google Docs will find this mildly amusing. If you create or open any spreadsheet, pressing Shift+F12 pops up a message that says: “Dragon slain! Congratulations, you’ve slain the dragon! ]B=8}”.

14. Google Ninja :~

Who doesn’t love ninjas? Google definitely does. If you’re using your Google Reader feed, press the keys “up, up, down, down, left, right, left, right, B, A” and a ninja (or a couple of them) appear!

15. All the Google Doodles :~

Over the years, Google has released several of its “doodles”—a temporary re-design of the Google logo made as a tribute to a historical event or the birthday of someone who has changed the world for the better. Through the link below, you’ll find all of the Google Doodles, not only the American versions.

16. Recursion :~

Type “recursion” into the Google search bar and Google in return asks, rather recursively: “Did you mean recursion?”

17. Google’s Nessie :~

Use the beach theme with your iGoogle homepage, then very patiently sit there and wait until the clock strikes 3:14 AM. Or you can just more the clock forward and see the monster” that comes out. If you actually waited several hours until 3:14 AM, finally seeing the monster might not totally amuse you.

18. Flight Simulator :~

What started as an Easter egg became so well-loved that Google eventually turned it into a regular feature of Google Earth. Just click Tools > Enter Flight Simulator, and you’re off to make a round-the-world tour. It would have been more awesome if Google Earth also has a “rocket launcher” feature with unlimited ammo to go with it, but maybe next time.

19. Google MentalPlex :~

One of the earliest (if not, the earliest) Google April Fool’s joke (this one surfaced in 2000) is the Google MentalPlex. Instead of typing their queries into the search bar, unwitting users were “invited” to just “think” their questions while gazing intently into the MentalPlex circle (apparently to allow Google enough time to “read” your brain signals and transform them into actual search engine queries), then click into the circle to see the results. Even Google’s CEO and co-founder Larry Page called MentalPlex “a quantum leap in finding what you are looking for on the Internet. Typing in queries is so 1999.” It was fun. Especially if you remember that this was the early days of Google, long before the billion-dollar behemoth called Adsense and what-have-you.

20. Google Anagram :~

Step 1: Type “anagram” into the Google search bar. Step 2: Google asks if you in fact mean “nag a ram.” Step 3: Proceed to LOL.

21. The disappearing “OO” :~

This is not really a Google fun trick per se, but you can wow your clueless friend with this little “magic.” Click anywhere on the white space of the Dark Arts page (URL in linked title above), then pretend to rub your two fingers on the two OO’s on the Google logo for 2 to 3 seconds, and the O’s will vanish. To bring it back, do the same thing: Click anywhere again and the OO’s will reappear, after which you will be redirected to the real Google.

22. Annoying Google :~

The “Annoying Google” trick is not really annoying under normal circumstances. Even if you’re in a hurry, Annoying Google’s way of messing up the words as you type them (randomly changing from upper-case to lower-case) is not really annoying. But if you want to see this in action and determine for yourself if it’s really annoying or simply mildly amusing, visit the link below.

23. Epic Google :~

Epic Google is Google on steroids — not the enhanced performance however, just the obscene bulk. Once the page loads, the logo, search bar, “Search” and “I’m Feeling Excessive” buttons, all swell until they either float off the page or you type a search and get the heck outta there.

24. Weenie Google :~

Weenie Google is the flip side of Epic Google. Once the page loads, the logo, search bar, “Search” and “I’m Feeling Inadequate” buttons,immediately begin to shrink to inscrutable and barely-usable sizes. Is fun, no?

25. Chicken Rolling :~

“Rick-rolling” is a popular prank that involves redirecting the unwitting user to a video of music artist Rick Astley singing one of his hit songs (most often “Never Gonna Give You Up”). Chicken-rolling, on the other hand, is like Rick-rolling, but with one dancing man eating fried chicken legs. To subject your unwitting friend to this prank, type the code “2204355” then click “I’m feeling lucky.” See what happens.

25. Google Loco :~


Sky kish 

TOP TEN PC MAINTAINENCE TRICKS :~

.Let your PC boot up completely before opening any applications.

2.Refresh the desktop after closing any application. This will remove any unused files from the RAM.

3.Do not set very large file size images as your wallpaper. Do not keep a wallpaper at all if your PC is low on RAM (less than 64 MB).

4.Do not clutter your Desktop with a lot of shortcuts. Each shortcut on the desktop uses up to 500 bytes of RAM

5.Empty the recycle bin regularly. The files are not really deleted from your hard drive until you empty the recycle bin.

6.Delete the temporary internet files regularly.

7.Defragment your hard drive once every two months. This will free up a lot of space on your hard drive and rearrange the files so that your applications run faster.

8.Always make two partitions in your hard drive FOR INSTALLING SOFTWARES. Install all large Softwares (like PSP, Photoshop, 3DS Max etc) in the second partition. Windows uses all the available empty space in C drive as virtual memory when your Computer RAM is full. Keep the C Drive as empty as possible.

9.When installing new Softwares disable the option of having a tray icon. The tray icons use up available RAM, and also slow down the booting of your PC. Also disable the option of starting the application automatically when the PC boots. You can disable these options later on also from the Tools or preferences menu in your application.

10. Protect your PC from dust. Dust causes the CPU cooling fan to jam and slow down thereby gradually heating your CPU and affecting the processing speed. Use compressed air to blow out any dust from the CPU. Never use vacuum. RAM IS THE WORKING AREA (DESKTOP) OF THE CPU, KEEP IT AS EMPTY AND UNCLUTTERED AS POSSIBLE!

Sky Kish

GET FREE LIVE CRICKET UPDATES IN MOZILLA FIRE FOX(ADDON) :~

THIS ONE IS FOR ALL CRICKET LOVERS !!!!!!!!!!!!!!!!!!

GENERALLY YOU ARE IN OFFICE OR WORKING ON NET
& WANT TO SEE SCORE
i know there are many websites that provide you live scores
but for that you need to switch your pages or tabs
how if live score is avalible in your browser



Now you can get live cricket score updates inside your browser. No need to go to any site and keep refreshing page after every few seconds.


yes its true

HitWicket is a live cricket score viewer Firefox extension. It shows cricket score updates from CMDN.com in the status bar panel.
Latest Cricket Scores from CMDN.com


* Customizable refresh intervals from 20 sec to 2 min
* Customizable UI theme
* Score updates from CMDN.com.
* Fall of wicket alerts.

Sky Kish

Online picture editing sites :~

Click here Pinnic                     :-   Click here to - sky kish 
Click here Magmypicture      :-   Click here to - sky kish
Click here Photofunio             :-   Click here to - sky kish
Click here Imagechef             :-   Click here to - sky kish
Click here Picartia                  :-   Click here to - sky kish
Click here to picmonkey         :-   Click here to - sky kish
Click here to ribbet                 :-   Click here to - sky kish
Click here to ipiccy                 :-   Click here to - sky kish
Click here to go2web20          :-   Click here to - sky kish
Click here to ohmyhandmade :-   Click here to - sky kish
Click here to smilebox            :-   Click here to - sky kish
Click here to pixlr                   :-   Click here to - sky kish
Click here to oned                   :-   Click here to - sky kish
Click here to 134 lanapic      :-    Click here to - sky kish
Click here to bufunky            :-    Click here to - sky kish
Click here to potoflexer         :-    Click here to - sky kish
Click here to phixr                 :-    Click here to - sky kish

Sky kish

Intresting abt google :~

Here is a funny google trick
for you all

1. Go to www.google.com
2. Type “Google Sphere” and then click “I’m feeling lucky” on Google, the entire page will start rotating.

Sky Kish

Install Windows xp in less than 15 minutes :~

Now, this tip will be very helpful for those who frequently install windows xp operating system. Normally OS installation takes around 40 minutes to complete, but through this trick you can now save 10-15 minutes. This simple tricks goes this way.

1. Boot through Windows XP CD.

2. After all the files are completely loaded, you get the option to select the partition. Select “c”.
3. Now Format the partition, whether it is normal or quick with NTFS or FAT
4. Once the formatting is completed, All the setup files required for installation are copied. Restart your system by pressing Enter.
Now, here begins the Simple trick to save 10-15 minutes.
5. After rebooting, you get a screen where it takes 40 minutes to complete or finalize the OS installation.
6. Now, Press SHIFT + F10 Key ->  This opens command prompt.
7. Enter “Taskmgr” at the command prompt window. This will open Task Manager.
8. Click the Process Tab, here we find a process called Setup.exe -> Right Click on Setup.exe -> Set Priority -> Select High or Above Normal. Initially it will be Normal.
Thats it, no more work to do. Relax your self and see how fast the installation process completes

 Sky kish

TEST Internet Speed :~

         

TEST Internet Speed :~

Well..

All of us have Internet Connections at our places... and pay for costly Hi-Speed Broadband Plans...

Internet speed cheaker meter

But never thought of checking the speed that you actually get?

Well I made an application to serve the purpose.....

About Application :
> Application Size = 208 KB
> It checks the Internet Speed from a Calcutta Server
> Downloads a 128 KB of Sample Data
> It calculates your inernet Speed for you

What you need to have :
> Windows 2000, NT, Xp, Vista or higher
> For Windows Xp, NT, 2000 .Net Framework 2.0 or higher (Vista has it preloaded)
> Internet Explorer Installed

>>>> Download Application <<<<

Usage :
** Just Double Click to test the speed of your connection.

 Sky kish