|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-for-all/
课程评论:没有评论
课程名称:Excel for All: Beginner to Experts 课程概述:Microsoft Excel 是最广泛使用且功能强大的软件之一。无论是日常开支记录、复杂的损益分析,还是学生考勤跟踪和全球饥饿数据分析,Excel 都是处理各种数据的基本工具。尽管 Excel 的潜力很大,但很多用户并没有充分利用它的功能。本课程旨在帮助初学者、中级用户和专家全面掌握 Excel,课程从基础功能入手,逐步深入,传授一些简单的小技巧,以显著提高使用 Excel 的效率和速度。 课程结构包括以下几个主要内容: - 数据清理 - 数据处理 - 数据总结(模板形式) - 数据展示(仪表板形式) - 使用VBA宏实现上述过程的自动化 课程包含视频讲解,每个视频的要点和总结均可下载。我们建议在观看视频之前,先快速浏览这些下载材料,以便了解学习内容。短视频以循序渐进的方式讲解每个概念,允许学员在学习时进行实践。本课程适合刚开始接触 Excel 的用户,以及希望提升 Excel 技能的用户。
Microsoft Excel is by far the most widely used and useful software there is! It is the most basic tool that is used when dealing with data - data in any format. This simple yet sophisticated tool has a use for everyone, from keeping a simple tab your daily expenses, to analyzing and presenting a complex profit and loss statement, from keeping a tab on attendance of students to analyzing and presenting data on world hunger! Excel when used intelligently makes for one of the most powerful yet simple reporting engine. Such is the power of Excel. But despite this, Microsoft Excel in most cases is not used to its full potential even though it one of the most easiest skill to pick up. With this course, aimed at beginners, intermediate and Expert users we begin by introducing the basic functionality of this software and then work upwards, along the way covering very simple tips that will profoundly increase your speed and efficiency while using Excel. At a high level the course is structured in the below format. - Data Cleaning - Data Processing - Data Summarizing (As A Template) - Data Presentation (As A Dashboard) - Automation of the above process using VBA Macros The course comprises of videos, key points /summary of each video is available as downloadable material. We suggest that you give a quick run through the downloadable material before you begin watching any video. This is will allow you to understand what it is that you will be learning in the attached video. The short videos take you through each concept step-by-step and allow you to practice while studying. This course as indicated is one for those just beginning with Excel and for those who need to master their Excel skills.