Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > General Actuarial
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Upload your resume securely at https://www.dwsimpson.com
to be contacted when new jobs meet your skills and objectives.


General Actuarial Non-Specific Actuarial Topics - Before posting a thread, please browse over our other sections to see if there is a better fit, such as Careers - Employment, Actuarial Science Universities Forum or any of our other 100+ forums.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-21-2018, 08:20 AM
californiakrazy californiakrazy is offline
Member
CCA Non-Actuary
 
Join Date: Jun 2017
Posts: 32
Default thoughts on walkenbach books?

I barely use excel and just bought the excel bible and vba programming book from walkenbach..have any of you used this? what are your thoughts? I have an interview coming up and since I dont use any excel, will they ask me for certain formulas such as, 'how do you find x using y function?'

thanks
Reply With Quote
  #2  
Old 05-21-2018, 08:28 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,436
Default

Quote:
Originally Posted by californiakrazy View Post
I barely use excel and just bought the excel bible and vba programming book from walkenbach..have any of you used this? what are your thoughts? I have an interview coming up and since I dont use any excel, will they ask me for certain formulas such as, 'how do you find x using y function?'

thanks
I have seen recommendations down in Software and Technology for those books. I think they are good.

But I would caution you about using such a book to pretend you know more than you actually do about Excel. Be up front that you haven't used it, but have read about it.


I'm not sure how the book is going to answer your bolded question, though.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #3  
Old 05-21-2018, 08:44 AM
SlowMotionWalter's Avatar
SlowMotionWalter SlowMotionWalter is online now
Member
CAS
 
Join Date: Jun 2013
Posts: 12,598
Default

Walkenbach is awesome. I highly recommend his books.

I also agree with JMO, there is a difference between reading and doing. You don't want to overstate your knowledge because you will be called out on it.

For an interview (EL or intern) you probably won't get much more than a question asking what you've done in Excel. Unless you put on your resume that you're proficient or above in Excel, it'll be assumed you don't know much.
__________________
Quote:
Originally Posted by bigb View Post
You should learn to communicate in a serious manner before you expect a serious answer.
Spoiler:
Quote:
Originally Posted by Kangaz wit Attitude View Post
Force of habit, 2pac's been typing "88" a LOT since Trump got elected.
Quote:
Originally Posted by JMO View Post
You ought to see the bush. It's impressive.
Quote:
Originally Posted by Pikachu
10:53 pm: some ppl dont take advices well
Quote:
Originally Posted by mayo fan
9:45 pm: ao fan would be hot covered in mayo!
Quote:
Originally Posted by Snikelfritz
if you'd like I can come visit and dress up like a girl and get in some fights
Quote:
Originally Posted by Kaner3339 View Post
i think everyone needs to do this type of thing to get a dose of reality and straighten people up. it's kinda like going to the mountains and becoming a monk except it's with hundreds of potatoes and a lot of stoners with tattoos in a kitchen
Reply With Quote
  #4  
Old 05-21-2018, 08:46 AM
californiakrazy californiakrazy is offline
Member
CCA Non-Actuary
 
Join Date: Jun 2017
Posts: 32
Default

thanks. this is for a FT job. there goes that then. D=

I have been using excelisfun videos for accounting and finance (to see how vlookups/pivot tables, etc)..
Reply With Quote
  #5  
Old 05-21-2018, 08:52 AM
act2106 act2106 is offline
Member
SOA
 
Join Date: Apr 2010
Posts: 1,244
Default

I completely agree that you won't be expected to know much about Excel and you shouldn't overstate what you know. But I also think starting to use those books shows awareness of and enthusiasm for what you're getting into, so I would try to work that into the interview. Something like "I haven't used Excel and know that I have a lot to learn, so I've been going through [this book] on my own."
Reply With Quote
  #6  
Old 05-21-2018, 08:56 AM
KernelMustard's Avatar
KernelMustard KernelMustard is offline
Member
SOA
 
Join Date: Aug 2015
Posts: 637
Default

Google is your best tool. In an interview, I'll ask an EL candidate how they would code this complicated problem in Excel/VBA. If their first thought isn't to Google search something (unless they already know how to do it), that's an instant fail for me. If you aren't using Google as your #1 tool, then you're just wasting time, IMO.
Reply With Quote
  #7  
Old 05-21-2018, 09:10 AM
californiakrazy californiakrazy is offline
Member
CCA Non-Actuary
 
Join Date: Jun 2017
Posts: 32
Default

hi Kernel, could you go into detail what that code is?
Reply With Quote
  #8  
Old 05-21-2018, 09:36 AM
DyalDragon's Avatar
DyalDragon DyalDragon is offline
Member
SOA
 
Join Date: Apr 2009
Location: Here
Studying for the hell of it...
College: AASU
Favorite beer: This one...
Posts: 31,473
Default

My answer to the question about my Excel proficiency was that I knew my way around it well enough that I could figure out what formulas would do what I needed, and that I wasn't afraid to use the function help links to learn how to use new tricks.
__________________
PRELIMS VEE FAP FAP FAP FAP FAP FAP FAP FAP

Quote:
Originally Posted by Androzani Major View Post
Maybe a better statement is that I enjoyed having experienced it both ways?
Reply With Quote
  #9  
Old 05-21-2018, 09:37 AM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 7,465
Default

Quote:
Originally Posted by californiakrazy View Post
hi Kernel, could you go into detail what that code is?
The specifics are irrelevant so it seems you missed the point of his post. Try re-reading the post to understand why.
__________________
I am a scientist. I am sorry to disappoint you but I have never seen an elf or a troll. But who am I to exclude their existence? - Arni Bjoernsson
You are stupid and evil and do not know you are stupid and evil. ... Dumb students are educated stupid. - timecube.com
Usually while I'm reading, I'm actually thinking about...midgets riding toy horses - Roto


Reply With Quote
  #10  
Old 05-21-2018, 09:40 AM
Kenny's Avatar
Kenny Kenny is offline
Member
Non-Actuary
 
Join Date: Jan 2003
Posts: 7,465
Default

Quote:
Originally Posted by Kenny View Post
The specifics are irrelevant so it seems you missed the point of his post. Try re-reading the post to understand why.
Oh, and I also thought his books were great. I don't know how they hold up now compared to what is available on the web. The Walkenbach book on my shelf is XL 2003. I haven't bought a new one because I use Google way more than referring back to a text because it is easier to find very specific answers once you have a basic understanding.
__________________
I am a scientist. I am sorry to disappoint you but I have never seen an elf or a troll. But who am I to exclude their existence? - Arni Bjoernsson
You are stupid and evil and do not know you are stupid and evil. ... Dumb students are educated stupid. - timecube.com
Usually while I'm reading, I'm actually thinking about...midgets riding toy horses - Roto


Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 12:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.27857 seconds with 9 queries