Jump to content

MS Excel - Tips, tricks, Qs & As etc.

John Hjorth

Recommended Posts

I just did a search by topic title, if this was covered already by a topic in the General Discussion forum. It does not seem to be, however specific questions related to MS Excel has been covered in a few separate topics over the years here at CoBF.


This topic is not meant only for nerds, wizards & addicts [, or even some people with Microsoft certificates, paid for [most likely dearly!], and drawn in a candy- or sandworm-for-fishing-like vending machine [<- like me]] ... - Please just post! [ ; - ) ]


- - - o 0 o - - -


For starters, attached is an Excel Shortcuts Cheat Sheet.


Link to comment
Share on other sites

There are some good macros to aid in financial modeling as well. A pretty basic and useful one is called ripper, which creates shortcuts for common formatting tasks. To use it, open a spreadsheet and run MACROS.xla and then ripper.xla. Available shortcuts are in the third attachment.


I used this several years ago while I was working at a small hedge fund. I'm sure there are some better ones out there. Can anyone recommend another tool to make financial modeling more efficient?




Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...