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


Reply
 
Thread Tools Search this Thread Display Modes
  #21  
Old 02-29-2012, 11:19 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,643
Default

Quote:
Originally Posted by Dan Moore View Post
F4 ftw! Nice explanation.
I like F4, too. But I do get annoyed when I hit F1 by accident. At least with Office 2010, it's easier to kill the help screen.

Speaking of help, I just did an internet seach for how to do histograms. Didn't even bother to use F1 for that.
__________________
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 Nov. 20, 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 El Actuario View Post
Therapists should ask the right questions, not give the right answers.
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
  #22  
Old 02-29-2012, 12:17 PM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Quote:
Originally Posted by JMO View Post
I like F4, too. But I do get annoyed when I hit F1 by accident. At least with Office 2010, it's easier to kill the help screen.

Speaking of help, I just did an internet seach for how to do histograms. Didn't even bother to use F1 for that.
In 2007, you can disable online help by the way. Just click where it says online in the F1 window. Online help was really slow and useless for when I was last using it.
__________________
Death is the only decrement.
Reply With Quote
  #23  
Old 02-29-2012, 12:33 PM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Quote:
Originally Posted by dumples View Post
=INDEX($E$2:$E$8,MATCH("Dog",$B$2:$B$8,0))

Which is simpler (IMO) to understand and also has the added benefit that
1.) you don't need the "Matching from" column to be at the left of the Returning column.
2.) your formula still returns the correct result if you add a new column between B and E. Vlookup will be off by a column.
3.) your formula doesn't need to recalculate if you change a value in cell("C7")
4.) if you use trace precedents ( Ctrl+[ ) it takes you first to the values that you're looking to Return from rather than the value you're trying to look up.
I second all of the above. Also the sooner your less technical coworkers understand how match works, the sooner they stop sending you files with things like
HLOOKUP(,,106,false)
VLOOKUP(,,D1,false) where D1,E1,F1,G1...=2,3,4,5...
VLOOKUP(,,HLOOKUP(,,4,true),false)
etc.
__________________
Death is the only decrement.

Last edited by Gedankenexperiment; 02-29-2012 at 12:38 PM..
Reply With Quote
  #24  
Old 02-29-2012, 02:12 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,254
Default

F2 is useful as well. It toggles between edit and enter mode when editing a cell formula.

If you have a formula in a cell and you hit F2 and you enter edit mode then the arrow keys will move the cursor around in the formula. If you're in "enter" mode and you use the arrow keys it'll say "Point" and you'll be able to select cells.


I feel like this thread already exists, anyone want to make predictions before it gets started again?
Reply With Quote
  #26  
Old 02-29-2012, 02:32 PM
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,643
Default

Quote:
Originally Posted by dumples View Post
I feel like this thread already exists, anyone want to make predictions before it gets started again?
You mean this one?
Quote:
Originally Posted by vividox View Post
__________________
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 Nov. 20, 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 El Actuario View Post
Therapists should ask the right questions, not give the right answers.
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
  #27  
Old 02-29-2012, 06:29 PM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Uhg.. another example of why people need to know INDEX. Boss just asked me to edit a file that was summing every 12 columns into years.
ie. =sum(F1:Q1), =sum(R1,AC1), =sum(AD1,AO1)...

and asked me to add 30 years to the projection.
__________________
Death is the only decrement.
Reply With Quote
  #28  
Old 02-29-2012, 08:53 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,254
Default

I don't know if you still have the toolbar that I put up, but it can handle that type of thing in two seconds, providing direct links rather than complicated formulas.

here's a link:
http://www.actuarialoutpost.com/actu...9&postcount=27
Attached Images
  
Reply With Quote
  #29  
Old 03-01-2012, 10:38 AM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Quote:
Originally Posted by dumples View Post
I don't know if you still have the toolbar that I put up, but it can handle that type of thing in two seconds, providing direct links rather than complicated formulas.

here's a link:
http://www.actuarialoutpost.com/actu...9&postcount=27
Oh man oh man I forgot all about that part! Thanks! Although I finished it last night... Another hour wisely wasted!

Note to self, leave uber running all the time
__________________
Death is the only decrement.
Reply With Quote
  #30  
Old 03-01-2012, 07:30 PM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,254
Default

I don't even leave it running all of the time... I just pinned it to my recent programs (xl2010).
Reply With Quote
Reply

Tags
excel

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 10:59 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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 8.31533 seconds with 10 queries