Monday, August 25, 2008

Stock Quote Reports in Excel

So, you want reports on your Stock Portfolio delivered into Excel, do you?

1) Select cell A1
2) Go to Data / Get External Data / Run Saved Queries,(this may differ slightly depending on Excel version), and choose Microsoft Investor Stock Quotes
3) Enter some stock symbols (eg. UTR, MSFT, GM, etc.) and click "OK"

Presto! In a few seconds, you will have all of the current data on your stocks!

Saturday, August 23, 2008

Welcome to the Excel Enthusiasts Blog!

Hello Excel Fans!

Today marks the debut of the Excel Enthusiasts blog! In the weeks and months ahead, this blog will explore all (or a whole lot of...) things Excel. Topics will range from common, routine procedures in this application to truly esoteric, wild and wonderful looks at what this powerful tool can do.

I hope you will check in now and then. You can also join the Excel Enthusiasts Group on LinkedIn and stay connected with other Excel afficiandos!

All the best,

Bob (The Excel Guy)