All articles with 'web' Tag

Track Your Mutual Fund Portfolio using Excel [India Only]

Published on Dec 28, 2009 in excel apps, personal finance
Track Your Mutual Fund Portfolio using Excel [India Only]

Excel is very good for keeping track of your investments. Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the latest NAVs (Net Asset Values) to see how your investments are doing. A while back we have posted a file on tracking mutual funds using excel. Today we are going to release an upgrade for that file.

Read the rest of this post to understand how this template works and download the free template.

Continue »

Now Edit Google Spreadsheets using MS Excel

Published on May 21, 2009 in Excel Howtos, Google Spreadsheets - Tip & Tricks
Now Edit Google Spreadsheets using MS Excel

Do you like the cool features of Google docs spreadsheets but too comfortable with MS Excel’s UI? Well, the supercool OffiSync add-in is for you. It is developed for Oudi Antebi an former marketing manager at Microsoft.

Once you finish the installation of the addin you will see a new ribbon in the corresponding applications (word, excel and powerpoint).

Continue »

Google Spreadsheets Holiday Art Template

Google Spreadsheets Holiday Art Template

This is pure fun! Few Googlers used the collaborative feature in Google Spreadsheets to create a holiday art template with snow flakes using 18 colors. Each of them added few colors on a blue canvas to create this massive template. The best part is they even made a time lapse video of the whole process […]

Continue »

The new Mac vs. PC web ad by Apple is really cool

Published on Nov 19, 2008 in advertising, technology
The new Mac vs. PC web ad by Apple is really cool

Did you checkout the new web based Mac vs. PC ads Apple is running on the CNN.com? They are totally cool. why? because, in that ad, the PC guy walks from one ad-block to another creating wow user experience for whoever seeing the ad. Here is a small animation I have created out of it […]

Continue »

Minor Changes to PHD’s Look and Feel

Published on Nov 4, 2008 in blogging, technology
Minor Changes to PHD’s Look and Feel

Over the weekend I had sometime to cleanup the CSS and improve page layouts of PHD. The changes are: Post bottoms are hot now! Beneath each post you can now see 2 sets of links. One set with the usual sharing links for you to save the article to delicious or stumble or email it […]

Continue »

Soon you can use Excel on the Web

Published on Oct 30, 2008 in technology
Soon you can use Excel on the Web

Yesterday Microsoft announced in PDC (professional developers conference) that it will be releasing a web based version office applications – Word, Excel, Power Point, One Note later this year. This is an exciting news since you can access the goodness of these powerful desktop apps inside a browser for free. No more hassles of upgrading […]

Continue »

Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar

Published on Oct 6, 2008 in Learn Excel, technology

Google Docs – spreadsheet application has introduced some major upgrades to their editor today. Some of the key changes include: Introduction of menus to access all spreadsheet functions / features by category: Now the spreadsheet app menus look more like Excel 2003 menus. Looks like Google is trying hard to close gap between the two […]

Continue »

Google Maps Walking Directions Bug ?!?

Published on Sep 26, 2008 in technology, wonder why

I love google maps. No, wait, I really love google maps. I think it is a perfect example of passion, intelligence and wit coming together to create software. [trivia link: google maps tells you swim across the ocean], I have been using maps to find transit directions from my hotel to office and I have […]

Continue »

Gmail Labs 2 new useful features – Mark as Read, Label Auto Suggest

Published on Sep 23, 2008 in technology
Gmail Labs 2 new useful features – Mark as Read, Label Auto Suggest

Gmail Labs constantly introduces new features that make using Gmail much more productive. Recently they introduced 2 new features – Mark as Read button and Auto suggest for label search which I find extremely useful. Mark as read is really useful since I use it often to get to inbox zero. I am obsessed with […]

Continue »

Web Page Monitor using Google Docs

Published on Sep 16, 2008 in ideas, Learn Excel, technology
Web Page Monitor using Google Docs

My guest post on monitoring web page changes using google docs is posted in Digital Inspiration – one of the most popular technology blogs. Do read it to learn a little bit about using XPATH, RSS Feeds, Google Spreadsheet import() functions. Here is a summary of the technique: First go to the web page which […]

Continue »

Tracking your stock portfolio using Google Docs

Published on Sep 12, 2008 in ideas, Learn Excel, personal finance
Tracking your stock portfolio using Google Docs

By integrating services like Google Finance, Search in to spreadsheet functions, google docs has paved the way for endless possibilities. Google spreadsheet function GoogleFinance() can be used to build stock portfolio tracker sheet that can fetch historical stock quotes to tell how your money is doing. Click here to see the stock portfolio tracker sheet […]

Continue »

Switch between firefox tabs using mouse scroll wheel

Published on Aug 19, 2008 in hacks, technology
Switch between firefox tabs using mouse scroll wheel

Firefox 3 has a ton of extremely useful productivity features and as I keep using it, I discover more and more of them. Here is one I found extremely useful and simple: When you have lots of tabs open, in order to switch between the tabs, place mouse pointer on any of the tab titles […]

Continue »

Search restaurants by cuisine – Google maps

Published on Aug 11, 2008 in food and drink, technology

This is another wow feature in Google maps that I started seeing last week. You can search restaurants by cuisine, how simple yet how effective .. 🙂 Click here to see all the Pizza places near Empire State Building in New York. Earlier on Gmaps: Get directions by public transport, See 3D building outlines in […]

Continue »

Analyze your blog post’s readability with Google docs

Published on Aug 5, 2008 in blogging, ideas, technology

How can you ensure that your blog post, term report or business case is readable without spending a lot of time getting beta reviews from others? Thanks to google docs, you can do that with one click. Just upload your word document / txt file to google docs. Once inside, goto menu > tools > […]

Continue »

Add more superstars to your gmail

Published on Aug 4, 2008 in technology

I use new superstars gmail labs feature a lot, to mark reader mails that I need to followup, comments I should respond to, ideas that are interesting, bill mailers that should be paid. The default setting allows any of the 4 superstars to be added. while trying to change my mail signature, I have realized […]

Continue »