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.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
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.
About 45 hours of lessons, from the estimate on each lesson.
Nothing done yet. Progress saves in this browser as you finish lessons, and in your account when you sign in.
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.
Finance teams live in Excel. You build formulas with the right references, IF logic, conditional totals, lookups and dates, then PivotTables, dynamic arrays and the financial functions and What-If tools a model needs.
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.
This is the core of the job. You work with the time value of money, read and forecast the statements, link a three-statement model, build budgets and variance bridges in FP&A, then value a company with a DCF and with comparable companies.
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.
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.
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.
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.
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.
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.
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.
| Tool | Tasks | Minutes |
|---|---|---|
| Excel | 3 | 10 |
| Accounting | 3 | 13 |
| Finance modeling | 3 | 13 |
| Power BI | 3 | 15 |
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 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.
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.
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.
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.
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.
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.
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.
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.
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.