Accounting Equation in Excel - First Month of Data Input

Course Overview

• Course Title: Accounting Equation in Excel - First Month of Data Input
• Instructor: Robert (Bob) Steele
• Target Audience:
  • Accounting professionals
  • Students with basic accounting knowledge
  • Intermediate Excel users
• Prerequisites:
  • Basic Accounting Knowledge
  • Proficiency in Microsoft Excel
  • Computer Literacy
  • Access to Excel Software (2016 or later)

Curriculum Highlights

• Key Topics Covered:
  • Analyzing the structure of an accounting equation
  • Entering beginning balances into a new system using Excel
  • Recording and organizing one month of financial transactions
  • Developing subledgers for accounts receivable, accounts payable, and inventory
  • Preparing financial statements (balance sheet, income statement)
  • Evaluating the accuracy of financial statements
• Key Skills Learned:
  • Proficiency in using Excel for accounting workflows
  • Managing balances, transactions, and subledgers
  • Ensuring data integrity in a new accounting system

Course Format

• Duration: 10.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 22 downloadable resources
  • Access on mobile and TV
  • Certificate of completion