Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Accounting & Bookkeeping Tally.ERP

Complete Inventory Management in Microsoft Excel &TALLY ERP9

Inventory Management,TALLY ERP9,Inventory,Microsoft Excel inventory ,Inventory,stock,Inventory Valuation,LIFO,FIFO,WACC
Rating: 4.2 out of 54.2 (69 ratings)
13,444 students
Created by A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office)
Last updated 1/2021
English
30-Day Money-Back Guarantee

What you'll 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?

Requirements

  • No Prior Knowledge

Description


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


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

Who this course is for:

  • You are going to take responsibility for Inventory Management
  • You are going for jobs which have a requirement for you to be able to know Inventory Management and use Tally ERP9 for Inventory Management process
  • You want to put this skill on your CV
  • You are a bookkeeper or accountant and will be offering inventory management services
  • You run your own business and want to know how to manage the inventory for yourself
  • Accountants
  • Stock keepers
  • Inventory Managers
  • Operational Managers

Course content

7 sections • 26 lectures • 3h 54m total length

  • Preview07:54

  • Preview01:20
  • INVENTORY VALUATION - FIFO METHOD
    15:49
  • INVENTORY VALUATION - LIFO METHOD
    13:12
  • INVENTORY VALUATION - WACC METHOD
    12:37

  • Preview03:46
  • INVENTORY MANAGEMENT IN MS EXCEL - VLOOKUP & SUMIF FUNCTIONS
    03:02
  • INVENTORY MANAGEMENT IN MS EXCEL - ITEM LIST CREATION IN MICROSOFT EXCEL
    16:29
  • INVENTORY MANAGEMENT IN MS EXCEL - INVENTORY IN , OUT, STATUS TABLE CREATION
    09:59
  • INVENTORY MANAGEMENT IN MS EXCEL - APPLY FORMULA ON INVENTORY IN ,OUT, STATUS
    22:46
  • INVENTORY MANAGEMENT IN MS EXCEL - ENTER ALL TRANSACTIONS
    29:31
  • INVENTORY MANAGEMENT IN MS EXCEL - ANALYSIS THE TABLES
    06:23

  • TALLY INSTALLATION
    04:13

  • Preview01:22
  • GODOWN CREATION IN TALLY ERP9
    02:10
  • STOCK CREATION IN TALLY ERP9
    05:37

  • Preview09:29
  • BASIC ACCOUNTS CREATION IN TALLY ERP9 - EXAMPLE 01
    05:49
  • GODOWN CREATION IN TALLY ERP9 - EXAMPLE 01
    02:32
  • STOCK CREATION - EXAMPLE 01
    12:09
  • RECORD JANUARY MONTH TRANSACTION - EXAMPLE 01
    12:56
  • RECORD FEBRUARY MONTH TRANSACTION - EXAMPLE 01
    10:36
  • RECORD MARCH MONTH TRANSACTION - EXAMPLE 01
    10:12
  • RECORD APRIL MONTH TRANSACTION - EXAMPLE 01
    10:19
  • STOCK SUMMARY REPORT ANALYSIS -EXAMPLE 01
    04:04

  • BONUS LECTURE
    00:37

Instructor

A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office)
130,000+ Students | 4+ Rated | 180 + Countries
A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office)
  • 4.2 Instructor Rating
  • 2,550 Reviews
  • 138,655 Students
  • 7 Courses

I Am the Expert in Microsoft Office ,Tally ERP 9,Accounting & Finance Related Subjects and A Degree Holder (Specialization In Finance) , I Was Working in Different Positions Such as Senior Accountant and Financial Manager of Construction Company. I Have Been Teaching More Than 5 Years And I Delivered Various Lecture Programs and My All Lecture Programs are Much Dynamics & interesting as well. I Hope That You Will Enjoy My All Courses.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.