COURSE DESCRIPTION
Computer – Based Financial Accounting using Excel
Employers around the globe are demanding digital skills especially excel spreadsheet skills in the employment process. These changing requirements of the job market have seen the emergence of a gap between the knowledge generated by the traditional learning management system (LMS) and the skills required by employers worldwide.
The need for graduates from high school level to college and university to start jobs with demand driven digital skills is therefore becoming more of a prerequisite for employment all over the world. This course provides them with the insight to uncover a new set of digital skills they need for employment and job security.
This “Computer - Based Financial Accounting” is a demand driven skill course that shows how to translate Financial Accounting concepts into computer language to solve complex digital problems. Therefore, the central focus is how to learn Financial Accounting through computer. The objective of this course, “Computer - Based Financial Accounting”, is to equip every teacher and student in high school, college and university with demand driven digital skills and prepare them to meet the requirements in the job market.
In furtherance of this objective, Microsoft Excel has been chosen as a tool of teaching and learning of Financial Accounting through computer. Given that Microsoft Excel Spreadsheet is standard software used in commerce and industry across the globe, it is essential to teach teachers and students in their use as an integrated part of their courses.
What you'll learn
Learn how to use computer to determine Depreciation Expense for Non-Current Assets under Straight Line, Reducing Balance, Sum-of-Year Digit, Revaluation and Production Unit Method in classroom and workplace.
Learn how to use computer for Financial Statement Analysis in classroom and workplace.
Learn how to use computer in Accounting for Manufacturing Concerns in classroom and workplace.
Learn how to use computer for Bank Reconciliation Statement in classroom and workplace.
Learn how to use computer to prepare Cash Flow Statement in classroom and workplace.
Learn how to use computer in Accounting for Sole Proprietorships in classroom and workplace.
Learn how to use computer in Accounting for Partnership in classroom and workplace.
The course comprises 7 chapters. Chapter 1 is step by step computer-based approach to determining Depreciation Expense for Non-Current Assets under Straight Line, Reducing Balance, Sum-of-Year Digit, Revaluation and Production Unit Method. Chapter 2 deals with Financial Statement Analysis. It covers Common Size Financial Statement Analysis, Trend Analysis, and Financial Ratio Analysis. Chapter 3 covers Accounting for Manufacturing Concerns. Chapter 4 deals with Bank Reconciliation Statement. Chapter 5 covers Cash Flow Statement. Chapter 6 covers Accounting for Sole Proprietorships. Chapter 7 covers Accounting for Partnerships.
Course Content / Title
Chapter 1: Depreciation Expense Determination under various methods
Lesson 1: How to use Keyboard
Lesson 2: Depreciation Expense under Straight Line Method
Lesson 3: Depreciation Expense under Reducing Balance Method
Lesson 4: Depreciation Expense under Sum-of-Year Digit Method
Lesson 5: Depreciation Expense under Revaluation Method
Lesson 6: Depreciation Expense under Production Unit Method
Chapter 2: Financial Statement Analysis.
Lesson 1: Common Size Financial Statement Analysis
Lesson 2: Trend Analysis
Lesson 3: Financial Ratio Analysis
Chapter 3: Accounting for Manufacturing Concerns
Lesson 1: Accounting for Manufacturing Concerns
Chapter 4: Bank Reconciliation Statement
Lesson 1: Bank Reconciliation Statement
Chapter 5: Cash Flow Statement
Lesson 1: Cash Flow Statement
Chapter 6: Accounting for Sole Proprietorships
Lesson 1: Accounting for Sole Proprietorships
Chapter 7: Accounting for Partnership
Lesson 1: Introduction to Partnership
Lesson 2: Dissolution of Partnership
This Course includes:
7 hours and 48 minutes of video tutorials (5 – 7 minutes each)
20 Spreadsheets on how to learn Financial Accounting through computer
Certificate of Completion
Requirements
Target group
Business Students and Teachers at all levels worldwide
Business Graduates looking for employment worldwide
Accounts and Finance Officers and Managers
Course Tutor
ISAAC ALORMENU – MBA (International Finance) Brandeis University, USA - 2009
