We may earn an affiliate commission when you visit our partners.
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 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...
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...
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/qq73y2/inventory
Good to know
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
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Inventory Analytics with Excel: Create an inventory system with these
activities:
Organize course notes and materials
Show steps
Improve your retention by organizing and reviewing your course materials regularly.
Show steps
-
Create a dedicated space for course notes and materials
-
Use a note-taking system that works for you
-
Review your notes and materials on a regular basis
Join a study group to discuss inventory management concepts
Show steps
Enhance your learning by engaging in discussions and sharing insights with peers.
Show steps
-
Find a study group or create one with fellow students
-
Meet regularly to discuss course topics
-
Share notes, ask questions, and provide support
Review basic concepts in operations management
Show steps
Ensure a solid foundation by reviewing key concepts in operations management before starting the course.
Browse courses on
Operations Management
Show steps
-
Go over your previous notes or textbooks
-
Identify areas where you need additional review
-
Find resources to fill any knowledge gaps
Three other activities
Expand to see all activities and additional details
Show all six activities
Review Operations Management by R. Dan Reid and Nada R. Sanders
Show steps
Reinforce and enrich your course understanding by reviewing a foundational text on Operations Management.
View
Operations Management
on Amazon
Show steps
-
Read chapters 1-3
-
Review key concepts including productivity, quality, and forecasting
-
Summarize the main ideas in your own words
Solve inventory management problems
Show steps
Practice applying inventory management concepts through problem-solving exercises.
Browse courses on
Inventory Management
Show steps
-
Identify the relevant inventory management concepts
-
Develop a step-by-step plan to solve the problem
-
Check your answer against the provided solution
Follow tutorials on inventory optimization techniques
Show steps
Expand your knowledge and skills by following tutorials on advanced inventory management techniques.
Browse courses on
Inventory Optimization
Show steps
-
Find tutorials that cover specific optimization techniques
-
Follow the instructions and implement the techniques
-
Evaluate the effectiveness of the techniques
Organize course notes and materials
Show steps
Improve your retention by organizing and reviewing your course materials regularly.
Show steps
Show steps
Show steps
- Create a dedicated space for course notes and materials
- Use a note-taking system that works for you
- Review your notes and materials on a regular basis
Join a study group to discuss inventory management concepts
Show steps
Enhance your learning by engaging in discussions and sharing insights with peers.
Show steps
Show steps
Show steps
- Find a study group or create one with fellow students
- Meet regularly to discuss course topics
- Share notes, ask questions, and provide support
Review basic concepts in operations management
Show steps
Ensure a solid foundation by reviewing key concepts in operations management before starting the course.
Browse courses on
Operations Management
Show steps
Show steps
Show steps
- Go over your previous notes or textbooks
- Identify areas where you need additional review
- Find resources to fill any knowledge gaps
Three other activities
Expand to see all activities and additional details
Show all six activities
Review Operations Management by R. Dan Reid and Nada R. Sanders
Show steps
Reinforce and enrich your course understanding by reviewing a foundational text on Operations Management.
View
Operations Management
on Amazon
Show steps
Show steps
Show steps
- Read chapters 1-3
- Review key concepts including productivity, quality, and forecasting
- Summarize the main ideas in your own words
Solve inventory management problems
Show steps
Practice applying inventory management concepts through problem-solving exercises.
Browse courses on
Inventory Management
Show steps
Show steps
Show steps
- Identify the relevant inventory management concepts
- Develop a step-by-step plan to solve the problem
- Check your answer against the provided solution
Follow tutorials on inventory optimization techniques
Show steps
Expand your knowledge and skills by following tutorials on advanced inventory management techniques.
Browse courses on
Inventory Optimization
Show steps
Show steps
Show steps
- Find tutorials that cover specific optimization techniques
- Follow the instructions and implement the techniques
- Evaluate the effectiveness of the techniques
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 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
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 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 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 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 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
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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/qq73y2/inventory
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.
Provides a comprehensive overview of inventory management concepts and practices, making it a valuable resource for anyone new to the field.
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.
Offers advanced coverage of inventory control management techniques, with a focus on mathematical models and optimization algorithms.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/qq73y2/inventory
Share
Similar courses
Here are nine courses similar to
Inventory Analytics with Excel: Create an inventory system.
Inventory Analytics
OpenCourser.com/course/1wy5qt/inventory
Inventory Analytics
Most relevant
Effective Inventory Management and Optimization
OpenCourser.com/course/e807v1/effective
Effective Inventory Management and Optimization
Most relevant
Procurement and Logistics Management
OpenCourser.com/course/fwqij3/procurement
Procurement and Logistics Management
Most relevant
Multi-Echelon Inventory Simulation Using R Simmer
OpenCourser.com/course/halu75/multi
Multi-Echelon Inventory Simulation Using R Simmer
Supply Chain Optimization
OpenCourser.com/course/ozta9r/supply
Supply Chain Optimization
Inventory and Portfolio Management
OpenCourser.com/course/akw5ui/inventory
Inventory and Portfolio Management
Inventory Management
OpenCourser.com/course/dt9jtx/inventory
Inventory Management
Simulation of Inventory Replenishment Using R Simmer
OpenCourser.com/course/udj0za/simulation
Simulation of Inventory Replenishment Using R Simmer
Effectively Optimizing Inventory with SAP
OpenCourser.com/course/asgxyy/effectively
Effectively Optimizing Inventory with SAP
Time
2 hours
Via
Coursera
Institution
Coursera Project Network
Instructor
Anna Dunn
Good to know
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
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