|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-365-intermediate-2022/
课程评论：没有评论
课程名称：掌握 Excel 365 - 中级（2022） 课程概述： 本课程旨在教授学员如何有效使用 Microsoft Excel 进行数据分析和共享。Excel 作为职场中最受欢迎的数据分析工具，掌握其使用技巧对任何商业专业人士都是一种重要技能。在课程中，您将学习到多种工具，以便对数据进行修改和优化工作簿。Excel 专家凯西·琼斯将教您如何嵌套函数、修改和格式化图表。您还将学习如何通过添加迷你图（sparklines）、图片和 SmartArt 来增强可视化效果。 课程内容包括： - 使用快速填充、文本分列和分组模式处理数据 - 运用查找和替换、校对选项及研究工具来优化工作簿 - 修改工作簿视图 - 对文本、数字和日期应用条件格式 - 应用自定义数字格式 - 使用嵌套函数、逻辑函数和统计函数 - 修改和格式化图表 - 添加迷你图、图片和 SmartArt - 修改表格、数据透视表和网络查询 - 共享工作簿及使用超链接、变更跟踪和评论等工具增强共享体验 - 使用目标搜索和数据表分析数据 该课程提供超过三个半小时的高质量高清内容，以“独特引人入胜”TM 的教学风格呈现，适合希望提升 Excel 技能的学员。
Learn many of Excel's tools for analyzing and sharing your data.Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you'll learn great tools to modify your data and refine your workbook. Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. You'll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you'll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.And if you need to know more about forecasting, you'll learn how to conduct What-If analysis using Excel's special features.Topics covered include:Using Flash Fill, Text to Columns, and Group Mode to work with your dataUsing editing features such as Find and Replace, proofing options, and research tools to refine your workbookModifying workbook viewsApplying conditional formatting to text, numbers, and datesApplying custom number formattingUsing nested, logical, and statistical functionsModifying and formatting chartsAdding sparklines, pictures, and SmartArtModifying Tables, PivotTables, and web queriesSharing workbooksUsing tools to enhance sharing such as hyperlinks, track changes, and commentsAnalyzing data with Goal Seek and Data TablesOver three and a half hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
