|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-from-zero-to-advanced/
课程评论：没有评论
课程名称：从零基础到高级的微软Excel 课程概述： 微软Excel是市场上需求极高的高级电子表格软件，无论在数据科学、金融会计还是行政管理中，Excel都能提供实现项目所需的工具和库。本课程专为没有任何Excel基础的学员设计，帮助您迅速掌握成为专业人士所需的所有技能。课程分为6个部分，共42个章节，提供的练习文件可与视频同步学习。 课程结构： 1. **Excel入门** - 认识Excel - 输入和编辑工作表数据 - 执行基本工作表操作 - 使用Excel范围和表格 - 格式化工作表 - 理解Excel文件和模板 - 打印工作成果 - 自定义Excel用户界面 2. **公式和函数的使用** - 公式和函数概述 - 使用公式进行基本数学运算 - 使用公式处理文本 - 使用公式处理日期和时间 - 使用公式进行条件分析 - 使用公式进行匹配和查找 - 使用公式进行财务分析 - 使用公式进行统计分析 - 理解和使用数组公式 - 让公式无错误 3. **图表及可视化** - Excel图表入门 - 高级图表技术 - 创建迷你图 - 通过自定义数字格式和形状进行可视化 - 实施Excel仪表盘最佳实践 4. **数据管理与分析** - 导入和清理数据 - 使用数据验证 - 创建和使用工作表大纲 - 链接和合并工作表 - PivotTable和数据分析入门 - 执行电子表格假设分析 - 使用目标寻求和求解分析数据 - 使用分析工具库分析数据 - 保护您的工作 5. **Power Pivot和Power Query** - 理解Power Pivot和Power Query - 直接使用内部数据模型 - 为Power Pivot添加公式 - Power Query应用 6. **Excel自动化** - 介绍Visual Basic for Applications - 创建自定义工作表函数 - 创建用户窗体 - 通过实例使用用户窗体控件 - 处理Excel事件 - 创建自定义Excel加载项 本课程旨在帮助学员全面掌握Excel的使用，从基础到高级技术，让您在职业生涯中更具竞争力。
Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.The course is divided into the following sections and chapters:Getting Started with ExcelIntroducing ExcelEntering and Editing Worksheet DataPerforming Basic Worksheet OperationsWorking with Excel Ranges and TablesFormatting WorksheetsUnderstanding Excel Files and TemplatesPrinting Your WorkCustomizing the Excel User InterfaceWorking with Formulas and FunctionsIntroducing Formulas and FunctionsUsing Formulas for Common Mathematical OperationsUsing Formulas to Manipulate TextUsing Formulas with Dates and TimesUsing Formulas for Conditional AnalysisUsing Formulas for Matching and LookupsUsing Formulas for Financial AnalysisUsing Formulas for Statistical AnalysisUnderstanding and Using Array FormulasMaking Your Formulas Error-FreeCreating Charts and Other VisualizationsGetting Started with Excel ChartsUsing Advanced Charting TechniquesCreating Sparkline GraphicsVisualizing with Custom Number Formats and ShapesImplementing Excel Dashboarding Best PracticesManaging and Analyzing DataImporting and Cleaning DataUsing Data ValidationCreating and Using Worksheet OutlinesLinking and Consolidating WorksheetsIntroduction to PivotTables and Data AnalysisPerforming Spreadsheet What-If AnalysisAnalyzing Data Using Goal Seeking and SolverAnalyzing Data with the Analysis ToolPakProtecting Your WorkUnderstanding Power Pivot and Power QueryIntroducing Power PivotWorking Directly with the Internal Data ModelAdding Formulas to Power PivotPower QueryAutomating ExcelIntroducing Visual Basic for ApplicationsCreating Custom Worksheet FunctionsCreating UserFormsUsing UserForm Controls in a Worksheet through an ExampleWorking with Excel EventsCreating Custom Excel Add-Ins
