How to use VLOOKUP in Excel
Find a key in the first column of a table and return a value from the same row.
Read guide →SheetCommand · Guides
Excel, e-commerce, and data analysis guides
Learn Excel formulas, e-commerce calculations, and marketing reporting with concrete examples. Each guide separates supported SheetCommand actions from steps you perform in Excel.
Excel formulas
How to use XLOOKUP in Excel
Return a matching value from either side of a lookup column with a modern formula.
Read guide →How to use the IF function in Excel
Test a condition and return one result when it is true and another when it is false.
Read guide →COUNTIF and COUNTIFS in Excel: worked examples
Compare one- and multi-condition counts on the same example.
Read guide →SUMIF and SUMIFS in Excel: worked examples
Compare one- and multi-condition totals on the same data.
Read guide →How to use the SUM function in Excel
Add numbers in a range with a reliable SUM formula.
Read guide →How to use IFERROR in Excel
Show a readable result when a formula fails without losing sight of the cause.
Read guide →20 essential Excel formulas for beginners
Twenty beginner formula topics with usable examples, expected behavior, and practical checks.
Read guide →Data editing
How to remove duplicate rows from an Excel file
Clear identical records while understanding exactly which rows remain.
Read guide →How to remove blank rows from an Excel file
Remove rows with no data without discarding partially filled records.
Read guide →How to sort an Excel file by a column
Sort by price, stock, or another column without separating values from their rows.
Read guide →Increase or decrease an Excel column by a percentage
Update a numeric column by a chosen percentage and verify the new values.
Read guide →How to calculate the average of an Excel column
Find the arithmetic mean of a numeric column without editing the file.
Read guide →Spreadsheet automation and analysis
How to create a PivotTable in Excel: a practical example
Build a PivotTable that totals sales by product category.
Read guide →Google Sheets Apps Script: a beginner automation example
Use an onEdit trigger in Google Sheets and understand its limits.
Read guide →Digital marketing data
What are UTM parameters? Track campaign links in Excel
Tag campaign links consistently and keep a clear spreadsheet inventory.
Read guide →Calculate CTR, CPC, CPA, conversion rate, and ROAS in Excel
Calculate five advertising metrics from one consistent example table.
Read guide →How to export a GA4 report to CSV and analyze it in Excel
Export a GA4 report and keep its scope intact when reviewing it in Excel.
Read guide →E-commerce calculations and CSV
How to edit Shopify product and inventory CSV files in Excel
Keep product and inventory exports distinct while preserving variant and location rows.
Read guide →Calculate Trendyol seller commission in Excel
Estimate seller commission without assuming one universal rate.
Read guide →How to calculate a discount and campaign contribution in Excel
Find the sale price first, then assess the effect of campaign costs.
Read guide →Calculate parcel volumetric weight in Excel for Turkish shipping
Estimate volumetric weight from dimensions without mistaking it for a carrier quote.
Read guide →Calculate e-commerce contribution margin in Excel
Assess a product's price without confusing margin with markup.
Read guide →SheetCommand
Try it on your file
Try the supported cleanup, sorting, and summary commands on your file. Use formula and script examples in their respective applications.