Level 5 · Specialist
Excel Expert
Professional Excel applications
Apply Excel to finance, projects, sales, HR and operations, and learn to use Copilot and Python with care.
Log in to open this level
Students log in to see their lessons and progress.
What is inside
1Financial statements and models0/5
- E-1-1Building an income statementComing soon
- E-1-2Balance sheet and cash flowComing soon
- E-1-3Linking three statementsComing soon
- E-1-4Scenarios, Goal Seek and Data TablesComing soon
- E-1-5Budgeting and forecastingComing soon
2Investment and loan analysis0/5
- E-2-1NPV, IRR, XNPV and XIRRComing soon
- E-2-2PMT, IPMT and PPMTComing soon
- E-2-3Loan amortisation schedulesComing soon
- E-2-4Depreciation functionsComing soon
- E-2-5Solver for optimisationComing soon
3Statistics and forecasting0/5
- E-3-1Descriptive statisticsComing soon
- E-3-2Regression and the Analysis ToolPakComing soon
- E-3-3FORECAST.ETS and trend linesComing soon
- E-3-4Correlation and its limitsComing soon
- E-3-5Python in Excel: a first lookComing soon
4Project management0/5
- E-4-1Building a Gantt chartComing soon
- E-4-2Task trackers and statusComing soon
- E-4-3Resource allocationComing soon
- E-4-4Critical path basicsComing soon
- E-4-5Project: a project status reportComing soon
5Sales and customer analysis0/5
- E-5-1Tracking sales performanceComing soon
- E-5-2Customer segmentationComing soon
- E-5-3Pricing and margin analysisComing soon
- E-5-4ABC analysisComing soon
- E-5-5Evaluating a marketing campaignComing soon
6HR and payroll0/5
- E-6-1Managing employee dataComing soon
- E-6-2Payroll calculations and deductionsComing soon
- E-6-3Leave and attendance trackingComing soon
- E-6-4HR metrics and reportingComing soon
- E-6-5Employee performance trackingComing soon
7Inventory and operations0/5
- E-7-1Tracking stock levelsComing soon
- E-7-2Reorder points and safety stockComing soon
- E-7-3Stock valuation methodsComing soon
- E-7-4Demand forecastingComing soon
- E-7-5Operations reportingComing soon
8Copilot, AI and data protection0/5
- E-8-1Copilot in Excel: prompts and limitsComing soon
- E-8-2Agent Mode and checking AI workComing soon
- E-8-3The COPILOT functionComing soon
- E-8-4Passwords, encryption and permissionsComing soon
- E-8-5Privacy, POPIA and audit trailsComing soon