Create a Financial Statement using Microsoft Excel
Understand the components and variations of a Financial Statement
Complete a Transactions page and Profit and Loss statement that summarizes monthly transactions.
Understand the components of a Balance Sheet.
By the end of this project, you will be able to complete a financial statement with Microsoft Excel, composed of a transactions page, profit and loss statement, and balance sheet. You will learn how to enter your business transactions and interpret the data presented in the profit and loss statement. You will also learn about the components of a balance sheet and will have a better understanding of how a financial statement can be used to help track and present financial information for your company.
您要培養的技能
- Spreadsheet
- Financial Statement
- Balance Sheet
- Calculations
分步進行學習
在與您的工作區一起在分屏中播放的視頻中，您的授課教師將指導您完成每個步驟：
Log into Microsoft Excel Online and open a blank spreadsheet.
Identify the assumptions for the financial statement and create a Transactions page.
Create a Profit and Loss statement that summarizes monthly transactions.
Use the SUMIFS formula to populate the categories for the Profits and Loss with the transactions.
Understand the components of a Balance Sheet and complete the Assets section
Complete the Liabilities and Owner’s Equity sections of the Balance Sheet and perform a final balance check.
指導項目工作原理
您的工作空間就是瀏覽器中的雲桌面，無需下載
在分屏視頻中，您的授課教師會為您提供分步指導
常見問題
常見問題
如果我購買指導項目，會得到什麼？
指導項目可在台式設備和移動設備上學習嗎？
指導項目的授課教師是誰？
我能在完成指導項目後從中下載作品嗎？
我能夠退款嗎？退款政策是如何規定的？
有助學金嗎？
我能旁聽指導項目並免費觀看視頻部分嗎？
我需要具備多少經驗才能做這個指導項目？
我能直接通過 Web 瀏覽器來完成此指導項目，而不必安裝特殊軟件嗎？
指導項目的學習體驗如何？
還有其他問題嗎？請訪問 學生幫助中心。
Coursera Footer
