John Hjorth Posted March 2, 2019 Share Posted March 2, 2019 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.Excel_Shortcuts_Cheat_Sheet_-_20190302.pdf Link to comment Share on other sites More sharing options...
QuickFS Posted March 7, 2019 Share Posted March 7, 2019 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?MACROS.xlaripper.xlaCopy_of_Macro__Ripper_v2_Commands.xlsx Link to comment Share on other sites More sharing options...
york Posted March 20, 2019 Share Posted March 20, 2019 The Power Query and Power Pivots are very helpful in modeling and pulling data from multiple set or locations together. The measure and KPI feature is very handy. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now