Excel Expert | Data Cleaning, Dashboards & Reports
Excel Expert | Data Cleaning, Dashboards & Reports
New year, new clarity. 📈
I designed this mobile layout to show how easy it is to keep your business’s key metrics right in your pocket. For any business, starting 2026 with real-time performance data is the difference between guessing and growing.
The goal: Clear, actionable, and mobile-optimized insights from Day 1.
What do you think about this layout for tracking your goals this year? 📱
21
258
Finding Powerful Insights in a Simple Report
You don’t need complex software to see the "hidden" story behind the numbers. Using standard Excel formulas (VLOOKUP, SUMIF, AVG), I turned a messy SKU list into a clear Inventory Report that reveals exactly where money is being lost.
Three key insights from this Inventory Report:
⚠️ The Capital Trap: We have $7.4M tied up in stock, but $4.5M of that is "frozen" in slow-moving items.
🚨 Revenue at Risk: We’re risking $350K in monthly sales because we're stocking the wrong items.
📊 The Efficiency Gap: Only 27% of our inventory is "Healthy." The rest is either dangerously low or excessively high.
This report is about moving from "guessing" to "knowing." By cleaning the data and adding simple Slicers, we created a tool that protects revenue and optimizes Cash Flow.
12
247
From Chaos to Clarity: MARKETING BUDGET ROI DASHBOARD📊
The Challenge: Manual budget tracking resulted in zero visibility. Budget was overspent by $1,875 (3.91%)🚩; the client lacked actionable insight on spending.
The Solution: Implemented a dynamic Excel dashboard for real-time oversight and Data Visualization. Key insights:
🛑Critical Overspend: Flagged Digital Content (23.5% over) and Incentives (11.9% over).
Reallocation: Identified Brand Activations (4.8% under), allowing $867 reallocation.💰
Cash Flow: 📉 Highlighted chaotic spikes in Jan (+29.9%) and Apr (+26.8%).
The Outcome & Next Step: Client has a one-click system for strategic decisions.🚀 Next step: Merge expense data with sales to calculate Net ROI and drive profitability.
5
22
355
Desarrollador Web Full-Stack | Landing Pages & E-Commerce
New to Contra
Desarrollador Web Full-Stack | Landing Pages & E-Commerce
Hitchhiker Orbital — Interactive 3D CAD Aerospace & Exploded Iso-Grid Viewer (60FPS WebGL / Three.js + Native Framer .TSX Code Component). Built from authentic SolidWorks CAD specifications featuring 6 modular payload bays, Xenon Hall-effect thrusters, 6-DOF Canadarm2 robotic capture, and zero Z-fighting geometry. Live 3D Demo: https://shokun123.github.io/web-demos/hitchhiker-orbital/
0
21
Medical Clinic & Healthcare SaaS Platform — Interactive Online Appointment Booking System with Real-Time Doctor Availability Calendar, Specialty Filtering, Patient Intake Form, and Instant Confirmation.
Live Interactive Healthcare Demo:
https://shokun123.github.io/web-demos/clinica-nova/
2
0
86
High-Converting E-Commerce & Interactive 2-Plan Ordering Platform — Built-in Stripe Card Checkout, Instant QR Payment Flow, Dynamic Cart Drawer, and Real-Time Product Filtering at 99/100 Lighthouse Speed.
Live Interactive E-Commerce Demo:
https://shokun123.github.io/web-demos/ecommerce-pro/
0
43
Longevity & Regenerative Medicine — Scroll-Controlled 3D Website Hero Animation (60fps WebGL / Three.js). As visitors scroll down or backward, 5,400 bioluminescent particles reversibly transform from a human anatomical portrait bust (0.0s) into a genomic DNA telomere helix (3.5s), stem-cell membrane (7.0s), and vascular equilibrium (10.0s).
Live Scroll-to-Reveal 3D Demo:
https://shokun123.github.io/web-demos/biotech-3d/
0
49
💼 Virtual Assistant
Brand Strategist and Creative Director making brands matter.
Brand Strategist and Creative Director making brands matter.
Junior Developer with Strong Foundations in C++ and Web Dev
Junior Developer with Strong Foundations in C++ and Web Dev
Creative Director / Producer
Creative Director / Producer
Songwriter & session player for your next big track
Songwriter & session player for your next big track
Versatile Illustrations with Detail & Precision
Versatile Illustrations with Detail & Precision
