|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2021-beginner-to-intermediate-course/
课程评论：没有评论
课程名称：Excel 2021/365入门套件：初学者到中级课程 课程概述：本课程结合了Excel 2021/365绝对初学者和中级课程，为您提供了一个终极入门套件，帮助您快速启动电子表格的学习之旅！无论您是Excel新手还是已经具备一定的Excel知识，这门课程都能帮助您打下坚实的基础，或在您已有的技能上进一步提升。特别适合那些在旧版Excel中拥有初级到中级技能的学生，想要探索最新功能的人。Excel 2021是微软最新的独立版本，开启了许多仅在Excel 365订阅版本中可用的功能和功能。课程的唯一前提是您需拥有Excel 2021或Excel 365的有效副本。 课程内容包括： - 熟悉Excel 2021中的新功能 - 导航Excel 2021界面 - 使用有效的快捷键提高工作效率 - 创建您的第一个Excel电子表格 - 使用基本到中级的Excel公式和函数 - 有效地对单元格进行格式化及使用条件格式 - 使用Excel列表和主排序与过滤 - 高效利用剪切、复制和粘贴选项 - 链接其他工作表和工作簿 - 利用图表分析数据 - 在电子表格中插入图片 - 处理视图、缩放及冻结窗格 - 设置页面布局和打印选项 - 保护和共享工作簿 - 以不同文件格式保存工作簿 - 设计更好的电子表格并控制用户输入 - 使用逻辑函数做出更好的商业决策 - 构建功能性灵活的查找公式 - 使用Excel表格结构化数据，方便更新 - 从列表中提取唯一值 - 使用高级特性和新Excel公式进行数据排序和过滤 - 处理日期和时间的函数 - 使用文本函数提取数据 - 导入数据并在分析前进行清理 - 使用数据透视表分析数据 - 使用数据透视图可视化数据 - 为数据透视表和数据透视图添加互动 - 创建交互式仪表板以展示高层指标 - 审核公式并排查常见Excel错误 - 使用数据验证控制用户输入 - 使用假设分析工具查看输入变化对结果的影响 课程包含： - 20多小时的视频教程 - 180多个单独的视频讲座 - 课程和练习文件以供跟随 - 完成证书 此课程为想要深入了解Excel并掌握其最新功能的学习者提供了全面的学习体验。
***Exercise and demo files included***We've combined our Excel 2021/365 for Absolute Beginners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It's also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features.Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.This course covers:Becoming familiar with what's new in Excel 2021Navigating the Excel 2021 interfaceUtilizing useful keyboard shortcuts to increase productivityCreating your first Excel spreadsheetUsing basic and intermediate Excel formulas and functionsEffectively applying formatting to cells and using conditional formattingUsing Excel lists and master sorting and filteringWorking efficiently by using the cut, copy, and paste optionsLinking to other worksheets and workbooksAnalyzing data using chartsInserting pictures in a spreadsheetWorking with views, zooms, and freezing panesSetting page layout and print optionsProtecting and sharing workbooksSaving your workbook in different file formatsDesigning better spreadsheets and controlling user inputHow to use logical functions to make better business decisionsConstructing functional and flexible lookup formulasHow to use Excel tables to structure data and make it easy to updateExtracting unique values from a listSorting and filtering data using advanced features and new Excel formulasWorking with date and time functionsExtracting data using text functionsImporting data and cleaning it up before analysisAnalyzing data using PivotTablesRepresenting data visually with PivotChartsAdding interactions to PivotTables and PivotChartsCreating an interactive dashboard to present high-level metricsAuditing formulas and troubleshooting common Excel errorsHow to control user input with data validationUsing WhatIf analysis tools to see how changing inputs affect outcomes.This course includes:20+ hours of video tutorials180+ individual video lecturesCourse and exercise files to follow alongCertificate of completion
