Get our latest video feeds directly in your browser - add our Live
bookmark feeds - http://goo.gl/SXUApX
For Google Chrome users download Foxish live RSS to use the Live Feed - http://goo.gl/fd8MPl
Learn to Create Easy to Navigate Financial Models with Academy of Financial Training's "Learn Financial Modeling from Scratch" Program
Academy of Financial Training's Video Tutorials on Financial Modeling in Excel
In this session, we start with building a 'STANDARD TEMPLATE' worksheet for our financial model which shall be used when we want to insert a new worksheet for our model.
Key tasks that we learn in this session are: ·View Management: (i) Removing 'Gridlines', (ii) Adjusting column widths in a way that is appropriate for information alignment purposes for presenting the text and numbers of the financial statements and calculations, (iii) Hiding the unwanted columns (to the right) and rows (to the bottom) to increase efficiency in navigation and working with information. ·Presentation Best Practice: Colour Coding (i) Virtual Page Borders (ii) Title Rows (iii) Appropriate Columns: For better comprehension and separating historical years from projection years ·Plugging in the Company Name, Historical & Projection Years by use of formulae & appropriate 'Date' Formatting, etc.
This completes our exercise of creating a Re-Usable Template for the purpose of our Model.
SUBSCRIBE for Updates on our Upcoming Training Videos
Visit us: http://www.ftacademy.in/
About Us:
Academy of Financial Training is training services company that specializes in providing a complete range of finance training services and solutions
Since its incorporation AFT has trained more than 5,000 attendees in various finance domains, and is serving marquee Fortune 500 clients, making it one of the largest corporate training companies in India
AFT's training modules include programs right from basic financial statements analysis to advanced financial modelling, corporate finance, risk management and capital markets, etc related trainings.
