Outschool
開啟貨幣、時區和語言設置
登入

使用 Google Sheets 製作財務電子表格

在 5 週的時間裡,學習者將了解企業資產負債表、損益表、現金流量和預算,同時練習使用 Google 試算表。使用模板,學習者將獲得會計術語和公式的實踐介紹。
Colleen Smith
平均評分:
5.0
評論數量:
(330)
明星教育家
班級

包含什麼

5 現場會議
4 小時 10 分鐘 上課時間
作業
每週 1 小時. I will provide optional homework to help reinforce terms used during class. I will also provide a one-page notes page for learners and/or parents to review after class.
等級
Please let me know if you need specific grading for this class.
我們無法翻譯此文,請刷新頁面並再試一次。

課堂經歷

英語程度 - 未知
美國 9 - 12 年級
Beginner - Intermediate 等級
During this five-week course, students will learn about basic financial statements, including a personal budget and a company's balance sheet, income statement, and cash flow. 

Students will use Google Sheets on their laptop or computer in-order to create each financial statement during class. In order to benefit from this course, students do not have to have used Google Sheets before but should be proficient in using their mouse and keyboard.

𝗪𝗲𝗲𝗸 𝟭: We will begin by creating a basic personal budget. I will define "static" and "cell reference" formulas and then we will discuss the benefits of cell reference formulas. We will then use a budget template and practice using and updating the template.

𝗪𝗲𝗲𝗸 𝟮: We will discuss assets, liabilities, and equity.  We will discuss the uses of a balance sheet and create a balance sheet using a mock company as an example.

𝗪𝗲𝗲𝗸 𝟯: We will create a revenue and expense tracker.  We will discuss how this information is used to create a company's income statement. We will practice linking two spread sheets with formulas. 

𝗪𝗲𝗲𝗸 𝟰: We will look at an income statement and cash flow and discuss the differences and what each tells us.  We will use the cash flow statement to create graphs that show changes over multiple years.

𝗪𝗲𝗲𝗸 𝟱: We'll review and look at real company's examples of the different types of financial statements.


𝗧𝗿𝗼𝘂𝗯𝗹𝗲𝘀𝗵𝗼𝗼𝘁𝗶𝗻𝗴 𝗱𝘂𝗿𝗶𝗻𝗴 𝗰𝗹𝗮𝘀𝘀:
Occasionally, learners may need additional help in completing a task in Google Sheets. I am able to give students the ability to share their screen so that I can see exactly what they are looking at. Usually, this works very well, and I am able to talk them through the task. If the learner is still not able to complete the task, they are able to grant me remote access so that I can complete the task for them. This allows us to move and cover all material in the class.  At the end of class, I will revisit the skipped step and further troubleshoot with the learner.
學習目標
Learners will be able to calculate profit and net worth / equity.
Learners will be able to state the purpose of a balance sheet, income statement, cash flow and budget.
學習目標

教學大綱

5 課程
超過 5 週
課 1:
Personal Budget
 We will begin by creating a basic personal budget. I will define "static" and "cell reference" formulas and then we will discuss the benefits of cell reference formulas. We will then use a budget template and practice using and updating the template. We will discuss what the average American spends in a month. 
50 分鐘線上直播課
課 2:
Balance Sheet
 We will discuss assets, liabilities, and equity.  We will discuss the uses of a balance sheet and create a balance sheet using a mock company as an example. 
50 分鐘線上直播課
課 3:
Income Statement
 We will create a revenue and expense tracker.  We will discuss how this information is used to create a company's income statement. We will practice linking two spread sheets with formulas. 
50 分鐘線上直播課
課 4:
Cash Flow
 We will look at an income statement and cash flow and discuss the differences and what each tells us.  We will use the cash flow statement to create graphs that show changes over multiple years. 
50 分鐘線上直播課

其他詳情

父母的引導和規範
Students use Google Sheets for this class. If students use Google Sheets, they will need to access an external website to access Google Sheets: https://docs.google.com/spreadsheets/u/0/?tgif=d Google Suite is on Outschool's approved list of resources for all learners.
先決條件
A learner does not need financial or Google Sheet experience for this class. However, they should have basic knowledge of using a computer, such as opening a file and using a mouse.
外部資源
除了 Outschool 教室外,本課程也使用:
已加入 September, 2021
5.0
330評論
明星教育家
教師檔案
教師專業知識和證書
學士學位 由 Bucknell University
Over the last three years, I have virtually tutored over 1,300 young learners on the Outschool platform. Prior to that, I enjoyed a thirteen-year corporate career, where I used financial statements regularly to make decisions. I hold a Bachelor of Science in Business Administration from Bucknell University.

評論

現場團體課程
分享

US$80

用於 5 課程
每週1次,共 5 週
50 分鐘

有7 位學習者完成此課程
即時視訊會議
年齡: 14-18
3-8 每班學員人數

關於
支援
安全隱私加州隱私學習者隱私管理資料首選條款
下載這個軟體
在應用程式商店下載在 Google Play 上取得
© 2024 校外