Dimple Panjwani
EXCEL AND DATA ENTRY
Excel PivotTable — Sales Summary
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
...
Quick one from a sales tracker I cleaned up recently — client had 8 months of product sales sitting in a spreadsheet with no totals and no way to quickly look up numbers for specific products.
I added the Total Sales column using SUM, then set up VLOOKUP so anyone on the team...
Excel Formulas & Assignment Help — Fast, Accurate, Ready to Use
Need help with Excel formulas, data tables, or MS Office assignments? I solve them quickly and accurately using proper formula logic — no shortcuts, no guesswork.
This sample shows a formula-based assignment solved...
Practicing my Excel formulas today — this one covers IF, COUNTA, COUNTIFS and PRODUCT logic on a simple inventory sheet (qty × rate = amount, then flagging items as Expensive/Cheap based on amount).
Nothing fancy, just clean formula work:
=Qty*Rate for amount
...
Excel Practice: INDEX + MATCH Lookup
Quick one from my formula practice sheet. Had two tables — one with full employee data (name, salary, department, ID) and a second smaller table with just Emp IDs where the salaries were missing. Instead of using VLOOKUP, I went with INDEX +...
