|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/cwexcel-2007-advanced/
课程评论：没有评论
Coursera 上的 Excel 2007 - 高级课程总结： 本课程建立在 Excel 入门和中级课程的基础上，旨在帮助学员深入分析和管理数据。 **主要内容包括：** * **数据分析工具：** 学习运用公式审计、单向目标分析、方案管理器和分类汇总等 Excel 内置的数据分析工具。 * **高级函数：** 掌握并应用更复杂的 Excel 函数。 * **条件格式：** 学会如何应用条件格式美化和区分数据。 * **数据筛选与管理：** 提升数据列表的筛选和管理能力。 * **数据透视表与数据透视图：** 创建并操作数据透视表和数据透视图，以更直观地分析数据。 * **宏录制：** 学习录制基本宏，自动化重复性任务。 **课程特色：** * 由 Intellezy 提供，拥有近 10,000 个视频课程，涵盖桌面应用、技术概念和商务技能。 * 课程内容生动且包含评估，可用于学习前后的知识水平测试。 * 课程内容定期更新，确保信息和技术的时效性。 * 支持内部开发，可快速适应并创建定制化内容。 **认证与学分：** * 本课程符合 CAP Body of Knowledge，可在“技术与信息分发”内容领域获得 3 个重新认证点。 * 完成课程后，请发送完成证明至 info@intellezy.com 以获取证书。
This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros.With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
