Ecommerce Inventory Tracker - Course Outline
If the modules are not clickable, please login by navigating to top menu Login.
If you are logged in, but still do not have clickable links,
try Refresh button on your browser to get the most current published content.
To purchase access to the course, choose the BUY NOW button at the bottom of this page.
| Module 1 | GENERAL INFORMATION ON INPUT REQUIREMENTS |
|---|---|
| Unit 1 | Read First |
| Unit 2 | Download This |
| Module 2 | OVERVIEW OF SHEETS |
| Unit 1 | Sheets Snapshot |
| Unit 2 | Overview of All Items Sheet |
| Module 3 | USING THE SHEETS |
| Unit 1 | Excel Table Settings |
| Unit 2 | How to Input Items - All Items List |
| Unit 3 | How to Delete Columns and Add Dynamic Columns |
| Unit 4 | How to Input New Inventory Purchases |
| Unit 5 | How to Input Sold Inventory |
| Unit 6 | How to Add Bundles and Multipacks |
| Unit 7 | How to Use and Read Inventory On-Hand |
| Unit 8 | How to Speed Up Input with Fill Series and Copy Cells Down |
| Module 4 | CUSTOMIZING THE SHEETS |
| Unit 1 | Excel Basics In a Nutshell |
| Module 5 | APPLICATIONS DEMONSTRATED |
| Unit 1 | How to Create Custom Seller SKU |
| Unit 2 | How the Amazon Lookup Works |
| Unit 3 | How to Use Barcode Scanner to Speed Up Input |
| Unit 4 | How to Import Beginning Inventory - Amazon Demonstration |
| Unit 5 | How to Copy and Paste All Items from CSV - Amazon Demonstration |
| Unit 6 | How to Import Sales, Copy & Paste, Find Monthly Sales and COGS |
| Unit 7 | How to Record Amazon Returns and Re-List on Another Platform |
| Unit 8 | How to Figure Beginning Inventory, Purchases, and Ending Inventory |