|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-excel-2021-beginner-to-advanced-training-course/
课程评论：没有评论
课程名称：终极Excel 2021/365 套件：初学者到高级课程 课程概述：本课程套餐包括练习题、可下载文件及终身访问权限。您将通过Simon Sez IT提供的这套极具价值的三门课程培训，从Excel新手成长为强大用户。完成这些培训课程后，您将轻松清理、汇总和分析数据，并能创建数据透视表、图表、宏等功能。所有课程都配有练习题和跟随的讲师文件，以便您立即应用所学知识。该Excel终极套餐适合各个水平的学生。无论您是刚接触Microsoft Excel，还是希望了解Excel 2021的新功能，这个套餐都适合您。 课程内容包括： - **Excel 2021 初学者**：熟悉Excel 2021的新功能、操作界面、实用快捷键、创建电子表格、基础及中级公式与函数、单元格格式设置、使用Excel列表、数据分析、插入图片、页面布局与打印选项等。 - **Excel 2021 中级**：设计更好的电子表格、逻辑函数应用、灵活的查找公式、利用Excel表格结构化数据、数据筛选与排序、日期时间函数、数据清理与分析、使用数据透视表和数据透视图、创建互动仪表板、公式审计及数据验证等。 - **Excel 2021 高级**：使用新动态数组函数、创建高级查找公式、统计函数、财务数据分析、创建变量与函数、分析数据的高级技巧、导入数据和使用Power Query、预测未来值、录制与运行宏、基础VBA代码编辑，以及创建特定任务的实用公式等。 该套餐包含：30+小时的视频教程、270+个独立视频讲座、课程及练习文件以便跟随学习、完课证书。 通过本课程，您将全面提升Excel使用能力，无论您是初学者还是有一定基础的用户，都能在学习中受益匪浅。
**This bundle includes practice exercises, downloadable files, and LIFETIME access**Learn all the tools you'll need to become a Microsoft Excel 2021/365 power user with this great value 3-course training bundle for beginner to advanced users from Simon Sez IT.Let us take you on a journey from being an Excel novice to an Excel guru. By the end of these training courses, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.This Excel ultimate bundle is designed for students of all levels. If you are brand new to Microsoft Excel or are upgrading from a previous version and want to keep up to date with Excel 2021 developments, then this bundle is for you.If you already have a good understanding of Excel, you might want to check out the intermediate and advanced sections where our expert instructor will help you take your spreadsheet skills to the next level.What's included?Excel 2021 for BeginnersBecome familiar with what's new in Excel 2021Navigate the Excel 2021 interfaceUtilize useful keyboard shortcuts to increase productivityCreate your first Excel spreadsheetUse basic and intermediate Excel formulas and functionsEffectively apply formatting to cells and use conditional formattingUse Excel lists and master sorting and filteringWork efficiently by using the cut, copy, and paste optionsLink to other worksheets and workbooksAnalyze data using chartsInsert pictures in a spreadsheetWork with views, zooms, and freezing panesSet page layout and print optionsProtect and share workbooksSave your workbook in different file formatsExcel 2021 IntermediateDesigning 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.Excel 2021 AdvancedUsing the NEW dynamic array functions to perform tasksCreating advanced and flexible lookup formulasUsing statistical functions to rank data and to calculate the MEDIAN and MODEProducing accurate results when working with financial data using math functionsCreating variables and functions with LET and LAMBDAAnalyzing data with advanced PivotTable and PivotChart hacksCreating interactive reports and dashboards by incorporating form controlsImporting and cleaning data using Power QueryPredicting future values using forecast functions and forecast sheetsRecording and running macros to automate repetitive tasksUnderstanding and making minor edits to VBA codeCombining functions to create practical formulas to complete specific tasks.This bundle includes:30+ hours of video tutorials270+ individual video lecturesCourse and exercise files to follow alongCertificate of completion
