We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

Inventory Analytics with Excel

Create an inventory system

Anna Dunn
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...
Read more
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.
Enroll now

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Provides hands-on experience in creating inventory management table
Suitable for intermediate analysts
Taught by Anna Dunn who has not been recognized as an expert in managing inventory

Save this course

Save Inventory Analytics with Excel: Create an inventory system to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Inventory Analytics with Excel: Create an inventory system. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Inventory Analytics with Excel: Create an inventory system will develop knowledge and skills that may be useful to these careers:
Inventory Control Specialist
Inventory Control Specialists are responsible for managing the day-to-day operations of an organization's inventory. They track inventory levels, process orders, and ensure that inventory is properly stored and accounted for. This course provides a comprehensive overview of inventory management principles and practices, which can greatly benefit Inventory Control Specialists in their daily tasks.
Inventory Analyst
An Inventory Analyst is responsible for managing and optimizing the inventory of an organization. This role involves tasks such as forecasting demand, managing stock levels, and ensuring that the right products are available at the right time and place. This course provides a foundation in inventory management principles and techniques, which can be highly valuable for individuals seeking to become Inventory Analysts.
Demand Planner
Demand Planners are responsible for forecasting demand for products and services. They use a variety of data and analytical techniques to develop demand forecasts, which are critical for making decisions about production, inventory levels, and marketing strategies. This course provides a solid foundation in inventory management and forecasting techniques, which can greatly enhance the skills of Demand Planners.
Warehouse Manager
Warehouse Managers are responsible for overseeing the operations of a warehouse. They ensure that inventory is received, stored, and shipped efficiently and accurately. This course provides insights into inventory management and optimization techniques, which can be valuable for Warehouse Managers as they make decisions about warehouse layout, inventory storage, and inventory control.
Supply Chain Manager
Supply Chain Managers oversee the flow of goods and services from suppliers to customers. They are responsible for planning, coordinating, and executing supply chain activities to ensure that products are delivered to customers efficiently and cost-effectively. This course provides knowledge in inventory management and optimization, which is essential for Supply Chain Managers to make informed decisions and optimize supply chain performance.
Procurement Manager
Procurement Managers are responsible for acquiring goods and services for an organization. They work with suppliers to negotiate contracts, manage vendor relationships, and ensure that the organization gets the best possible value for its money. This course provides insights into inventory management and forecasting, which can be highly beneficial for Procurement Managers as they make decisions about purchasing and inventory levels.
Logistician
Logisticians are responsible for planning, coordinating, and executing the movement of goods and services. They work to ensure that products are delivered to customers efficiently and cost-effectively. This course provides knowledge in inventory management and optimization, which can be highly beneficial for Logisticians as they make decisions about transportation, warehousing, and inventory management.
Operations Manager
Operations Managers are responsible for overseeing the day-to-day operations of an organization. They work to improve efficiency, reduce costs, and ensure that the organization meets its goals. This course can be beneficial for Operations Managers as it provides knowledge in inventory management and optimization, which can help them make better decisions about resource allocation and inventory management.
Purchasing Manager
Purchasing Managers are responsible for acquiring goods and services for an organization. They work with suppliers to negotiate contracts, manage vendor relationships, and ensure that the organization gets the best possible value for its money. This course may be beneficial for Purchasing Managers as it provides insights into inventory management, which can help them make better decisions about purchasing and inventory levels.
Transportation Manager
Transportation Managers are responsible for planning, coordinating, and executing the transportation of goods and services. They work to ensure that products are delivered to customers efficiently and cost-effectively. This course may be helpful for Transportation Managers as it provides knowledge in inventory management and optimization, which can assist them in making better decisions about inventory levels and transportation strategies.
Data Analyst
Data Analysts collect, analyze, and interpret data to help organizations make informed decisions. They use a variety of tools and techniques to extract insights from data, which can be valuable for inventory management. This course may be helpful for Data Analysts as it provides a foundation in inventory management principles and techniques, which can enhance their ability to analyze and interpret data related to inventory.
Business Analyst
Business Analysts identify and analyze business needs and recommend solutions to improve business processes. They work with stakeholders to gather requirements, analyze data, and develop solutions that meet business objectives. This course may be beneficial for Business Analysts as it provides knowledge in inventory management, which can help them understand and analyze inventory-related business processes and make recommendations for improvement.
Operations Research Analyst
Operations Research Analysts use mathematical and analytical techniques to solve complex business problems. They work with organizations to improve efficiency, reduce costs, and make better decisions. This course may be beneficial for Operations Research Analysts as it provides a foundation in inventory management, which can enhance their ability to analyze and solve inventory-related problems.
Management Consultant
Management Consultants help organizations improve their performance. They work with clients to identify problems, develop solutions, and implement changes. This course may be helpful for Management Consultants as it provides knowledge in inventory management, which can assist them in understanding and analyzing inventory-related issues and developing effective solutions for clients.
Financial Analyst
Financial Analysts analyze financial data to help organizations make informed decisions. They use a variety of tools and techniques to assess financial performance, identify trends, and make recommendations. This course may be helpful for Financial Analysts as it provides knowledge in inventory management, which can assist them in understanding and analyzing inventory-related financial data.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Inventory Analytics with Excel: Create an inventory system.
Provides a practical approach to inventory management, with a focus on real-world scenarios and industry best practices.
This textbook provides a comprehensive overview of operations management, including supply chain management and inventory management concepts.
Provides a concise overview of key inventory management concepts and their application in practice.
This advanced textbook covers complex inventory management topics, such as forecasting, optimization, and risk management.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser