Sara Beattie College

Higher Certificate in Accounting with Excel

Enquire Now

Course Information

Schedules
  • 18 Aug 2021 (Wed) - 8 Oct 2021 (Fri) 12:00 PM
  • 15 Sep 2021 (Wed) - 5 Nov 2021 (Fri) 12:00 PM
  • 13 Oct 2021 (Wed) - 3 Dec 2021 (Fri) 12:00 PM
Registration period
25 May 2021 (Tue) - 31 Dec 2021 (Fri)
Price
HKD 6,700
($300 Cash rebate upon successful completion of each module)
Study Mode
Duration
8 Month(s)
Language
English
Location
-
42 views

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.


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

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