Freelancers using Microsoft Excel in KarachiFreelancers using Microsoft Excel in Karachi
I fix warehouse chaos SOPs, SAP & Excel system for ops team
5.0
Rating
9
Followers
I fix warehouse chaos SOPs, SAP & Excel system for ops team
Cover image for 5 Excel formulas every inventory
5 Excel formulas every inventory planner must know You don't need a fancy WMS to manage inventory well. You need Excel and the right formulas. After years of managing inventory in FMCG operations, these are the 5 formulas I use constantly — and the ones I build into every custom Excel system I deliver for clients. 1. SUMIFS — your most powerful counting tool Instead of filtering manually, SUMIFS lets you sum quantities based on multiple conditions at once. =SUMIFS(quantity_column, SKU_column, "SKU001", warehouse_column, "WH-A") Use it for: total stock by SKU and location, total dispatched by date range, production output by shift. 2. IFERROR — stop broken formulas from crashing your sheet When a formula can't find a value it returns an error. IFERROR catches it and shows something cleaner. =IFERROR(VLOOKUP(A2,data_range,2,0),"Not found") Use it for: wrapping any VLOOKUP or INDEX/MATCH so your sheet doesn't fill with #N/A errors. 3. INDEX/MATCH — better than VLOOKUP VLOOKUP breaks when you add columns. INDEX/MATCH never does. =INDEX(return_column,MATCH(lookup_value,lookup_column,0)) Use it for: pulling SAP data into your planning sheet, matching SKU codes to descriptions, linking sheets without breaking. 4. COUNTIFS — find gaps instantly COUNTIFS counts rows that meet multiple conditions. Use it to spot where data is missing or incomplete. =COUNTIFS(status_column,"Pending",date_column,"<"&TODAY()) Use it for: overdue orders, pending GRs, items with zero stock, SKUs not yet received. 5. TODAY() and date logic — automate your daily planning Stop manually updating dates. TODAY() always returns the current date — build your planning triggers around it. =IF(reorder_date<=TODAY(),"Order Now","OK") Use it for: reorder alerts, overdue shipment flags, days-since-last-receipt calculations. These 5 formulas are the foundation of every inventory Excel system I build. Master them and you can automate 80% of your daily planning without spending a rupee on software. Need a custom Excel system built around your operation? Check out my services below.
0
65
Expert Accountant & Bookkeeper | ACCA Certified
Expert Accountant & Bookkeeper | ACCA Certified
Dashboard & Data Analytics Expert
New to Contra
Dashboard & Data Analytics Expert
Proposal development and C-Level Presentation Consultant
New to Contra
Proposal development and C-Level Presentation Consultant
Cover image for I help organizations win strategic
I help organizations win strategic contracts, secure funding, and communicate their capabilities through high-impact proposals, executive presentations, and consulting-grade documentation. With 20 years of experience in management consulting and business development, I support organizations in preparing compliant, persuasive, and decision-ready submissions for solicitations, government tenders, donor-funded programs, consulting engagements, and corporate opportunities. I have supported organizations preparing submissions and corporate materials for institutions such as USAID, World Bank, Asian Development Bank (ADB), UN agencies, DFID, and JICA, as well as clients across the public, financial, and corporate sectors. Core Consulting Services (A) Proposal Development & Bid Strategy ➙ Solicitation, IFB, RFP, RFQ, and tender proposal development ➙ Technical and financial proposal preparation ➙ Expression of Interest (EOI) and pre-qualification submissions ➙ Technical methodologies and project approaches ➙ Compliance matrices aligned with donor and procurement standards ➙ Bid structuring and evaluator-focused proposal strategy (B) Executive Presentations & Pitch Decks ➙ Board, C-level and Customer facing presentations ➙ Consulting and advisory presentations ➙ Client pitch decks and bid presentations ➙ Investor and stakeholder briefings ➙ Technical solution and methodology presentations ➙ Corporate capability presentations (C) Corporate Documentation & Capability Materials ➙ Capability statements and corporate profiles ➙ Organizational credentials and project references/Quals ➙ Proposal, EOI, and presentation templates ➙ Corporate reporting and deliverable templates ➙ Subcontractor and partnership documentation including NDA, MSA, and Teaming Agreements Results Delivered My work has helped organizations: ➙ Win multimillion-dollar government and donor contracts ➙ Secure funding from international development agencies ➙ Strengthen proposal compliance and evaluation scores ➙ Present complex technical solutions clearly to executive decision-makers
1
34
Bookkeeping and Accounting expert with QBO and Excel.
New to Contra
Bookkeeping and Accounting expert with QBO and Excel.
Cover image for Are your books behind? Statements
Are your books behind? Statements missing? Let's fix that. I'm Abdullah Umer — a bookkeeper & accounting specialist helping freelancers, e-commerce sellers, startups, and small businesses get their finances in order. Here's what I deliver: ✅ Monthly Bookkeeping (Excel & QuickBooks Online) ✅ Catch-Up & Backlog Bookkeeping ✅ Balance Sheet, Income Statement & P&L ✅ Cash Flow Statement ✅ Financial Dashboards in Excel ✅ QuickBooks Online Setup Whether you're starting fresh or 6 months behind — I'll get your books clean, accurate, and ready for tax season or investor review. 💬 DM me if you have a custom need — I'll build a package just for you. #Bookkeeping (https://www.linkedin.com/search/results/all/?keywords=%23bookkeeping&origin=HASH_TAG_FROM_FEED) #QuickBooks (https://www.linkedin.com/search/results/all/?keywords=%23quickbooks&origin=HASH_TAG_FROM_FEED) #Accounting (https://www.linkedin.com/search/results/all/?keywords=%23accounting&origin=HASH_TAG_FROM_FEED) #SmallBusiness (https://www.linkedin.com/search/results/all/?keywords=%23smallbusiness&origin=HASH_TAG_FROM_FEED) #Freelancer (https://www.linkedin.com/search/results/all/?keywords=%23freelancer&origin=HASH_TAG_FROM_FEED) #Ecommerce (https://www.linkedin.com/search/results/all/?keywords=%23ecommerce&origin=HASH_TAG_FROM_FEED) #FinancialStatements (https://www.linkedin.com/search/results/all/?keywords=%23financialstatements&origin=HASH_TAG_FROM_FEED) #BookkeepingServices (https://www.linkedin.com/search/results/all/?keywords=%23bookkeepingservices&origin=HASH_TAG_FROM_FEED) #QuickBooksOnline (https://www.linkedin.com/search/results/all/?keywords=%23quickbooksonline&origin=HASH_TAG_FROM_FEED) #RemoteWork (https://www.linkedin.com/search/results/all/?keywords=%23remotework&origin=HASH_TAG_FROM_FEED) #VirtualBookkeeper (https://www.linkedin.com/search/results/all/?keywords=%23virtualbookkeeper&origin=HASH_TAG_FROM_FEED) #ExcelDashboard (https://www.linkedin.com/search/results/all/?keywords=%23exceldashboard&origin=HASH_TAG_FROM_FEED) #Finance (https://www.linkedin.com/search/results/all/?keywords=%23finance&origin=HASH_TAG_FROM_FEED)
0
18