I like big spreadsheets and I cannot lie
- Thread starter ChrisFilter
- Start date
citydreams
on the road again
for each geek in geeks
my_beer = my_beer +1
next geek
my_beer = my_beer +1
next geek
Monkeygrinder's Organ
Dodgy geezer swilling vapid lager
What are your views on graphs? If you do an Economics degree you'll have to do many, many, many graphs. Mostly variations on the same theme.
ChrisFilter
Like a boss.
I like graphs. Very much.
dolly's gal
killing things
have you considered a career in direct marketing? MASSIVE spreadsheets, graphs, numbers AND creativity all rolled into one tantalizing job of joy 
i loved a-level economics but when i started it at degree level i hated it. i drooped it and went on to politics full time, essentially because it was too maths based.
i loved a-level economics but when i started it at degree level i hated it. i drooped it and went on to politics full time, essentially because it was too maths based.
ChrisFilter
Like a boss.
have you considered a career in direct marketing? MASSIVE spreadsheets, graphs, numbers AND creativity all rolled into one tantalizing job of joy
I'm in marketing now, but it's almost entirely strategy, product, creative and copy based. I'll have a google about direct marketing. Sounds like it'd be up my street.
Thanks
dolly's gal
killing things
ChrisFilter
Like a boss.
Actually, it seems I do a fair bit at the moment. Mass email marketing, landing pages, conversion rates, etc!
Idaho
continuity character
I'm in marketing now, but it's almost entirely strategy, product, creative and copy based. I'll have a google about direct marketing. Sounds like it'd be up my street.
Thanks
Marketing and want to more nerdy things? Sounds like you want to do Insight analysis. Learn SQL and Crystal Reports. Spreadsheets of for user level. You want to get into the big ugly relational database and tinker.
dolly's gal
killing things
ChrisFilter
Like a boss.
what and you don't do spreadsheets?! how the fuck do you get away with that?
My job is tricky to explain. I'm basically a salaried entrepreneur. I work with the big boss of a group of companies. His nickname is Mr 80% or Mr Rush because he never finishes things and is always rushing onto the next thing. My nickname is Baby <boss's name>. We're kind of a team who fuck about with stuff but rarely do anything formally.
The below is basically how I roll at work:
"Let's build a wicked landing page and see if that gets better conversions than a full brochureware site"
"Ok, great"
Next week...
"Did it work?"
"Yeah, seems alright"
"Cool!"
"Let's start a social media café; that'd be well cool!"
"Ok!"
Two months later...
"Did it work?"
"Nope.. kinda forgot about it actually."
"Ah well"
....."Let's start a publishing company!"
dolly's gal
killing things
My job is tricky to explain. I'm basically a salaried entrepreneur. I work with the big boss of a group of companies. His nickname is Mr 80% or Mr Rush because he never finishes things and is always rushing onto the next thing. My nickname is Baby <boss's name>. We're kind of a team who fuck about with stuff but rarely do anything formally.
The below is basically how I roll at work:
"Let's build a wicked landing page and see if that gets better conversions than a full brochureware site"
"Ok, great"
Next week...
"Did it work?"
"Yeah, seems alright"
"Cool!"
"Let's start a social media café; that'd be well cool!"
"Ok!"
Two months later...
"Did it work?"
"Nope.. kinda forgot about it actually."
"Ah well"
....."Let's start a publishing company!"
i see. no data/results/income analysis then?
dolly's gal
killing things
I'm whats known as a spreadsheet guru
Formulas come out of my ears.
I fucking hate this shit as well. Fuck knows how I ended up doing it
are you serious?!
oh my god that's made my day!!!!
ChrisFilter
Like a boss.
i see. no data/results/income analysis then?
Nope! We take a half-arsed look at the built-in campaign stats module and if more people called us than called the police on us for copyright infringement then we consider it a success.
More often than not we'll forgot about a project before we even start it.
There are many perks to the job. Alright salary, pretty much on flexi-time (I rock up late, spend all day fucking about doing very little, leave early), all very relaxed. That said, it just means I never do anything. It's not very fulfilling!
ChrisFilter
Like a boss.
chat to gracious about economics - not much she doesn't know about it.
as for accountancy? you're having a laugh aren't you??? That will be one rut that you'll never get out of. You'll die a little every day just looking at the people you work with...
Yeah, you're probably right about accountancy. Economics looks interesting though; very interesting.
Yetman
Cheesecar Fucksquad #1
are you serious?!
oh my god that's made my day!!!!
You know, I really wish I knew your address so I could send you a big bag of rotting salamanders to express just how much I truly, truly hate you
A Dashing Blade
Takes horses to water but can't make donkeys drink
My standard interview questions . . .
-------------------------------------------
Excel / Excel VBA
1) In your opinion, what should be the first line in any code or class or form module ie the very first line, before any pocedures and declarations of module level variables/constants.
2) What is the syntax of a VLOOKUP() function. Can you think of any inherent limitations of this function?
3) What is a "volatile" function. Give an example. Extra points for functions that are not volatile now but were in XL97 and earlier!
4) Not a trick question! What is displayed in the message box ie what is the value of intCounter after it has left the For . . . Next loop?
Sub PrintInAMessageBox()
Dim intCounter as Integer
For intCounter = 1 to 10
'do something
Next
Msgbox(intCounter)
End Sub
5) Give a brief overview of Excel's object model.
5) Give a brief overview of Excel's calculation engine (XL2000 & lower)
6) What's the difference between using Workbook_Open and Autpen?
7) What can cause a #NAME! error in a worksheet cell.
8) How have you got real-time data into a spreaddy, if so how. Ever used Bloomberg's API?
9) What are the standard ways of "apparantly" speeding up a spreadsheet's operation.
10) Arrays, collections and dictionarys as data structures. Compare and contrast.
If you can also answer these questions
Business
1) Tell me about any financial product you are familiar with so we can have a chat about it. Absolutley any poduct no matter how generic . . . Options, Bonds, Equity, Convertible, Derivatives, Swaps . . . whatever
1) If the price of a bond goes up, what happens to the yield?
2) What does "FRN" stand for? From this, what can you deduce about its structure. How often does a typical FRN reset?
3) What does CDS stand for. Very, very simply, what do you think a CDS is?
4) Approximately, what is the delta of an at the money option.
-------------------------------------------
Then you're worth at £500-£1500 per day to any trading floor subject to personality.
-------------------------------------------
Excel / Excel VBA
1) In your opinion, what should be the first line in any code or class or form module ie the very first line, before any pocedures and declarations of module level variables/constants.
2) What is the syntax of a VLOOKUP() function. Can you think of any inherent limitations of this function?
3) What is a "volatile" function. Give an example. Extra points for functions that are not volatile now but were in XL97 and earlier!
4) Not a trick question! What is displayed in the message box ie what is the value of intCounter after it has left the For . . . Next loop?
Sub PrintInAMessageBox()
Dim intCounter as Integer
For intCounter = 1 to 10
'do something
Next
Msgbox(intCounter)
End Sub
5) Give a brief overview of Excel's object model.
5) Give a brief overview of Excel's calculation engine (XL2000 & lower)
6) What's the difference between using Workbook_Open and Aut
pen?7) What can cause a #NAME! error in a worksheet cell.
8) How have you got real-time data into a spreaddy, if so how. Ever used Bloomberg's API?
9) What are the standard ways of "apparantly" speeding up a spreadsheet's operation.
10) Arrays, collections and dictionarys as data structures. Compare and contrast.
If you can also answer these questions
Business
1) Tell me about any financial product you are familiar with so we can have a chat about it. Absolutley any poduct no matter how generic . . . Options, Bonds, Equity, Convertible, Derivatives, Swaps . . . whatever
1) If the price of a bond goes up, what happens to the yield?
2) What does "FRN" stand for? From this, what can you deduce about its structure. How often does a typical FRN reset?
3) What does CDS stand for. Very, very simply, what do you think a CDS is?
4) Approximately, what is the delta of an at the money option.
-------------------------------------------
Then you're worth at £500-£1500 per day to any trading floor subject to personality.
dolly's gal
killing things
You know, I really wish I knew your address so I could send you a big bag of rotting salamanders to express just how much I truly, truly hate you
sorry, what's that spreadsheet boy?
something about excel and formula and that? yes yes very interesting dear. now run along and make a pie-chart or a graph and that... 
Yetman
Cheesecar Fucksquad #1
sorry, what's that spreadsheet boy?
Keep on shovelling motherfucker, keep on shovelling......
dolly's gal
killing things
Keep on shovelling motherfucker, keep on shovelling......
very good sundance, very good
chegrimandi
associated with adultery
Keep on shovelling motherfucker, keep on shovelling......
you need to factor in number of handbags collecting dust in wardrobe somewhere in this graph for it to be a true representation
dolly's gal
killing things
you need to factor in number of handbags collecting dust in wardrobe somewhere in this graph for it to be a true representation
oi! you won't get no tea at this rate!
x
Yetman
Cheesecar Fucksquad #1
very good sundance, very good
*Slings another bag of dead salamanders on the slowly decomposing heap.......*
you need to factor in number of handbags collecting dust in wardrobe somewhere in this graph for it to be a true representation
The scale doesnt go that high man, putting those sorts of numbers in would probably break my computer in fact
Mr Retro
Beware hedgehogs
Have a look at Business Intelligence and Enterprise Applications. Sounds right up your alley. It's going to be to the end of this decade what being a web designer was to the end of the last. i.e. money for old rope.
