VBA section now open!

The last category that was not open yet is now! Without any prior knowledge of Visual Basic coding you can now create simple macros that will calculate interests during construction or any other financing costs for you. These macros are the solution to circular references that you should ban from your models. In this section you can also learn how to automate repetitive taks such as running Goal Seek with the creation of a button that will make the whole process seamless for the user. You can click here to access the VBA section. As always any feedback is welcome! Vincent

Excel tricks section now open!

One week after the launch of the Financial Modeling Academy the first update has arrived! You can go to the "More Excel tricks" section to learn additional tricks to save time and make your models more user friendly. In this section you will learn how to add spin buttons to help users change input values, how to create dynamic graphs that not only will save you time but also impress whoever you will show this to, how to create the very useful waterfall graph and how to hide spreadsheets in a manner that will make it harder for non expert user to access them. You can click here to access the Excel Tricks section. I hope you will enjoy this first update and let me know if there are specific to

Featured Posts
Recent Posts
Archive
Search By Tags
Follow Us
  • LinkedIn App Icon
  • Wix Facebook page
  • Wix Twitter page
  • Google+ Classic

Financial Modeling Academy

  • LinkedIn App Icon
  • Wix Facebook page
  • Wix Twitter page