I’ll be attending Palisade’s user conference at the end of March in Amsterdam. This year, I’ll only be giving one talk (instead of the customary 3 or 4), so – for a change – will have a bit of a chance to relax and to listen to the other presenters. My own talk will be about modelling best practices in both Excel and @RISK.
Archives for January 2011
When one has data or graphs in Excel it can be very tempting to just copy these in to Word or PowerPoint by using the ‘Ctrl C and Ctrl V’ options. However, the robust interaction between these applications is more complex than this and may have a number of unintended consequences.
I am not a great believer in the extensive use of short-cuts; at least for most of my own modelling work, most of the time is not spent copying endless rows or columns of formulae, but rather in thinking through a solution to a problem, which is then implemented in Excel. Nevertheless, knowledge of those short-cuts that match closely with the type of activities that a particular modeller frequently undertakes can save valuable time. Attached to this message is an Excel file that lists the approximately 45 short-cuts that I tend to use fairly frequently. [Read more…] about Excel Short-Cuts