|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-excel-training-basic-to-advanced-skills/
课程评论：没有评论
**Coursera Excel 课程全方位精通：从入门到高级技能** 本课程旨在帮助您全面掌握 Microsoft Excel，无论您是新手还是有经验的用户，都能从基础函数、图表绘制到高级数据分析和自动化操作。您将学会处理大量数据，运用数据透视表、宏和VBA提升工作效率。 **课程亮点：** * **15小时以上视频内容：** 涵盖18个章节，共57个视频。 * **实践导向：** 提供可下载的练习文件。 * **终身访问权限：** 随时随地回顾学习。 * **跨平台支持：** 电脑与移动设备均可访问。 **核心模块：** * **Excel 界面概览：** 熟悉工具栏、功能区、名称框、公式栏等。 * **基础格式与编辑：** 学习单元格操作、文本格式化、百分比、货币等。 * **基础公式与函数：** 掌握加、减、乘、除、求幂，以及 SUM、COUNT、AVERAGE 等常用函数。 * **单元格引用：** 理解相对、绝对和混合引用。 * **图表类型：** 学习创建各类统计图表。 * **Excel 核心功能：** 包含选择性粘贴、冻结窗格、排序与筛选、页面设置、条件格式、数据验证等。 * **工作表与工作簿保护：** 学习锁定单元格、隐藏公式、保护工作表/工作簿、设置密码备份。 * **高级 Excel 函数：** 深入学习 SUMIFS、AVERAGEIFS、VLOOKUP、HLOOKUP、XLOOKUP、IFERROR、INDEX、MATCH 等。 * **文本函数：** 掌握LEN, LEFT, RIGHT, MID, CONCATENATE 等文本处理函数。 * **公式审计：** 学习追踪公式依赖关系。 * **模拟运算：** 掌握单目标模拟和规划求解。 * **数据合并：** 学习合并来自不同工作簿的数据。 * **数据透视表与图表：** 学习创建和格式化数据透视表及图表。 * **Power Pivot：** 掌握创建数据模型和关系。 * **交互式仪表板：** 学习创建动态数据可视化。 * **宏与 VBA：** 学习录制、编写和调试宏，创建数据录入窗体。 本课程将帮助您在各行各业脱颖而出，提升职业竞争力。
Become a Pro at Microsoft Excel with "The Complete Excel Training: Basic to Advanced Skills" Whether you are a complete novice or a seasoned pro, this one-stop shop course will take you from basic Excel functions to advanced data analysis and automation in Microsoft Excel.Master Microsoft Excel, use simple formulas, plot graphs, and easily handle thousands of rows of data! Learn about advanced features such as PivotTables, macros, and VBA for increased productivity.This course will equip you with Excel skills that can be used across industries, whether you are a student, job seeker, business professional, or entrepreneur.Course Features:15 hours 12 mins of on-demand video18 sections with 57 videosDownloadable practice filesFull lifetime accessExplained in English LanguageAccess on mobile and ComputerCourse Modules:Introduction - Importance of MS Excel and course details (About advanced level functions, special problem solver, interactive dashboards & Macro for automation).Overview Of Excel Interface - Quick access toolbar, Ribbon, Name Box, Formula Bar, Cells, Sheet Tabs, Status Bar.Basic formatting & Editing - Insert Row, Insert Column, Merge, Wrap Text, Alignment, Border, Bold, Italic, Underline, Cut, Copy, Paste, Percentage, Currency, Comma, Decimal, Font Style, Font Size, Fill Color, Undo, Redo, Text Orientation, Naming Cell Range, Ribbon customization.Basic excel formula - ADD, SUBTRACT, MULTIPLY, DIVIDE, INDICES.Type of cell references - Relative Reference, Absolute Reference & Mixed Reference.Basic Excel functions - ROUND, INT, SUM, SUMIF, COUNT, COUNTA, COUNTIF, AVERAGE, AVERAGEIF, MIN & MAX, RANK, MATCH, INDEX, RAND & RANDBETWEENTypes of Chart - Column, Bar, Pie, Line, Combo, etc.Essential features of Excel - Paste Special, Freeze & Split Panes, Sort & Filter, Page Setup & Print Settings, Conditional Formatting, Data validation, Dependable dynamic Dropdown list.Sheet & Workbook Protection - Lock Cells, Hide Formulas, Protect Sheet, Protect Workbook, Allow specific access, Allow specific users to edit ranges & Password protect the Excel file, Create Excel file backup.Advanced Excel Functions - SUMIFS, COUNTIFS, AVERAGEIFS, DATE & TIME, IF, NESTED IF, IF WITH AND/OR, VLOOKUP, HLOOKUP, XLOOKUP, IFERROR, MATCH, INDEX, INDIRECT, VLOOKUP WITH MATCH, INDEX WITH MATCH, FUZZY LOOKUP, VLOOKUP WITH INDIRECT.Miscellaneous Text Function - LEN, LEFT, RIGHT, MID, LOWER, UPPER, PROPER, VALUE, TRIM, CONCATENATE, FIND, SEARCH, SUBSTITUTE, REPLACE.Formula Auditing in Excel - Show Formulas, Trace Dependents, Trace Precedents, Remove Arrows, and Evaluate Formula.What if Analysis - Goal Seek & Solver.Merge Data From Multiple Workbooks - Add Compare & Merge Workbook command, Share Workbook, Merge or Combine Data from Multiple Files to Single File.Create Pivot Table & charts - Pivot, Chart, Formatting Chart, Types of Charts, Slicer, Timeline, and Use of shapes & SmartArt Graphics in Presentation.Create Power Pivot Table - Create Pivot Table from multiple worksheets, Add to Data Model, Create Relationship & Manage.Create Interactive Dashboard -1.Create Interactive Dashboard -2.Learn Macro with VBA code - Macro Basics: Preparation, record, create button, editing, debugging, Dynamic Selection, Use relative reference, Create Macro Data Entry Form & Protect coding of Macro.Enroll now to become proficient in Excel and boost your career opportunities.
