|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-analysis-using-excel/
课程评论：没有评论
课程名称：研究人员数据分析基础：使用Excel 课程概述：构建扎实的Excel技能 Excel是分析和可视化数据的最广泛使用的工具之一。它现在包含了用于分析更多数据的工具，并改进了可视化效果和更复杂的逻辑。Excel是全球最受欢迎的数据分析工具，各公司和机构利用它将大量原始数据转化为清晰的洞见。扎实的Excel技能能够开启新的职业道路，提高在各行各业的就业能力，并节省日常任务中的时间。 实践使用Excel与实际数据集 在本课程中，您将培养可就业的数据分析师技能，从Excel基础知识开始，了解Excel的功能以及应遵循的数据分析步骤。课程开始时将探讨数据的使用，如何导航工作表，以及如何修整和分类数据类型。您将使用真实世界的数据，通过新的Excel技能分析成功项目的关键要素。 学习如何使用VLOOKUP 课程的其他部分将教您如何通过提取文本、准备日期数据以及使用Excel公式来整理数据。您将学习Excel中最重要的功能：VLOOKUP，如何结合来自不同来源的数据。这些Excel技能、函数和节省时间的捷径可应用于任何行业，无论您是希望转向数据分析领域，还是希望在营销、财务、人力资源、物流等领域提升技能。
Build Strong Excel SkillsExcel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated logics. Excel is the world's most popular data analysis tool. Companies and institutions worldwide use it to transform mountains of raw data into clear insights. Strong Excel skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks.Practice Using Excel with Practical DatasetsIn this course, you'll develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow.The sections begin by exploring data; navigate your worksheet and trim and classify your data types. You'll even work with real-world data to use your new-found Excel skills to analyze what makes a successful project.Learn How to Use VLOOKUPOther sections in this course will teach you how to prepare your data by extracting text, preparing date data, and which Excel formulas can help. You'll learn to use the most important function in Excel: VLOOKUP to combine data from different sources.These Excel skills, functions, and time-saving shortcuts can be applied to any industry, whether you're looking to move to a career in data analysis, or looking to improve your skills in marketing, finance, HR, logistics, and more.
