Complete Inventory Management in Microsoft Excel &TALLY ERP9

Inventory,StockControl,Inventory Control,Microsoft Excel inventory ,Stock Calculation,Inventory Valuation,LIFO,FIFO,WACC

4.28 (432 reviews)
Udemy
platform
English
language
Accounting & Bookkeeping
category
60,759
students
4 hours
content
Feb 2024
last update
$54.99
regular price

What you will learn

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 ?

What Are The Steps Of Inventory Management In Tally ERP9?

How To Create The Company In Tally ERP9?

How To Create The Basic Accounts In Tally ERP9?

How To Create The Godown In Tally ERP9?

How To Create The Stocks In Tally ERP9?

How To Enter The Transactions & Analysis The Report In Tally ERP9?

Description

Recent Student's Reviews


  • Excellent highly recommended course, key Inventory management terms and concepts explained in detail and summarized; with real practical examples to consolidate what has been learned - Luis Rodrigo I.


  • This course is well detailed in inventory management. I really learnt how to make practical use of excel, tally ERP9 and good inventory valuation (Williams Oguamah)


  • Yes it is, I'm having refresher course for what I have learned during college days and it really helps me a lot - SHYRRA APRIL E.


  • Yes it is a good match for me. It will help me in my career path ( Dineo )


  • it was awesome to learn & get insights from this course (Haritha.L)


  • Very Helpful (JULIUS IGNACIO)


  • Happy and learning ( Roshir Ann Go Poyaoan)


Eight Reasons why you should choose this Complete Inventory Management in Microsoft Excel &TALLY ERP9 Course


  1. Best Rated Course on Udemy

  2. Latest updated and Doubts Are Solved in this course

  3. Carefully designed curriculum By Proficient In Inventory Management

  4. you can complete this course In Short time

  5. Inventory related examples and case studies Provided

  6. Example And  practice exercises Are Able to Download in The Recourse Section

  7. Your queries will be responded by the Instructor With In Short time

  8. A Verifiable Certificate will Be Provided On the Completion


  • 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 .


  • The Managing and processing Inventory Management is an important task, and it’s vital that those handling the inventory management have a full understanding and knowledge of the processes involved. The understanding and operating of a inventory management system within a business is an essential requirement for perform the inventory management process exactly and correctly with lower financial Cost. The course is assist that how to Manage the inventory in Microsoft Excel and Tally ERP9.


  • Welcome to My Complete Inventory Management In Microsoft Excel & TALLY ERP9 Course. This course contain a Real practical Example with calculation process. I have given task to do then video answer is available. It is suggested that you.


  • This Course is covered the Following areas such as Inventory Management, Microsoft Excel, Tally ERP9, Stock Control, Spreadsheet Inventory, Excel Inventory Tracking, Tally ERP Inventory, Supply Chain Management, Stock Optimization, Excel Formulas for Inventory, Tally ERP9 Tutorial, Inventory Tracking System, Warehouse Management, Excel Data Analysis, Inventory Reports in Tally ERP9.


What is Key Section in this course?


  1. What Is Inventory?

  2. What Are The Types Of Inventory?

  3. What Is Inventory Management?

  4. What Are The Objectives For Inventory Management?

  5. What Is The Inventory Valuation?

  6. What Are The Types Of Inventory Valuation?

  7. What Is The First In First Out (FIFO) Inventory Valuation Method?

  8. What Is The Last In First Out (LIFO) Inventory Valuation Method?

  9. What Is The Weighted Average Cost/Price Inventory Valuation Method?

  10. How To Create The Item List Table For Inventory Management In Microsoft Excel?

  11. How To Create The Inventory In , Out , Status Table In Microsoft Excel?

  12. How To Apply The Formulas For The Inventory In , Out , Status Table In Microsoft Excel?

  13. How To Enter The Inventory Transactions & Analysis The Report In Microsoft Excel?

  14. How To Install Tally ERP9?

  15. What Are The Steps Of Inventory Management In Tally ERP9?

  16. How To Create The Company In Tally ERP9?

  17. How To Create The Basic Accounts In Tally ERP9?

  18. How To Create The Godown In Tally ERP9?

  19. How To Create The Stocks In Tally ERP9?

  20. How To Enter The Transactions & Analysis The Report In Tally ERP9?


Go ahead and click the enroll button, and I'll see you in Chapter 1!

Cheers

A.M.A.M.Mubeen

Content

CHAPTER -01 - INTRODUCTION TO INVENTORY

INTRODUCTION TO INVENTORY

CHAPTER- 02 - METHODS OF INVENTORY VALUATIONS

INVENTORY VALUATION - INTRODUCTION
INVENTORY VALUATION - FIFO METHOD
INVENTORY VALUATION - LIFO METHOD
INVENTORY VALUATION - WACC METHOD

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

