Using MS Excel ...for nearly everything!

The Howling Wolves said:

Use Microsoft Excel for (Nearly) Everything - PCWorld

Click to expand...

Hi there
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.

Cheers
jimbo

Interesting, indeed. But this sentence near the very end is the most important one: "If you were planning to manage your finances, do your taxes, or create brochures, your tool of choice in most cases should be a dedicated application."

No kidding. I'm not a graphic designer but I've been around enough of them to pick up some stuff, and I know they'd puke if they saw that thing for training pilots.