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

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Reply
 
Thread Tools Display Modes
  #51  
Old 06-12-2009, 05:23 PM
no driver's Avatar
no driver no driver is offline
Note Contributor
SOA
 
Join Date: Jan 2006
Studying for nothing!
Posts: 2,330
Default mouse shortcuts

Here's an article with some doubleclick shortcuts. I'd rather use the keyboard for some of these but it's nice to know they are there too:
http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/
__________________
Exam FM Formula Summary (covers theory of interest formulas from the pre-2007 FM exam).
Reply With Quote
  #52  
Old 06-16-2009, 08:47 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,141
Default

Quote:
Originally Posted by no driver View Post
Here's an article with some doubleclick shortcuts. I'd rather use the keyboard for some of these but it's nice to know they are there too:
http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/
These are for Excel 2007, in case anybody was wondering. Some work in earlier versions as well.
__________________
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 Jan 13, 2017.

Spoiler:
I should keep these two permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
MORE:
All round good advice:
Quote:
Originally Posted by snikelfritz View Post
Don't live your life by other people's expectations.
Note that DTNF doesn't use red font, but it ought to be obvious anyway.
Quote:
Originally Posted by Dr T Non-Fan View Post
Yes, it must be a vast conspiracy.
Quote:
Originally Posted by Dr T Non-Fan View Post
If you feel you have to lie, then you're don't have enough integrity to be an actuary.
Quote:
Originally Posted by Westley View Post
"It seems" isn't really compelling for me.
Quote:
Originally Posted by JohnLocke View Post
The danger is in mistaking the stereotypes for reality itself and not simplifications of reality.
Reply With Quote
  #53  
Old 06-24-2009, 06:01 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,441
Default

found this by accident a while back.

entered ---> displayed

6**6 ---> 6,000,000(depending on format)

used to use
6e6 ---> 6,000,000(depending on format)

but like using the numpad keys
Reply With Quote
  #54  
Old 06-24-2009, 06:21 PM
skittles's Avatar
skittles skittles is offline
Member
 
Join Date: Jul 2008
Posts: 43
Default

does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?
Reply With Quote
  #55  
Old 06-25-2009, 08:34 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,141
Default

Quote:
Originally Posted by skittles View Post
does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?
One of the default toolbars has a couple of icons, one that has a little arrow and .0 on the top line and .00 on the bottom. The other has the positions reversed and the arrow points the other way. These let you increase or decrease the number of decimals displayed in the currently select cell(s).
__________________
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 Jan 13, 2017.

Spoiler:
I should keep these two permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
MORE:
All round good advice:
Quote:
Originally Posted by snikelfritz View Post
Don't live your life by other people's expectations.
Note that DTNF doesn't use red font, but it ought to be obvious anyway.
Quote:
Originally Posted by Dr T Non-Fan View Post
Yes, it must be a vast conspiracy.
Quote:
Originally Posted by Dr T Non-Fan View Post
If you feel you have to lie, then you're don't have enough integrity to be an actuary.
Quote:
Originally Posted by Westley View Post
"It seems" isn't really compelling for me.
Quote:
Originally Posted by JohnLocke View Post
The danger is in mistaking the stereotypes for reality itself and not simplifications of reality.
Reply With Quote
  #56  
Old 06-25-2009, 09:42 AM
skittles's Avatar
skittles skittles is offline
Member
 
Join Date: Jul 2008
Posts: 43
Default

Thanks JMO, I knew about the toolbar, I meant keyboard shortcuts....
Reply With Quote
  #57  
Old 06-25-2009, 10:54 AM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,034
Default

Quote:
Originally Posted by skittles View Post
Thanks JMO, I knew about the toolbar, I meant keyboard shortcuts....
I don't think it exists. I tried writing a macro for it awhile ago but that seems to be impossible too. It's about the only thing I ever use the mouse for when I am using excel anymore.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #58  
Old 06-25-2009, 11:38 AM
GatesIsAntichrist's Avatar
GatesIsAntichrist GatesIsAntichrist is offline
Member
SOA AAA
 
Join Date: Mar 2005
Location: Hell (on temporary assignment on Earth)
Favorite beer: New(fave)! Black'n'Tan
Posts: 206
Default

If you could live with lame limited usability (unless you found the complete rules of format specifications - I haven't looked for it), you could build your own decimal increaser/decreaser with something roughly starting with
Code:
Sub macIncrDec()
  If InStr(Selection.NumberFormat, ".") = 0 Then
    Selection.NumberFormat = Selection.NumberFormat & "."
  Selection.NumberFormat = Selection.NumberFormat & "0"
End Sub
and assign those to your own toolbar icons with accelerator shortcuts.

My definition of lame might be something that's only usable 98% of the time or crashes over 0% of the time. But you might get 98% satisfaction with an expansion of something like the above, or 100% depending on how you use Excel.
Reply With Quote
  #59  
Old 06-25-2009, 11:53 AM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,034
Default

It seems to never work for me. Even after I add the "end if" in the place where I assume you meant it to be. Thanks for the effort though.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #60  
Old 06-25-2009, 11:58 AM
GatesIsAntichrist's Avatar
GatesIsAntichrist GatesIsAntichrist is offline
Member
SOA AAA
 
Join Date: Mar 2005
Location: Hell (on temporary assignment on Earth)
Favorite beer: New(fave)! Black'n'Tan
Posts: 206
Default

Quote:
Originally Posted by ADoubleDot View Post
It seems to never work for me.
Try
Code:
Sub macIncrDec()
  If Selection.NumberFormat = "General" Then
    Selection.NumberFormat = "0."
  Else
    If InStr(Selection.NumberFormat, ".") = 0 Then
      Selection.NumberFormat = Selection.NumberFormat & "."
    End If
  End If
  Selection.NumberFormat = Selection.NumberFormat & "0"
End Sub
and build from there if needed.

edit:All with Selection
Reply With Quote
Reply

Thread Tools
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:28 AM.


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