Quote: Originally Posted by The Howling Wolves
good article and valid as far as it goes -- but sometimes you need to STORE the results into some sort of database system - for a simple example just say you want to plot the OPEN / CLOSE of a stock over several months.
EXCEL retrieves the data but you need to store it into a some sort of data base where you can run QUERIES (SQL) against historical data or even use the excel data to possibly predict future trends.
EXCEL is a marvellous tool but shouldn't be looked at in total isolation.
Integrating it into say MySQL (easy) or Postgre(more difficult) database systems DRAMATICALLY increases the power of EXCEL dramatically.