Financial Analyst Training Program (Live Online)

Master advanced Excel, corporate finance, and corporate valuation in this intensive five-day bootcamp.  You’ll learn the terms and vocabulary used within the industry to prepare you for interviews and have a valuation model to present from your portfolio. After this course, you’ll be prepared to work as a financial analyst.Learn Microsoft Excel and Corporate Finance. The five-day Financial Analyst Training program offers the most affordable and comprehensive training available for complete beginners to learn the necessary skills to become a financial analyst. By the end of this course, you’ll have the skills for a position at a Fortune 500 firm.Throughout the course, you’ll develop the following skills:Excel proficiency - Master formulas, functions, and Pivot TablesExcel for Financial Modeling - Learn Goal Seek and other financial functions in ExcelCorporate Finance and Accounting - Learn corporate finance and accounting conceptsFinancial Modeling - Build a three-statement DCF model on a public companyBy the end of this course, you’ll have knowledge of cash flow projection tools in Excel. You’ll develop experience with financial statement analysis and DCF modeling techniques, and corporate valuation principles. Each student will learn to review financial data, including earnings releases, financial reports, and use this information to evaluate business decisions.PrerequisitesNone; Prior knowledge of corporate finance and accounting is helpful, but not required.Course attendees will receive access to our free online corporate finance and accounting materials before the course.The Financial Analyst Training Program IncludesBeginner Microsoft ExcelGet going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow. Intermediate Microsoft ExcelTake your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.Financial Modeling BootcampBuild a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.Full Course SyllabusExcel for Business FundamentalsIntroductionFormulasFormattingCharts & TablesWorkbook ManagementEnd of Class ProjectIntermediate Excel for BusinessWorksheet ManagementWorking with TextDatabase FunctionsLogical FunctionsPivot TablesStatistical FunctionsAdvanced ChartsEnd of Class ProjectFinancial Modeling BootcampDay I: Advanced Excel for Financial ModelingDay II: Intro to Corporate Finance, Accounting, & ModelingDay III: In-depth Financial Modeling & ValuationExcel & Financial Modeling Courses for Financial AnalystsTraining Program for Investment Banking, Hedge Funds, Private Equity, Real Estate & Finance ProfessionalsTo become a successful financial analyst, you'll need several skills, including a strong comfort level in Excel, a background in accounting, finance, and valuation, and financial modeling capabilities. This training program is geared toward current or aspiring financial analysts, including investment banking, private equity, hedge funds, asset management, real estate, and venture capital.After completing this program, you will:Go from beginner to advanced in your  Excel capabilitiesLearn accounting concepts: Financial statements, working capital, and footnotesLearn financial concepts: Enterprise value, corporate valuation, Discounted Cash Flow Modeling, LBO ModelingBuild financial modeling skills: Learn how to project cash flows for companies in ExcelLearn more about Financial Analyst Training Program at NYC Career Centers