UDEMY
UDEMY Logo

Complete Inventory Management in Microsoft Excel &TALLY ERP9 

  • Offered byUDEMY

Complete Inventory Management in Microsoft Excel &TALLY ERP9
 at 
UDEMY 
Overview

Gain a comprehensive understanding with TALLY ERP 9 for effective inventory tracking and management

Duration

4 hours

Total fee

549

Mode of learning

Online

Official Website

Go to Website External Link Icon

Credential

Certificate

Complete Inventory Management in Microsoft Excel &TALLY ERP9
 at 
UDEMY 
Highlights

  • Earn a certificate after completion of course from UDEMY
  • 30-Day Money-Back Guarantee
  • Full lifetime access
Details Icon

Complete Inventory Management in Microsoft Excel &TALLY ERP9
 at 
UDEMY 
Course details

Who should do this course?

Business Owners and Entrepreneurs

Inventory Managers

Finance and Accounting Professionals

Supply Chain and Logistics Personnel

Retail Managers

Students and Recent Graduates

 

What are the course deliverables?
What Is Inventory
What Are The Types Of Inventory
What Is Inventory Management
What Are The Objectives For Inventory Management
What Is The Inventory Valuation
What Are The Types Of Inventory Valuation
What Is The First In First Out (FIFO) Inventory Valuation Method
What Is The Last In First Out (LIFO) Inventory Valuation Method
What Is The Weighted Average Cost/Price Inventory Valuation Method
How To Create The Item List Table For Inventory Management In Microsoft Excel
How To Create The Inventory In , Out , Status Table In Microsoft Excel
How To Apply The Formulas For The Inventory In , Out , Status Table In Microsoft Excel
How To Enter The Inventory Transactions & Analysis The Report In Microsoft Excel
How To Install Tally ERP9 
Read more
More about this course

This comprehensive course is designed for individuals seeking to master inventory management using two powerful tools: Microsoft Excel and TALLY ERP 9

Participants will learn essential inventory management concepts, techniques, and practical applications, enabling them to efficiently manage stock, track inventory levels, and streamline reporting processes

The Course is part of the Operational Management Training Program and Every companies need to Manage inventory to produce their goods or services and make sure to supply the goods or services continuously to their market segment

Complete Inventory Management in Microsoft Excel &TALLY ERP9
 at 
UDEMY 
Curriculum

CHAPTER 1 INTRODUCTION TO INVENTORY

 

CHAPTER 2 METHODS OF INVENTORY VALUATIONS

INVENTORY VALUATIONS-INTRODUCTION

INVENTORY VALUATION - FIFO METHOD

INVENTORY VALUATION - LIFO METHOD

INVENTORY VALUATION - WACC METHOD

 

CHAPTER 3  INVENTORY MANAGEMENT PROCESS IN MICROSOFT EXCEL WITH EXAMPLE-01

INVENTORY MANAGEMENT IN MS EXCELINTRODUCTION

INVENTORY MANAGEMENT IN MS EXCEL - VLOOKUP & SUMIF FUNCTIONS

INVENTORY MANAGEMENT IN MS EXCEL - ITEM LIST CREATION IN MICROSOFT EXCEL

INVENTORY MANAGEMENT IN MS EXCEL - INVENTORY IN , OUT, STATUS TABLE CREATION

INVENTORY MANAGEMENT IN MS EXCEL - APPLY FORMULA ON INVENTORY IN ,OUT, STATUS

INVENTORY MANAGEMENT IN MS EXCEL - ENTER ALL TRANSACTIONS

INVENTORY MANAGEMENT IN MS EXCEL - ANALYSIS THE TABLES

 

CHAPTER 4 TALLY INSTALLATION

TALLY INSTALLATION

 

CHAPTER 5 THE STEPS OF INVENTORY MANAGEMENT IN TALLY ERP9

BASIC ACCOUNTS CREATION IN TALLY ERP9 - EXAMPLE 01

GODOWN CREATION IN TALLY ERP9 - EXAMPLE 01 

STOCK CREATION - EXAMPLE 01

RECORD JANUARY MONTH TRANSACTION - EXAMPLE 01

RECORD FEBRUARY MONTH TRANSACTION - EXAMPLE 01

RECORD MARCH MONTH TRANSACTION - EXAMPLE 01 

RECORD APRIL MONTH TRANSACTION - EXAMPLE 01

STOCK SUMMARY REPORT ANALYSIS -EXAMPLE 01

 

BONUS SECTION

BONUS LECTURE

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
549
4 hours
– / –
599
10 hours
– / –
View Other 2344 CoursesRight Arrow Icon
qna

Complete Inventory Management in Microsoft Excel &TALLY ERP9
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...