Excel Expert for Marketing Analytics Assignments

TWO EXCEL DATA ANALYTICS ASSIGNMENTS - DIGITAL MARKETING & CLTV ANALYSIS

I need an Excel expert to complete 2 academic analytics assignments with strict quality requirements.

ASSIGNMENT 1: Digital Marketing & MIS Analysis

Fill yellow-highlighted cells in Excel using formulas only (no manual values)

Analyze order-to-revenue conversion from MIS data

Quarter-on-quarter digital marketing channel efficiency analysis

Quarter-on-quarter order value movement tracking

Create charts in Excel (not inserted images)

Prepare Word doc with insights and conclusions

ASSIGNMENT 2: Customer Lifetime Value (CLTV) Calculation

Build CLTV model using retail transaction dataset

Create cohort analysis with pivot tables

Calculate retention rates, frequency, customer lifespan

Generate professional charts showing trends

STRICT REQUIREMENTS:

ALL calculations must use Excel formulas (no typed numbers)

Unique structure and formatting (checked for copying)

Charts created in Excel, not inserted as images

No external links in Excel files

No AI tools usage (detectable)

Professional, well-organized work

DELIVERABLES:

2 completed Excel files with formula-driven analysis

1 Word document with observations for Assignment 1

Proper file naming with roll number

SKILLS NEEDED:

Advanced Excel (pivot tables, VLOOKUP, formulas)

Marketing analytics experience

CLTV calculation knowledge

Data visualization expertise

Timeline - 1 Day