|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-microsoft-excel-data-analysis-toolkit-bundle/
课程评论：没有评论
课程名称：微软Excel数据分析工具包组合 概述：本课程组合包含实践练习，数据分析是现代职场所需的核心技能。数据分析并不像你想象的那么复杂，你无需掌握编码或算法，而是要深入理解如何使用Microsoft Excel进行全面的数据分析。在这个包含五门课程的组合中，我们将探讨多种高级Excel技巧，旨在帮助你理解业务中的数字。这个特别课程将五个完整的标题整合为一个高价值的课程包。 内容包括： 1. **商业分析师的Excel** - 学习使用VLOOKUP、HLOOKUP、INDEX MATCH和XLOOKUP合并数据。 - 应用IF、IFS、IFERROR、SUMIF和COUNTIF进行逻辑分析。 - 使用文本函数分割数据。 - 数据标准化与清理，使用PivotTable进行分析。 - 使用切片器提取信息和展示分析结果，进行预测和回归分析。 2. **高级Excel 2019课程** - 更新Excel 2016的新功能。 - 高级图表和图形、格式工具及财务函数。 - 连接外部数据集，创建美观的可视化。 3. **初学者PivotTables** - 清理和准备数据，创建基础PivotTable。 - 数据汇总和格式化，使用多个字段和维度。 - 创建和更新PivotChart，应用条件格式以及切片器。 4. **高级PivotTables** - 结合多个工作表的数据、格式化PivotTable。 - 使用切片器、时间轴和计算字段，创建交互式仪表板。 5. **高级公式在Excel上** - 使用公式过滤和排序数据。 - 创建多依赖的动态下拉列表，执行复杂的逻辑计算。 - 使用XLOOKUP和其他函数进行数据查找与处理。 本课程包含：超过30小时的视频教程，230多节个别视频讲座，练习文件供学习使用，完成证书。该课程使用Excel 2019和Excel 365录制，也适用于其他较新版本的Excel，包括Excel 2013和2016。 学生反馈： “描述清晰，演示明确。” - Harlan “我有IT知识，但之前从未考虑专注于数据分析，现在非常激动。” - Kenvis “我非常喜欢这位讲师，我通过回顾教程解决了我在MIN函数上的问题。” - Beverly
**This course bundle includes practice exercises**Data Analysis is THE skill you need to thrive in the modern workforce.Data Analysis is easier than you might think. You don't need to be able to code or understand algorithms. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct comprehensive data analysis.In this five-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business.In this special course, we've combined five of our full-length titles into one, huge-value bundle. Here's what you get:Excel for Business AnalystsWhat you'll learn:How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUPHow to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysisHow to split data using text functions SEARCH, LEFT, RIGHT, MIDHow to standardize and clean data ready for analysisAbout using the PivotTable function to perform data analysisHow to use slicers to draw out informationHow to display your analysis using Pivot ChartsAll about forecasting and using the Forecast SheetsConducting a Linear Forecast and Forecast SmoothingHow to use Conditional Formatting to highlight areas of your dataAll about Histograms and RegressionHow to use Goal Seek, Scenario Manager, and Solver to fill data gapsAdvanced Excel 2019 CourseWhat You'll Learn:What's new/different in Excel 2016Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek, and SolverAdvanced charts such as Surface, Radar, Bubble, and Stock ChartsPivotTables for BeginnersWhat You'll Learn:How to clean and prepare your dataCreating a basic PivotTableUsing the PivotTable fields paneAdding fields and pivoting the fieldsFormatting numbers in PivotTableDifferent ways to summarize dataGrouping PivotTable dataUsing multiple fields and dimensionThe methods of aggregationHow to choose and lock the report layoutApplying PivotTable stylesSorting data and using filtersCreate pivot charts based on PivotTable dataSelecting the right chart for your dataApply conditional formattingAdd slicers and timelines to your dashboardsAdding new data to the original source datasetUpdating PivotTables and chartsAdvanced PivotTablesWhat You'll Learn:How to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping, and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboardsAdvanced Formulas in ExcelWhat You'll Learn:Filter a dataset using a formulaSort dataset using formulas and defined variablesCreate multi-dependent dynamic drop-down listsPerform a 2-way lookupMake decisions with complex logical calculationsExtract parts of a text stringCreate a dynamic chart titleFind the last occurrence of a value in a listLook up information with XLOOKUPFind the closest match to a valueThis course includes:30+ hours of video tutorials230+ individual video lecturesExercise files to practice what you learnedCertificate of completionThis course was recorded using Excel 2019 and Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013 and 2016.Here's what our students are saying…"Well described and clearly demonstrated."- Harlan"My name is Kenvis and i have a knowledge in IT but never thought of specializing in Data Analytics before. This was so exciting and am now anxious to learn more."- Kenvis"I like the instructor very much. I had a slight problem with the MIN function but I reviewed the tutorial again until I realized where my error was, and fixed it!"- Beverly
