Site map
Every page of Tabellab in one list: all 443 courses by category and all guides. To search and filter, open all courses.
Pages
Courses
Excel (41)
- Excel for Finance
- Excel Essentials: Beginner to Advanced
- Advanced Excel Formulas & Functions Masterclass
- Excel Charts & Data Visualization
- What-If Analysis: Scenarios, Data Tables & Goal Seek
- Excel Dashboards & Reports
- Excel Basics in 60 Minutes
- Google Sheets for Business
- Excel for Accountants: Reconciliations, Ledgers & Month-End
- Excel IF & Logical Functions: From Simple IF to IFS, SWITCH & Nested Logic
- Excel Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules
- Excel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups
- Excel Text Functions: LEFT, MID, FIND, SUBSTITUTE & Clean Data
- Excel Data Validation & Error-Proof Templates
- Excel Conditional Formatting: Highlight Rules, Data Bars & Heat Maps
- Excel Financial Functions: PMT, IPMT, NPV, XNPV, IRR, XIRR & RATE
- Excel Statistical Functions: AVERAGEIFS, MEDIAN, PERCENTILE, RANK & FREQUENCY
- SUMPRODUCT & Array Formulas: Multi-Condition Sums, Counts and Lookups
- Excel Formula Errors & Auditing: #N/A, #VALUE!, #REF! and How to Fix Them
- Excel Rounding & Precision: ROUND, MROUND, CEILING, Currency & Floating-Point Traps
- Excel Invoice & Quote Templates: Line Items, Tax, Numbering & Payment Tracking
- Sorting & Filtering with Formulas: Top-N Lists, Dynamic Rankings & Extracts (No FILTER Needed)
- Excel Time Intelligence: MTD, YTD, YoY, Rolling 12 Months & Fiscal Years
- Excel Named Ranges & Readable Models: Constants, Names and the Name Box
- Excel Trackers: Habit, Task, Expense & Goal Trackers with Formulas
- Excel Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE & Spill Ranges
- Excel LET & LAMBDA: Readable Formulas, Custom Functions & MAP/REDUCE
- Pivot-Style Summary Reports with Formulas: UNIQUE, SUMIFS, Cross-Tabs & Subtotals
- Percentages in Excel: Percent Change, % of Total, Markup vs Margin & CAGR
- Excel Calendars & Schedules: Dynamic Monthly Calendar, Shift Rota & Gantt with Formulas
- Loan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons
- Weighted Scoring Models in Excel: Decision Matrices, Normalisation & Sensitivity
- Combining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation
- Comparing Two Lists in Excel: Matches, Missing Records, Changed Values, Tolerances & Exception Reports
- Scoring Competitions & Awards in Excel: Judges' Panels, Dropping High & Low, Weighted Criteria, Judge Normalisation & Tie-Breaks
- Engineering Calculation Sheets in Excel: Units, Interpolation in Design Tables, Iteration, Tolerance Stack-Ups & Design Checks
- Pro-Rata Calculations in Excel: Daily Rates, Partial Months, Joiners & Leavers, Mid-Cycle Plan Changes & Splitting Amounts by Period
- Retail & 4-4-5 Fiscal Calendars in Excel: Fiscal Weeks, Periods, 53-Week Years, Comparable Weeks & Weekly Sales Reports
- Tiered & Banded Calculations in Excel: All-Units vs Incremental Tiers, Block Tariffs, Volume Rebates, Stepped Costs & Band Lookups
- Allocation & Matching in Excel: FIFO Payments to Invoices, Stock to Orders, Fair-Share Rationing, Capacity Allocation & Matching Two Lists
- Averages Done Right in Excel: Weighted Means, Averages of Rates & Ratios, Geometric Growth, Time-Weighted Balances & the Average-of-Averages Trap
Data & Analytics (46)
- Business Analytics in Excel
- Business Statistics & Regression in Excel
- Data Cleaning & Preparation in Excel
- Forecasting & Time-Series Analysis in Excel
- Survey & Customer Feedback Analysis in Excel
- A/B Testing & Experimentation
- Data Storytelling with Charts
- Data Analyst Portfolio Projects in Excel
- Regression Analysis for Business in Excel
- Location Analytics in Excel: Distances, Catchments & Territories
- Customer Segmentation: RFM Scoring, Personas & k-Means by Hand
- Bayesian Statistics in Excel: Priors, Posteriors & Bayesian A/B Tests
- Nonparametric Statistics: Rank Tests, Spearman & Bootstrap
- Cross-Tabs & Chi-Square: Analysing Categorical Data in Excel
- Network & Graph Analysis in Excel: Degree, Paths & Centrality
- Customer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves
- Market Basket Analysis: Support, Confidence, Lift & Cross-Selling
- Causal Inference for Business: Difference-in-Differences, Matching & Natural Experiments
- ANOVA & Experimental Design in Excel: One-Way, Two-Way & Post-Hoc Tests
- Polling & Survey Sampling: Margin of Error, Weighting & Poll Averages
- E-commerce Cohort Analysis: Repeat Purchase, Revenue per Cohort & Payback
- Data Privacy in Practice: Pseudonymisation, k-Anonymity & Re-identification Risk
- Queue Simulation with Spreadsheets: Arrivals, Service Times & Waiting Lines
- Data Modeling Basics: Fact Tables, Dimensions, Keys & Star Schemas
- Competitor Price Monitoring: Price Index, Changes & Promotion Detection
- Forecast Accuracy & Forecast Value Added: MAPE, WAPE, Bias & FVA
- IoT Sensor Data Analysis: Resampling, Thresholds, Drift & Uptime
- Energy Bill & Load Profile Analytics: kWh, Peak Demand & Tariffs
- Education Analytics: Attendance, Grades, Pass Rates & Cohort Progress
- Fraud Detection Rules: Velocity Checks, Rule Scoring & Alert Tuning
- Index Numbers: Laspeyres, Paasche, Fisher & Building a Price Index
- Sample Size & Power Analysis: How Many Observations Do You Need?
- Principal Component Analysis in Excel: Standardise, Covariance, Eigenvectors & Scores
- Data Quality Metrics: Completeness, Validity, Uniqueness, Timeliness & DQ Scorecards
- Survey Weighting: Post-Stratification, Raking (IPF) & Design Effects
- Meta-Analysis in Excel: Effect Sizes, Fixed vs Random Effects & Forest Plots
- Process Mining with Spreadsheets: Event Logs, Case Durations, Variants & Bottlenecks
- Prioritisation Surveys: Ranking Questions, Best–Worst Scaling, TURF Reach & Kano Categories
- SQL Window Functions in a Spreadsheet: Running Totals, Ranks per Group, Previous-Row Values, Moving Averages & Sessions
- Election Night Analytics: Turnout, Vote Shares, Swing, Seat Projections & Disproportionality
- Traffic Count Analysis: Hourly Volumes, Peak-Hour Factors, Directional Splits, Vehicle Classes, Annual Averages & Growth Projections
- Population Analysis & Projections: Age-Band Profiles, Birth & Death Rates, Migration, Cohort Projections and Dependency Ratios
- Vehicle Telematics Analytics: Trips from GPS Logs, Distance & Speed, Idling, Fuel per 100 km, Utilisation & Fleet Exception Reports
- Tourism Statistics by the Numbers: Arrivals vs Overnight Stays, Length of Stay, Bed & Room Occupancy, Seasonality Indices and Regional Reports
- Time-Series Models by Hand: Stationarity, Differencing, Autocorrelation, AR & MA Terms, ARIMA Forecasts and Residual Checks
- BI-Style Measures with Formulas: Filter Context, Removing Filters, Semi-Additive Balances, Top-N with Others, New vs Returning Customers & Dynamic Segments
Accounting (40)
- Accounting & Bookkeeping Fundamentals
- Managerial & Cost Accounting
- VAT & Sales Tax Fundamentals
- Bookkeeping in Practice: Bank, Receivables, Inventory & Assets
- Advanced Accounting: Leases, Deferred Tax & Consolidation
- Audit & Forensic Analytics in Excel
- Payroll Accounting & Bookkeeping
- Inventory Accounting: FIFO, LIFO, Weighted Average & Valuation
- Lease Accounting: IFRS 16 & ASC 842 in Excel
- Deferred Tax Accounting: Temporary Differences, DTA & DTL
- Consolidation & Group Accounting: Goodwill, NCI & Intercompany Eliminations
- Revenue Recognition: IFRS 15 & ASC 606 Five-Step Model in Excel
- Accounts Payable & Purchase-to-Pay: Three-Way Match, Duplicates & Payment Runs
- Impairment Testing: IAS 36 Value in Use, CGUs & Goodwill
- Foreign Currency Accounting: Transactions, Remeasurement & Translation (IAS 21 / ASC 830)
- Construction Contract Accounting: WIP Schedules, Over/Under Billing & Margin Fade
- Transfer Pricing Basics: Arm's Length, Margins & Benchmarking
- Stock-Based Compensation Accounting: Grant-Date Fair Value, Vesting & Expense (IFRS 2 / ASC 718)
- Accounts Receivable & Collections: DSO, CEI, Credit Limits & Bad Debt
- Nonprofit Fund Accounting: Restricted Funds, Grants & Functional Expenses
- Partnership Accounting: Profit Sharing, Capital Accounts, Admission & Dissolution
- Internal Controls Testing: Control Matrices, Sample Sizes & Deficiency Evaluation
- Cash Basis to Accrual Accounting: Conversions, Adjustments & Year-End Entries
- Earnings per Share: Basic & Diluted EPS, Weighted Shares, Splits & Convertibles
- Fixed Asset Accounting: Depreciation Methods, Disposals, Revaluation & Componentisation
- Crypto Asset Accounting: Cost Basis, Lots, Fair Value & Gains
- Purchase Price Allocation: Goodwill, Intangibles & Fair Value Step-ups
- Provisions & Contingencies (IAS 37): Recognition, Expected Values & Unwinding
- Hedge Accounting Basics: Fair Value, Cash Flow Hedges & Effectiveness Testing
- Statement of Cash Flows: Indirect Method, Working Capital & Free Cash Flow
- Intangible Assets (IAS 38): R&D Capitalisation, Amortisation & Software Costs
- Agriculture Accounting (IAS 41): Biological Assets, Fair Value Less Costs to Sell & Produce
- Investment Fund Accounting: Daily NAV, Unit Pricing, Subscriptions & Redemptions, Fee Accruals & Performance Fees with a High-Water Mark
- Bank Transaction Categorisation: Keyword Rules, Vendor Maps, Amount Rules, Split Transactions & an Exceptions Queue
- The Effective Interest Method: Amortised Cost Schedules for Loans & Bonds with Fees, Discounts, Premiums and Changed Cash Flows
- Daily Sales Reconciliation for Shops & Restaurants: Register Reports, Card Settlements, Tips, Refunds, Gift Cards & the Daily Sales Journal
- Bill of Materials Costing: Multi-Level BOMs, Scrap Factors, Routings, Overhead Rates & Product Cost Roll-Ups
- Running a Bookkeeping Practice: Client Fees, Hours per Client, Fixed vs Hourly Pricing, Deadline Calendars, Capacity & Profit per Client
- Budget Control with Commitments: Purchase Orders, Encumbrances, Available Budget, Year-End Carry-Forwards & Fund Reports
- Accounting for Capital Projects: Assets Under Construction, Capitalisable vs Expensed Costs, Borrowing Costs, Commissioning & Transfer to the Asset Register
Corporate Finance & Valuation (55)
- Financial Statements & Ratio Analysis
- Financial Modeling & DCF Valuation
- Budgeting & Cash-Flow Forecasting (FP&A)
- Corporate Finance & Time Value of Money
- Investment Banking Modeling: LBO & M&A
- Credit & Risk Analysis
- Banking & Insurance Math
- Fixed Income & Bond Analytics
- Three-Statement Financial Model in Excel
- Private Equity & Venture Capital Math
- Treasury, Cash & FX Risk Management
- Islamic Finance Math: Murabaha, Ijara, Musharaka & Sukuk
- Project Finance Modeling: Cash Flow Waterfall, DSCR & Debt Sculpting
- Credit Risk Modeling: PD, LGD, EAD & Expected Credit Loss
- Bank ALM: Interest Rate Risk, Gap Analysis & Liquidity Ratios
- Insurance Claims Reserving: Chain Ladder, Loss Ratios & IBNR
- Microfinance & Small-Loan Math: Flat vs Declining Rates, APR & Portfolio Quality
- Trade Finance: Letters of Credit, Factoring & Supply Chain Finance
- Pension Fund Math: DB Obligations, Funding Ratios & Liability Hedging
- Public Finance: Government Budgets, Deficits & Debt Sustainability
- Consumer Credit Math: Credit Cards, APR, Minimum Payments & BNPL
- Payments & Fintech Economics: Interchange, MDR, Take Rates & Chargebacks
- Credit Spreads & CDS Basics: Hazard Rates, Spreads & Default Probabilities
- Insurance Ratemaking: Pure Premium, Loss Trends & Rate Indications
- Revenue-Based Financing & Venture Debt: Caps, Repayment Rates and True Cost
- Bank Loan Pricing: Funding Cost, Expected Loss, Capital & RAROC
- Green Bonds & Sustainable Finance: Use of Proceeds, Greenium & Impact Metrics
- Corporate Treasury: Cash Pooling, Intercompany Netting & Liquidity Forecasting
- Restructuring & Bankruptcy Math: Recovery Waterfalls, Absolute Priority & Plan Value
- Equipment Leasing & Finance: Lessor Yield, Residual Value & Lease-vs-Loan
- Municipal Bonds: Tax-Equivalent Yield, Credit & Call Risk
- Student Loan Repayment Math: Standard, Graduated & Income-Based Plans
- Bank Capital Ratios: Risk-Weighted Assets, CET1, Buffers & Leverage
- Dividends & Share Buybacks: Payout Policy, Yields & EPS Effects
- ESG Ratings Methodology: Indicators, Normalisation, Weights & Scores
- Convertible Bonds: Conversion Value, Premium, Bond Floor & Dilution
- Interest Rate Swaps: Pricing, Valuation, DV01 & Hedging
- 13-Week Cash Flow Forecast: Receipts, Disbursements, Liquidity & Variance
- Real Options Valuation: Binomial Trees for Expand, Delay & Abandon Decisions
- Comparable Company Analysis: Trading Comps, Multiples & Precedent Transactions
- Credit Card Issuer Economics: Interchange, Revolve Rates, Losses & Rewards Cost
- Wealth Advisory Practice Economics: AUM Fees, Client Profitability & Practice Value
- Invoice Factoring & Supply Chain Finance: Advance Rates, Fees & Effective Cost
- Venture Debt: Term Sheets, Warrant Coverage, Runway & Effective Cost
- Credit Scorecards: Weight of Evidence, Information Value & Points Scaling
- Variance Bridges for FP&A: Price, Volume, Mix, FX & Cost Effects from Budget to Actual
- Finance for Managers Without a Finance Background: P&L Lines, Department Budgets, Headcount Costs, Cash vs Profit & Simple Business Cases
- Mortgage-Backed Securities by Hand: Pool Cash Flows, Prepayment Speeds, Servicing Strips, Weighted Average Life & Price Scenarios
- Private Credit Deals: Floating Margins, Upfront Fees & OID, PIK Interest, Call Protection & Lender Yield
- Reinsurance by Hand: Quota Share, Surplus Treaties, Excess-of-Loss Layers, Reinstatements & the Ceded Result
- Professional Football Club Finance: Wage-to-Revenue, Player Registration Amortisation, Transfer Instalments, Matchday & Broadcast Income
- Aircraft Leasing by the Numbers: Lease Rate Factors, Maintenance Reserves, Return Conditions, Residual Values & Lessor Returns
- Inflation-Linked Bonds by Hand: Index Ratios, Adjusted Principal, Real Yields, Breakeven Inflation & Deflation Floors
- Money Markets by Hand: Discount Yields, Money-Market Yields, Day Counts, Short-Term Deposits, Repos & Cash-Fund Yields
- Litigation Funding by the Numbers: Case Budgets, Stage Probabilities, Expected Recoveries, Funder Return Structures, Proceeds Waterfalls, Duration & IRR and Case Portfolios
Investing & Personal Finance (33)
- Personal Finance in Excel
- Investing & Portfolio Analysis in Excel
- Options & Derivatives Basics in Excel
- Retirement & Financial Independence Planning
- Dividend & Income Investing in Excel
- Stock Market, ETF & Index Fund Investing
- Value Investing & Intrinsic Value
- Technical Analysis Indicators in Excel
- Forex Trading Math & Risk Management
- Crypto & DeFi Math
- Futures & Commodities Trading Math
- ETF & Index Fund Investing Math
- Factor Investing: Value, Momentum, Quality & Smart Beta
- Trading Journal Statistics: Win Rate, Expectancy, R-Multiples & Drawdown
- Angel Investing Math: SAFEs, Dilution & Power-Law Portfolios
- Tax-Efficient Investing Math: After-Tax Returns, Asset Location & Loss Harvesting
- P2P Lending & Crowdfunding Returns: Defaults, Diversification & Net Yield
- Portfolio Performance Attribution: TWR, Benchmarks & Brinson Allocation/Selection
- Bond Ladders for Income: Building Rungs, Reinvestment & Cash-Flow Matching
- Value at Risk & Expected Shortfall: Historical, Parametric & Stress Tests
- House Flipping Math: ARV, the 70% Rule, Rehab Budgets & Holding Costs
- Pension Lump Sum vs Annuity: Present Value, Break-Even Age & Risk Trade-offs
- Portfolio Rebalancing: Drift, Bands, Cash-Flow & Tax-Aware Rebalancing
- College Savings Planning: Future Cost, Monthly Savings & Tax-Advantaged Accounts
- Gold & Precious Metals Investing: Premiums, Storage Costs, Ratios & Portfolio Role
- Investment Fees: Expense Ratios, Advisory Fees, Loads & Their Long-Run Cost
- Employee Equity: RSUs, Stock Options, Vesting, Dilution & Exit Scenarios
- Currency-Hedged Investing: Unhedged vs Hedged Returns, Forward Points, Hedge Costs, Partial Hedge Ratios & Rolling Hedges
- Volatility, Volume & Price Levels: True Range & ATR, Stochastic Oscillator, VWAP, On-Balance Volume, Pivot Points, Retracement Levels & ATR-Based Stops
- Portfolio Optimisation by Hand: Covariance Tables, Two- and Three-Asset Mixes, Minimum-Variance Portfolios, the Efficient Frontier & the Tangency Portfolio
- Pairs Trading by the Numbers: Spreads, Hedge Ratios, Mean-Reversion Tests, Z-Score Signals, Half-Lives, Backtests & Trading Costs
- Volatility & Risk Budgets by Hand: Rolling and Exponentially Weighted Volatility, a GARCH(1,1) Recursion, Volatility Targeting, Inverse-Volatility Weights & Risk Parity
- Structured Products by the Numbers: Zero-Coupon Floors, Capital-Protected Notes, Participation & Caps, Discount Certificates, Reverse Convertibles, Barriers, Worst-Of and Autocall Schedules
Business & Operations (64)
- Project Management with Excel
- Operations & Supply Chain in Excel
- Startup Finance & SaaS Metrics
- Sales & Marketing Analytics in Excel
- HR & People Analytics in Excel
- Economics for Business in Excel
- Pricing & Profitability Analysis
- Valuing & Buying a Small Business
- Business Plan Financials in Excel
- Freelancer Finance: Rates, Cash Flow & Taxes Set-Aside
- ESG & Carbon Accounting in Excel
- Call Center Metrics & Erlang C Staffing
- Procurement & Spend Analytics
- Six Sigma & Quality Statistics: DPMO, Cp/Cpk & Control Charts
- SaaS & Subscription Metrics: MRR, Churn, NRR & Cohorts
- Decision Analysis: Decision Trees, Expected Value & Monte Carlo
- Sales Compensation & Quota Planning
- Franchise Business Economics: Unit Economics, Royalties & Multi-Unit Growth
- Customer Experience Metrics: NPS, CSAT, CES & Retention Impact
- Workforce Planning & Headcount Budgeting
- Strategy Frameworks by the Numbers: BCG Matrix, Market Attractiveness & Scenarios
- KPIs & OKRs: Designing, Scoring and Cascading Goals
- Negotiation by the Numbers: BATNA, ZOPA, Concessions & Deal Value
- Supply Chain Risk & Resilience: Safety Stock, Dual Sourcing & Disruption Scenarios
- Professional Services Metrics: Utilisation, Realisation & Project Margin
- Value Stream Mapping by the Numbers: Lead Time, Process Efficiency & Flow
- Membership Business Economics: Gyms, Coworking & Clubs
- Two-Sided Marketplace Metrics: GMV, Take Rate, Liquidity & Unit Economics
- Business Continuity: Impact Analysis, RTO/RPO & Recovery Priorities
- Office Space & Hybrid Work: Desk Utilisation, Space per Person & Cost
- E-commerce Returns Analytics: Return Rates, Reasons, Reverse Logistics Cost
- Zero-Based Budgeting: Decision Packages, Ranking & Cost Baselines
- Salon & Spa Business Economics: Chair Utilisation, Commissions & Retail Attach
- Grant Budgeting for Nonprofits: Direct Costs, Indirect Rates & Cost Share
- Deal Desk & Discount Governance: Margin Floors, Approval Routing & Price Waterfalls
- 3PL Warehouse Pricing: Storage, Pick & Pack Fees and Building a Quote
- Business Travel & Expense Analytics: Policy Compliance, Per Diems & Savings
- Freight Tender Analysis: Lane Bids, Carrier Scoring & Award Scenarios
- Gig Driver Earnings: True Hourly Pay, Cost per Mile & Platform Comparison
- Landed Cost & Import Duties: Incoterms, Tariffs, VAT & True Unit Cost
- Insurance Agency Economics: Commissions, Retention, Book Value & Producer Pay
- Maintenance & Reliability: MTBF, MTTR, Preventive Intervals & Spare Parts
- Event Ticket Pricing: Price Tiers, Sell-Through, Dynamic Pricing & Comps
- Crowdfunding Campaign Planning: Reward Tiers, Funding Goals, Fulfilment & Shipping Costs
- Subscription Box Economics: Box COGS, Churn by Cohort, CAC Payback & Skip Rates
- Project Portfolio Prioritisation: Scoring, NPV, Resource Constraints & Capacity
- Freelance Translation & Localisation Business: Word Counts, Match Discounts, Throughput, Rush Fees & Project Quotes
- Customer Success by the Numbers: Health Scores, Time-to-Value, Renewal Forecasts, Expansion & Account Coverage
- Vending Machine Business by the Numbers: Machine Payback, Location Commissions, Product Mix, Restock Routes & Cash vs Card
- Staffing & Recruitment Agency Economics: Bill vs Pay Rates, Employer Cost Loads, Placement Fees, Fill Rates & Recruiter Productivity
- Freight Brokerage by the Numbers: Load Margins, Carrier Rates, Quick-Pay & Factoring Fees, Accessorials & Desk Productivity
- Contract Price Adjustment Clauses: Index-Linked Formulas, Base Dates, Caps & Floors, Thresholds and Multi-Year Escalation
- Warranty & Service Contract Economics: Failure Curves, Claims per Unit Sold, Extended-Warranty Pricing, Attach Rates & Contract P&L
- Benefits Realisation for Projects & Programmes: Benefit Registers, Baselines, Ramp-Up Curves, Realised vs Planned & Net Benefit
- Outsourcing & Shared Services Business Cases: Baseline Costs, Vendor Pricing, Transition Costs, Retained Organisation & Payback
- Equipment & Event Rental Business: Utilisation, Day–Week–Month Rate Ladders, Availability Calendars, Damage Waivers & Item Payback
- Staffing 24/7 Posts: Post Hours, Relief Factors, Officers Needed, Shift Patterns, Overtime & Bill-Rate Build-Ups
- Running a Coach & Bus Charter Business: Cost per Hour and km, Dead Mileage, Driver Duty Limits, Quote Building & Fleet Utilisation
- Driving School Business Economics: Lesson Capacity, Instructor Utilisation, Packages, Pass-Rate Effects, Vehicle Costs & Break-Even
- Running a Removals Company: Survey Volumes, Crew & Van Planning, Pricing per m³ and Hour, Storage, Claims and Seasonal Peaks
- Running a Flower Shop: Stem Costs, Recipes per Arrangement, Waste of Perishable Stock, Event Quotes, Subscriptions & Peak Days
- Business Analysis by the Numbers: Stakeholder Grids, RACI Checks, Elicitation Plans, Requirement Quality, MoSCoW Capacity, Objective Traceability, Process Gaps & the Business Case
- Funeral Home Economics: Calls & Service Mix, Itemised Prices vs Packages, Cost per Call, Third-Party Disbursements, On-Call Rotas, Chapel & Vehicle Capacity, Merchandise and Pre-Arranged Plans
- Auto Repair Workshop Economics: Job Cards, Technician Productivity & Efficiency, Bay Utilisation, Labour and Parts Pricing, Comebacks, Seasonal Tyre Service and Break-Even
Industry Finance (3)
- E-commerce & Online Seller Finance
- Trucking & Logistics Business Math
- Airline & Travel Revenue Management
Real Estate & Property (23)
- Real Estate Investment Analysis
- Real Estate Development & Equity Waterfalls
- Mortgage & Loan Underwriting Math
- Short-Term Rental Investment Analysis
- Property Management Math: Rent Rolls, Vacancy & CAM Reconciliation
- REIT Analysis: FFO, AFFO, NAV & Dividend Coverage
- Real Estate License Exam Math: Commissions, Prorations & Loans
- Real Estate JV Waterfalls: Preferred Return, IRR Hurdles & Promote
- Mortgage Refinancing Math: Break-Even, Points, Cash-Out & ARMs
- Self-Storage Business Economics: Unit Mix, Occupancy & Revenue Management
- Housing Market Analytics: Price Indices, Affordability & Supply
- Home Appraisal Math: Sales Comparison Grid, Adjustments, Cost & Income Approaches
- Real Estate Agent Business Math: Commission Splits, Caps, GCI Goals & Expenses
- HOA & Condo Association Finance: Dues, Reserve Studies & Special Assessments
- Rental Service Charges & Utility Billing: Allocation Keys, Prepayments & Year-End Statements
- Value-Add Apartment Investing: Renovation Premiums, Unit Turn Schedules, Rent Uplifts, Expense Ratios & Refinance Proceeds
- Site Feasibility for Developers: Plot Ratio, Site Coverage, Unit Yield, Parking Ratios & Build-Cost Checks
- Parking Facility Economics: Occupancy by Hour, Turnover, Rate Structures with Daily Caps, Permit Oversell & NOI
- Student Housing & Co-Living by the Bed: Unit Mix, Rent per Bed, Academic-Year Leases, Pre-Leasing Pace, Summer Income & NOI per Bed
- Shopping Centre Leasing: Base Rent, Turnover Rent & Breakpoints, Service Charge Recoveries, Occupancy Cost Ratios & Centre NOI
- Industrial & Logistics Property: Clear Height and Storage Capacity, Dock Ratios, Rent per Pallet Position, Development Yield on Cost & Exit Value
- Hotel Investment & Valuation: From RevPAR to NOI, Departmental Profits, Management Fees, FF&E Reserve, Hotel Cap Rates & Hold-Period Returns
- Land Subdivision & Lot Development: Gross to Net Area, Lot Yield, Infrastructure Cost per Lot, Phasing, Sales Absorption & Residual Land Value
Career & Interview Prep (26)
- Excel Interview Test Practice
- Accounting Interview Practice
- Financial Modeling Test Prep
- Consulting Case Interview Math
- Salary Negotiation & Job Offer Math
- Product Manager Metrics & Interview Cases
- PMP Exam Math: Earned Value, PERT, Critical Path & Formulas
- Quantitative Methods Practice for Finance Exams (CFA-Style Level I)
- Numerical Reasoning Tests: Practice for Job Aptitude Tests
- Operations & Supply Chain Exam Math: EOQ, MRP, Capacity & Forecast Error (CPIM/CSCP-Style Practice)
- Excel Certification Practice: Exam-Style Tasks for Core Skills (MO-200-Style)
- Quant Trading Interview Math: Expected Value, Probability Puzzles & Market Making
- Insurance License Exam Math: Premiums, Coinsurance, Deductibles & Annuities
- Cash Handling & Till Math: Counts, Change, Deposits & Variances
- Flight Planning Math for Student Pilots: Wind Triangle, Fuel & Weight-and-Balance
- Bookkeeping Exam Practice: Double Entry, Trial Balance & Bank Reconciliation
- Fire Pump Hydraulics: Friction Loss, Nozzle Pressure & Pump Discharge Pressure
- Securities Exam Math: Yields, Options, Margin & Mutual Fund Calculations
- Management Accounting Exam Practice: Variances, Budgets, Cost-Volume-Profit, Pricing Decisions & Performance Measures
- Data Analyst Interview Practice: Take-Home Tasks, SQL-Style Questions, Metric Definitions, Quick A/B Reads & Sanity Checks
- Mechanical Reasoning Test Practice: Levers, Gears, Pulleys, Inclined Planes, Springs, Hydraulics & Belt Drives
- FP&A Analyst Interview Practice: Variance Questions, Driver-Based Forecasts, Budget Bridges, Headcount Costs & Exhibit Cases
- Number Sequence & Logic Test Practice: Differences, Ratios, Interleaved Series, Letter Codes and Grid Puzzles
- Apprenticeship & Trade Entrance Test Math: Mental Arithmetic, Fractions, Percentages, Units, Areas & Volumes and Word Problems
- Marketing Analyst Interview Practice: Funnel Questions, Campaign ROI, Attribution Cases, Test Readouts, Cohorts & Take-Home Exhibits
- Procurement & Buyer Interview Practice: Savings Calculations, Should-Cost, TCO, Quote Comparisons, Price Indexation & Negotiation Cases
Marketing Analytics (41)
- Digital Advertising Math: Search & Social Ads
- Email & Social Media Marketing Metrics
- SEO Analytics & Keyword Research Math
- Customer Analytics: Lifetime Value, Cohorts & Churn
- Creator Economy Math: YouTube, Streaming & Sponsorships
- Media Planning: Reach, Frequency, GRP & CPM
- Marketing Mix Modeling & Attribution in Excel
- Pricing Research: Van Westendorp, Gabor-Granger & Conjoint Basics
- Marketplace Seller Math: Fees, ACoS, TACoS & Profit per Unit
- Affiliate Marketing Math: EPC, Commissions, Conversion & Payouts
- Promotion & Markdown Analytics: Lift, Cannibalisation & Profit
- Loyalty Program Economics: Points, Breakage & Member Value
- Web Analytics Metrics: Sessions, Engagement, Conversions & UTM Data
- B2B Demand Generation Funnel: MQL, SQL, Pipeline & CAC by Channel
- Mobile App Marketing Metrics: ASO, CPI, Retention & ROAS
- Brand Health Tracking: Awareness Funnel, Share of Voice & Brand Lift
- Referral Program Economics: Reward Design, Viral Loops & Referral CAC
- Direct Mail & Catalog Marketing Math: Response Rates, Break-Even & List Testing
- Sponsorship & Event Marketing ROI: Exposure Value, Leads & Pipeline
- Store Traffic & Conversion Analytics: Footfall, Conversion, ATV & Staffing
- Podcast Advertising Math: Downloads, CPM, Promo Codes & ROAS
- Markov Chain Attribution: Channel Paths, Removal Effects & Fair Credit
- Influencer Marketing ROI: Creator Selection, CPM, Promo Codes & Incrementality
- Trade Promotion Analytics for CPG: Baseline, Lift, Trade Spend ROI & Deductions
- Fundraising Analytics: Donor Retention, LTV, Campaign ROI & Upgrades
- Content Marketing ROI: Cost per Article, Organic Traffic Value, Decay & Refresh
- Price Elasticity: Estimating Demand Curves, Log-Log Regression & Optimal Price
- Email Deliverability: Bounce Rates, Complaints, Inbox Placement & List Hygiene
- SMS Marketing Metrics: Opt-ins, Cost per Message, Click Rates & Revenue per Recipient
- Market Sizing & Launch Forecasts: TAM, SAM, SOM, Adoption Curves & Bottom-Up Sales Plans
- Freemium & Free-Trial Economics: Activation, Product-Qualified Leads, Free-to-Paid Conversion & the Cost of Free Users
- PR Measurement: Coverage Tracking, Share of Voice, Message Pull-Through, Reach & Outcome Metrics
- Ratings & Reviews Analytics: Star Distributions, Fair Average Ratings, Confidence-Adjusted Rankings, Review Velocity & Response Rates
- Running a Marketing Agency by the Numbers: Retainer Packages, Hours per Client, Contractor Margins, Client Churn & Account Capacity
- Webinar & Virtual Event Funnels: Registrations, Show-Up Rates, Replays, Engagement and Cost per Lead
- Price-Pack Architecture: Pack-Size Ladders, Price per Unit, Price Thresholds, Pack Changes, Retailer Margins & Portfolio Mix
- Brand Licensing Deals by the Numbers: Royalty Bases, Minimum Guarantees, Advances & Recoupment, Territories and Royalty Audits
- Marketing Budget Planning: Top-Down vs Objective-Based Budgets, CAC Targets, Diminishing Returns, Channel Allocation & Monthly Phasing
- Win-Back & Reactivation Campaigns: Defining Lapsed Customers, Reactivation Rates, Offer Economics, Incrementality & Second-Life Value
- Retail Media & Sponsored Listings: Bids, Cost per Click, ROAS vs Incremental ROAS, Halo Sales, Share of Shelf & Budget Pacing
- Channel Partner Programmes: Partner Tiers, Margins & Rebates, Deal Registration, Marketing Development Funds, Partner Pipeline & Programme ROI
Excel VBA (20)
- VBA Basics
- Ranges & Cells
- Logic & Loops
- Macro Recorder & Cleanup
- Worksheets & Workbooks
- Errors & Debugging
- UserForms
- Automation & Reports
- Arrays & Performance
- Collections & Dictionary
- Text & Strings
- Dates & Times
- Custom Functions (UDF)
- PivotTables with VBA
- Charts with VBA
- Excel Tables (ListObjects)
- Files, Folders & CSV
- External Data with SQL (ADO)
- Web, APIs & JSON
- Class Modules & Structure
HR & People Ops (13)
- Fair Pay Architecture: Job Grading, Range Design, Compa-Ratios & Merit Budgets
- Hiring Pipeline Math: Applicants Needed, Time-to-Fill & Recruiter Capacity
- Leave & Rota Planning: PTO Accruals, Holiday Liability & Shift Coverage
- Learning & Development by the Numbers: Skills Matrices, Certificate Expiry & Training ROI
- Performance Calibration & Bonus Pool Math: Rating Curves, Multipliers & Payouts
- Talent Reviews & Succession Planning: Nine-Box Grids, Bench Strength, Readiness & Flight Risk
- Employee Benefits Budgeting: Plan Options, Enrolment by Tier, Employer Contribution Strategies, Renewals & Cost per Head
- International Assignments by the Numbers: Cost Projections, Allowances, Cost-of-Living Indices, Split Pay & Assignment Budgets
- Employee Engagement Survey Analytics: Response Rates, Favourability, Index Scores, eNPS, Small-Group Suppression & Driver Analysis
- Contingent Workforce Costs: Agency Markups, Contractor Day Rates, Fixed-Fee Statements of Work, Conversion Fees & Total Cost per Hour
- New-Hire Onboarding & Ramp-Up: Time to Productivity, Cost of Vacancy, Ramp Curves, Onboarding Capacity & Early-Leaver Costs
- HR Service Delivery Metrics: HR-to-Employee Ratios, Case Volumes, Resolution Times, Self-Service Rates, HR Cost per Employee & Service Levels
- Flexitime & Time Banks: Daily Balances, Core Hours, Carry-Over Caps, Time Off in Lieu & Annualised Hours Contracts
Personal Tax (7)
- How Income Tax Is Computed: Brackets, Allowances, Credits & Effective Rates
- Reading Your Payslip: Gross-to-Net, Withholding & Year-End Refunds
- Side Income & Self-Employment Tax: Expenses, Home Office, Mileage & Quarterly Payments
- Property, Wealth & Inheritance Taxes: Assessed Values, Mill Rates & Estate Shares
- Build a Personal Tax Return Workbook: From Source Documents to Refund or Balance Due
- Taxing Rental Income: Rent Ledgers, Allowable Expenses, Depreciation, Interest & Loss Carry-Forward
- Profit Tax for a Small Company: From Accounting Profit to Taxable Profit, Add-Backs, Capital Allowances, Loss Carry-Forwards & Instalments
Economics (7)
- International Trade by the Numbers: Comparative Advantage, Terms of Trade, Tariffs & Quotas
- Macroeconomic Models in a Spreadsheet: Multipliers, AD–AS, IS–LM & the Output Gap
- Money, Banks & Central Banks: Deposit Creation, the Quantity Equation & Policy-Rate Rules
- Labour Markets & Inequality: Unemployment, Wage Floors, Lorenz Curves & the Gini Coefficient
- Economic Growth & Development: Growth Accounting, the Solow Model, Convergence & PPP
- Behavioural Economics in a Spreadsheet: Present Bias, Loss Aversion, Prospect Theory & Nudge Experiments
- Economic Impact Assessment: Visitor Spending, Leakage, Multipliers, Jobs per Spend, Additionality & Net Local Impact
E-Commerce & Online Selling (11)
- Dropshipping & Print-on-Demand Margins: Variant Costs, Shipping Zones, Ad Cost per Order, Refunds & Break-Even ROAS
- Shipping & Packaging for Online Shops: Dimensional Weight, Zone Rate Cards, Box Selection, Surcharges & Carrier Mix
- Sourcing Products for Your Brand: Supplier Quotes, MOQ Price Breaks, Samples, Inspection Sampling & Deposit Cash Flow
- Selling Wholesale to Shops: Line Sheets, Wholesale vs Direct Margins, Case Packs, Payment Terms & Retailer Reorders
- Multichannel Selling: Stock Allocation, Channel Fees, Buffer Stock, Oversell Risk & Channel P&L
- Selling Abroad from Your Online Shop: Localised Prices, Currency Fees, Duties at Checkout, International Shipping & Returns
- Selling Digital Products: Templates, E-Books & Presets – Pricing Tiers, Bundles, Licences, Refunds & Store Fees
- Bookkeeping for Online Sellers: Payout Reconciliation, Fees, Refunds, Chargebacks, Reserves & Clearing Accounts
- Reselling Second-Hand Goods: Maximum Buy Price, Fees, Days to Sell, Inventory Ageing, Lot Buying & Profit per Hour
- Planning Sale Events for Online Shops: Discount Depth, Break-Even Uplift, Stock Build-Up, Pull-Forward Effects, Shipping Peaks & Post-Event Review
- Pre-Orders & Made-to-Order Selling: Deposits, Lead-Time Promises, Order Backlogs, Cash Before Cost, Cancellations & Batch Triggers
Supply Chain & Logistics (13)
- Freight Forwarding Quotes: Chargeable Weight, Weight Breaks, W/M for Sea Freight, FCL vs LCL, Surcharges & Quote Margins
- Load Planning: Cartons per Layer, Pallet Height & Weight Limits, Pallets per Truck & Container, Cube Utilisation & Cost per Unit
- Sales & Operations Planning: Demand Plans by Product Family, Capacity Gaps, Inventory Projections, Level vs Chase & the Monthly S&OP Pack
- Spare Parts & Slow Movers: Intermittent Demand, ADI & CV², Croston Forecasts, Service-Level Stock, Criticality and Dead Stock
- Kanban & Pull Systems: Card Counts, Two-Bin Sizing, Supermarket Levels, Replenishment Lead Times & Levelled Schedules
- Route Planning by Hand: Distance Matrices, Nearest-Neighbour Tours, 2-Opt Improvements, Time Windows, Vehicle Capacity & Sweep Routes
- Distribution Network Design: Centre-of-Gravity Locations, Customer Assignment, Transport vs Warehouse Costs, Service Coverage & the Number of Depots
- Periodic Review & Min–Max Inventory Policies: Review Periods, Order-Up-To Levels, Pipeline Stock, a 52-Week Simulation & Joint Replenishment
- Choosing Transport Modes: Road, Rail, Sea, Air & Intermodal – Door-to-Door Cost, Transit Time, Inventory in Transit & CO₂ per Tonne-km
- Returnable Packaging & Pallet Pools: Pool Sizing, Cycle Times, Loss Rates, Deposits, Repair & Cleaning Costs and Cost per Trip vs One-Way Packaging
- Material Handling Equipment Fleet Sizing: Forklift Cycle Times, Moves per Hour, Truck Counts, Battery Shifts & Rent vs Buy
- Parcel Hub & Sortation Capacity: Inbound Waves, Sorter Throughput, Cut-Off Times, Staffing per Shift, Missorts & Cost per Parcel
- Yard & Trailer Management: Trailer Inventory, Dwell Times, Yard Slots, Shunter Moves, Drop-Trailer Pools & Detention-Style Charges
Guides
Excel formulas (45)
- SUMIFS Examples: Sum with Multiple Criteria in Excel
- XLOOKUP vs VLOOKUP: Differences and When to Use Each
- Loan Amortization Schedule in Excel: PMT, IPMT & PPMT
- How to Make a Waterfall Chart in Excel (2 Methods)
- How to Make a Histogram in Excel: Bins, Chart & COUNTIFS
- Excel Dashboard Tutorial: KPI Cards, Charts & a Month Picker
- LINEST in Excel: Multiple Regression with a Worked Example
- Haversine Formula in Excel: Distance from Latitude/Longitude
- Nested IF vs IFS in Excel: Examples and When to Use Each
- NETWORKDAYS and WORKDAY in Excel, with Holidays
- Extract Text Between Two Characters in Excel (MID + FIND)
- INDEX MATCH with Multiple Criteria in Excel (+ XLOOKUP)
- Conditional Formatting Formula Examples in Excel (10 Rules)
- XIRR vs IRR in Excel: Why the Results Differ (Example)
- SUMPRODUCT with Multiple Criteria: AND, OR & Partial Text
- #N/A Error in Excel: Causes and How to Fix It
- Round to Nearest 0.05 in Excel: MROUND, CEILING & FLOOR
- Top 10 List in Excel with LARGE + INDEX MATCH (Ties Fixed)
- YTD Formula in Excel: Year-to-Date with SUMIFS and Dates
- Named Ranges in Excel: How to Create Them and Why They Help
- Habit Tracker in Excel: Streak Formula, COUNTIF & Ticks
- FILTER Function in Excel with Multiple Criteria (AND, OR)
- UNIQUE Function in Excel: Distinct Lists, Counts & Sorting
- LAMBDA Function in Excel: Create Your Own Custom Functions
- Pivot Table with Formulas in Excel: SUMIFS Cross-Tab
- Percent Change Formula in Excel: Increase, Decrease, Errors
- CAGR Formula in Excel: Calculate Compound Annual Growth
- Dynamic Calendar in Excel with SEQUENCE and WEEKDAY
- Amortization Schedule with Extra Payments in Excel
- Weighted Decision Matrix in Excel: Template & Example
- VSTACK in Excel: Combine Multiple Sheets and Tables
- INDEX MATCH vs VLOOKUP: Differences and Which to Use
- COUNTIFS with Multiple Criteria: Excel Examples
- IFERROR in Excel: Examples, IFNA and When to Avoid It
- XMATCH in Excel: Match Modes, Wildcards & XMATCH vs MATCH
- NPV vs XNPV in Excel: Difference and Worked Example
- Compound Interest Formula in Excel: FV with Examples
- Weighted Average in Excel: SUMPRODUCT / SUM Formula
- TEXTJOIN in Excel: Combine Text with a Delimiter
- ROUND vs ROUNDUP vs ROUNDDOWN in Excel (with Negatives)
- RANK and PERCENTILE in Excel: RANK.EQ to PERCENTRANK
- SORT and SORTBY in Excel: Syntax, Multiple Keys, Examples
- LET Function in Excel: Name Values Inside a Formula
- Absolute vs Relative References in Excel ($A$1, A$1, $A1)
- Dependent Drop-Down List in Excel: FILTER and INDIRECT
Accounting & financial statements (17)
- Trial Balance Example: How to Prepare One Step by Step
- How to Calculate VAT from Gross: Reverse VAT Formula
- Cash Conversion Cycle Formula: DSO, DIO & DPO Example
- Current Ratio vs Quick Ratio: Formulas and Example
- DuPont Analysis Example: ROE in 3 and 5 Steps
- Bank Reconciliation Example: Step by Step with Entries
- Payroll Journal Entries: Examples with Debits and Credits
- FIFO vs LIFO vs Weighted Average: Inventory Methods Example
- Chain Ladder Method Explained: IBNR Worked Example in Excel
- IFRS 16 Lease Liability Calculation: Worked Example in Excel
- Black-Scholes Stock Option Expense: Excel Example
- Days Sales Outstanding (DSO) Formula: Simple and Count-Back
- Diluted EPS Calculation Example: Options & Convertibles
- Statement of Cash Flows: Indirect Method Example
- Straight-Line vs Declining Balance Depreciation in Excel
- Inventory Turnover Ratio Formula: Excel Example & Days
- Working Capital Formula: Net vs Operating, Excel Example
Valuation, investing & credit (29)
- How to Calculate WACC in Excel: Formula & Example
- How to Build a DCF Model in Excel: Step-by-Step Example
- How to Calculate IRR in Excel: IRR, XIRR and MIRR
- Simple LBO Model Example: Sources & Uses, MOIC and IRR
- How to Calculate the Sharpe Ratio in Excel (Example)
- Cap Rate Calculation: Formula, NOI and Worked Example
- Debt Service Coverage Ratio (DSCR): Formula & Example
- Three-Statement Model Example: Linked IS, BS and Cash Flow
- Liquidation Preference Example: Participating vs Not
- How to Calculate Pip Value: Formula, Lots and Examples
- RSI Formula in Excel: Wilder's RSI(14) Step by Step
- Graham Number Formula: Calculation, Example and Limits
- Debt-to-Income Ratio Calculation: DTI Formula & Limits
- Impermanent Loss Formula: 2√r ÷ (1 + r) − 1, with Example
- Debt Sculpting in Excel: DSCR-Based Repayment Explained
- How to Calculate FFO and AFFO for a REIT, with Example
- Portfolio at Risk (PAR30) Formula, with an Excel Example
- Trading Expectancy Formula, with an Excel Example
- Credit Card Interest Calculation: Average Daily Balance
- Equity Waterfall with an IRR Hurdle in Excel (Example)
- Tax-Equivalent Yield Formula: Muni vs Taxable Bond Example
- Historical VaR in Excel: PERCENTILE.INC Step by Step
- Refinance Break-Even Calculator: Closing Costs ÷ Savings
- 70% Rule in House Flipping: Formula, Example & Limits
- Risk-Weighted Assets Calculation: RWA Example in Excel
- 13-Week Cash Flow Forecast: Excel Template & Worked Example
- Enterprise Value to Equity Value Bridge: Excel Example
- Gold-to-Silver Ratio: Formula, z-Score and Ratio Switch
- Payback Period in Excel: Simple and Discounted Formula
Business & operations (22)
- Break-Even Analysis in Excel: Formula and Example
- EOQ Formula: Economic Order Quantity Example in Excel
- Earned Value Formulas: CPI, SPI, EAC Worked Example
- LTV:CAC Ratio: How to Calculate It, With Example
- Compa-Ratio: Formula, Excel Example and How to Read It
- RevPAR Calculation: Formula, ADR, Occupancy and Example
- Cost per Mile in Trucking: How to Calculate It (2026)
- ROAS vs ROI: Formulas, Break-even ROAS and Example
- Freelance Hourly Rate Calculator: The Formula in Excel
- Total Compensation Calculator: Compare Job Offers in Excel
- Scope 1, 2 and 3 Emissions Calculation: Excel Example
- Erlang C Formula in Excel: Calculator with Worked Example
- Net Revenue Retention (NRR) Formula with an Excel Example
- Cp and Cpk Formula in Excel: Process Capability Example
- Van Westendorp Price Sensitivity Meter: Excel Example
- ACoS vs TACoS: Formulas, Break-Even ACoS and Excel Example
- Coinsurance Formula: Did ÷ Should × Loss − Deductible
- Markov Chain Attribution: Removal Effect in Excel
- Landed Cost Formula: Per-Unit Calculation with Duty & VAT
- Price Elasticity of Demand from a Log-Log Regression
- Contribution Margin Formula in Excel: Per Unit & Ratio
- EBITDA Margin Formula: Excel Example with Cross-Check
Data, tech, science & health (21)
- How to Calculate NPS in Excel: Formula and Example
- How to Calculate MAPE in Excel (with MAE, Bias and WAPE)
- A/B Test Sample Size Calculator: Formula & Excel Example
- Mann-Whitney U Test in Excel: Step by Step with p-Value
- Chi-Square Test in Excel: Test of Independence Step by Step
- Odds Ratio and Relative Risk in Excel, with 95% CI
- Support, Confidence and Lift Explained with Excel Example
- Churn Hazard Rate and Median Customer Lifetime in Excel
- One-Way ANOVA in Excel: F Test and p-Value Step by Step
- Difference-in-Differences in Excel: 2×2 Table and LINEST
- Margin of Error in Excel: Formula and Poll Calculator
- k-Anonymity Explained with an Example (Excel COUNTIFS)
- Forecast Value Added (FVA): Calculation and Excel Example
- Laspeyres Price Index: Formula and Excel Calculation
- Sample Size for Two Means: Power Analysis in Excel
- Raking Survey Weights in Excel: IPF Step by Step
- Weight of Evidence and Information Value in Excel
- STDEV.S vs STDEV.P in Excel: Which One to Use
- Moving Average in Excel: Simple, Weighted, Exponential
- FORECAST.LINEAR in Excel: Trendline Forecast Example
- Z-Score in Excel: Find Outliers with STANDARDIZE