November 17, 2005

Google may acquire Riya. Riya can recognise faces and lettering in your pictures. Comments Sai 8 Dec 2005 11:50 pm: Hi, do post the rest of the tips for excel when you get the time. Good Stuff.

Rule #3: Avoid manual labour. Use Excel to automate the task. I use Excel’s formulas to speed up repetitous tasks. These techniques are powerful, meaning, you can do a lot with a little, but can have unforeseen consequences. Excel can find and replace formulas. If you had hardcoded formulas and wanted to change =B1*3.14 to =B1*3.1416 across all rows, just find “*3.14” and replace it with “*3.1416”. Find and replace works in formulas. This is very powerful. You can use it to change the source (e.g. change the source from column B to C by finding “=B” and replacing with “=C”) or even the formula (find and replace “SUM(” with “SUBTOTAL(9,”). ...