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

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


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
  #41  
Old 12-10-2015, 01:20 AM
actuary21c actuary21c is offline
Member
 
Join Date: Sep 2009
Location: UK
Studying for double bass & jazz piano
Posts: 1,786
Default Some nice suggestions re formatting here

(Apologies if there is a better thread for this, but I couldn't find one quickly).

Some good suggestions here re worksheet formattting:

http://www.powerpivotpro.com/2012/01...rmatting-tips/
__________________
Spoiler:

Quote:
Originally Posted by Brock View Post
a21c is one of the better posters on the AO. That's not saying he's good.

UK software developer, actuary, musician, atheist. All posts in a personal capacity (unless explicitly stated otherwise in the post).
Reply With Quote
  #42  
Old 12-10-2015, 01:33 AM
Malcolm's Avatar
Malcolm Malcolm is offline
Member
CAS AAA
 
Join Date: Apr 2007
Location: the Middle
Posts: 4,343
Default

No one live blogged this?

Didn't anybody count the "um"s?
__________________
Life is unfair
Reply With Quote
  #43  
Old 12-10-2015, 07:23 AM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 90,488
Blog Entries: 6
Default

Quote:
Originally Posted by Malcolm View Post
No one live blogged this?

Didn't anybody count the "um"s?
The session was recorded so people can count the ums at their own convenience.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #44  
Old 12-10-2015, 11:57 AM
Ranger's Avatar
Ranger Ranger is offline
Member
SOA AAA
 
Join Date: Sep 2001
Favorite beer: An icy cold one in a glass bottle
Posts: 1,338
Default

I liked the session. I even learned a thing or two.
Reply With Quote
  #45  
Old 12-10-2015, 12:06 PM
examsarehard examsarehard is offline
Member
CAS
 
Join Date: May 2011
Posts: 599
Default

You mentioned using a macro to toggle displaying formulas. You don't need a macro since the default Excel shortcut to do this is Ctrl+` (I don't know what that character is called, it's the same button as tilde on my keyboard).

Last edited by examsarehard; 12-10-2015 at 02:22 PM.. Reason: clarification
Reply With Quote
  #46  
Old 12-10-2015, 02:08 PM
Dan Moore's Avatar
Dan Moore Dan Moore is online now
Member
SOA AAA
 
Join Date: Jan 2008
College: University of Dallas
Posts: 2,637
Blog Entries: 1
Default

Great job, MPC!

One nitpick: I am not a fan of grouping. This bias dates back to the pre-Google 90s, when I received a workbook with grouped rows. I knew there was something weird about the workbook because I couldn't sort or filter it, and the symptom was the column of dots on the left margin. I couldn't get rid of the grouping via copy paste to another workbook. I didn't know the name of what had been done to the workbook; I just knew someone had put a pox on it.

This was before the Excel 2007 ribbon. I eventually painstakingly figured out that I was dealing with grouped data via the main menu and its many sub-menus - it had to be in there somewhere, right?

If you are going to foist grouping on someone, make sure you tell them what it is and how to turn it off. Hiding could be a lesser evil than grouping.
__________________
The best time to plant an oak tree is twenty years ago. The second best time is right now.
Reply With Quote
  #47  
Old 12-10-2015, 02:31 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 90,488
Blog Entries: 6
Default

Quote:
Originally Posted by examsarehard View Post
You mentioned using a macro to toggle displaying formulas. You can use Ctrl+` to do this (I don't know what that character is called, it's the same button as tilde on my keyboard).
Awesome -- thanks!

If you don't, I'll make a note of it at the Actex eLearning site for the info of others. Not everybody is going to want to fool around with VBA.

In my own case, I'm generally flipping between different Excel set-ups and versions, sometimes with macros with some standard keystrokes re-assigned. (I want to kill the person who re-assigned CTRL-A in one a spreadsheet I received once. It took me forever to figure out what had happened).

As a result, I usually just keep the specific code/toggles I want, set up the way I want, in PERSONAL.XLSB.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #48  
Old 12-10-2015, 02:46 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 90,488
Blog Entries: 6
Default

Quote:
Originally Posted by Dan Moore View Post
Great job, MPC!

One nitpick: I am not a fan of grouping. This bias dates back to the pre-Google 90s, when I received a workbook with grouped rows. I knew there was something weird about the workbook because I couldn't sort or filter it, and the symptom was the column of dots on the left margin. I couldn't get rid of the grouping via copy paste to another workbook. I didn't know the name of what had been done to the workbook; I just knew someone had put a pox on it.

This was before the Excel 2007 ribbon. I eventually painstakingly figured out that I was dealing with grouped data via the main menu and its many sub-menus - it had to be in there somewhere, right?

If you are going to foist grouping on someone, make sure you tell them what it is and how to turn it off. Hiding could be a lesser evil than grouping.
I generally don't want to sort or filter in production spreadsheets for the underlying data as it is. (I certainly don't want to do it on mortality tables, the specific example I showed)

This might be for a later webcast, about the distinction of tools of data exploration vs. building spreadsheets for "production" purposes (e.g., regular reports and the kind of spreadsheet I was trying to build in the example.)

But back to your point -- I agree it's a good idea for people to know what constraints using certain Excel techniques will do to their spreadsheets. And to throw out a practice that doesn't help them in a particular situation.... but to think through the trade-offs when doing so.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #49  
Old 12-11-2015, 11:31 AM
SpaceActuary's Avatar
SpaceActuary SpaceActuary is offline
Member
 
Join Date: Apr 2010
College: Drake U
Posts: 602
Default

Quote:
Originally Posted by campbell View Post
(I want to kill the person who re-assigned CTRL-A in one a spreadsheet I received once. It took me forever to figure out what had happened).
I can feel your pain. I had to deal with a bunch of related spreadsheets in which the author had reassigned CTRL-F to a macro.
__________________
And all this science, I don't understand; It's just my job five days a week...a rocket man, a rocket man...

"I'm from Iowa. I only work in space." - Adm. James T. Kirk
Reply With Quote
Reply

Tags
actex, excel, professionalism, spreadsheet, webinar

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 09:27 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 0.21526 seconds with 9 queries