Advanced Excel Course

thunderdog

Work are looking for me to do an advanced excel course. We have in house courses which I have done which cover formulas, v/h lookups, macros, pivots etc which I have done. But I'm looking for something more advanced.

One of my main tasks that they would like me to complete is to have a nice way of combining several (up to approx 10) workbooks into a nice interactive sheet, with different layers in it e.g. with one interface that your average excel user can click on and get into different workbooks etc from one click-make changes in one part which then makes changes in 10 different workbooks). I could fiddle around myself and hack my way through it but I'd like advice on any courses which might be useful.

Work are happy to send me on course for a few weeks (seems excessive on excel but I'll take the extra training!) so I'd be looking to cover some VBA too. I have some experience in C and shell scripting from my PhD days but I would be rusty to say the least.

Any advice on part time excel courses in the Dublin-Kildare areas appreciated.

Tom Dunne

I would suggest the Microsoft Office Specialist (MOS). They have a number of levels, in all the MS products including Excel, one of which is Expert level.

No idea where you would actually do this course, but this should get you started.

thunderdog

Tom Dunne wrote: »

I would suggest the Microsoft Office Specialist (MOS). They have a number of levels, in all the MS products including Excel, one of which is Expert level.

No idea where you would actually do this course, but this should get you started.

Thanks. Would you use VBA yourself? If you do, I'd be curious to see how useful you think it is to learn. Cheers

Tom Dunne

thunderdog wrote: »

Thanks. Would you use VBA yourself? If you do, I'd be curious to see how useful you think it is to learn. Cheers

No, I've managed to avoid VBA quite well.

My background is in databases, so I would do advanced work in various other languages before the data gets to an Excel spreadsheet.

beauf

If you want to do very advanced stuff in Excel. I would suggest you learn some programming. As to get the best out of it, efficiently you have to approach it like a programmer, not as an advanced user (power user).

I don't know what the office courses are like now. But I'd reckon they don't do much advanced VBA. Just the basics. If I were you I would consider doing a basic .net course. Get the basics of that. Then go back to the VBA in excel and you'll have a whole new perspective on how to approach the problems you have to solve.

Hollister11

Maybe have a look on youtube. They have loads of free and excellent tutorials. It wouldn't cost you or your company anything, except time.