|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/infotrek-excel-intermediate/
课程评论：没有评论
**课程名称：** Microsoft Excel 进阶 **课程概述：** 本课程适合所有级别的文员、职员、高管、主管、行政人员、经理以及所有已掌握基础Excel知识并希望进一步提升其知识和实际应用能力的人员。 **先修要求：** * 已完成Microsoft Excel 基础级别课程；**或** * 能够切换任务应用程序； * 能够创建具有基本格式的电子表格； * 能够创建基本图表； * 能够添加页眉和页脚打印电子表格； * 能够应用冻结窗格命令； * 能够创建基本公式（加、减、乘、除）； * 能够使用基本函数（自动求和、计数、最大值、最小值、平均值）。 **课程目标：** 完成本课程后，学员将能够： * 创建简单到复杂的公式和函数，例如：COUNTIF、AVERAGEIF、SUMIF、IF、VLOOKUP 函数。 * 使用自动筛选功能筛选数据。 * 创建图表。 * 应用条件格式。
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel. Basic knowledge of Microsoft Excel is essential with the following pre-requisites: Have attended Microsoft Excel - Foundation Level; OR Able to switch between task applications Able to create a spreadsheet with simple formatting Able to create a basic chart Able to print a spreadsheet with headers and footers added Able to apply Freeze Pane command Able to create basic formulas - Addition, Subtraction, Multiplication and Division Able to use basic functions - AutoSum, Count, Max, Min and Average functions. Upon completion of this program, participants should be able to: Create simple to complex formulas and functions, like: COUNTIF Function AVERAGEIF Function SUMIF Function IF Function VLOOKUP Function Filter data using Auto Filters Create Chart Apply Conditional Formatting
