Inventory Analytics with Excel: Create an inventory system

This guided project, Inventory Analytics with Excel: Create an inventory system, will help an intermediate analyst who is looking to create an inventory management table for a business. In this 1.5-hour long project-based course, you will learn how to create an inventory management table in Excel, add colors to the table, create inventory transactions, and add formulas to the table.

To achieve this, you will be taking on the role of a supply analyst. You will create an inventory system to keep track of a set of supplies for an office supply company.

In order to be successful in this project, some experience with Excel is recommended.

• Project Overview
• In this guided project, you will learn how to create an inventory management table in Excel, add colors to the table, create inventory transactions, and add formulas to the table.