Skip to main content

Financial Analyst Training Program Course Online

via Virtual Design and Construction Institute Affiliated with Course Report

A 30-hour bundle pairing Excel fundamentals and intermediate Excel with a financial modeling bootcamp. It covers corporate finance, financial accounting, and valuation from the ground up, and assumes no prior finance or accounting background. The program...

View curriculum Lesson previews

What's included

  • Software access during the course
  • 30 hours of project-based instruction
  • 40 training videos
  • Instructor support for questions during the course
  • Class recordings for 30 days
  • Verified digital certificate of completion
  • Instruction at an ACCET-accredited school

Overview

A 30-hour bundle pairing Excel fundamentals and intermediate Excel with a financial modeling bootcamp. It covers corporate finance, financial accounting, and valuation from the ground up, and assumes no prior finance or accounting background.

The program builds toward a full valuation model for a real public company, working through three-statement models and discounted cash flow analysis along the way. VDCI sends a short pre-learning guide about a week before the course begins.

Who this course is for

People preparing for financial analyst roles, and professionals who need modeling and valuation skills without an existing finance background.

Tuition & enrollment

Enroll with Virtual Design and Construction Institute, the course provider.

View tuition & enroll

Prefer to enroll directly? Open the course website.

Preview the course

Watch free previews and explore the lessons included with enrollment at VDCI.

Excel Fundamentals Course Online

  • Play preview

    Interface

    Lesson 1: Introduction

    8:26

    Explore the Microsoft Excel user interface, including the Quick Access Toolbar, Ribbon tabs and groups, Review tab features, Insert Function button, Zoom slider, Sheet Selector buttons, and the expansive rows and columns.

  • Enrollment required

    Rows and Columns

    Lesson 1: Introduction

    6:02

    Insert, delete, hide, and group rows and columns using ribbon commands, right-click menus, keyboard shortcuts, and grouping buttons.

    View enrollment options at VDCI
  • Play preview

    Autofill

    Lesson 2: Formulas

    9:07

    Use Excel's autofill and flash fill features to efficiently complete patterns and replicate data across cells.

  • Enrollment required

    Data Entry

    Lesson 2: Formulas

    5:13

    Learn techniques for efficient data entry, editing, copying, pasting, and cutting in spreadsheets.

    View enrollment options at VDCI
  • Enrollment required

    Calculations

    Lesson 2: Formulas

    10:16

    Learn to perform basic calculations in Excel using formulas, cell references, and functions like AVERAGE while considering the order of operations (PEMDAS).

    View enrollment options at VDCI
  • Enrollment required

    Autosum Functions

    Lesson 2: Formulas

    9:58

    Use Excel's AutoSum functions to quickly calculate Sum, Average, Max, Min, and Count in tables.

    View enrollment options at VDCI
  • Enrollment required

    Text Functions

    Lesson 2: Formulas

    8:04

    Use text functions like PROPER, UPPER, LOWER, and TRIM in Excel to efficiently adjust text casing and remove extra spaces.

    View enrollment options at VDCI
  • Enrollment required

    True False

    Lesson 2: Formulas

    7:14

    Verify statements in Excel as true or false using comparison operators.

    View enrollment options at VDCI
  • Enrollment required

    Absolute Cell References

    Lesson 2: Formulas

    10:07

    Utilize absolute cell references in Excel formulas to fix a specific cell while autofilling calculations, preventing unwanted shifts in cell references.

    View enrollment options at VDCI
  • Enrollment required

    Multi Input Functions

    Lesson 2: Formulas

    12:37

    Learn to use multi-input Excel functions like LEFT, RIGHT, SUMPRODUCT, and ROUND for extracting data, calculating totals, and managing rounding errors efficiently.

    View enrollment options at VDCI
  • Enrollment required

    Formatting

    Lesson 3: Formatting

    14:04

    Explore various Excel formatting tools to enhance cell appearance, including changing colors, fonts, alignment, number formats, and merging cells.

    View enrollment options at VDCI
  • Enrollment required

    Conditional Formatting

    Lesson 3: Formatting

    9:30

    Use conditional formatting to visually highlight and differentiate data based on set criteria within Excel.

    View enrollment options at VDCI
  • Play preview

    Line Chart

    Lesson 4: Charts & Tables

    5:34

    Create a basic line chart in Excel by selecting a single cell in your data, using the insert tab to choose a line chart, and customizing it with quick layout, color, and style options.

  • Enrollment required

    Column Chart

    Lesson 4: Charts & Tables

    7:53

    Create a column chart by selecting data, inserting it from the Insert tab, and customizing elements like axis titles, data labels, and grid lines through the Chart Design tab.

    View enrollment options at VDCI
  • Enrollment required

    Trendlines

    Lesson 4: Charts & Tables

    3:05

    Apply trend lines to charts by selecting the desired type (linear, exponential, linear forecast, or moving average) in the chart design options.

    View enrollment options at VDCI
  • Enrollment required

    Pie Chart

    Lesson 4: Charts & Tables

    7:27

    Create and customize pie charts by selecting data, converting between 2D, 3D, and donut styles, and isolating specific slices for emphasis.

    View enrollment options at VDCI
  • Enrollment required

    Tables

    Lesson 4: Charts & Tables

    13:52

    Learn to create and use Excel tables for efficient data management and analysis.

    View enrollment options at VDCI
  • Play preview

    Printing

    Lesson 5: Workbook Management

    10:00

    Explore and adjust printing options in Excel by utilizing the Page Layout tab to control margins, orientation, print area, page breaks, print titles, scale to fit, and gridlines, while adding headers and footers through the Insert tab for enhanced page setup and layout management.

  • Enrollment required

    Worksheets

    Lesson 5: Workbook Management

    7:04

    Manage Excel worksheets by inserting, deleting, hiding, moving, copying, and renaming them using right-click options or the ribbon menu.

    View enrollment options at VDCI
  • Enrollment required

    Freeze Panes

    Lesson 5: Workbook Management

    5:03

    Freeze panes by selecting the desired row or column below or to the right of where you want the freeze, then choose "Freeze Panes" from the View tab.

    View enrollment options at VDCI
  • Enrollment required

    Excel Tricks

    Lesson 5: Workbook Management

    9:14

    Explore Excel tricks like repeating commands with F4, applying multiple formats using Format Painter, inserting comments and links, and capturing screenshots directly into your spreadsheet.

    View enrollment options at VDCI

