Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Advanced Excel Course

  • 01-07-2015 4:04pm
    #1
    thunderdog
    Registered Users, Registered Users 2 Posts: 2,676 ✭✭✭


    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.


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭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.


  • #3
    thunderdog
    Registered Users, Registered Users 2 Posts: 2,676 ✭✭✭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


  • #4
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭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. :D

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


  • #5
    beauf
    Closed Accounts Posts: 22,648 ✭✭✭✭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.


  • #6
    Hollister11
    Closed Accounts Posts: 5,482 ✭✭✭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.


  • Advertisement
Advertisement