Question for Excel pros

[slow99]

I've always used Excel a lot in my job, mainly in financial modeling. I never really got into many advanced features. With the new job, I'm not forecasting financial statements anymore. I need to be up to speed on managing our huge trading/portfolio management file. This means getting ramped quickly on a lot of things I'm not familiar with. It's a trade file with tons of worksheets, and data for about 300 accounts, each with about 50 bits of info. Our vlookups, sumifs, etc are pretty long, but nothing I can't figure out. My biggest concern is learning all about macros. I'm taking over ownership of this file in a couple weeks, and it will be on me if any snafus occur. I've played around with little piddly macros before, the ones we have are pretty complex. Is there a good book anyone has used to learn this? I'd ideally like something that just walks me through creating and maintaining macros. Any advice is greatly appreciated.

[BradM]

When I had my bar YouTube taught me Excell. Good luck!

[Geor!]

Excel for seckertary and shit yo

[Nash B.]

I don't know shit about Excel macros but it looks like a Basic-ish language. Ever done any programming in Basic, or for a Texas Instruments graphing calculator?

[slow06]

The way I have always done macros you record a series of steps by hitting the record button and then clicking / typing through the steps. Then assign the macro to a button and it repeats the task for you.

Maybe I just do the piddly stuff, is there some level of ability macros have that I am missing?

[abecx]

sounds like you should full relational database for analytics

[YALE]

What Brad said: [ame]http://www.youtube.com/watch?v=c7CjWjBRgnQ[/ame]

The business building on campus has a bunch of older edition textbooks for free. Want me to see if there's one on the subject?

[46Tbird]

sounds like you should full relational database for analytics

Bingo.

Excel, really? Mission critical client data belongs in a database and the analytics piece should be handled using OLAP. Maybe that's overkill for what you're needing, but that comment 'it will be on me if any snafus occur' makes me think it's not.

If you still think macros are the right way to handle it, run through this: http://office.microsoft.com/en-us/tr...001150634.aspx

[Chili]

Bingo.

Excel, really? Mission critical client data belongs in a database and the analytics piece should be handled using OLAP. Maybe that's overkill for what you're needing, but that comment 'it will be on me if any snafus occur' makes me think it's not.

If you still think macros are the right way to handle it, run through this: http://office.microsoft.com/en-us/tr...001150634.aspx

Yeah, I was thinking at least an Access database..

[hunt4m3x]

200mil business, everyone use excel to update their sales.

[slow99]

Thanks guys, and thanks for the link. The person who handles it now has the book she used to learn macros and gave it to me.

I don't think I said the data was housed in excel, we use it for portfolio management and trading. The data is in a database that feed this excel file daily.

[Chili]

Thanks guys, and thanks for the link. The person who handles it now has the book she used to learn macros and gave it to me.

I don't think I said the data was housed in excel, we use it for portfolio management and trading. The data is in a database that feed this excel file daily.

Cool, misunderstood. Believe it or not, I use excel's help feature a lot with good success. That and googling specific formulas have not failed me. It takes some extra time up front but I, personally,learn much more effeciently that way.

[momo]

let me and tony make it into a program with a database for you. as payment you can invest us and make us CHOOO$$

[abecx]

200mil business, everyone use excel to update their sales.

yeah thats badddddddddddddddddddddddddddddd