Excel Intermediate Course Online

  • Enrollment required

    Tips and Fundamentals

    Lesson 5: Workbook Management

    10:24

    Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.

    View enrollment options at VDCI
  • Play preview

    Navigation

    Lesson 1: Worksheet Management

    6:58

    Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.

  • Enrollment required

    Paste Special

    Lesson 2: Working with Text

    8:55

    Use paste special in Excel to apply formats, perform calculations, and change data orientation.

    View enrollment options at VDCI
  • Enrollment required

    Paste Special Values

    Lesson 2: Working with Text

    3:14

    Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.

    View enrollment options at VDCI
  • Enrollment required

    Splitting Text

    Lesson 2: Working with Text

    5:08

    Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.

    View enrollment options at VDCI
  • Enrollment required

    Joining Text

    Lesson 2: Working with Text

    5:06

    Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.

    View enrollment options at VDCI
  • Enrollment required

    Named Ranges

    Lesson 3: Cell Ranges

    3:56

    Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.

    View enrollment options at VDCI
  • Play preview

    Data Validation

    Lesson 4: Database Functions

    7:35

    Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.

  • Enrollment required

    Remove Duplicates

    Lesson 4: Database Functions

    3:51

    Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.

    View enrollment options at VDCI
  • Enrollment required

    VLOOKUP

    Lesson 4: Database Functions

    10:06

    Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.

    View enrollment options at VDCI
  • Enrollment required

    HLOOKUP

    Lesson 4: Database Functions

    2:58

    Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.

    View enrollment options at VDCI
  • Enrollment required

    Sort and Filter

    Lesson 4: Database Functions

    15:53

    Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.

    View enrollment options at VDCI
  • Play preview

    Pivot Tables New

    Lesson 5: Pivot Tables

    10:00

    Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.

  • Enrollment required

    Pivot Grouping Timelines

    Lesson 5: Pivot Tables

    5:16

    Group and filter pivot table data by time periods using the group and insert timeline features.

    View enrollment options at VDCI
  • Enrollment required

    Multiple Pivot Tables

    Lesson 5: Pivot Tables

    11:40

    Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.

    View enrollment options at VDCI
  • Play preview

    If Statements

    Lesson 6: Logical Functions

    8:30

    Explain how to use if statements and if error functions in Excel for logical testing and error handling.

  • Enrollment required

    And Or

    Lesson 6: Logical Functions

    6:17

    Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.

    View enrollment options at VDCI
  • Play preview

    COUNTIFS and SUMIFS

    Lesson 7: Statistical Functions

    9:46

    Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.

  • Enrollment required

    Combo Charts

    Lesson 8: Advanced Charts

    5:01

    Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.

    View enrollment options at VDCI

Curriculum

What you'll learn

  • Write essential formulas and functions, including database functions like VLOOKUP and HLOOKUP
  • Build compelling data visualizations using line, column, and pie charts, and share and print your work
  • Create Pivot Tables and work with logical statements like AND, OR, and IF, plus statistical functions like Ranking, COUNTIFS, and SUMIFS
  • Analyze real companies and build models and projections using real-world data
  • Work with Discounted Cash Flow modeling, corporate valuation, and leveraged buyout modeling techniques
  • Get grounded in key financial accounting concepts, including market capitalization, enterprise value, and accrual and cash accounting

Course outline

  1. Excel Fundamentals Course Online 6 hours

    Join our beginner Excel workshop to master the fundamentals of Microsoft Excel, including calculations, basic functions, creating graphs, formatting, and printing. This course is designed for individuals with limited experience who want to enhance their skills and build proficiency in Excel.

  2. Excel Intermediate Course Online 6 hours

    Master intermediate Excel functions such as VLOOKUP and SUMIFS, and learn how to summarize data using Pivot Tables, sort and filter databases, and manipulate text with split and join techniques. Develop the skills required to work with advanced Excel functions and get ready for more in-depth training.

  3. Financial Modeling Bootcamp Online 18 hours

    Take this financial modeling class to master essential finance and accounting concepts, build a discounted cash flow model in Excel, strengthen advanced Excel skills, and explore corporate finance and valuation using real company data. The course focuses on practical, job-ready financial modeling skills you can apply at your own pace.

    • Essential financial concepts, including market capitalization and enterprise value
    • Financial accounting fundamentals, with a focus on accrual versus cash accounting
    • Discounted cash flow modeling, covering assumptions, cash flow projections, sensitivity analysis, and model auditing
    • Advanced Excel techniques such as Data Validation, CHOOSE, Data Tables, and Goal Seek
    • Leveraged buyout modeling and valuation fundamentals
    • Real company financial analysis using practical data
    • Structuring financial models and building clear, reliable projections
    • Corporate valuation methods, how to calculate value per share, and interpreting and evaluating model outputs for accuracy and decision-making

Course Reviews

No reviews yet

Be the first to share your experience with this course

Write the First Review

Find the path that fits your
career goals

Match with Bootcamps Explore Courses

Sign up for bootcamp advice

Enter your email to join our newsletter community.

By submitting this form, you agree to receive email marketing from Course Report.