|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/googlesheets-analysis-automation-ishanluthra/
课程评论：没有评论
课程名称：Google Sheets 数据分析与工作流程自动化 课程概述： 《Google Sheets 数据分析与工作流程自动化》是一门全面的课程，旨在帮助学习者掌握如何高效地使用 Google Sheets 进行数据分析和工作流程自动化。该课程非常适合对 Google 表格感到陌生的个体，或者希望提升自己数据分析技能和简化工作流程的学员。 在课程中，学习者将学习如何使用 Google Sheets 进行一系列数据分析任务，包括数据清理与整理、运用各种函数进行数据分析，以及通过 Google Forms 实现自动化。本课程还提供了两个实际项目，以使学习体验更具实用性：一个是销售数据分析，另一个是实施在线请假申请和审批工作流程，利用 Google Sheets、Google Forms 和 Gmail 生产力功能进行。 课程涵盖的函数包括： - 数学函数：COUNTIF、COUNTIFS、COUNTUNIQUE、FLOOR、CEILING、ROUND、ROUNDUP、ROUNDDOWN、ISEVEN、ISODD、SUM、SUMIF 和 SUMIFS - 统计函数：AVERAGE、AVERAGEIF、AVERAGEIFS、COUNT、COUNTA、MIN、MAX 和 RANK - 文本函数：LEN、LEFT、RIGHT、MID、UPPER、LOWER、PROPER、TRIM、REPLACE、SUBSTITUTE、REGEXREPLACE、REGEXMATCH 和 REGEXTRACT - 逻辑函数：AND、OR、IF、嵌套 IF、IFS、SWITCH、IFERROR 和 IFNA - 筛选函数：FILTER、SORT 和 UNIQUE - 日期与时间函数：DATE、ISDATE、DATEDIF、DAY、MONTH、YEAR、DAYS、DAYS360、EDATE、EOMONTH、NOW、TODAY、HOUR、MINUTE、SECOND、WEEKDAY 和 WEEKNUM - 其他重要函数：VLOOKUP、IMPORTRANGE、ARRAYFORMULA、QUERY 和 CONCATENATE 这些函数同样适用于 Microsoft Excel 和高级 Excel。课程还将涵盖一些基本主题，比如条件格式、数据验证、协作、数据共享与安全性，让学习者深入理解如何利用 Google Sheets 来优化工作流程。 通过本课程的学习，学员将打下坚实的基础，掌握使用 Google Sheets 进行数据分析和工作流程自动化的技能，能够运用多种函数进行数据分析，提高工作效率。
"Google Sheets for Data Analysis & Workflow Automation" is a comprehensive course designed to equip learners with the skills to use a Google Sheet effectively for analysing data and automating the workflows. This course is ideal for individuals who are new to Google SpreadSheet or those who have some experience in sheets but want to enhance their skills to analyse data more effectively and streamline their workflows.Throughout the course, learners will learn to perform a range of data analysis tasks using Google Sheets, such as cleaning and organizing data, using various functions to analyze the data and implement automation through Google Forms as a bonus package of this course. Learners of this course will be able to work on two real life projects, one on Sales Data Analysis and another on implementing a completely Online Leave Application and Approval workflow by leveraging Google Sheets, Google Forms and Gmail Productivity features in Google Workspace (G Suite).The functions covered in this course include:Mathematical Functions: COUNTIF, COUNTIFS, COUNTUNIQUE, FLOOR, CEILING, ROUND, ROUNDUP, ROUNDDOWN, ISEVEN, ISODD, SUM, SUMIF & SUMIFSStatistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, MIN, MAX & RANKText Functions: LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, REPLACE, SUBSTITUTE, REGEXREPLACE, REGEXMATCH & REGEXTRACTLogical Functions: AND, OR, IF, NESTED IF, IFS, SWITCH, IFERROR & IFNAFilter Functions: FILTER, SORT & UNIQUEDate & Time Functions: DATE, ISDATE, DATEDIF, DAY, MONTH, YEAR, DAYS, DAYS360, EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND, WEEKDAY & WEEKNUMOther Important Functions in G-Sheets: VLOOKUP, IMPORTRANGE, ARRAYFORMULA, QUERY & CONCATENATEMost of these functions can also be used, equally well, in Microsoft Excel / Advanced Excel.The course will also cover essential topics such as conditional formatting, data validation, collaboration, data sharing & security, allowing learners to gain a deeper understanding of how to use Google Sheets to streamline their work processes. They will also explore add-ons and other advanced features to enhance their productivity.By the end of this course, learners will have gained a solid foundation in using a Google Sheet for data analysis and workflow automation. The learners will be able to use a wide variety of functions for Data Analysis. They will be able to use Google Sheets to streamline their workflows, saving them time and improving their productivity.
