|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-intermediate-course-z/
课程评论：没有评论
Coursera 课程《精通 Excel：中级篇》 **课程概述：** 本课程是 Excel 中级水平的进阶学习。您将学习使用 Excel 的高级功能和函数来创建、分析和呈现数据。课程还将涵盖如何自动化任务、处理多个工作表和工作簿、使用数据验证和保护工具。完成本课程后，您将能够： * 应用条件格式和自定义数字格式，美化工作表。 * 使用 IF、VLOOKUP、SUMIF、COUNTIF 等公式和函数进行复杂计算和数据分析。 * 创建和修改图表、迷你图和切片器，以可视化和汇总数据。 * 使用数据透视表和数据透视图来组织和处理大型数据集。 * 链接、合并和分组来自多个工作表和工作簿的数据。 **目标学员：** 本课程适合希望提升 Excel 技能和生产力的中级用户。建议学员已完成 Excel 1 级课程或具备同等知识和经验。同时，需要使用安装有 Excel 2016 或更高版本的计算机。 **课程内容（部分）：** * 条件格式 * 平均值、计数、最大值、最小值、求和、SUMIF 函数 * 基本方案 * 工作表布局和设计 * 命名单元格/区域 * 绝对引用/百分比 * 基本数据透视表 * 使用三维引用 * 目标搜索 * 数据表 * 工作表和单元格保护 * 链接工作表和工作簿 * 使用数组公式 * 使用分组和分级显示/保存视图 * 命名工作表 * 使用 SUBTOTAL 功能 * 创建模板 * 基本查找/基本 IF 函数 **先修要求：** Excel Level 1 或同等技能。 **所需软件：** Excel 2016 或更高版本。
Welcome to the course on Excel level 2. In this course, you will learn how to use advanced features and functions of Excel to create, analyze, and present data. You will also learn how to automate tasks, work with multiple worksheets and workbooks, and use data validation and protection tools. By the end of this course, you will be able to:- Apply conditional formatting and custom number formats to enhance the appearance of your worksheets.- Use formulas and functions such as IF, VLOOKUP, SUMIF, COUNTIF, and more to perform complex calculations and data analysis.- Create and modify charts, sparklines, and slicers to visualize and summarize data.- Use pivot tables and pivot charts to organize and manipulate large data sets.- Link, consolidate, and group data from multiple worksheets and workbooks.This course is designed for intermediate users of Excel who want to enhance their skills and productivity. To enroll in this course, you should have completed Excel level 1 or have equivalent knowledge and experience. You should also have access to a computer with Excel 2016 or later installed.We hope you enjoy this course and find it useful for your personal or professional goals. If you have any questions or feedback, please feel free to contact us at any time. Thank you for choosing us as your learning partner.Outline is below:· Conditional formatting· Average function/Count· Maximum function/Sum· Minimum function/SumIF· Basic Scenarios· Sheet Layout and design· Named Cells/Ranges· Absolute Referencing/ percentages· Basic Pivot Tables· Using 3-D Referencing· Goal Seek· Data Tables· Sheet and cell Protection· Linking Sheets and Workbooks· Using Array Formulae· Using Group and Outline/Saving Views· Naming Worksheets· Using the Subtotals Feature· Creating Templates· Basic Lookups/Basic IF
