Financial Accounting with Excel training course outline by Computer Academy

Everyday we are facing much competition from internal and external of a corporation. Who can maintain the quality and lower costing should be the winner. Due to use much manpower to handle data, it is difficult to keep lower costing

This course use Microsoft Excel features, which can help Accountant, Management people to store information of customers, products, account details, tracking of transaction, preparing purchasing order, sales invoice etc. So they can save their time and do it more accurate.

You can learn the features of Microsoft Excel step by step through different kind of examples. These can give you a clear picture of Excel.

What you’ll learn

How to setup customer database

  • How to setup product database
  • How to setup chart of account General entry
  • How to prepare sales invoice
  • How to prepare purchasing order
  • How to prepare trial balance
  • How to prepare profit & loss and balance sheet

Database setup

  • Database setup
  • Setup customer database system
  • Assign customer ID
  • Edit, search, and sorting of customer
  • Setup manufacturer database system
  • Setup products database

Account setup

  • Accounting setup
  • Chart of account
  • Double-entry system for assets and liabilities
  • The Asset of stock
  • Double entry system for expenses and revenues
  • The effect of profit or loss on capital
  • Setup General Journal
  • General Journal Entry
  • Editing General Journal item
  • The sales journal
  • The Purchases Journal

SCHEDULES
 
FEX3111 - 廣東話 09 Nov enrol
 
FEX3112 - 廣東話 27 Nov enrol
 
FEX3122 - 廣東話 28 Dec enrol
 
FEX4013 - 廣東話 01 Jan enrol
 
FEX4014 - 廣東話 23 Jan enrol
RELATING COURSES
  Excel-formulas & functions
  Mastering Excel PivotTables and PivotCharts

Sales

  • Setup purchasing order
  • Setup sales invoice
  • Setup quotation
  • Trial Balance

Profit & Loss accounts and balance sheet

  • Setup Profit & Loss accounts
  • Setup Balance Sheet
  • Setup Monthly Balance
  • Protect your account system