|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-basic-to-advance-in-one-course/
课程评论：没有评论
课程名称：Microsoft Excel：从基础到高级的全面课程 课程概述：本课程专为对Excel不熟悉或仅具基础知识的人士设计。完成课程后，学员将能够掌握Excel的大部分功能。课程将涵盖以下主题：基本Excel术语和预定义函数、高级Excel函数（如if、sum if、count if、财务函数、统计函数）、查找函数（如vlookup、hlookup）、数据分析（如目标求解、数据透视表）、格式化（美化Excel、宏和简单快捷键）。Excel在各行各业中都是一项重要工具，此课程适合任何人，帮助学员更好地进行数据管理、分析及洞察。无论是建筑师、项目经理、产品经理、金融专业毕业生、电影制片人、执行制片人，还是学生，此课程都能提供支持。课程将帮助简化重复性任务，让学员能够在学习后继续自主利用网络进一步学习。Microsoft Excel是数据分析、交易和仪表板制作的强大工具。尽管课程未详细覆盖宏的内容，但学员将了解其理论基础，以及如何利用Excel进行编程，VBA是其中的编程语言。
This course is tailored made for people who don't know excel or have very basic knowledge. After completion of this course, the student will be able to do most of what excel can do. Please see the introduction video in which I have given lecture-wise what all topics would be covered in the course. The topics are:Basic Excel Lingo and Predefined functions Advanced excel Function (if, sum if, count if, financial functions, statistics functions)Look up functions ( v lookup , h lookup)Data Analytics ( goal seek, pivot table)Formatting (beautifying excel, macros, simple shortcuts)Excel is a very Important tool irrespective of the industry and this course can help anyone and everyone as in the end its all about data-keeping, its analytics, and insights. It can be useful for architects, project managers, product managers, finance graduates, filmmakers, executive producers, students and many more.This course will help you simplify the repetitive tasks as excel is a very important tool and this course will ensure you are at certain pedestal to start learning on your own using the internet. Microsoft Excel is one of the most powerful tools for data analysis, trading, dashboard making. This course does not cover macros in detail but in theory, you can use excel and create anything and everything as macros is sort of a programming tool in which you can code anything and VBA is the language used for it.
