Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Using MS Excel ...for nearly everything!

26 Feb 2011   #1

Windows 7 Home Premium 64bit
 
 
Using MS Excel ...for nearly everything!

My System SpecsSystem Spec
27 Feb 2011   #2

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 

Quote   Quote: Originally Posted by The Howling Wolves View Post
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
My System SpecsSystem Spec
27 Feb 2011   #3

Black Label 7 x64
 
 

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.
My System SpecsSystem Spec
Reply

Thread Tools



Similar help and support threads for2: Using MS Excel ...for nearly everything!
Thread Forum
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel help Microsoft Office
Excel? Software
Excel help Microsoft Office
excel has gone mad Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 08:39 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33