Practical guides

Work through a real Excel task.

Step-by-step examples for the product codes, photo catalogs and business records you already work with.

SkuGallery

How to show product photos by SKU in Excel

Use SkuGallery to match an Excel product code to photos in a local or network folder, browse the results and insert a photo into your worksheet.

Read the guide ↗02

SkuGallery

How to find products without photos in an Excel SKU list

Check a list of SKUs against your photo catalog with SkuGallery. Filter missing photos and lookup errors before preparing an offer or product catalog.

Read the guide ↗03

CellLens

How to look up SQL Server stock from an Excel cell

Configure a CellLens lookup to read SQL Server inventory records for the SKU selected in Excel, including multiple stock rows for one product.

Read the guide ↗