fbpx

Compare Certifications

Select certifications to compare:

Financial Modeling & Valuation Analyst (FMVA)®

Learn More Learn More

Commercial Banking & Credit Analyst (CBCA)™

Learn More Learn More

Capital Markets & Securities Analyst (CMSA)® Program

Learn More Learn More

Business Intelligence & Data Analyst (BIDA)™

Learn More Learn More

At a glance

100 - 200 hours
6 months to complete
Financial modeling, valuation and analysis
Excel skills focus
Starting at $497
60 - 100 hours
4 months to complete
Credit analysis, lending and risk
Documentation skills
Starting at $497
100 - 150 hours
6 months to complete
Asset classes, trading strategies
Capital markets knowledge and trading techniques
Starting at $497
150 - 200 hrs
6 months to complete
Data transformation, modeling, and visualization
Statistical and predictive analysis using code
Starting at $497

Skills learned

  • Financial modeling and valuation techniques, dashboards and data visualization in Excel
  • Pitchbooks and presentations in PowerPoint
  • Industry-specific financial models and case studies
  • Credit analysis and underwriting, risk assessment, financial modeling, and loan pricing
  • Master the 5 Cs of credit, loan documentation, covenants, and early warning signs
  • Equities, fixed income, foreign exchange, commodities, derivatives
  • Technical analysis, behavior finance, and trading strategies
  • Sourcing data from various sources including SQL databases and CSV files
  • Transforming and automating repetitive data tasks such as combining files
  • Data modelling & data visualization to evaluate performance and trends, using interactive visuals and dashboards
  • Statistical and predictive analysis to model uncertain scenarios
  • Machine learning concepts to constantly improve automated decision making

Career paths

  • Investment Banking
  • Financial Planning and Analysis (FP&A)
  • Private Equity
  • Corporate Development
  • Equity Research
  • Other areas of Corporate Finance
  • Commercial Loan Officer
  • Credit Analyst
  • Corporate Banking
  • Rating Agencies
  • Real Estate Lending
  • Business Banking
  • Sales & Trading
  • Asset & Portfolio Management
  • Wealth Management
  • Buy-Side and Sell-Side Analysts
  • Treasury
  • Risk Management
  • Business Intelligence Analyst
  • Data Analyst
  • Data Visualization Specialist
  • Quantitative Analyst
  • Data Scientist

Courses offered

  • Accounting Fundamentals
  • Capital IQ Fundamentals
  • Corporate Finance Fundamentals
  • Excel Fundamentals - Formulas for Finance
  • Macabacus Fundamentals
  • Math for Corporate Finance
  • Reading Financial Statements

  • Accounting Principles and Standards
  • Budgeting and Forecasting
  • Building a 3 Statement Financial Model
  • Business Valuation Modeling Part I
  • Business Valuation Modeling Part II
  • Dashboards & Data Visualization
  • Financial Analysis Fundamentals
  • FP&A Monthly Cash Flow Forecast Model
  • PowerPoint & Pitchbooks
  • Professional Ethics
  • Scenario & Sensitivity Analysis in Excel

  • Advanced Excel Formulas & Functions
  • Case Study - Financial Statements in Power BI
  • Corporate & Business Strategy
  • ESG Integration & Financial Analysis
  • Excel VBA for Finance
  • Leveraged Buyout LBO Modeling
  • Mergers & Acquisitions (M&A) Modeling
  • Mining Financial Model & Valuation
  • Modeling Risk with Monte Carlo Simulation
  • Operational Modeling
  • Power BI Fundamentals
  • Power Pivot Fundamentals
  • Power Query Fundamentals
  • Presentation of Financial Information
  • Real Estate Financial Modeling
  • Regression Analysis - Fundamentals & Practical Applications
  • Renewable Energy - Solar Financial Modeling
  • Startup / e-Commerce Financial Model & Valuation
  • The Amazon Case Study (New Edition)

  • Financial Modeling Template Library

  • 5 Cs of Credit
  • Account Monitoring and Warning Signs
  • Assessing Drivers of Business Growth
  • Assessing Management
  • Building a 3 Statement Financial Model
  • Business Writing Fundamentals
  • Cash Flow Cycles and Analysis
  • Completing a Credit Application
  • Credit Administration and Documentation
  • Evaluating a Business Plan
  • Financial Analysis for Credit
  • Loan Covenants
  • Loan Pricing
  • Loan Security
  • Professional Ethics
  • Reading Business Financial Information

  • Accounting Fundamentals
  • Analyzing Growth Drivers & Business Risks
  • Banking Products and Services
  • Careers in Commercial Banking
  • Excel Fundamentals - Formulas for Finance
  • Forms of Business Structure
  • Fundamentals of Credit
  • Introduction to Banking
  • Vertical IQ Fundamentals

  • Asset-Based Lending & Alternative Finance
  • Commercial Banking - Debt Modeling
  • Commercial Mortgages
  • Construction Finance Fundamentals
  • Converting Leads to Customers - Negotiation & Closing
  • Corporate & Business Strategy
  • Equipment Finance
  • ESG for Commercial Lenders
  • FP&A Monthly Cash Flow Forecast Model
  • Lending to Complex Structures
  • Lending to Medical Professionals
  • Mergers & Acquisitions (M&A) Modeling
  • Operational Modeling
  • Origination Fundamentals - Debt Capital Markets Perspective
  • Private Banking
  • Problem Loans
  • Profitable Lead Generation
  • Real Estate Fundamentals
  • Retail, Restaurant, & Franchise Lending
  • Securitized Products Part 1
  • Syndicated Lending
  • Trade Finance
  • Venture Debt

  • Case Study - RockCrusher Rentals
  • Case Study - Woodchucks Ltd. Owner Occupied Commercial Real Estate

  • Advanced Fixed Income
  • Advanced Futures & Forwards
  • Applied Fixed Income
  • Behavioral Finance
  • Commercial Mortgages
  • Convertible Bonds
  • Credit Fixed Income
  • Equity, FX, and Rate Futures
  • Foreign Exchange - Deliverable Forwards
  • Futures Pricing and Commodity Futures
  • High-Yield Bonds, Subordinated Debt, and Loans
  • Modeling Risk with Monte Carlo Simulation
  • Origination Fundamentals - Debt Capital Markets Perspective
  • Prime Services and Securities Lending
  • Repo (Repurchase Agreements)
  • Securitized Products Part 1
  • Short Duration Products
  • Swaps Fundamentals
  • Syndicated Lending
  • Trading Using Technical Analysis
  • Understanding Options

  • Applied Technical Analysis for Equity Markets

  • Commodities Fundamentals
  • Derivatives Fundamentals
  • Equity Markets Fundamentals
  • Fixed Income Fundamentals
  • Hedge Fund Fundamentals
  • Portfolio Management Fundamentals
  • Professional Ethics
  • Spot Foreign Exchange

  • Economics for Capital Markets
  • Excel Fundamentals - Formulas for Finance
  • Foreign Exchange Fundamentals
  • Introduction to Capital Markets
  • Math Fundamentals for Capital Markets
  • Refinitiv Workspace Fundamentals

  • Advanced Excel Formulas & Functions
  • Advanced Power BI
  • Advanced Tableau - Data Model
  • Advanced Tableau - LOD Calculations
  • Bayesian Thinking
  • Enterprise Deployment & Governance: Power BI Edition
  • Excel VBA for Finance

  • Case Study - Financial Statements in Power BI
  • Case Study - Trading Dashboard in Tableau
  • Classification - Fundamentals & Practical Applications
  • Dashboards & Data Visualization
  • Loan Default Prediction with Machine Learning
  • Modeling Risk with Monte Carlo Simulation
  • Power BI Fundamentals
  • Power Pivot Fundamentals
  • Power Query Fundamentals
  • Professional Ethics
  • Python Fundamentals
  • Regression Analysis - Fundamentals & Practical Applications
  • SQL Fundamentals
  • Tableau Fundamentals

  • Data Science & Machine Learning Fundamentals
  • Excel Fundamentals - Formulas for Finance
  • Introduction to Business Intelligence
  • Statistics Fundamentals

What will I earn upon completing the entire program?

Financial Modeling & Valuation Analyst (FMVA)® certification

Certified Banking & Credit Analyst (CBCA)™ certification

Capital Markets & Securities Analyst (CMSA)® certification

Business Intelligence & Data Analyst (BIDA)™

Get Certified
Corporate Finance Institute
Back to Website
0 search results for ‘’
People also search for: excel Free free courses accounting 2 Balance sheet 3