Post in 1 month ago

Finance Tutor for Video Course: Accounting, Excel Modelling & Power Query

Summary

The client is creating a beginner training programme to prepare students for entry-level roles such as Financial Analyst, FP&A Analyst, Treasury Analyst, Data Analyst, and Business Analyst. The course uses a fictional UK manufacturing company, Northbridge Components Ltd, with approximately £40 million in sales, GBP and EUR transactions, and bank debt. The client will provide the case study, Excel data, model answers, video outlines, and production instructions. Your job is to teach the material clearly by recording 11 educational videos. This is not just screen recording. You must understand the finance concepts, demonstrate Excel and Power Query tasks accurately, and explain everything in simple English to complete beginners. Week-by-week video requirements Week 1 — Accounting basics and P&L 1.1 Accounting basics — 12 minutes Explain fundamental accounting concepts.

1.2 Modelling best practice — 10 minutes Explain how to structure a financial model.

1.3 Building a P&L with SUMIFS — 15 minutes Demonstrate a profit and loss statement using Excel.

Week 2 — Three statements and ratios 2.1 Balance sheet and cash flow — 12 minutes Introduce the balance sheet and indirect cash flow statement.

2.2 Statement links and ratios — 10 minutes Explain how the three financial statements connect and introduce key ratios.

2.3 Writing finance commentary — 8 minutes Explain how to communicate financial results clearly.

2.4 Linking the model — 15 minutes Demonstrate how the three statements link in Excel.

Week 3 — Data cleaning and KPIs 3.1 Power Query primer — 15 minutes Introduce data importing and transformation.

3.2 Data quality and KPIs — 8 minutes Explain data accuracy and KPI selection.

3.3 Cleaning the sales ledger — 15 minutes Demonstrate cleaning a messy 5,000-row dataset.

3.4 Requirements and process mapping — 12 minutes Introduce basic requirements gathering and process mapping

  1. What the client provides
  2. Case brief for Northbridge Components Ltd.
  3. Excel data pack, including trial balance and balance sheet schedules.
  4. Messy 5,000-row sales ledger.
  5. Completed and checked model answers.
  6. Content outline for every video.
  7. Production guide.
  8. Assessment rubric template.
  9. What you must deliver
  10. 1. Eleven screen-recorded videos with voice narration.
  11. 2. Approximately two hours of total educational content.
  12. 3. 1080p video quality.
  13. 4. Clear spoken English and beginner-friendly explanations.
  14. 5. Step-by-step demonstrations using the provided case study.
  15. 6. Explanations of common mistakes and lesson recaps.
  16. 7. Scripts or outlines submitted for approval before recording.
  17. 8. One round of revisions per video.
  18. 9. Completion of Stage 1 within 3–4 weeks.
  19. Important: Although the combined video length is about two hours, preparing examples, checking the model answers, scripting, recording, editing, and handling revisions will take considerably longer.
$350.00
Medium
Remote Job
Ongoing project

Skills and Expertise

Skill ImportanceAccounting EssentialFinancial Accounting EssentialFinancial Modeling EssentialMicrosoft Excel EssentialSUMIFS and XLOOKUP / INDEXMATCH EssentialPower Query EssentialThreestatement modeling EssentialFinancial Analysis EssentialFinancial Ratios and KPIs EssentialTeaching and Video Recording EssentialFinancial Projections RelevantProcess Mapping UsefulACCAACAor CIMA Advantagenot mandatoryAccounting knowledge requiredYou need to understand:Accrual accounting versus cash accounting.Revenue and cost recognition.Depreciation.Profit and loss statement.Balance sheet.Indirect cash flow statement.How the three statements link and balance.MarginsROCEcurrent ratiogearingand interest cover.UK terminologyincluding debtorscreditorsaccrualsprepaymentsVATand NIC.Excel and Power Query knowledge requiredSUMIFSIFXLOOKUP or INDEX/MATCH.Absolute and relative references.Tables and pivot tables.Model checks and error detection.Importing and cleaning data in Power Query.Setting data types using locale settings.Trimming textreplacing valuesand removing duplicates.Merging and appending queries.Fixing dates and numbers stored as text.

Activity on this job

Proposals:0 to 2
Last viewed by client:1 month ago
Interviewing:0
Hired:0

Explore similar jobs on Working Trust

Posted 1 month agoMedium
Proposals:0 to 2

Excel & Finance Online Course Development Client

The client wants a subject matter expert (SME) to work with their employee and AI tools to develop and administer three asynchronous microcredential courses. These courses will teach students basic Microsoft Excel skills alongside financial statement literacy and valuation concepts. The expert will be responsible for checking AI-generated educational content for accuracy, creating professional screen-recorded video tutorials, preparing supporting course materials, answering students' questions, and evaluating student assignments for an agreed period. The client prefers someone with experience in: - Financial modeling instruction - Corporate finance content development - Moodle-based finance course design This is more than simple Excel data entry. It combines financial knowledge, instructional design, video production, and ongoing student support.

WC

WorkingTrust Client

Schenectady, New York, USA

$5,000.00 fixed price

Required skillsMicrosoft Excel+5 Skills

$ 450 spent

Payment Unverified

Posted 1 month agoMedium
Proposals:0 to 2

Beginner-to-Advanced Business Case Tutoring Client

The client is looking for a long-term, one-to-one online tutor for their younger sister, who plans to enter a BBA program next year. She is a complete beginner and needs to learn business case solving from the basics to an advanced level. Her long-term goals are to participate in university case competitions and potentially pursue management consulting at companies such as McKinsey, BCG, and Bain. The client does not want a one-time mock interview or short-term interview preparation. They want a tutor who can develop a structured learning plan with weekly lessons, practice assignments, and regular feedback. The curriculum should include: - Business fundamentals - Structured and logical thinking - MECE (Mutually Exclusive, Collectively Exhaustive) - Issue trees and business frameworks - Business mathematics and market sizing - Profitability, growth, and market-entry cases - Data and chart interpretation - Developing business recommendations - Case competition preparation - Presentation and case-deck development - Advanced case practice

WC

WorkingTrust Client

Verified client

Thailand

$400.00 fixed price

Required skillsBusiness case solving+7 Skills

$ 450 spent

Payment Verified