|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-2016-intermediate/
课程评论：没有评论
**课程名称：** Mastering Excel 2016 - Intermediate **课程概述：** 本课程旨在帮助您成为Microsoft Excel 2016的精通者，掌握数据管理、图表制作及表格分析的高级技能。Excel是现代商业环境中不可或缺的工具，无论是在整理列表、创建复杂报表，还是在进行财务决策、库存管理等方面都发挥着重要作用。本课程将巩固您的Excel基础知识，并重点教授如何利用Pivot Tables、Pivot Charts、Slicers和Timelines等强大工具，深入分析和可视化数据。 **课程亮点：** * **全面覆盖Excel 2016高级功能：** 适用于已掌握Excel基础知识的学习者。 * **实战应用导向：** 教授如何管理数据、创建和修改图表与表格，以及运用各种函数（逻辑、文本、日期等）进行复杂计算。 * **掌握数据分析利器：** 深入学习Pivot Tables、Pivot Charts、Slicers和Timelines等工具，实现高效的数据筛选、汇总和交互式分析。 * **提升效率与决策力：** 了解如何使用命名区域和数组公式，以及条件格式化等功能，优化工作流程。 * **优质高清内容：** 提供超过三小时的“独具吸引力”TM Bigger Brains师生互动式教学视频。 * **备考Microsoft Office Specialist 77-727：** 结合基础和高级课程，可覆盖Microsoft Office Specialist exam 77-727的所有考试目标。 **课程主题包括：** * 命名区域与公式应用 * 逻辑、文本、日期及其他函数的使用 * 数据排序、筛选与汇总 * 图表与表格的创建和修改 * Pivot Tables与Pivot Charts的创建 * 条件格式化应用 * Slicers与Timelines数据分析 无论您是想提升个人工作效率，还是希望在职业生涯中获得竞争优势，本课程都将助您一臂之力，让您快速掌握Excel的精髓。
The world is filled with two kinds of people: A handful of people who are masters of Excel, and the millions of others who wish they wereWhen you master Microsoft Excel 2016, you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet expert can work wonders - from organizing lists to creating multi-layered, interactive reports. Spreadsheets can help businesses make decisions on critical issues involving accounting, budget allocations, expenditures, and inventory. This course builds on your existing knowledge of Excel and teaches you how to manage data, charts, and tables, including using tools such as Pivot Tables, Pivot Charts, Slicers, and Timelines.Excel is our most requested training course! Once you learn Excel, you'll quickly see how useful it is in your life - from formatting your grocery list to calculating complex ROI values. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Barbara Evers walk you through additional features offered in Microsoft Excel 2016.Topics covered include:Working with named ranges and formulasUsing Logical, Text, Date, and other functionsSorting, filtering, and summarizing dataCreating and modifying charts and tablesCreating Pivot Tables and Pivot ChartsUsing Conditional FormattingAdding Slicers and Timelines to analyze informationQuickly search and find the skills you want to master-then just point, click, and learn.Enjoy over three hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Note: When combined with the Basics and Advanced versions of this course, you will cover all the objectives required in the Microsoft Office Specialist exam 77-727
