|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-google-sheets/
课程评论：没有评论
课程名称：Google Sheets 数据分析与商业智能 课程概述： 本课程是一门动手实践、项目导向的课程，旨在帮助学员掌握在Google Sheets中管理、探索、分析和可视化数据的技能。课程开始将介绍Google Sheets的界面和工作流程，随后深入学习电子表格的基本结构，如表格结构、数据类型、格式设置、排序和筛选。接着，我们将探讨用于数据分析的公式和函数，介绍语法、引用类型和常见错误等关键主题，并实践应用一些最常用和强大的数据管理与分析技术，包括计数和汇总值、创建逻辑测试、跨表连接数据、文本和日期值的操作等。 课程接下来将介绍数据透视表，这是数据探索（EDA）和分析的重要工具。我们将准备原始数据进行分析，创建不同视图以切片和切块数据，并应用排序、分组和计算字段等工具。此外，我们还会深入数据可视化和讲故事的世界，审视有效设计的最佳实践，并使用条形图、列图、折线图、面积图、散点图和地图等可视化工具让数据生动呈现。 最后，我们将演示Google Sheets独特的共享与协作功能，包括评论、通知、编辑历史、工作表保护等。 课程大纲： 1. Google Sheets 入门：介绍Google Sheets，创建和管理电子表格，探索其界面，回顾重要设置，并与Microsoft Excel进行对比。 2. 电子表格基础：涵盖数据素养概念，如表格、单元格引用、排序与筛选、数据类型、格式设置等。 3. 公式与函数：介绍在Google Sheets中处理数据所需的基本公式和函数，包括数学、逻辑、文本、日期和查找函数，以进行数据准备和分析。 4. 数据透视表数据分析：探讨如何使用数据透视表探索和分析数据，这是Google Sheets的重要“拖放”工具，可无需公式或函数即可进行计算。 5. 数据可视化：讨论如何使用图表和图形可视化数据，包括如何识别合适的图表类型，如何正确格式化以及如何用图表讲故事。 6. 共享与协作：介绍Google Sheets的共享与协作选项，包括与他人共享电子表格、实时协作、设置通知等。 准备好立即开始学习了吗？加入我们，您将获得以下内容的终身访问权： - 6小时高质量视频 - 6个课程测验 - Google Sheets电子书（100多页） - 可下载的项目文件和解决方案 - 专家支持和问答论坛 - 30天满意保证 如果您准备好通过Google Sheets建立强大且实用的数据素养和分析技能，这就是适合您的课程。 祝您学习愉快！- Enrique Ruiz（Excel与Google Sheets讲师，Maven Analytics） 此外，想要查看我们的完整课程库？搜索“Maven Analytics”以浏览我们完整的Excel、Power BI、SQL、Tableau、Python、Alteryx和机器学习课程集合！
This is a hands-on, project-based course designed to help you build the skills you need to manage, explore, analyze, and visualize data in Google Sheets.We'll start by introducing the Google Sheets interface and workflow, then dive into spreadsheet fundamentals like table structures, data types, formatting, sorting and filtering.From there we'll dig into formulas and functions for data analysis, introduce key topics like syntax, reference types, and common errors, and practice applying some of the most common and powerful techniques for data management and analysis. We'll use functions to count and aggregate values, create logical tests, join data across tables, manipulate text and date values, and more.Next we'll introduce Pivot Tables, an essential spreadsheet tool for data exploration (EDA) and analysis. We'll prepare raw data for analysis, create views to slice and dice the data, and apply tools like sorting, grouping, and calculated fields. We'll also dive into the world of data visualization and storytelling, review best practices for effective design, and bring our data to life using visuals like bars and columns, line and area charts, scatterplots and maps.Last but not least, we'll demonstrate some of Google Sheets' unique sharing and collaboration features, including comments, notifications, edit history, sheet protection, and more.COURSE OUTLINE:Intro to Google SheetsIn this section we'll introduce Google Sheets, create & manage spreadsheets, explore its interface, review important settings, and draw comparisons with Microsoft ExcelSpreadsheet FundamentalsIn this section we'll cover spreadsheet fundamentals, including data literacy concepts like tables, cell references, sorting & filtering, data types, formatting, and moreFormulas & FunctionsIn this section we'll introduce essential formulas & functions you need to work with data in Google Sheets, including math, logical, text, date, and lookup functions for data prep and analysisData Analysis with Pivot TablesIn this section we'll cover exploring & analyzing data with pivot tables, Google Sheets' essential "drag & drop" tool that lets you perform calculations without formulas or functionsData Visualization with Charts & GraphsIn this section we'll cover visualizing data with charts & graphs, including how to identify the right chart type, how to format it properly, and how to use it to tell a storySharing & CollaborationIn this section we'll cover Google Sheets' sharing & collaboration options, including sharing spreadsheets with others, collaborating in real time, setting notifications, and more__________Ready to dive in? Join today and get immediate, LIFETIME access to the following:6 hours of high-quality video6 course quizzesGoogle Sheets ebook (100+ pages)Downloadable project files & solutionsExpert support and Q & A forum30-day Udemy satisfaction guaranteeIf you're ready to build powerful, practical data literacy and analytics skills with Google Sheets, this is the course for you.Happy learning!-Enrique Ruiz (Excel & Google Sheets Instructor, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!
