|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analytics-in-excel/
课程评论：没有评论
课程名称：《Excel完全数据分析课程》 课程概述： 您是否认为需要学习新软件才能进行数据分析、统计和模拟？其实您不需要！进行数据分析所需的一切功能都已在您电脑上的Excel中。此课程首先将向您介绍Excel环境，包括如何使用简单和复杂的函数、热键快捷方式和导航技巧，以确保您高效、有效地工作。在此基础上，我将通过讲座和实践练习，带您学习数据分析的基本主题。 1. **数据可视化**：数据可视化是分析数据、展示和解释其意义的重要部分。本课程将讲解如何制作和使用条形图、折线图、径向图、直方图、箱线图、饼图、条件格式和Sparkline。 2. **数据透视表**：数据透视表是Excel中强大且易于使用的工具。课程将介绍如何结构化数据以充分利用数据透视表，并包括根本原因分析、比较分析等使用案例。 3. **统计学**：统计学模块是本课程内容最丰富的部分。作为一名统计学专业的讲师，我将深入探讨统计背后的数据以及如何根据不同情况使用不同的统计测试。该模块包含多个关于方差分析、T检验、卡方检验、正态性测试、回归分析等讲座和练习。 4. **预测**：组织需要能够预测未来。本课程中介绍的预测工具帮助实现这一目标。预测分为两种方式：因子预测和时间序列预测，并介绍了包括回归分析、蒙特卡洛模拟、简单移动平均和自回归技术等多种工具和技术。 5. **Excel工具**：Excel中有很多有用的工具不符合其他模块的定义。课程的最后一个模块探讨这些工具的使用案例，特别是引入并解决一些典型问题，使用Excel中的杂项数据分析工具，包括Excel求解器。 通过此课程，您将掌握使用Excel进行数据分析的必要技能，无需额外的软件支持。
Do you think you need to learn new software to perform data analysis, statistics, simulations? You don't! Everything you need to get started in the world of data analytics is already on your computer in the wonderful application called Excel.This course will first acquaint you with the Excel environment including how to use simple and complex functions, hot-key shortcuts and navigation tips to make sure you work efficiently and effectively. From there, I lead you in lectures and practice exercises on the fundamental topics of data analytics.Data Visualizations - Visualizing data is an important part in analyzing data as well as presenting and explaining what it means. Lectures in this course Included how to craft and use bar charts, line charts, radial charts, histograms, box and whisker charts, pie charts, conditional formatting and Sparklines.Pivot Tables - Pivot Tables are very powerful, simple to use tools built into excel. The lectures will include how to structure data to get the most out of pivot tables, and then a few use cases including root cause analysis, comparative analysis, along with other visualization tools specific to pivot tables.Statistics - The Statistics module is by far the most densely packed module in this course. As a statistician by training, I present a deep dive into the data behind the statistics and how to use different statistical tests based on different circumstances. The module is filled with different lectures and exercises involving ANOVA tests, T Tests, Chi-Squared Tests, Tests for Normality, Regression Analysis and more.Forecasting - Organizations have to be able to anticipate the future. The forecasting tools presented in this course help us accomplish this feat. Forecasting is presented in two different ways - Factor forecasting and Time Series forecasting. For each approach to forecasting, many tools and techniques are introduced and reviewed including Regression analysis, Monte Carlo Simulation, Simple Moving Averages, and Auto-Regressive techniques. Excel Tools - Excel has a lot of useful tools that don't quite fit neatly into any of the other modules. The last module of this course explores the use cases of using these tools. In particular, several archetypal problems are introduced and solved using the miscellaneous data analysis tools found in excel, including Excel Solver.
