|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-hands-on-advanced-excel/
课程评论：没有评论
课程名称：全面实践高级Excel 课程概述：Excel是管理和分析各种数据的最强大工具。本课程经过精心设计，从Excel的基本介绍开始，带您深入了解其各项功能。如果您是Excel初学者或中级用户，并希望学习Excel，那么这里是您理想的起点。通过掌握Excel中的数据分析，助力您的数据分析师职业生涯。本课程详细讨论了各种关键知识点，如函数和公式、数据验证、数据透视表、Power Pivot、VLookup、HLookup、KPI等，帮助您在职场中脱颖而出。 课程内容将从基础到高级全面覆盖Excel的各种功能，让您熟悉单元格引用、表格创建、自定义单元格样式、边框、公式与函数、条件语句、数据排序、筛选和验证等内容。您还将学习如何应用描述性统计，包括平均值、中位数、计数、最大值和最小值函数。此外，课程还将深入讲解如何使用图表和图形分析数据，以及通过数据透视表、Power Pivot和KPI展示数据。 所有学习资源将为您提供实践机会，使您在Excel能力上迈出坚实的一步。
Excel is the most powerful tool to manage and analyze various types of Data. This perfectly designed Excel course will begin with an introduction to Excel and will take you through various features of Excel. If you're an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. Grow your career as a Data Analyst through knowing Data Analysis in Excel. Everything that is very important to know like Functions and Formulas, Data Validation, Pivot Table, Power Pivot, VLookup, HLookup, KPI and many more things are discussed in details in this course. This course will help you to make yourself one step ahead of everyone. All the resources are given that will help you to practice.This course is designed perfectly, from introduction to advanced will be covered through various features of excel. You will get familiarized with Cell Refencing, Table formation, Customizing Cell Style, Border, Formula and Functions, Conditional Statements, Data Sorting, Filtering, Validation.You will get notion of use Descriptive Statistics through the use of Average, Median, Count, Max, Min functions. An in-depth knowledge of using Chart and Graphs to analyse data, and presenting data through pivot table using of power pivot and KPI.
