|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-google-sheets-basic-to-advance-course/
课程评论:没有评论
**Google Sheets 从入门到精通课程概览** 本课程旨在帮助您快速掌握Google Sheets的各项功能和应用。Google Sheets作为免费且基于云的电子表格程序,因其跨设备便捷访问和日益强大的灵活性而广受欢迎。 **课程内容亮点:** * **数据处理与分析:** 深入学习数据导入(包括Excel数据)、Pivot Table(数据透视表)的应用,以及日期、时间、文本等数据的处理技巧。 * **动态报告与可视化:** 掌握创建动态MIS报告和动态仪表板(Dashboard)的方法,提升数据呈现能力。 * **自动化与集成:** 学习使用Google Forms(谷歌表单)进行数据收集,并探索其他高级功能。 * **公式与函数:** 涵盖Lookups(查询)、Conditional Sum/Counting(条件求和/计数)、Logical Operators(逻辑运算符)等常用函数。 * **格式化与技巧:** 学习各类格式化技巧(Formatting Tip & Tricks),快速美化表格。 **课程目标:** 完成本课程后,您将能够: * 熟练运用Google Sheets的各项功能。 * 进行复杂的计算和数据分析。 * 在短时间内创建专业的表格和报告。 * 应用Google Forms和制作动态仪表板。 课程会持续更新,加入新的技术和功能。
Google Sheets becomes very popular spreadsheets program because First, it's FREE, Secondly, Cloud base simply login your account on any device and start working, above all Flexibility of uses, Getting improved day by day.So keeping Google Sheets's importance in mind, you need get familiar with Feature & Function of Google Sheets as quickly as possible.We bring this Google Spreadsheet course for you to get in depth knowledge of Google's Free Wonderful Program.This course will begin from very basic level, once you complete you will be able to do complex calculations, make formats within minutes, create Dynamic MIS Reports, Use Google Forms, Create Dynamic Dashboards & So....What you Learn?We tried to cover almost all feature & Functions but majors are listed below: -Pivot TableImport of Data in Google Sheets from ExcelGoogle FormsFormatting Tip & TricksDate & TimeTextLookupsConditional Sum, CountingLogical OperatorsNew Techniques will be uploaded time to time.