|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-analytics-for-business-professionals/
课程评论：没有评论
课程名称：使用 Power Query 在 Excel 中准备分析数据 概述：在这个 Excel 职业数据分析培训课程中，您将全面了解 Microsoft Excel 这一数据分析领域的强大工具。本课程首先介绍 Microsoft Excel 及其关键功能。随后，您将掌握 Excel 函数和公式，这对执行计算和数据处理至关重要。课程接着讲解在 Excel 中处理数据、连接外部数据库，以及使用 Power Query 进行高级数据清理和转换。此外，课程中还将重点讲解使用数据透视表进行探索性数据分析，数据透视表在总结和分析大数据集方面发挥着重要作用。最后，课程将关注使用 Power Pivot 进行数据建模和分析，帮助您创建复杂的数据模型并进行高级分析。此课程专为希望使用 Excel 进行专业数据分析的人士设计。 课程概览：从入门到精通，无需具备商业智能和分析方面的先前知识或经验。课程适合对这些领域感兴趣的初学者。学员在培训结束后仍可无限访问课程材料，还提供可下载的内容和动手练习。 注意：该培训项目结构分为六个关键部分，旨在增强您对 Microsoft Excel 的熟练度。
In the Professional Data Analytics Training in Excel course, you will embark on a comprehensive journey through the powerful features of Microsoft Excel, a leading tool in data analytics. The course begins with an introduction to Microsoft Excel and an exploration of its key features. You will then gain proficiency in Excel functions and formulas, essential for performing calculations and data manipulations. The program goes on to cover working with data in Excel, connecting to external databases, and engaging in advanced data cleaning and transformation using Power Query. Furthermore, a significant portion of the course is devoted to exploratory data analysis using PivotTables, which are instrumental in summarizing and analyzing large datasets. The course concludes with a focus on data modeling and analysis using Power Pivot, empowering you to create complex data models and perform advanced analytics. This course is designed for people who want to use Excel for professional data analysis. Course Overview:Beginner to ProNo prior knowledge or experience in business intelligence and analytics is required. The course is designed for beginners who are interested in learning about these fields.Students will have unlimited access to course materials even after the training ends.Downloadable contentHands-on exercisesNote: This comprehensive training program is structured into six key parts, each designed to enhance your proficiency with Microsoft Excel.
