KEY FEATURES
This online course includes over 4 hours of instruction and Excel drills. The course is essential for anyone who will be required to use Excel, including but not limited to:
- The financial services industry (investment banking, consulting, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital, entrepreneurship and start-ups)
- Corporate/strategic development or finance group of a corporation
- Marketing, brand management or operations for a corporation or any position responsible for a product or divisional budget, projections and profit/loss statement
- Enhancing their learning in finance and financial statement analysis classes
- Non-finance roles, but interested in gaining a solid foundation in applied corporate finance
- Optimized for PC based Excel
TOPICS COVERED
- Basic Excel setup – macro security, iterations, calculations settings
- Financial modeling essentials – appropriate color schemes, page setup, and customizing toolbars in Excel
- Common shortcut keys and other efficiency tips
- Understanding how to efficiently design historical inputs and forecast financial projections
PREREQUISITES
- This course assumes no prior knowledge of Excel or Financial Modeling