|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel365-intermediate/
课程评论：没有评论
**课程名称：** Microsoft Excel 365 中级 **课程概述：** 本课程专为希望深入探索Excel 365强大功能、提升电子表格技能的学习者设计。课程提供可下载的讲师和练习文件，便于学员同步学习和实践。 **核心学习内容：** * **电子表格设计与优化：** 学习使用单元格样式设计更具可读性、便于数据管理的电子表格。 * **逻辑函数与决策：** 掌握AND、OR、IF等逻辑函数，用于做出更优决策和精简数据分析。 * **数据检索与分析：** 熟练运用VLOOKUP、INDEX/MATCH等查找公式进行数据检索，并学习使用排序和筛选技术高效组织数据。 * **进阶统计与数学函数：** 探索统计和数学函数，轻松执行复杂计算，并学习专业的数据呈现格式化技巧。 * **日期、时间、文本与数组处理：** 学习处理日期、时间、文本及数组，实现全面的数据操作。 * **数据透视表与数据透视图：** 深入了解数据透视表和数据透视图的分析能力，实现动态数据分析和可视化。学习如何为数据透视表和图表添加交互性，提升报告的吸引力。 * **公式审核与数据验证：** 掌握公式审核和数据验证技术，确保工作中的准确性和可靠性。 * **假设分析：** 学习使用PMT、单目标搜索和数据表等假设分析工具，进行场景预测和明智决策。 * **数据处理与识别：** 学习使用条件格式和公式识别和处理重复数据。 * **数值处理：** 掌握数值取整及运用Excel的数学函数进行特殊取整。 * **统计函数应用：** 了解并应用平均值、中位数、众数等统计函数。 **课程亮点：** * 包含9小时的视频教程，共计97个独立视频讲座。 * 提供同步学习的课程和练习文件。 * 完成课程后可获得结业证书。 **课程目标：** 学完本课程后，您将能够高效管理数据，执行复杂的数据分析，并在Microsoft Excel 365中创建引人入胜的数据报告，将您的Excel专业技能提升到一个新的水平。
**This course includes downloadable course instructor files and exercise files to work with and follow along.**In this Microsoft Excel 365 Intermediate course, you'll delve deeper into Excel's powerful features to enhance your spreadsheet skills. You'll learn to design better spreadsheets for improved readability and efficient data management.You'll explore logical functions to make better decisions and streamline data analysis, work with lookup formulas for data retrieval, and master sorting and filtering techniques to organize data effectively.Furthermore, you'll explore advanced features like statistical and mathematical functions, enabling you to perform complex calculations effortlessly. Gain insights into formatting techniques to present your data professionally. You'll also learn to handle date, time, text, and arrays for comprehensive data manipulation.You'll also explore the analytical capabilities of PivotTables and Pivot Charts, empowering you to analyze data dynamically and create insightful visualizations. Additionally, you'll learn to add interaction to PivotTables and Charts, making your reports more interactive and engaging.Formula auditing and data validation techniques will ensure accuracy and reliability in your work. Finally, you'll discover what-if analysis tools to forecast scenarios and make informed decisions.By the end of this course, you should have the skills to efficiently manage data, perform complex analyses, and create compelling reports in Microsoft Excel 365. Join us to take your Excel proficiency to the next level.In this course, you will learn how to:Design spreadsheets for improved readability using cell styles.Implement data validation for accurate input control.Utilize logical functions like AND, OR, and IF for decision-making.Perform lookup operations using VLOOKUP and INDEX/MATCH.Sort and filter data efficiently using built-in Excel functions.Identify and handle duplicates in data using conditional formatting and formulas.Round values and perform special rounding using Excel's math functions.Apply statistical functions such as mean, median, and mode.Analyze data using PivotTables and Pivot Charts for insights.Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.This course includes:9 hours of video tutorials97 individual video lecturesCourse and exercise files to follow alongCertificate of completion