INVENTORY MANAGEMENT IN MS EXCEL- INTRODUCTION
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 -04 - TALLY INSTALLATION

TALLY INSTALLATION

CHAPTER- 05 - THE STEPS OF INVENTORY MANAGEMENT IN TALLY ERP9

CREATE BASIC LEDGER ACCOUNTS IN TALLY ERP9
GODOWN CREATION IN TALLY ERP9
STOCK CREATION IN TALLY ERP9

CHAPTER- 06 - INVENTORY MANAGEMENT PROCESS IN TALLY ERP9 WITH EXAMPLE -01

COMPANY CREATION IN TALLY ERP9 - EXAMPLE 01
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

Screenshots

Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Screenshot_01Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Screenshot_02Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Screenshot_03Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Screenshot_04

Reviews

Ngozi
January 11, 2023
Yes it was a good match for me and very interesting, with this lecture I've gotten another knowledge about inventory. Thank you very much
Suman
July 17, 2022
Good content so far. Nice and brief explanation of types of inventories and valuations. Providing Captions and transcripts could make it more easy.
SHYRRA
March 6, 2022
Yes it is, I'm having refresher course for what I have learned during college days and it really helps me a lot.
Luis
March 4, 2022
excellent highly recommended course, key Inventory management terms and concepts explained in detail and summarized; with real practical examples to consolidate what has been learned
Timothy
November 22, 2021
So far so good I am excited to get another certificate to add on CV The excel worksheets are hard to keep up with, but If I am honest, I take a bit more time to process information and click well.
Avijoy
September 29, 2021
Very informative course. The professor explained how to manage an inventory system in Excel and ERP9 in a detailed manner.
Kisha
March 16, 2021
This was a refresher course for me. I was not familiar with the price method but this course made it easy to understand!
Williams
February 26, 2021
This course is well detailed in inventory management. I really learnt how to make practical use of excel, tally ERP9 and good inventory valuation

Coupons

DateDiscountStatus
11/2/2020100% OFF
expired
11/14/2020100% OFF
expired
11/28/2020100% OFF
expired
12/15/2020100% OFF
expired
12/24/2020100% OFF
expired
1/1/2021100% OFF
expired
1/6/2021100% OFF
expired
1/12/2021100% OFF
expired
1/19/2021100% OFF
expired
2/6/2021100% OFF
expired
2/12/2021100% OFF
expired
3/5/2021100% OFF
expired
3/13/2021100% OFF
expired
3/29/2021100% OFF
expired
5/18/2021100% OFF
expired
5/28/2021100% OFF
expired
6/1/2021100% OFF
expired
6/7/2021100% OFF
expired
6/13/2021100% OFF
expired
7/12/2021100% OFF
expired
7/16/2021100% OFF
expired
7/25/2021100% OFF
expired
8/12/2021100% OFF
expired
8/16/2021100% OFF
expired
8/23/2021100% OFF
expired
9/5/2021100% OFF
expired
9/14/2021100% OFF
expired
9/24/2021100% OFF
expired
10/7/2021100% OFF
expired
10/18/2021100% OFF
expired
10/22/2021100% OFF
expired
11/3/2021100% OFF
expired
11/27/202150% OFF
expired
12/12/202195% OFF
expired
12/27/202195% OFF
expired
12/30/2021100% OFF
expired
1/17/2022100% OFF
expired
1/23/2022100% OFF
expired
2/6/2022100% OFF
expired
2/22/2022100% OFF
expired
3/3/2022100% OFF
expired
3/27/202250% OFF
expired
4/23/202250% OFF
expired
7/4/2022100% OFF
expired
7/10/2022100% OFF
expired
7/16/2022100% OFF
expired
8/28/2022100% OFF
expired
8/30/2022100% OFF
expired
10/2/2022100% OFF
expired
11/7/2022100% OFF
expired
11/14/2022100% OFF
expired
11/21/2022100% OFF
expired
11/24/2022100% OFF
expired
5/21/2023100% OFF
expired
6/4/2023100% OFF
expired
6/5/2023100% OFF
expired
1/16/2024100% OFF
expired
1/20/2024100% OFF
expired
1/24/2024100% OFF
expired
1/28/2024100% OFF
expired
2/7/2024100% OFF
expired
2/22/2024100% OFF
expired
3/3/2024100% OFF
expired
3/10/2024100% OFF
expired
3/23/2024100% OFF
working

Charts

Price

Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Price chart

Rating

Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Ratings chart

Enrollment distribution

Complete Inventory Management in Microsoft Excel &TALLY ERP9 - Distribution chart
3603368
udemy ID
10/30/2020
course created date
11/2/2020
course indexed date
Bot
course submited by