|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-accounting-1transactions-for-common-data-input-forms/
课程评论：没有评论
课程名称：Excel会计1-常见数据输入表格的交易 课程概述：在本课程中，我们将从空白的Excel工作表开始，构建一个会计系统，创建总日记帐、总账、试算表、明细账和财务报表。每个步骤都有可下载的Excel工作簿，包含至少两个标签页：一个是完成步骤后的答案，另一个是上一个演示停留的地方。我们将利用创建的会计系统工作表记录常见交易，将分录输入总日记帐，过账到总账，创建试算表，调整明细账，并构建财务报表。在录入每笔交易时，我们将考虑会计软件（如QuickBooks）中经常使用的数据输入。在会计软件中，数据输入表格（如账单、发票、信用凭证、支票、销售收据等）用于简化数据输入过程，使得会计知识较少的用户也能熟悉数据输入。会计人员如果理解会计理论、每笔交易对财务报表的影响，以及会计数据库程序（如QuickBooks）的运作，尤其是输入常规财务交易所用的表格，将更具价值。由于电子表格具有高度透明性，它们是理解会计理论和会计软件的理想工具。此外，在Excel中构建会计系统是提高Excel技能的绝佳途径之一。
In this course we will build an accounting system starting with a blank Excel worksheet, creating a general journal, a general ledger, a trial balance, subledgers, and financial statements.For each new step in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps having been completed, the other starting out where the prior presentation left off.Once we have created our accounting system worksheet, we will use it to record common transactions, entering the journal entries into the general journal, posting to the general ledger, creating the trial balance, adjusting the subsidiary ledgers, and constructing the financial statements.As we enter each transaction, we will consider the data input often used in accounting software like QuickBooks. Accounting software will use data input forms like bills, invoices, credit memos, checks, sales receipts, and more, to simplify the data input process, allowing users with little accounting experience to learn data input.Accountants are generally more valuable when they understand both the accounting theory, the impact on financial statements of each transaction, as well as how an accounting database program like QuickBooks works, including the data input forms used to enter normal financial transactions.Because spreadsheets are so transparent, they are the perfect tool to gain and understanding of both, accounting theory and accounting software.Conversely, building an accounting system in Excel is a great way, one of the best ways, to improve your Excel skills.
