zico martin 89 Posted June 2, 2008 Share Posted June 2, 2008 I've got a job interview on Wednesday which I'm led to believe will include a 'desktop exercise', probably testing my excel ability. My excel knowledge is pretty limited to what i need to use (and work out myself) in my current role but is there anywhere which could teach me some of the more advanced stuff? As I've had little to no formal training I wanna try and plug any gaping holes in my knowledge if possible. cheers guys Link to comment Share on other sites More sharing options...
MrBass 2651 Posted June 2, 2008 Share Posted June 2, 2008 Dunno if this is a bit advanced for what you're after but Clicky Link to comment Share on other sites More sharing options...
wykikitoon 20110 Posted June 2, 2008 Share Posted June 2, 2008 Just come on here and ask MrBassm Link to comment Share on other sites More sharing options...
MrBass 2651 Posted June 2, 2008 Share Posted June 2, 2008 Just come on here and ask MrBassm Howsabout we call that plan B! Link to comment Share on other sites More sharing options...
Fop 1 Posted June 2, 2008 Share Posted June 2, 2008 I've got a job interview on Wednesday which I'm led to believe will include a 'desktop exercise', probably testing my excel ability. My excel knowledge is pretty limited to what i need to use (and work out myself) in my current role but is there anywhere which could teach me some of the more advanced stuff? As I've had little to no formal training I wanna try and plug any gaping holes in my knowledge if possible. cheers guys Claim discrimination for not being allowed the option of OOo then sue them and retire on the proceeds. Link to comment Share on other sites More sharing options...
zico martin 89 Posted June 3, 2008 Author Share Posted June 3, 2008 Dunno if this is a bit advanced for what you're after but Clicky bloody hell I dont even understood the website! I'll have a look later to see if i can make some sense of it though I do suspect it's just a little advanced for me unfortunately I dont think i'll be able to smuggle you into my interview bassy so plan B. and what's OOo, you've lost me fop Link to comment Share on other sites More sharing options...
Fop 1 Posted June 3, 2008 Share Posted June 3, 2008 and what's OOo, you've lost me fop OOo Link to comment Share on other sites More sharing options...
zico martin 89 Posted June 4, 2008 Author Share Posted June 4, 2008 and what's OOo, you've lost me fop OOo oh well there was no excel test after all of that, made a right hash of the interview anyway so sod it, Im happy where i am Link to comment Share on other sites More sharing options...
zico martin 89 Posted October 7, 2008 Author Share Posted October 7, 2008 anyway, is there a site which can give a bit of info & tuition on creating macros and formulas in excel? Link to comment Share on other sites More sharing options...
MrBass 2651 Posted October 7, 2008 Share Posted October 7, 2008 Dunno if this is a bit advanced for what you're after but Clicky Link to comment Share on other sites More sharing options...
trophyshy 7083 Posted October 7, 2008 Share Posted October 7, 2008 Link to comment Share on other sites More sharing options...
zico martin 89 Posted October 7, 2008 Author Share Posted October 7, 2008 you guys kill me go on man give us a clue - basics on creating a macro? Link to comment Share on other sites More sharing options...
MrBass 2651 Posted October 8, 2008 Share Posted October 8, 2008 you guys kill me go on man give us a clue - basics on creating a macro? Creating basic macros in Excel is a doddle (much like crucifixion) as it writes all the code for you. To get started all you need to do is open Excel and select Tools > Macro > Record New Macro..., give it a name and description if you like then perform the steps that you want your macro to carry out, such as opening a spreadsheet, printing it then closing it. Once completed, press the 'Stop' button on the Stop Recording tool bar. To then go and view your handy work, press [ALT+F11] (or select Tools > Macro > Visual Basic Editor). In the VBA window, you'll see a Project box top right which, if you used the default save location when recording your macro, will have your bit of code under VBAProject (Book1) > Modules > Macro1 (or whatever you called your macro). Double click on the macro and, voila!, your code will appear over on the right. That any help? Link to comment Share on other sites More sharing options...
peasepud 59 Posted October 8, 2008 Share Posted October 8, 2008 I agree with MrBass, the best way to learn VBA (or at least the basics) is to make hundreds of macros in the ways hes described then analyze the code to see how its doing it, as long as you have any kind of apptitude for code (and understand the concepts of Object Orientated Programming) then you'll pick it up without a problem. Link to comment Share on other sites More sharing options...
zico martin 89 Posted October 8, 2008 Author Share Posted October 8, 2008 I agree with MrBass, the best way to learn VBA (or at least the basics) is to make hundreds of macros in the ways hes described then analyze the code to see how its doing it, as long as you have any kind of apptitude for code (and understand the concepts of Object Orientated Programming) then you'll pick it up without a problem. cheers guys that's a good help, they were easier to set up than I thought but will take the VB route you advised. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now