|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-beginner-to-advanced/
课程评论：没有评论
**课程名称：** Microsoft Excel - 从入门到精通 **课程概述：** 本课程旨在帮助学员全面掌握Microsoft Excel的关键功能，重点关注数据可视化和提高工作效率。课程使用Excel 2019版本，但与2010、2013、2016、2019、2021、2022等版本兼容性高达90-95%。 **课程内容亮点：** * **Excel基础入门 (30分钟)：** * 用户界面概览 * 工作簿保存 * 拖放操作 * 行、列、单元格的概念 * 快速单元格移动 * 数据输入与数据类型 * 公式与引用、运算符 * 单元格、区域、列、行的选择 * 数据复制粘贴 * 自动填充与自动完成 * 函数介绍 * 定义名称 * 数据排序与筛选 * 创建简单图表 * 多工作表操作 * 缩放功能 * **数据可视化技术：** * 动态高亮图表中的最大值 * 条件格式突出关键数据 * 创建易于理解的地图图表 * 在条形图中添加图标增强表现力 * 创建信息图式进度图 * **Excel快捷键：** * 介绍超过100个Excel快捷键，涵盖七大类别： * 通用快捷键 * 导航快捷键 * 数据录入快捷键 * 格式设置快捷键 * 选择快捷键 * 公式快捷键 * 其他杂项快捷键 * **常用Excel公式/函数：** * 相对与绝对单元格引用详解 * 日期函数应用 * SUM(), SUMIF(), SUMIFS() 函数 * MIN(), MAX(), AVERAGE(), COUNT() 函数 * VLOOKUP(), HLOOKUP() 函数示例 * INDEX(), MATCH(), XLOOKUP() 函数用于数据搜索 * **高级Excel主题 (PivotTable)：** * PivotTable（数据透视表）的全面讲解，化繁为简 * 创建多种报表和数据透视表图 * 数据库设计原则简介 * 创建数据模型，使用多表PivotTable * 将Excel作为数据库使用 **课程目标：** 通过本课程，学员的Excel技能将远超平均水平。无论您是初学者还是有一定基础的用户，本课程都将提供循序渐进的指导和深入的知识，帮助您高效处理和分析数据。 **建议：** 建议观看课程的介绍视频，了解课程内容详情。
In this special Microsoft Excel - Ms Excel from Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016, 2019, 2021, 2022 versions.If you're a beginner, in the first section you can learn Excel basics from scratch in 30 minutes.Topics covered in the 30-min Getting Started With Excel lecture:quick overview of the user interfacehow to save your excel worksheetdrag & drop gestureexcel rows, columns, cellshow to move between cells quicklyexcel data entryexcel data typesexcel formulas & referencesexcel operatorshow to select cells, ranges, columns, rows in excelcopy & paste dataAutoComplete featureAutoFill featurewhat is functiondefine Namehow to sort & filter your data in excelhow to create a simple chart with a few clicksmultiple worksheetszoom functionThen we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.Projects covered:highlight max value dynamically on an Excel chartdiscover Excel's conditional formatting feature to highlight key data in your tablehow to create a map chart that reads well by the viewerhow to use icons in your bar charts to make it excitinghow to create a progress chart in infographic styleI dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.Shortcuts covered in seven categories:general shortcutsshortcuts for navigationshortcuts for data entryExcel formatting shortcutsselection shortcutsshortcuts for formulasmiscellaneous shortcut keysI created a section for the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics:Relative vs Absolute cell references explainedworking with date functionsSUM(), SUMIF(), SUMIFS() functionsMIN(), MAX(), AVERAGE(), COUNT() functionsVLOOKUP(), HLOOKUP() functions examplesINDEX(), MATCH(), XLOOKUP() functions to search dataIn the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database.By taking this course you can really take your Excel skills to way above the average.Don't worry if you're an absolute beginner. I'll explain everything step by step.If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.Please watch the Intro video to see what you can expect from this course. Enjoy learning!
