|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analytics-with-microsoft-excel/
课程评论：没有评论
**课程名称：** 使用 Microsoft Excel 进行数据分析入门 **课程概述：** 本课程旨在帮助学员掌握利用 Microsoft Excel 进行数据分析的核心技能。通过提供可下载的 instructor files，学员可以同步练习。数据分析是当今市场发展最快的领域之一，但企业却普遍面临合格人才短缺的困境。本课程将深入探讨 Excel 作为数据分析工具的关键特性，教授如何高效地从组织收集的信息中提取最大价值。 课程从基础讲起，涵盖电子表格的布局、应用、公式、数据清洗以及数据属性识别等内容。学员将学会如何使用 Excel 分析数据，解决复杂的数据问题，并通过 Excel 图表来可视化数据、揭示数据间的关系及潜在结果。此外，课程还将介绍 Excel 内置的 Analysis ToolPak 加载项中的“假设分析”功能。每部分都包含实际案例，帮助学员将所学技术应用于真实世界的商业问题。 **课程主要内容包括：** * Excel 电子表格的基础知识，包括布局和应用。 * 在 Excel 中查看、输入和格式化数据类型。 * 理解和应用 Excel 公式与函数。 * 导入文件数据并进行重复数据删除。 * 识别数据属性。 * 排序数据和应用筛选（包括高级筛选）。 * 使用“合并字符”和“Sum-if”公式分析数据集。 * 创建问题陈述以解决复杂的“或”条件。 * 创建数据透视表和数据透视图。 * 使用 Excel 图表，如簇状柱形图、折线图和瀑布图。 * 利用专门为处理大型数据集而设计的数据库函数。 * 识别和避免公式错误的技术。 * 理解和使用“假设分析”工具包，包括方案管理器、单目标查找和数据表。 * 使用 Analysis ToolPak 计算基本统计概念，如相关性和协方差。 * 计算描述性统计量、移动平均值以及应用指数平滑技术。 * 利用排名和百分位数选项，并生成直方图。 **课程亮点：** * 超过 4 小时的视频教程。 * 36 个独立的视频讲座。 * 提供课程文件供学员跟随练习。 * 完成课程可获得证书。
**This course includes downloadable instructor files to work with and follow along.**One of the most rapidly developing areas in today's market is data analytics-it is also an area in which businesses are struggling to find qualified staff. In this course, we will explore the key features of Microsoft Excel that make it such an essential tool for data analytics. Using the data analysis and visualization features that are native to Excel, this course will show you how to extract maximum value most efficiently from the information your organization collects. This course starts off with the fundamentals, walking you through all you need to understand about spreadsheets, from layout to applications. We will cover a variety of topics, including exploring formulas, cleaning data, and identifying data attributes. This course demonstrates how to analyze data using Excel and tackle complicated criteria. We will use Excel charts to depict data, relationships, and potential outcomes. In addition, we will also be discussing how to use the what-if functionality of the Analysis ToolPak add-in that comes with Excel. Each section includes practical examples that show how to apply these techniques to real-world business problems.After finishing this course, students will be able to:Describe the fundamentals of Excel spreadsheets, from their layout to the applicationsView, enter, and format data types in ExcelUnderstand and apply Excel formulas and functionsImport file data and remove duplicatesIdentify data attributesSort data and apply filters, including advanced filtering techniquesApply Concatenation and Sum-if formulas to analyze data setsCreate problem statements to tackle complicated "or" criteriaCreate Pivot tables and chartsWork with Excel charts, including clustered columns, line graphs, and waterfallsUtilize database functions created specifically to work with large datasetsApply techniques to recognize and avoid formula errorsUnderstand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functionsUse the Analysis ToolPak to calculate basic statistical concepts such as correlation and covarianceCompute descriptive statistics and moving averages and apply exponential smoothing techniquesUtilize rank and percentile options and generate histograms.This course includes:4+ hours of video tutorials36 individual video lecturesCourse files to follow alongCertificate of completion
