|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-sheets-for-entrepreneurs/
课程评论：没有评论
**Coursera 课程：《Google Sheets 助力企业家与小型企业》内容摘要** 本课程是一门注重实践的课程，旨在教授企业家和小型企业主如何利用 Google Sheets 这一强大工具来解决实际业务问题。课程将从零开始，涵盖 Google Drive 和 Google Sheets 的基础知识，直至构建两个关键的业务工具：五年财务模型和详细的运营预算。 **课程主要内容：** * **Google Drive 入门：** 介绍 Google Drive 的基本概念和使用方法。 * **Google Sheets 基础：** 讲解如何上传、转换文档，以及在 Google Sheets 中进行四种不同的工作方式。 * **电子表格结构与操作：** 深入了解电子表格的结构，学习快捷命令和菜单栏的使用技巧，提升工作效率。 * **格式化技巧：** 详细讲解如何格式化行、列、工作表，以及利用格式化工具栏进行全面的格式设置。 * **公式与函数运用：** 探索 Google Sheets 公式的力量，并学习使用最常见的函数来处理数据。 * **实战项目：** * **五年财务模型构建：** 从零开始搭建一个具有五年预测能力的财务模型。 * **详细十二个月运营预算制定：** 完成一个完整的十二个月运营预算。 **课程成果：** 完成本课程后，学员将能够熟练运用 Google Sheets，并获得两个可以直接部署到实际业务中的工作模板（五年财务模型和十二个月运营预算），从而提升业务管理和决策能力。
Welcome to GOOGLE SHEETS for ENTREPRENEURS & SMALL BUSINESS OWNERS!This is a HANDS ON, working course. So, although its short, its POWERFUL. We'll cover Google Drive, Google Sheets and how to use this dynamic tool to create business solutions for your small business or startup (heck, it even works for big businesses!). The two tools that we'll build FROM SCRATCH are:A Five Year Financial ModelA Detailed Operating BudgetWe're going to cover EVERYTHING you need in this course to be successful:Chapter 3, we're going to cover the basics and getting started with Google Drive.Chapter 4, we're going to cover the basics of Google Drive and Spreadsheets. How to upload them, convert them and the four ways that you can work on them.Chapter 5, we're going to cover the Spreadsheet structure and how to use the shortcut commands and the menu bar to make your life easier.Chapter 6, we're going to cover cover how you can format rows, columns and sheets!Chapter 7, we'll continue the formatting fun and we'll cover formatting everything using the formatting bar.Chapter 8, we'll explore the power of formulas and how they can be used in spreadsheets.Chapter 9, we'll wrap things up with a conversation on functions and we'll use the most common ones.This is where things get fun! We'll take everything we've learned and we'll build the two tools I mentioned above. We'll first build a five year financial model and we'll finish the course by building a Detailed Twelve (12) Month Operating Budget.The Result:You'll be ready to deploy Google Sheets into your business. You'll have two working templates that you can use however and wherever you want! Its going to be a fun course.We'll see you in class.
