Higher Certificate in Accounting with Excel 會計及財務 / 電腦, 資訊科技及設計

Accounting Fundamentals covers all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period. Whether you're a sole proprietor looking to manage your business finances or you simply want to gain an understanding of accounting basics for career advancement or for personal use, this course will give you a solid foundation in financial matters.

HOW YOU WILL BENEFIT
• Learn everything you need to know to better manage your finances
• Gain a solid understanding of accounting basics to be able to manage business finances or advance your career
• Open the door to more career opportunities in the in-demand field of accounting and finance

WHAT YOU WILL LEARN
• Learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions
• Get hands-on experience with handing accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities
• Learn about writing checks, preparing an income statement, and closing out accounts at the end of a fiscal period

The Four (4) Modules in this Higher Certificate Course include:

Module 1:  Introduction to Microsoft Excel 2016

• Excel Basics
• Creating a worksheet
• Time-savers
• Relative, absolute, mixed, and circular references
• Three dimensional workbooks
• Sorting, subtotaling, and filtering
• Charting Basics
• Advanced charting techniques
• Intro to Excel’s statistical functions
• Financial Functions
• Worksheet Automation
• Mastering Excel’s IF function

Module 2: Intermediate Microsoft Excel 2016

• Excel charts and graphs
• More Excel charts
• Autofilter and sorting
• Goal seeking
• Pivottables
• Advanced Pivottables
• Solver
• Sparklines
• Macros
• Introduction to functions
• Math/Trig functions
• Vlookup, Index, and Match Functions

Module 3: Accounting Fundamentals I

• Account Classifications, Account Titles, T Accounts, and the Accounting Equation
• General ledger accounts and the balance sheet
• Journalizing Transactions and posting to the general ledger
• Journalizing and posting cash and charge purchases and payments on account
• Payroll and various deductions
• Banking services and reports
• Posting journal totals to the general ledger and schedule of accounts
• Payable and schedule of accounts receivable
• End-of-year worksheet
• End-of-year financial reports
• Journalizing and posting adjusting entries
• Journalizing and posting closing entries and preparing a post-closing trial balance

Module 4: Accounting Fundamentals II

• Accounts payable
• Accounts receivable
• Uncollectible accounts receivable
• Plant assets and depreciation
• Notes payable and notes receivable
• Accrued income and accrued expenses
• Dividends and starting the year-end worksheet
• Complete year-end worksheet with adjustments
• End-of-fiscal-period financial reports
• Adjusting and closing entries and post closing trial balance
• Preparing a payroll
• Preparing federal tax deposits and year-end tax reports