|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-google-sheets-pivot-tables-and-charts/
课程评论：没有评论
课程名称：Google Sheets数据透视表完全入门 课程概述：Google Sheets提供了许多传统电子表格产品的功能，并正成为一种极受欢迎的数据分析和报告工具。Google Sheets允许用户轻松设置和分享云端数据与信息。本课程将探讨Google Sheets最强大的功能之一——数据透视表。您将学习如何通过简单的鼠标点击轻松创建强大的数据透视表和图表。本课程主要面向希望学习如何让Google Sheets为他们工作的人，无需编写复杂的公式或函数即可实现数据分析。 课程内容和成果： - 学习正确结构化您的数据 - 创建数据透视表，汇总和聚合您的数据 - 使用不同的计算方法：求和、计数、唯一计数、平均值、中位数、最大值、最小值 - 创建自己的强大自定义计算 - 进行时间/趋势分析 - 创建时间/趋势分析图表 - 过滤数据并提出问题 - 贡献分析：百分比 - 贡献分析：图表 - 分析人力资源数据：创建强有力的报告 - 学习分组年龄和工资数据 - 对数据应用条件格式 关于讲师：我是一名拥有超过20年培训和管理咨询经验的Udemy讲师合作伙伴。我专注于培训业务用户学习强大的方法和技术，将数据转化为有用的信息和智能，以及学习强的数据分析方法论，使用Microsoft Excel、Microsoft Power BI、Looker Studio（前身为Google Data Studio）、Amazon QuickSight和ChatGPT。 学生评价：本课程真是太棒了，易于理解且案例跟随简单。课程内容的章节大小恰到好处，讲师在每个主题中讲解得非常清晰，易于消化。Ian是一位出色的培训师，课程易于跟随，并提供了实用的实践经验。我对包含真实人力资源数据分析的部分感到惊讶，这非常有帮助。我希望能看到更加适合人力资源专业人士的课程。我获得了关于创建强大报告和数据分析的巨大洞见，非常感谢！ 数据分析课程路线图：随着技术行业的不断发展，人工智能、机器学习和大数据领域的重大投资带来了对数据分析师日益增长的需求。拥有正确的技能并采取积极的态度，数据分析师可以达到前所未有的高度！我目前在Udemy上提供14门涵盖各种工具和技能的数据分析课程，帮助您自信地探索数据分析的动态领域，获得数据解读的宝贵技能，并推动智能数据驱动的决策。
Google Sheets offers many of the features of traditional spreadsheet products and is becoming an extremely popular tool for data analysis and reporting. Google Sheets makes it easy to setup and share data and information within the cloud.In this course we explore one of the most powerful features of Google Sheets which is Pivot Tables. You will learn how to easily create powerful Pivot Tables and Graphs using a few clicks of the mouse.This course is primarily for people who want to learn how to get Google Sheets to do the work for them, without having to write complicated formulas or functions to achieve data analysis.COURSE CONTENT AND OUTCOMESLearn to correctly structure your dataCreate Pivot Tables to summarize and aggregate your dataUsing Different Methods of Calculation - Sum,Count, Unique Count, Average, Median, Max, MinCreate your own powerful custom calculationsCreate Time / Trend AnalysisTime / Trend Analysis graphsFilter and ask questions of your dataContribution Analysis - percentagesContribution Analysis - graphsAnalyze Human Resource data - Create powerful reportsLearn to group Age and Salary dataApply conditional formatting to dataABOUT THE TRAINERI am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.WHAT STUDENTS ARE SAYINGThis course is really amazing i would say it's easy to understand and to follow the examplesThe size of the lessons are perfect, the instructor moves very clearly throughout each topic. Very easy to digest.Ian is a phenomenal trainer. The course is easy to follow, digest, and provides practical hands on experience. I was so surprised to see real world human resource data analysis included, which was super helpful. I would love to see this course for HR professionals. I've gained a tremendous amount of insight to creating powerful reports and data analysis. Thank you!DATA ANALYSIS COURSES ROADMAPThe tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.Microsoft ExcelIntroduction to Analyzing Data with Excel Pivot TablesComplete Introduction to Excel Power PivotComplete Introduction to Excel Power QueryExcel Interactive Dashboards and Data AnalysisComplete Introduction to Business Data AnalysisTables and Formulas with ExcelMicrosoft Power BIComplete Introduction to Microsoft Power BIComplete Introduction to Power BI Query EditorPower BI Master Class-Data Models and DAX FormulasPower BI Master Class - Dashboards and Power BI ServiceGoogleComplete Introduction to Google Sheets Pivot TablesComplete Introduction to Looker Studio (formerly Google Data Studio)Amazon QuickSightComplete Introduction to Amazon QuickSightChatGPTIntroduction to Analyzing Data with ChatGPT
