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
  #81  
Old 07-21-2010, 04:40 PM
sysmod sysmod is offline
 
Join Date: Oct 2004
Location: Europe
Posts: 6
Default

The standard reference on Excel accelerators /hotkeys / short cuts is
Microsoft Excel : Charlie’s List, or “214 Keyboard Shortcuts” ( 40k)

blogs.msdn.com/excel/archive/2006/02/23/538311.aspx
__________________
Sysmod.com : Systems Modeling
Reply With Quote
  #82  
Old 07-21-2010, 05:35 PM
limabeanactuary's Avatar
limabeanactuary limabeanactuary is offline
Mary Pat Campbell
 
Join Date: Jan 2010
Studying for Anglo-Saxon
Favorite beer: Bass Ale
Posts: 14,142
Default

Hi sysmod! To the rest of the AO: he's one of the guys I met from the European Spreadsheet Risks Interest Group last week...

[btw, if you'd like your real name posted, you need to do it yourself. Moderators get touchy about people "outing" users here. I assume that as you link to your website in your profile, you're not trying to hide... but I'd rather not get banned by the mods for doing it myself]

If you edit your post, and stick an http:// in front of that URL, the forum will automagically hyperlink that, which will be helpful.
Reply With Quote
  #83  
Old 10-01-2010, 10:22 AM
E's Avatar
E E is offline
Eddie Smith
SOA AAA
 
Join Date: May 2003
College: UGA
Posts: 8,992
Default

I just discovered that you can paste the format of one chart to another. I often create collections of charts that I want to be formatted similarly. If I change the format of one, it's a pain to bring the others in sync.

You can simply click on a chart to select it, copy, then select another chart and go to Paste Special. Choose formats.

Somewhat related. . . you can quickly add a new data series by copying cells and pasting onto a chart.
__________________


Learn how FSA exams are different from the prelims

We have your exam covered:

LP | LFV-U | LFV-C | LRM | ERM | QFI Core | QFI Adv | QFI IRM | G&H Core | G&H Adv | G&H Sp

Check out our Technical Skills Course and our new R Course!

Connect on Twitter, Facebook, & LinkedIn
Reply With Quote
  #84  
Old 10-02-2010, 03:02 PM
Noddy's Avatar
Noddy Noddy is offline
Member
 
Join Date: May 2007
Posts: 2,450
Default

Can't remember if I've mentioned these here or not.

1) You can 'Snap to grid' (to borrow an AutoCAD term) your charts by pressing alt when you relocate it on a sheet. Helps line them up and size neatly.

2) For pasting excel tables to word documents try pasting an image of the table. Select the table, hold shift and select edit/copy picture/ (as shown on screen), and paste. I find tables typically look nicer, resize nicer and the values are uneditable.

3) Some might occasionally find =EDATE(start date, months to extend start date by) useful.
Reply With Quote
  #85  
Old 05-18-2011, 11:30 AM
TI30XIIS TI30XIIS is offline
SOA
 
Join Date: Sep 2008
Location: Princeton, NJ
Studying for FAP FA
College: Kean University
Favorite beer: Victory
Posts: 18
Default

Quote:
Originally Posted by E View Post
I keep the ribbon minimized probably 95% of the time. Being able to minimize the ribbon and gain more screen real estate is a nice "feature" of all the Office 2007 apps.

I use keyboard shortcuts for most things in Excel, so I don't have much need to look at the ribbon. I also keep a few frequently used buttons on the custom quick access toolbar.
The quick access toolbar is the best way to create custom keyboard shortcuts. For example, I put [Paste Special - Values] in spot 1, so I can paste values-only by hitting Alt+1. [Paste Link] is spot 2. This is so much better than having macro shortcuts (you can't undo the macros!)
Reply With Quote
  #86  
Old 05-18-2011, 12:25 PM
no driver's Avatar
no driver no driver is offline
Note Contributor
SOA
 
Join Date: Jan 2006
Studying for nothing!
Posts: 2,352
Default

Quote:
Originally Posted by TI30XIIS View Post
The quick access toolbar is the best way to create custom keyboard shortcuts. For example, I put [Paste Special - Values] in spot 1, so I can paste values-only by hitting Alt+1. [Paste Link] is spot 2. This is so much better than having macro shortcuts (you can't undo the macros!)
I Alt-E-S-V all the time. Thanks!
__________________
Exam FM Formula Summary (covers theory of interest formulas from the pre-2007 FM exam).
Reply With Quote
  #87  
Old 05-18-2011, 12:32 PM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Quote:
Originally Posted by no driver View Post
I Alt-E-S-V all the time. Thanks!
Yeah, me too!

Last edited by Gedankenexperiment; 05-18-2011 at 12:38 PM..
Reply With Quote
  #88  
Old 07-18-2011, 02:15 PM
Gedankenexperiment Gedankenexperiment is offline
Member
 
Join Date: Dec 2010
Posts: 443
Default

Mouse shortcuts!

Another not listed there, is that double clicking on the format paintbrush locks it in place until you click it again.

Last edited by Gedankenexperiment; 07-18-2011 at 02:29 PM..
Reply With Quote
  #89  
Old 07-18-2011, 06:38 PM
Ozzman's Avatar
Ozzman Ozzman is offline
Member
SOA
 
Join Date: Apr 2011
Studying for P
College: Xavier
Favorite beer: Free
Posts: 317
Default

Quote:
Originally Posted by Gedankenexperiment View Post
Mouse shortcuts!

Another not listed there, is that double clicking on the format paintbrush locks it in place until you click it again.


I never knew this
Reply With Quote
  #90  
Old 07-21-2011, 09:53 AM
llcooljabe's Avatar
llcooljabe llcooljabe is offline
Member
CAS
 
Join Date: Aug 2002
Posts: 22,476
Default

From Microsoft's Excel Blog:

Keyboard shortcuts - Ctrl keys
Keyboard shortcuts - Function keys
Keyboard shortcuts - Miscellaneous

The comments also have some links to other sources.
__________________
www.GoodNewsNow.info
Propoganda
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 11:32 AM.


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.43271 seconds with 10 queries