|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-data-analysis-using-microsoft-excel-basics-fast/
课程评论：没有评论
**课程名称：** 快速学习微软Excel数据分析基础 **课程概述：** 本课程旨在快速教授学员使用微软Excel进行数据分析的基础知识。课程强调了学习数据分析和数据科学的重要性，包括： * **提升解决问题的能力：** 培养分析性思维，有效应对职场和生活中的问题。 * **高市场需求：** 数据分析师和数据科学家的需求日益增长，尤其在数字化转型加速的当下。 * **应用无处不在：** 数据分析已渗透到各行各业，帮助企业优化流程、挖掘价值。 * **重要性日益提升：** 面对海量数据，数据分析师在企业决策中的作用愈发关键，带来更多就业机会。 * **技能广泛性：** 数据分析涉及计算机科学、商业、数学等多个领域，并需要良好的沟通能力。 课程将采用CRISP-DM模型，专注于**数据理解**（数据可视化、统计、数据分析）和**数据准备**（处理缺失值、去重）的Excel操作。 **先决条件：** 具备基础的计算机知识和微软Excel的基础操作能力（可先学习“快速学习微软Excel基础”课程）。 **课程内容亮点：** * **入门：** 数据集下载、CSV文件读取。 * **数据挖掘流程：** 掌握一系列Excel功能，包括各种图表（折线图、柱状图、饼图、散点图、组合图）的插入。 * **数据分析工具：** * **数据透视表与数据透视图：** 强大的数据汇总和分析工具。 * **数据分析插件：** 介绍并使用Excel的数据分析插件。 * **描述性统计：** 计算均值、中位数、标准差等。 * **图表分析：** 直方图、相关性、协方差。 * **假设检验：** t检验（配对样本、相等方差、不等方差）、F检验、方差分析（单因素、双因素无重复）。 * **回归分析：** 预测和关系分析。 * **数据准备：** 去除重复值、处理缺失值、排序数据、筛选数据。 **证书信息：** 可通过EMHAcademy参加考试，获得SVBook微软办公与Excel数据分析高级证书。 **配套课程系列：** 学习本课程可与“快速学习微软Word基础”、“快速学习微软PowerPoint基础”、“快速学习微软Excel基础”打包学习，系统掌握微软Office应用。
Why learn Data Analysis and Data Science?According to SAS, the five reasons are1. Gain problem solving skillsThe ability to think analytically and approach problems in the right way is a skill that is very useful in the professional world and everyday life. 2. High demandData Analysts and Data Scientists are valuable. With a looming skill shortage as more and more businesses and sectors work on data, the value is going to increase. 3. Analytics is everywhereData is everywhere. All company has data and need to get insights from the data. Many organizations want to capitalize on data to improve their processes. It's a hugely exciting time to start a career in analytics.4. It's only becoming more importantWith the abundance of data available for all of us today, the opportunity to find and get insights from data for companies to make decisions has never been greater. The value of data analysts will go up, creating even better job opportunities. 5. A range of related skillsThe great thing about being an analyst is that the field encompasses many fields such as computer science, business, and maths. Data analysts and Data Scientists also need to know how to communicate complex information to those without expertise.The Internet of Things is Data Science + Engineering. By learning data science, you can also go into the Internet of Things and Smart Cities. This is a bite-size course to learn Data Analysis using Microsoft Excel fasts. This course will use CRISP-DM model, and we will go through Data Understanding (Data visualization, Statistics, Data analysis) and Data Preparation (Removing Missing values and removing duplicates) using Microsoft Excel. You will need to know some computer knowledge before learning this course and you need to know Microsoft Excel before learning also. You can learn Microsoft Excel in my course "Learn Microsoft Excel Basics Fast". You can take the course as follows and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel: - Learn Microsoft Word Basics Fast- Learn Microsoft Powerpoint Basics Fast- Learn Microsoft Excel Basics Fast- Learn Data analysis using Microsoft Excel Basics Fast. ContentGetting StartedDownload DatasetRead CSVData Mining ProcessInsert Lien CHartInsert Bar ChartInsert Pie ChartInsert ScatterplotInsert Combo ChartPivot TableInsert Pivot Table and Pivot ChartData Analysis PluginsData Analysis PLugins 2Descriptive StatisticsHistogramCorrelationCovarianceTTest Two Samples Paired for meansTTest Two Samples Equal VariancesTTest Two Samples Unequal VariancesF Test Two Samples for VariancesANOVA Single FactorANOVA Two Factor WIthout ReplicationRegression AnalysisRemove DuplicatesRemove MissingSort DataFilter Data
