Looking for corporate training?
We offer custom onsite training and discounted class vouchers.
nyc@careercenters.com212 • 684 • 5151
Download Syllabus
Financial Analyst Training Program in NYC or Live Online
Hands-on Classes in NYC
- $1333 $1195
- 35 Hours
-
Mac or PC provided
We provide computers to use during class. Choose a Mac or a PC during the checkout process.
- Small in-person class
- 185 Madison Avenue, NYC
- Also available live online
Financial Analyst Course in Manhattan, NYC
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 Tables
- Excel for Financial Modeling - Learn Goal Seek and other financial functions in Excel
- Corporate Finance and Accounting - Learn corporate finance and accounting concepts
- Financial Modeling - Build a three-statement DCF model on a public company
By 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.
Questions?
Do you have questions that aren't answered in the program descrtiption? Email the program director directly to find out if this is the right course for you.
Related Courses
- Enroll in our Summer Financial Modeling Bootcamp to prepare for interviews, internships, and full-time jobs after graduation
- Are you an intermediate Excel user? Consider taking our Financial Modeling Bootcamp to dive right into Advanced Excel and financial modeling
Prerequisites
- None; 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.
212 • 684 • 5151
Download Syllabus
The Financial Analyst Training Program Includes
Beginner Microsoft Excel
Get 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 Excel
Take 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 Bootcamp
Build 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 Syllabus
Download PDF OutlineExcel for Business Fundamentals
Introduction
- Interface
- Data Entry
Formulas
- Autofill
- Calculations
- True or False
- AutoSum Functions
- Text Functions
- Multi-Input Functions
- Absolute Cell References
Formatting
- Formatting
- Format Painter
- Conditional Format
Charts & Tables
- Line Chart
- Column Chart
- Pie Chart
- Tables
Workbook Management
- Printing
- Worksheets
- Repeat Action
- Shortcuts
End of Class Project
- Project
- Save and Close
Intermediate Excel for Business
Worksheet Management
- Navigation
- Paste Special
Working with Text
- Splitting Text
- Joining Text
- Named Ranges
- Data Validation
- Sort & Filter
- Remove Duplicates
Database Functions
- VLOOKUP
- HLOOKUP
- VLOOKUP - Closet Match
Logical Functions
- AND, OR
- IF statements
Pivot Tables
- Pivot Tables
- Pivot Tables & Grouping
- Multiple Pivot Tables
Statistical Functions
- Ranking
- COUNTIFS
- SUMIFS
Advanced Charts
- Combo Charts
End of Class Project
- Project
Financial Modeling Bootcamp
Day I: Advanced Excel for Financial Modeling
- Advanced techniques to Expedite Workflow
- Advanced Analytical Tools & Sensitivity Analysis
- Database Functions for Finance
- Functions for Financial Modeling
Day II: Intro to Corporate Finance, Accounting, & Modeling
- Intro to Corporate Finance
- Enterprise value
- Financial Accounting & Statement Analysis
- Integrated Financial Modeling
- Intro to DCF Modeling
- Sensitivity Analysis
- Intro to LBO Modeling
Day III: In-depth Financial Modeling & Valuation
- Company Analysis
- Financial projections
- Terminal Value
- Discounting Cash Flows
- Corporate Valuation
- Final Analysis & Reasonability Testing