Spreadsheets

180 commands · 3 subcategories

Subcategories

Turn into a single dynamic array formula a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.

Spreadsheetsadvanced#lookup#vlookup

Stress-test the assumptions in a departmental budget model — e.g. a marketing budget split across five campaigns.

Spreadsheetsadvanced#budget#finance

Add protection and access rules to a contact list — e.g. 3,000 leads exported from three different tools.

Spreadsheetsadvanced#contacts#crm

Convert between spreadsheet dialects for a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.

Spreadsheetsmedium#cross-sheet#reference

Reconcile discrepancies between a sales commission calculator — e.g. tiered commission rates based on quota attainment.

Spreadsheetsmedium#commission#sales

Merge and reconcile columns from data merged from multiple source sheets — e.g. customer lists exported from two CRMs after a merger.

Spreadsheetsmedium#merge#multi-source