Excel for Business & Operations 6

What's inside

Excel for Business & Operations 6: 14 courses, 280 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.

• 14 complete courses, 280 lessons, 280 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

• 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

Details

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