Master advanced Excel, corporate finance, and corporate valuation in this intensive five-day bootcamp. You will learn the terms and vocabulary used throughout the financial industry, preparing you for interviews and providing a valuation model to present from your professional portfolio. After this course, you will be fully prepared to work as a financial analyst.
Learn Microsoft Excel and Corporate Finance. The five-day Financial Analyst Training program offers the most comprehensive and affordable training available for complete beginners seeking to learn the necessary skills to become a financial analyst. By the end of this course, you will possess the skills required for a position at a Fortune 500 firm.
Skills Developed Throughout the Course:
- Excel proficiency: Master formulas, functions, and Pivot Tables for data analysis and manipulation
- Excel for Financial Modeling: Learn Goal Seek and other financial functions in Excel for sophisticated modeling
- Corporate Finance and Accounting: Learn corporate finance and accounting concepts from foundational to advanced levels
- Financial Modeling: Build a three-statement DCF model on a public company for practical application
By the end of this course, you will have knowledge of cash flow projection tools in Excel. You will develop experience with financial statement analysis and DCF modeling techniques and understand corporate valuation principles. Each student will learn to review financial data, including earnings releases and financial reports, using this information to evaluate and support sound business decisions.
Prerequisites:
- None; Prior knowledge of corporate finance and accounting proves helpful but is not required.
- Course attendees will receive access to our complimentary online corporate finance and accounting materials before the course begins.
the The Financial Analyst Training Program Includes
Beginner Microsoft Excel
- Get started with the fundamentals of Excel and begin working on projects. Gain practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and essential keyboard shortcuts to accelerate your workflow.
Intermediate Microsoft Excel
- Advance your Excel skills to the next level with this Intermediate Excel course. Master important Excel functions like VLOOKUP, SUMIFs, and PivotTables in this hands-on training. You will also learn critical text-related features, including splitting and joining text, removing duplicates, and data validation.
Financial Modeling Bootcamp
- Build a financial model and learn corporate finance and accounting principles. By the end of this course, you will have a comprehensive Discounted Cash Flow (DCF) model to add to your professional portfolio. You will possess fundamental knowledge of corporate finance and accounting concepts. Your advanced Microsoft Excel skills will enable you to build financial models quickly and accurately.
Complete Course Syllabus
Excel for Business Fundamentals
- Introduction
- Formulas
- Formatting
- Charts and Tables
- Workbook Management
- End of Class Project
Intermediate Excel for Business
- Worksheet Management
- Working with Text
- Database Functions
- Logical Functions
- Pivot Tables
- Statistical Functions
- Advanced Charts
- End of Class Project
Financial Modeling Bootcamp
- Day I: Advanced Excel for Financial Modeling
- Day II: Intro to Corporate Finance, Accounting, and Modeling
- Day III: In-depth Financial Modeling and Valuation
Excel and Financial Modeling Courses for Financial Analysts
Training Program for Investment Banking, Hedge Funds, Private Equity, Real Estate, and Finance Professionals
To become a successful financial analyst, you will need several core skills, including strong proficiency in Excel, a background in accounting, finance, and valuation, and competent financial modeling capabilities. This training program is specifically designed for current or aspiring financial analysts, including those in investment banking, private equity, hedge funds, asset management, real estate, and venture capital.
After completing this program, you will
- Progress from beginner to advanced in your Excel capabilities
- Learn accounting concepts, including financial statements, working capital, and financial statement footnotes
- Learn financial concepts, including enterprise value, corporate valuation, Discounted Cash Flow Modeling, and LBO Modeling
- Build financial modeling skills to project cash flows for companies in Excel
Learn more about Financial Analyst Training Program at NYC Career Centers
