Excel for Marketing & E-Commerce 5

What's inside

Excel for Marketing & E-Commerce 5: 13 courses, 260 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 13 complete courses, 260 lessons, 257 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Channel Partner Programmes: Partner Tiers, Margins & Rebates, Deal Registration, Marketing Development Funds, Partner Pipeline & Programme ROI
• Excel for Online Sellers: Profit per Order, Fees, Ads & Stock
• 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

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	675
Series	The Tabellab Workbook, volume 5
Author	Babala Özdemir
Delivery	Instant download after payment