|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-excel/
课程评论：没有评论
**课程名称：** Microsoft Excel 2010：高级培训 **课程概述：** 本课程紧随 Excel 2010 入门课程之后，旨在帮助学员深入掌握这款强大的电子表格软件的进阶功能和函数。学员将学会如何嵌套 IF 语句，以及如何使用 AVERAGEIF、SUMIF 等函数计算一组数字的平均值。课程还将教授如何利用 HLOOKUP 和 VLOOKUP 进行查找，深入讲解数据透视表和图表，并介绍 Sparklines（迷你图）。最终，学员将掌握如何创建和录制自定义宏。 **适用人群：** 本课程适合已有 Excel 基础知识，并希望进一步提升技能的学习者，**不适合初学者**。 **学习目标：** 完成本课程后，学员将能够熟练运用 Microsoft Excel 2010 的高级功能和函数，并获得可验证的结业证书。 **学习资料：** 课程提供配套的练习文件，方便学员跟随视频教程进行实践操作。
A Verifiable Certificate of Completion is presented to all students who undertake this Excel course. This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software. Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros. This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.
