|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-excel-and-solve-500-problems-beginner-advanced/
课程评论：没有评论
**Coursera课程总结：精通Excel，解决500个实际问题（从入门到精通）** 本课程旨在帮助学习者掌握Microsoft Excel的各项功能，涵盖从初级到高级的全部内容。课程以500个按时间顺序组织的视频教程为特色，深入讲解如何运用各种函数和工具解决不同复杂程度的问题。每个视频教程都配有详细的问题定义和专门的工作表，以便学习者实践。 **核心内容涵盖：** * **公式与函数：** 课程重点在于公式和函数的应用。从基础的数学运算（如在单元格中输入“2+2=4”）开始，逐步深入到复杂的嵌套函数，部分解决方案甚至需要嵌套多达10种不同的函数。 * **Excel工具：** 教学内容涵盖20多种Excel工具，旨在帮助学习者清理和整理数据、创建用户模板、可视化数据等。 * **图表与仪表板：** 课程包含创建各种图表以及使用Power Query、Power Pivot和数据透视表构建交互式仪表板以实现数据可视化。 * **VBA宏：** 提供关于如何录制宏、手动编写VBA代码、构建用户窗体、创建触发式代码，以及使用VBA创建用户定义函数等内容的视频。 **此外，课程还包括：** * 常用的Excel快捷键。 * 函数中美元符号($)的用法。 * 同时处理多个工作表的操作技巧。 **教学辅助材料：** 课程提供一份附带的词汇表，列出了所有500个视频教程的详细信息，包括： * 问题复杂程度。 * 用于解决问题的函数/工具。 * 对每个视频的学习建议，指示是独立解决问题（“自己动手”）还是跟随讲师一起学习（“观看视频”）。 这份文件极大地便利了学习者在课程中进行导航，并能快速找到他们感兴趣的视频内容。 **立即开始您的Excel精通之旅！**
This MS Excel course covers all levels - from beginner to advanced. The course includes 500 chronologically structured video tutorials in which student can learn how different complexity level problems can be solved using various functions and tools. Every video tutorial has its own worksheet where problem definition is explained in detail.The main point the course covers are:Formulas and functions - the course is highly concentrated on formulas and functions. We start from the most basic mathematical formulas, like how to write 2+2=4 in a cell. In later video tutorials, as the problems become more and more complex, students will learn how to write nested functions and some of the solutions even require nesting up to 10 different functions inside each other;Tools - covered up to 20 different excel tools that help to clean and arrange the data, create user templates, visualize the data, etc.;Charts and Dashboards - the course includes creating different types of charts and building dashboards to visualize the data using Power Query, Power Pivot and Pivot Tables;VBA Macros - included videos on how to record macros, write VBA codes manually, build user forms, build codes that run on specific triggers and creating user defined functions using VBA.In addition to the points listed above, the course includes some of the most commonly used shortcuts, using $ signs in functions, working with different worksheets at the same time and much more.As an additional material, glossary supporting file is provided where students can find the list of all 500 videos with the indication of:Problem complexity;Functions/tools to be used to solve the problem;Suggestion on every video whether the problem should be solved independently (Do it yourself) or should the user watch the video and solve the problem along with instructor (Watch video).This file makes it easy for the users to navigate through the course and find the videos they are interested in.Let the practice begin!
