|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excelgptcourse2025/
课程评论：没有评论
课程名称：Excel课程2025从基础到高级（与Chat GPT AI工具） 课程概述： 这是一门为期15天的在线Excel课程，旨在帮助学习者从基础到高级掌握Excel技巧，并结合Chat GPT工具进行学习。课程内容涵盖了Excel的基本操作，数据处理，高级分析工具，以及在实际项目中的应用。 课程内容： 第1天：Excel简介 - 了解Excel界面、基础导航及快捷键 - 创建和保存工作簿 第2天：基本数据输入和格式设置 - 数据输入与编辑，单元格格式化 - 条件格式的基础应用 第3天：公式与函数入门 - 理解Excel中的公式与基本函数 - 实践创建销售数据表的公式 第4天：数据处理 - 数据排序与过滤 - 数据验证与下拉列表创建 第5天：格式化与打印 - 表格格式化、主题使用 - 页面布局与打印设置 第6天：图表与可视化 - 创建和格式化基本图表 - 定制图表元素 第7天：逻辑与文本函数 - 使用逻辑函数与文本函数 - 创建条件语句，提取文本数据 第8天：高级数据分析工具 - 创建数据透视表和切片器 - 介绍透视图表的使用 第9天：查找与引用函数 - 理解VLOOKUP、HLOOKUP等查找函数 - 实践INDEX和MATCH组合 第10天：日期与时间处理 - 使用日期与时间函数 - 计算时限与截止日期 第11天：高级公式技巧 - 学习数组公式及动态数组 - 使用TEXTJOIN进行文本拼接 第12天：数据清洗与转换 - 使用TRIM、CLEAN等函数 - 清洗数据集与文本拆分 第13天：宏的自动化 - 了解宏与VBA，录制和运行宏 - 编写基础VBA代码 第14天：高级数据分析工具 - 使用目标查找与求解工具 - 创建情境分析 第15天：建构最终项目，与Chat GPT结合 - 应用所有学习的技能在真实项目中 - 设计动态销售仪表板并进行项目展示 课程交付： - 学习材料包括PDF、视频教程和实践数据集。 - 完成课程后颁发结业证书。 该课程通过结构化的学习计划，确保学员全面理解Excel的基础操作到高级功能，使其能够有效地运用于实际工作中。
15 Days Online Excel Course 2025 From Basics to Advanced With Chat GPT ToolsDay 1 Introduction to ExcelTopics CoveredOverview of the Excel interface (ribbons, toolbars, sheets)Understanding rows, columns, cells, and rangesSaving and managing Excel filesBasic navigation and shortcutsActivitiesCreating and saving a workbookPracticing navigation using shortcutsDay 2 Basic Data Entry and FormattingTopics CoveredEntering and editing dataFormatting cells (font, color, alignment)Using number formats (currency, date, percentage)Conditional formatting basicsActivitiesFormatting a data tableApplying conditional formatting rulesDay 3 Introduction to Formulas and FunctionsTopics CoveredUnderstanding formulas in ExcelUsing basic functions: SUM, AVERAGE, MIN, MAXRelative vs. absolute cell referencesActivitiesCreating formulas for a sales data tablePracticing absolute and relative referencesDay 4 Working with DataTopics CoveredSorting and filtering dataFreezing panes and splitting windowsData validation for input controlActivitiesSorting and filtering customer dataAdding dropdown lists using data validationDay 5 Formatting and PrintingTopics CoveredFormatting tablesUsing themes and stylesPage layout and print settings (margins, headers, footers)ActivitiesFormatting a professional-looking reportPreparing a sheet for printingDay 6 Charts and VisualizationTopics CoveredCreating basic charts: column, line, and pieFormatting chartsAdding data labels and customizing chart elementsActivitiesCreating charts for a sales reportCustomizing a chart for presentationDay 7 Logical and Text FunctionsTopics CoveredLogical functions IF, AND, ORText functions: LEFT, RIGHT, MID, CONCATCombining text and logical functionsActivitiesCreating conditional statements with IFExtracting and formatting text dataDay 8 Advanced Data Analysis ToolsTopics CoveredUsing PivotTables to summarize dataCreating slicers for interactive filteringIntroduction to PivotChartsActivitiesBuilding a PivotTable from sales dataCreating a PivotChart to visualize trendsDay 9 Lookup and Reference FunctionsTopics CoveredUnderstanding lookup functions: VLOOKUP, HLOOKUPAdvanced lookup functions: XLOOKUP, INDEX, MATCHCombining lookup functionsActivitiesUsing VLOOKUP to search product detailsPracticing INDEX and MATCH combinationsDay 10 Working with Dates and TimesTopics CoveredDate and time functions: TODAY, NOW, DATEDIF, NETWORKDAYSFormatting date and time dataCalculating durations and deadlinesActivitiesBuilding a project timelineCalculating working days between datesDay 11 Advanced Formula TechniquesTopics CoveredArray formulas and dynamic arrays (UNIQUE, FILTER, SORT)Using TEXTJOIN for concatenating valuesNested formulas for complex calculationsActivitiesExtracting unique values from a datasetCreating a dynamic report using FILTERDay 12 Data Cleaning and TransformationTopics CoveredUsing TRIM, CLEAN, and SUBSTITUTE functionsRemoving duplicatesSplitting and merging text dataActivitiesCleaning messy datasetsSplitting full names into first and last namesDay 13 Automation with MacrosTopics CoveredIntroduction to macros and VBARecording and running macrosEditing basic VBA codeActivitiesRecording a macro for repetitive tasksCustomizing VBA code for a small projectDay 14 Advanced Data Analysis ToolsTopics CoveredGoal Seek and SolverUsing What-If analysis toolsCreating scenarios and scenario summariesActivitiesSolving optimization problems with SolverBuilding a financial forecast modelDay 15 Building a Final Project , Chat GPT , AI Formula and FeaturesTopics CoveredApplying all learned skills to a real-world projectCreating interactive dashboardsReviewing and improving Excel efficiencyAI tools and featuresBest AI Add insHow to use Chat GPT in ExcelActivitiesDesigning a dynamic sales dashboardPresenting the project to peers or instructorCourse DeliverablesLearning Materials PDFs, video tutorials, and practice datasets.Certification Certificate of Completion upon finishing the course.This structured plan ensures a comprehensive understanding of Excel, from basic operations to advanced functionalities.
