Useful excel formulas & use cases

• Create texts depending on the values with the IF function
• Search function
• How to move single Excel sheets into another document

view all

Attributes

• Change the attribute set of a product
• Creating new attribute options
• Determine double values in a column

view all

Categories

• Add categories depending on attributes
• Category match

view all

Images

• Configuring cobby to prevent image duplicates
• Image description
• Image formulas: Usage examples
• How to store Magento product images in Excel

view all

Import

• Import data
• Import mode

view all

Macros and cobby

• When do macros make sense?
• Advantages and disadvantages of formulas and macros

view all

Prices

• Automatic price calculation
• Determine net price based on gross price in Excel
• Price update

view all