|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/googlesheets/
课程评论：没有评论
这个Coursera课程“我爱Google表格：面向雇主所需技能的培训”旨在教您如何高效使用Google表格进行数据分析。课程将带您从创建基础电子表格开始，逐步掌握数据输入、编辑、展示调整、公式编写（包括Vlookup, Hlookup, Index, Pivot Tables）、相对/绝对/混合引用、函数运用，以及图表创建、数据排序、筛选、冻结窗格、工作表格式化等实用技巧。课程还包含快捷键、小贴士和分享协作功能。作为额外福利，您还将学习如何用Google表格创作艺术。完成本课程后，您将能自信地驾驭Google表格，有效进行数据分析，为您的工作或个人生活增添价值。
Google Sheet is an extremely powerful alternative to Microsoft's Excel spreadsheet software. Jon will teach you step-by-step how to create a basic spreadsheet and analyze the. This course covers all the essentials that will help you manipulate and analyze large sets of data. Of course, you will learn the fundamentals such as the basic calculations, formulas, creating charts, and tips & tricks that will get you started quickly.By the end of this introductory course, you will feel confident maneuvering around Google Sheets and gain instincts to use it effectively for data analysis, and ultimately adding value to your company or to your own personal life.In this course you will learn how to:Effectively and efficiently navigate around Google SheetsEnter and edit data in Google SheetsAdjust the way data and information are displayed in Google SheetsWrite formulas quickly and easilyLeverage data with Vlookup, Hlookup, Index, and Pivot Tables Use relative, absolute, and mixed references in Google SheetsCreate powerful calculations with Google Sheets functionsVisually represent your data with charts and graphs in Google SheetsUse data tools like sorting, filtering, and filter viewsUtilize freeze panes in Google SheetsFormat worksheets in Google Sheets for impact and appealLearn shortcuts, tips, and tricksLearn how to use commenting and sharing in Google SheetsAs a fun bonus material, you will also learn how to create art with Google Sheets!Enroll today in this course! We are 100% confident that you will learn
