|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-course-analysis-fundamentals/
课程评论：没有评论
**微软Excel数据分析课程总结** 本课程专为希望提升数据分析能力的人士设计，旨在教授如何将Excel函数融会贯通，构建高级Excel公式。 **核心内容涵盖：** * **Excel技巧与快捷键：** 掌握高效操作Excel的用户界面和常用快捷方式，节省时间和精力。 * **基础函数与高级公式：** 深入理解SUM, IF, COUNT, AVERAGE, SMALL, LARGE等基础函数，并学习如何组合这些函数创建动态、高级的分析模型。 * **数据建模与动态分析：** 学习数据建模原理，运用IF语句实现动态时间周期，使用XLOOKUP, CHOOSE, OFFSET等函数进行高级分析（如情景分析）和创建动态输出。 * **数据汇总与查找：** 掌握VLOOKUP和INDEX MATCH MATCH组合的使用，高效汇总和查找数据。 * **自动化与what-if分析：** 运用INDIRECT函数进行What-if分析，了解GOALSEEK工具。 * **专业报表制作：** 利用CELL, RIGHT, LEN, FIND等函数创建专业的封面页。 * **条件逻辑与数据统计：** 学习COUNT, COUNTA函数，以及IF与AND, OR的组合应用。 * **数据可视化：** 熟练运用Pivot Tables（包括字段设置、筛选、计算字段、切片器和时间线）进行数据汇总。学习创建结合柱状图和折线图的双图表，以及创建动态图表（单数组和多数组）。 * **宏的录制与开发：** 学习如何录制和开发宏，实现重复性任务的自动化。 * **数据管理与组织：** 学习数据分组、Trace Precedents/Dependents、Go to Special、条件格式、数据表设置以及专业地使用日期函数。 **学员收获：** 完成本课程后，您将能够： * 全面理解Microsoft Excel的各项选项和设置。 * 熟练运用Excel快捷键大幅提高工作效率。 * 自定义Excel界面以优化分析流程。 * 掌握核心基础Excel函数及其应用。 * 轻松实现数据锚定（Anchoring）和格式化。 * 有效组织和分组数据。 * 利用Trace功能诊断公式。 * 使用Go to Special和条件格式化突出关键数据。 * 应用数据建模基础原理组织和管理数据。 * 专业地使用日期函数。 * 熟练设置和操作数据表及Pivot Tables。 * 将数据分析结果转化为美观且富有洞察力的图表。 本课程是您开启数据分析之旅、提升技能、探索新工作机会的坚实第一步。
This course is made for those who are interested in taking their data analysis skills to another level. Moreover, it will teach you how to combine Excel functions together in order to build up a very advanced Excel formulas.You'll learn the following in this course:Microsoft Excel Tips and tricks.Most important Excel basic functions and formulas.How to use Excel shortcuts.How to combine Excel functions and formulas to make your analysis and models more dynamic.Microsoft Excel Dynamic Time Periods (using IF statements)Advanced Analysis Techniques (Scenario analysis with XLOOKUP and CHOOSE functions).Dynamic outputs using OFFSET and IF statements.Data summary with VLOOKUP and INDEX MATCH MATCH combination.Using INDIRECT functions and What-if analysis (GOALSEEK tool).Creating a very professional Cover Page using CELL, RIGHT,LEN and FIND functions.Using COUNT, COUNTA and combining IF with AND,OR formulas.Pivot tables field settings, filters, calculated fields, slicers and timeline.Combining two different chart types (Column and line charts)Dynamic Charts (Single and Multi-Array Charts).Recording and developing Macros.This course is made for those who are interested in data analysis. Moreover, it will give you an idea on how can you link up data together following the data modelling principles.This course will help you to start data analysis from scratch and it will be your first step for developing your analysis skills and finding new work opportunities. Moreover, it will help you to transform your data analysis into beautiful and insightful chartsAt the end of this course, you'll understand the following:Understand all Microsoft Excel options and settings, this is explained in a step by step approach.Using Excel shortcuts for saving a lot of time and efforts.How to customize Excel interface to make you faster in doing analysis tasks.Most important basic Excel functions (SUM, IF Statement, COUNT, AVERAGE, SMALL, LRAGE and many more..).How to apply Anchoring and Formatting in a very easy way.How to make data grouping in order to organize your data.Trace functions and formulas using trace precedents and trace dependents.How to use Go to special and Conditional formatting.Saving a lot of time by using Excel shortcuts for each and every action you need to take.Organizing data using data modeling fundamentals and principles.Using date functions in a very professional way.Setting up Data tables and Pivot tables.
