CRM & Lead Management System by Kenan Cengiz GülerCRM & Lead Management System by Kenan Cengiz Güler

CRM & Lead Management System

Portfolio project
Kenan Cengiz Güler

Overview

An independent sample of a lead-tracking spreadsheet for a small team. The 80 organizations are synthetic; no real names, emails or contact details appear.

Objective

Keep lead records consistent and make overdue follow-ups visible.

My role

I defined the fields, validation rules and pipeline logic, built the workbook with AI-assisted tooling, and reviewed and tested it.

Approach

Owner, source, stage and opportunity value are validated on entry. Editable stage probabilities drive a weighted pipeline value. Follow-up date logic flags overdue, unscheduled and incomplete records.

Tools

Microsoft Excel; AI-assisted build and checks.

Deliverables

One workbook with a lead register and a pipeline dashboard showing open opportunities, won value and closed-deal win rate.

Results

Stage counts, pipeline arithmetic, required fields and zero-value handling were tested. No client work or sales results are represented.

0 likes · 0 views · Oct 11, 2026

Independent sample: Excel lead tracker with validated inputs, weighted pipeline and follow-up flags. Synthetic data.

Tags