Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        How to become a financial analyst

        Learn the spreadsheet skills finance runs on, how the three statements fit together, how to build a forecast and a DCF, and how to report the result. Every exercise is checked, and the pathway ends in a month-end project, a timed assessment across the tools and the interview.

        Tools
        Excel, Accounting, Finance modeling, Power BI, Microsoft Dynamics 365, Oracle NetSuite
        Units
        30 units, 186 lessons
        Checked exercises
        1,014
        Cross-tool projects
        2
        Final assessment
        12 tasks, 50 minutes

        About 45 hours of lessons, from the estimate on each lesson.

        Your progress

        Nothing done yet. Progress saves in this browser as you finish lessons, and in your account when you sign in.

        Lessons
        0 of 186 lessons
        Projects
        0 of 2 finished
        Assessment
        Not taken yet

        Start with Formula basics

        The pathway, unit by unit

        Take the steps in this order. Each step is a set of units from one course, not the whole course: the units this role uses. Open a unit to start its first lesson.

        1. Accounting

          You can't analyze numbers you can't read. You learn how a transaction becomes a journal entry, a ledger and a trial balance, how the financial statements come out of it, and the adjusting entries a month-end close needs.

          1. How accounting worksBeginner · 4 lessons · 23 exercisesFree
          2. Journal entriesBeginner · 5 lessons · 30 exercises
          3. Ledger and trial balanceBeginner · 4 lessons · 23 exercises
          4. Financial statementsBeginner · 4 lessons · 26 exercises
          5. Adjusting entriesIntermediate · 4 lessons · 22 exercises
        2. Reporting in Power BI

          Results have to reach people who won't open your model. You build a report on a data model, write DAX measures and compare periods, so this month's numbers sit next to last month's and the budget.

          1. Build your first reportBeginner · 4 lessons · 22 exercisesFree
          2. Slice and filterBeginner · 5 lessons · 25 exercises
          3. Model the dataBeginner · 4 lessons · 25 exercises
          4. DAX measuresIntermediate · 6 lessons · 30 exercises
          5. Dates and time intelligenceIntermediate · 5 lessons · 26 exercises
        3. Business Central financial reports

          Trace posted ledger entries into a dated financial report in Dynamics 365 Business Central. Apply a department filter, inspect the source movements and export the report with its scope intact.

          1. Financial reportingAdvanced · 5 lessons · 28 exercises
        4. NetSuite saved searches and reporting

          Define the transaction population and result grain, then compare a saved search with the dated financial report. Keep subsidiary scope and export evidence attached to the result.

          1. Saved searchesIntermediate · 5 lessons · 27 exercises
          2. Reporting and closeExpert · 5 lessons · 27 exercises

        Projects for this role

        Each project starts from a fictional company's brief and moves between tools the way the job does: what you build in one stage is where the next one starts. Every brief is free to read.

        Marlow & Pike
        AccountingExcelPower BI
        Project

        Close October and explain the cash

        October looks profitable, yet cash ended well below forecast. Post the adjusting entries, put each cash line next to its forecast in Excel, build the CFO's view in Power BI and write the month-end note.

        4 stages · 1 h 40 minView brief
        Greenbasket Market
        SQLExcel
        Case study

        Why did September revenue drop?

        The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.

        3 stages · 1 hView brief

        The job-readiness assessment

        When you finish the units, test yourself across the tools of the job at once: 12 practical tasks in 50 minutes, each in the tool it is about and checked automatically. The clock keeps running if you close the page.

        ToolTasksMinutes
        Excel310
        Accounting313
        Finance modeling313
        Power BI315

        How it is scored

        Each tool
        Ready when you get two thirds of its tasks right or more, Close at one third, otherwise Not yet. A coding task earns the share of its tests that pass.
        Ready for interviews
        75% or more overall, and every tool at Ready.
        Nearly ready
        50% or more overall, and no tool at Not yet.
        Keep practicing
        Anything else. The report lists every task you missed with the lesson that teaches it.

        Open the assessment

        The assessment is free. The result is practice feedback in the Interview Hub's report format, not a hiring decision. Retakes draw different tasks where the question pools allow.

        The interview

        The Interview Hub runs the financial analyst interview round by round, at a fictional employer: you answer out loud or in writing, the interviewer follows up, and the report quotes your answers.

        Practice the financial analyst interview

        What each plan opens

        Free
        The first unit of every course, with no account: 4 of the 30 units on this pathway. Every project brief is free to read, and the job-readiness assessment is free.
        One Course
        One course in full. On this pathway that is one of these: Excel (9 units), Accounting (5 units), Finance modeling (8 units), Power BI (5 units), Microsoft Dynamics 365 (1 units), Oracle NetSuite (2 units).
        All Access
        The whole pathway: every unit, every project stage and spoken interview practice.

        See plans and prices

        What a financial analyst does

        A financial analyst explains a company’s numbers and what they mean for decisions. In a corporate finance or FP&A team that means building the budget and the forecast, comparing actual results with both, explaining every gap, and valuing projects or companies when someone wants to invest. Most of it happens in Excel models that other people have to be able to follow and check.

        From the spreadsheet to the report

        Excel comes first because every later step happens in a workbook. Accounting comes next, because a model is only as good as your reading of the statements it forecasts. Modeling is the longest step and the one interviews test hardest. Power BI presents what the model produced. You then practice tracing posted Business Central entries into a financial report, so a dashboard total can be reconciled to its source.

        Showing what you can do

        In the Marlow & Pike project, October looks profitable but cash ended well below forecast. You post the adjusting entries, put each cash line next to its forecast in Excel, build the CFO’s view in Power BI and write the month-end note. In an interview that is a story with numbers in it. The assessment then shows which tool to practice before you apply.

        Markets and banking roles

        For work that uses securities and rates, the financial markets course adds terminal practice to the modeling foundation. The AML and KYC course covers customer and transaction review. Use the banking interview guide to choose practice for the role you want.

        Common questions

        Do I need an accounting or finance degree?

        Many financial analyst jobs ask for a degree in finance, accounting or economics, and some ask for a qualification such as the CFA. Check the ads you plan to apply to. This pathway gives you practice in the tools and methods those jobs use; it is not a qualification.

        Is this the same as investment banking?

        No. This pathway is for corporate finance and FP&A roles: budgets, forecasts, variance analysis and valuation. The finance modeling course goes further into leveraged buyouts, mergers and modeling tests if you are aiming at banking or private equity.

        How long does it take?

        The lessons on this pathway add up to about 45 hours. The modeling units take longest, because each builds on the model you made before. We don't promise how long getting hired takes.

        What does it cost?

        The first unit of every course is free, with no account. One Course opens one course in full; All Access opens the whole pathway. The pricing page shows every plan and its price.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.