Sara Beattie College

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

Enquire Now

Course Information

  • 15 Dec 2021 (Wed) - 4 Feb 2022 (Fri) 12:00 PM
  • 12 Jan 2022 (Wed) - 4 Mar 2022 (Fri) 12:00 PM
  • 9 Feb 2022 (Wed) - 1 Apr 2022 (Fri) 12:00 PM
Registration period
28 Sep 2021 (Tue) - 2 Feb 2022 (Wed)
HKD 6,700
($300 Cash rebate upon successful completion of each module)
Study Mode
8 Month(s)

Course Overview

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.

• 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

• 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

What You’ll Learn

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

Course Media

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed