Online Intranet office structure with custom databases to run your brokerage.

Google Spreadsheet Beats Excel With Dates

Now, I’ll admit right away that I’m still working, or at least was before Google Docs, with Excel 2003.  So, maybe 2007 is better in this one respect.  However, with Microsoft’s attempts to support third party vendor revenues, I doubt it.

Anyway, I wanted to be able to have a popup calendar in Excel sheets for fast date entry.  To get it, I had to buy an addon from a third party vendor.  Well, I just found that Google Spreadsheets has the feature for free.  First, the cell or column/row must be set up with date formatting.  Second, and the only tiny gripe I have, is that it must already have a date in it.  I’m not sure why that is, but it is.  So, I’ve set up the transaction task spreadsheets to load up for you with the current date in the date cells.

So, all you do is open a new sheet, enter the transaction name once, and the agent’s name once, pick the dates from a calendar for the tasks, and you’re ready to get it into the WebOffice system with six clicks and three minutes work.

Reblog this post [with Zemanta]



Download Free Database Layouts


Tagged as: , ,

Leave a Response