Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Computer Accounting Training with CAT22 Microsoft Excel

Computer Accounting Training with CAT22 Microsoft Excel

Mastering 2 skills (Programming Language & Accounting Programmer) in one course. In 20 minutes theory & 2 hours practice
Created byYayasan YPTII
Last updated 1/2021
English
English [Auto],

What you'll learn

  • Account (Chart of Account)
  • Document (10 financial document such as: Customer Invoice, Supplier Bill, Material Consumption, Goods Receive, Production Report, Receive Voucher, Payment Voucher, General Journal, Adjustment, Opening Balance)
  • Journal (Debet Credit)
  • GL (General Ledger)
  • Costing
  • Report (Profit & Loss, Balance Sheet)
  • Closing

Course content

2 sections • 10 lectures • 31m total length

  • CAT22 Microsoft Excel0:02

    Please use this file along the tutorial

  • User Guide1:36

    Navigate a step-by-step computer accounting training with CAT22 Microsoft Excel, featuring restudy prompts, step-by-step cues, hip hop scene references, and next-video instructions.

  • Account0:54

    Cover profit and loss concepts and how to name a range in Excel for CAT22.

  • Document (10 financial documents)5:49

    Standardize ten financial documents by linking employees, customers, suppliers, and production data to support the bottom line and uniform reporting.

  • Journal (Debet Credit)16:26

    Explore debet and credit concepts in journal entries, including how assets increase and liabilities decrease, and how equal credits apply.

  • GL (General Ledger)1:09

    Work with the general ledger in Excel, using formulas to support costing tasks. Apply practical steps to costing processes within a computer accounting framework.

  • Costing2:45

    Learn ship costing fundamentals, including material consumption, ending balances, production and delivery reports, and how to prepare profit and loss statements for effective costing.

  • Report (Profit & Loss, Balance Sheet)0:56

    Learn to generate profit and loss and balance sheet reports, apply costing concepts, and analyze money-related transactions in Excel-based computer accounting.

  • Closing1:02

    Conclude the session by confirming understanding and announcing that the exercise will be explained in the next video as we continue to the next segment.

Requirements

  • Instal Microsoft Excel
  • Basic accounting cycle

Description

CAT22 is a miniature Accounting Program for Manufacturing Company.


It is designed to help you mastering 2 skills: programming language and accounting programmer in a fantastic quick way (only 20 minutes theory and 2 hours practice)


It's Research & Development based on accounting practice of some Multi National Companies in Indonesia, Singapore, Malaysia, Australia


This course is cover the following material:

* Chart Of Account

* Financial Documents: Customer Invoice, Supplier Bill, Material Consumption, Goods Receive, Production Report, Receive Voucher, Payment Voucher, General Journal, Adjustment, Opening Balance

* Journal (Debet Credit)

* Costing

* Financial Report: Profit & Loss, Balance Sheet

* Closing


There exist 22 options in CAT22. Semi Automatic and Fully Automatic. Semi Automatic for example by Microsoft Excel, and Fully Automatic for example by VB .NET. We suggest you to select Microsoft Excel first before you go to Fully Automatic option.


This course is conducted with Microsoft Excel.


It is required that you have accounting knowledge before taking CAT22. For example, you know the accounting cycle theory. Beside that, it is required that you can operate computer. For example, you know how to turn on and turn off the computer. No coding skill required for this course.


If you have any other questions, don't be hesitate to contact us.

Who this course is for:

  • scholar
  • prospective employees
  • employee
  • freelance

Report abuse