|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-sheets-basic-to-super-advance-with-practicals/
课程评论：没有评论
课程名称：Google Sheets-基础到高级的实用培训（15小时） 课程概述：本课程将教您如何在Google Sheets中工作，包含14个部分，涵盖了Sheets的每个细节。课程内容包括： - 如何开始使用Google Sheets，包括安装和基本操作。 - 学习剪切、复制、粘贴、插入行和列、数据排序和过滤等功能。 - 如何插入、删除和重命名工作表，以及保护数据。 - 创建工作表的副本或完整的Google Sheet。 - 与同事分享工作表的方法。 - 根据所在国家设置语言。 - 学习过滤视图，掌握排序和过滤函数。 - 使用VLOOKUP、MATCH、TRIM和INDEX等函数进行数据查找。 - 组合多个函数，构建复杂公式。 - 使用LARGE、SMALL与FILTER和SORT等其他函数配合。 - 学习逻辑函数如IF、IFAND、IFOR及新函数IFS的区别。 - 使用错误处理函数如IFERROR和IFISERROR。 - 深入了解日期和时间函数。 - 使用INDIRECT函数，这是Sheets中非常有用的功能。 - 定义名称范围及其在Google Sheets中的实际应用。 - 创建下拉菜单和动态下拉菜单，利用INDEX和FILTER实现多级动态下拉。 - 使用数据验证功能限制不希望输入的数据。 - 定期进行实践测验以监测学习进度。 - 学习如何使用图表进行数据分析，从基本到高级，包括柱状图、折线图、饼图等。 - 使用切片器控制数据。 - 用数据透视表和切片器总结数据，创建一个包含所有功能的仪表板。 - 在Google Sheets中使用SQL查询。 - 学习如何从网站导入数据，无需编程的网页抓取技术，如IMPORTXML和IMPORTHTML。 - 课程最后提供了多个项目，以帮助您理解这些知识在Google Sheets中的应用。 此外，提供全天候支持，随时回答您的问题。
This course will educate you about how to work with Google sheets. It has 14 sections as on date covering every minute detail about Sheets.How to begin with Google sheets - from installing to using it.How to use features like Cut paste, copy paste, insert rows, insert columns, sort data ,filter dataHow to insert sheets, delete , rename sheets, protect the dataHow to create duplicate copies of sheets or google sheet as a wholeHow to share sheets with other colleagues in officeHow to set up the language based on your countryHow to use Filter Views Learn Sort and filter functions.How to lookup the data using VLOOKUP , MATCH , TRIM and INDEX functionsHow to join more than one function and make a single large complex formulaHow to use LARGE, SMALL function with other functions like FILTER and SORTHow to use logical functions like IF, IFAND, IFOR and new function IFS with the difference between themHow to use Error handlers like IFERROR & IFISERROR. - Use them with other lookup functionsHow to use VLOOKUP inside VLOOKUP and infact more than 3 VLOOKUPs in one formulaKnow your Date and Time functionsHow to use INDIRECT Function - the most amazing and helpful function in sheetsHow to define Name range and their practical use in G sheetsHow to create drop down and dynamic drop down - two or three level dynamic drop down with the help of INDEX and FILTERHow to restrict data from entering anything you do not want by using data validation featuresPractical Quizzes time to time to monitor your preferenceHow to do data analysis using Charts - Basic to advance - column chart, line chart, pie , doughnut chart, combo chart, scorecard chart, table chart etc.How to control data using SLICERSHow to summarize data using Pivots and Slicers Create an Awesome Dashboard which uses above all functions and features.How to use SQL Query in Google sheetsHow to work with websites to import their data into sheets. Webscraping without any programming. IMPORTXML/HTMLLast but not least, there are so many projects for your help to understand how all of this knowledge is used in Google sheets.24*7 Support is available to answer your queries
