Author: FinancialRadDeveloper

I am an Python & Excel VBA RAD Developer in Banking. I am trying to share the tips and info I have picked up in the last few years.

Further Excel VBA RAD Interview Questions


I had an interview today.  I didn’t do all that well at all and I got a little bit schooled.

This always seems to happen on my first technical interview with any serious technical ‘harrasment’.  I also have a load of knowledge tucked away in my brain, none of which the guy wanted to know about sadly.

Here are the things he did want to know about that I really got flustered and couldn’t answer.  Embarrasingly I gave myself an 8 out of 10, when I actually performed like a 5.5.  I think he rated himself as an 8, and then quite easily proceeded to destroy me. 😦  boo.

So… back to the hard core technical stuff for me as I spent too long this week on the finance side and not enough on the actual RAD side, silly me.

Ranges:  How do you create a range that will grow as and when data is enetered into it.

  • Name the 5 types of join on a database
  • how can I get a range to grow when data is added ( VBA & Excel)
  • How can I change the Last Used cell in Excel.
  • C++ pointers
  • Basic C# questions.

Ooh, and make sure that you can eloquently discuss the previous projects you have had on your CV.  Especially be prepared to get right into the nitty gritty.  I was silly enough to let information like the usings and data types etc I was using in one of my projects I only stopped working on about 8 months ago.  Not great either.

If I have a column with data in it.

ab

cd

ef

and I want to add in another item of data, but have the range grow.  What can I do.

5 Types of Join – I was going to write the answer in here, but now I realise that what I need to do… is have a post dediected to SQL.  Any decent RAD developer is going to have to dig around in a database from time to time.  I think the problem I had is that I let the info go too stale, and didn’t keep on top of it.  I mean sure I seriously believe 100% I could do the job.  I would merely look in w3schools / Wikipedia for a few minutes and then be away and fine.  However… interviews just aren’t like that.  You need a decent answer, confident and concise right there, at the time to give the person that warm fuzzy glow that gets one hired.

Snippet :

Here are the first few things I selected to look at.   A simple glance over these for 30-90 mins before the interview would  have given me a massive boost in the interview:

http://www.w3schools.com/sql/sql_join.asp

http://www.tomjewett.com/dbdesign/dbdesign.php?page=jointypes.php

http://en.wikipedia.org/wiki/Join_%28SQL%29

Summary ( for my own revision )

Dynamic Ranges:

http://www.ozgrid.com/Excel/DynamicRanges.htm

Last Used Cell:

Run a small macro.. ActiveSheet.UsedRange.   Or you can do this in the Immediate window if you don’t want it to be anywhere in the code.

0

Essential material for Excel VBA RAD Development


I have been doing Excel VBA RAD ( Rapid Application Development) for over 4 years now, and I thought it would be useful to list all of the most useful resources that I have found over the years in one post.   I guess as much for my own benefit as for other readers.

Print :

Excel Development:

Professional Excel Development:

This has to be “The Bible” of all professional Excel developers.  I am being quite bold in this claim.  Continue reading “Essential material for Excel VBA RAD Development” →

0

Excel VBA Interview Questions (aka Things every *good* Excel VBA developer should know)


I thought that I would compile a list of things that *I* think every good Excel developer should know.   I don’t mean techniques in particular, just things that people who work with Excel VBA intensely each day should know.

Edit: I think a lot of people will be searching for Excel VBA Interview questions and answers so I have renamed the post and changed the format slightly.  I will include all the answers on a separate post so people can try these for themselves and use it to check, or just go there immediately and cheat ;-P

I’ll illustrate :   Alt+F11.  If you don’t use this, or don’t know when asked what it does, I would say you know Jack about VBA.    This is only my own opinion, but a lot of these things do come up as interview questions as they are quite esoteric and won’t really be something a pretender would, or come to think about it, could Google for when cramming for the interview.

I’ll start simple and group things up so they should all make sense.

Excel Interview Questions

Easy

  • What does Shift+D do in this case?
  • What does Ctrl+D do in this case?

  • What will happen if I pull down on the corner using the plus symbol making the 1×3 cell deep selection grow to 1×10?

Continue reading “Excel VBA Interview Questions (aka Things every *good* Excel VBA developer should know)” →

5

Excel VBA WTF 002


I have to say that poor old VBA and Excel gets blamed for a lot of things.   I guess its just easier for people who should never be allowed near a computer let alone develop on one to start messing about with it and produce something truly ghastly.

This story here is a great example of such evil being conducted in the good name of VBA.  ;P  THe DailyWTF is a great site and one of only 3 I can say I visit basically every working day for a quick check when I need a cheeky break.   Alex, if you are reading this I must get a sticker in snail mail soon.  I’ll collect up some stuff and send it over!

I must try to alternate these posts with something really positive or quirky that has been done in Excel VBA and has warmed a developers heart, or perhaps made the world a cooler place.

0

Really useful factoid – 001


Where I am developing at the moment an unusual little character is being used.  It’s this one  ‘¬’.  Its what you get with Shift+`  which for most (PC, non laptop I mean) keyboards is Shift+top left key on the keyboard.   When I first saw it I only had to have a 2 sec scan of my keyboard to work out how to type it myself.  I guess years and years in front of something quite limited will lead it to soaking in!

What I did find interesting is that Google and the other search engines tend to remove characters from their search terms or presume that you want to do an advanced search if you do use them, so I was out of luck to work out what the little blighter is called.  I know a ‘~’ is a tilde.  I don’t know where I knew that from either, so apart from looking like a bit of a loon and asking my whole team if they knew I resolved to work out how I could get to know, and then also all the weird other things that can be generated.

A few minutes went by and then it hit me… Continue reading “Really useful factoid – 001” →

0

Found my first Googlewhack!


Awesome!   Its a bit sad, but after watching the DVD of Dave Gorman’s Googlewhack adventure I did struggle to find out how he found so many and the stories and people he met really struck a cord with me.

Dave Gorman's Googlewhack adventure
Dave Gorman's Googlewhack adventure

My Googlewhack?   ‘Argentine omniglossolalia’   it was used in an Independent article I was reading this morning as something made me take the free Independent paper that they are giving out until the conclusion of the UK Election.

I have yet to find out what omniglossolalia actually means which is how I stumbled across the Googlewhack itself.   Continue reading “Found my first Googlewhack!” →

0

Excel VBA Interview questions


I started this blog mainly to record my experiences while looking for Excel / VBA roles.   I do remember that there were a number of blogs that I myself found very useful.  This one always stick in my mind as I remember using 2 posts on the blog for both my current spate of job hunting and also the previous spate where I first started to look for Excel / VBA / RAD roles when I worked out I just wasn’t going to make a very good C++ programmer.

Excel VBA Questions:

http://www.toomik.net/helen/blog/2007/01/31/interviewing-for-an-excel-vba-job/

Hiring:

http://www.toomik.net/helen/blog/2006/02/28/hiring/

I’ll post some more thoughts up on a re-edit, I just thought  I would post this up right now in my lunch break first.

0

New Contract!


I have managed to leave my perm employer and start in my very first contract!   I will be blogging the experience of searching, finding jobs and then interviewing for them here. 

I’ll try to get a proper blog about interview questions for :

  • Excel
  • VBA
  • Finance
  • Some C# / .Net resources
  • C++ ( not so much )

I’ll also blog about my experiences of goign contracting with a view to setting up a Limited Company, Pay schemes and Agency negotiations too.

0

Blog at WordPress.com.

Up ↑