|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-analysis-bootcamp/
课程评论：没有评论
课程名称：Excel数据分析实训营 课程概述：本课程旨在深入讲解高级Excel公式和函数，使其成为强大的数据分析工具。大多数Excel课程只关注公式的功能，而本课程通过实际的例子来展示这些公式的强大及其多种应用方式，帮助学员学会“像Excel一样思考”。课程中提供了实践操作的示例Excel表格，帮助学员掌握以下技能： - 构建动态工具和Excel仪表板，以过滤、展示和分析数据 - 创建基于公式的Excel格式设置规则 - 使用XLOOKUP、INDEX和MATCH函数合并多个数据源 - 操作日期、时间、文本和数组 - 使用Excel中的单元格公式和函数自动化繁琐的任务（无需VBA） - 从API实时提取数据（如天气、股市报价、路线等） - 制作各种图表，学习数据的操作与分析 完成课程后，学员将掌握常用的Excel工具，能够自信高效地完成各类Excel任务。课程还将教授有效创建电子表格、管理大型数据集、掌握流行的Excel函数（如SUM、VLOOKUP、IF、AVERAGE、INDEX/MATCH等）、使用Excel数据透视表创建动态报告、利用Excel的插件及PowerPivot功能，以及通过宏和VBA掌握日常Excel任务的自动化。 课程最终将帮助学员学会如何进行数据分析和绘制美观的图表。
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways for analysis of data I will teach you how to THINK like Excel.This course is hands on tutorial where sample excel sheets are provided for practice.Easily build dynamic tools & Excel dashboards to filter, display and analyze your dataCreate your own formula-based Excel formatting rulesJoin datasets from multiple sources with XLOOKUP, INDEX & MATCH functionsManipulate dates, times, text, and arraysAutomate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)Plotting chartsLearn how to manipulate and analyse dataAt completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:Creating effective spreadsheetsManaging large sets of dataMastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)Create dynamic report with Excel PivotTablesUnlock the power and versatility of Microsoft Excel's Add-In, PowerPivotAudit Excel Worksheet formulas to ensure clean formulasAutomate your day to day Excel tasks by mastering the power of Macros and VBAHow to do data analysis How to plot beautiful charts
