|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-microsoft-excel-for-beginners-z/
课程评论：没有评论
课程名称：学习微软Excel基础课程 概述：在这门在线课程中，您将从初级学习微软Excel，逐步提升至专家级别。该课程最初由两个独立课程组合而成。第一部分将帮助您掌握Excel的基本知识，而第二部分则深入讲解Excel中的公式和函数。课程内容经过精心设计，以便您在最短的时间内轻松学习Excel。完成课程后，您将具备实用的Excel技能，有助于您的职业生涯或商业发展。此外，这门课程还提供两级考试，以巩固和确保您掌握所有技能。完成后，您将获得一份有效的Udemy证书，以增强您的专业简历。 关于作者：我是一名企业家，同时也是信息系统和计算机图形学的学术讲师。我拥有软件开发的本科学位和信息系统及商业管理的硕士学位。在过去的20多年里，我在各种需求下使用微软Excel，包括商业和学术用途。我使用Excel进行记账和财务管理、学生数据管理、学术研究、项目管理、数据分析等。发布此课程时，我在Udemy上已有超过50,000名学生，平均评分超过4.5，全球学生总数达100,000人。 您将学到的内容：在这门在线课程中，您将学习许多内容，具体详情可查看课程大纲。大致概述包括18章（不包括介绍章节），其中10章为基础课程，8章为进阶公式与函数课程。总共有135节以上的课程和16.5小时以上的视频内容。 第一部分课程中，您将学习Excel的基础知识，如用户界面和导航技巧、数据类型及数据处理技巧。接下来，您将学习使用各种类型的单元格引用，从最简单到最复杂的使用方法，了解Excel中的数据呈现和表格结构技术。之后会介绍图形相关内容，如创建SmartArt、图表和迷你图。接着，您将学习更复杂的数据处理技巧，包括查找和替换、数据排序和过滤等。然后，我们再详细讨论表格和数据透视表，并涵盖多种条件格式化功能。课程最后将涉及与打印和导出相关的不同技术。 第二部分课程中，您将学习处理公式的重要技巧，掌握与表格及动态数组相关的高级技巧，深入讲解条件函数（如IFS、SUMIFS、AVERAGEIFS等）和逻辑函数（如AND、OR、NOT）。此外，您将学习各种查找函数的使用，如VLOOKUP、XLOOKUP、INDEX、MATCH、XMATCH等，了解“匹配模式”和“搜索模式”的参数及其应用实例。课程后续将介绍日期和时间相关的技巧，文本数据处理技巧，以及与统计相关的各种函数，如如何根据趋势或过去的数据预测未来情况。 不要再犹豫了，立即加入课程！充分发挥您的Excel技能。
In this online course, you will learn Microsoft Excel from the beginner level all the way to the expert level. This course was originally 2 separate courses, but then combined into one. In the first course, you will learn Excel from the very basics until you can master all aspects of the software. And in the second course, you will go deeper into formula and functions in Excel.The curriculum is carefully crafted so you can learn Excel in the shortest time possible but still through a learning process that feels easy. After this course, in sha Allah, you will have real and applicable competencies in Excel that can help your business or your career.In addition to providing complete lessons from start to finish, this course also provides 2 levels of exams to reinforce and guarantee that you have mastered all the skills. Upon completion, we will reward your success with a valid Udemy certificate that can help boost your professional resume.About the authorI am an entrepreneur, who is also an academic lecturer in information systems and computer graphics. I have a bachelor's degree in software development and a master's degree in information systems and business management. For more than 20 years, I have been using Microsoft Excel for a variety of needs, be it for business or academic purposes. I use Excel for bookkeeping or finance, student data management, academic research, project management, data analysis, and so on. By the time I published this course, I had more than 50,000 students at Udemy, with an average star rating above 4.5. And a total of 100,000 students worldwide.What you will learnThere are so many things that you will learn in this online course. It would take too long to explain all of them in this description. To see the details, you can check the curriculum section. As a macro-overview, there are a total of 18 chapters, excluding the introduction chapter. 10 of which are from the basic-level course. And 8 of which are from the advanced formula and functions course. In total, there are more than 135 lessons, and more than 16.5 hours of video content.In the first course, after the introduction chapter, you will learn the basics of Microsoft Excel such as the UI and navigation techniques, etc. Learn about data types and techniques for working with data. Then you will learn how to use various types of cell references, from the simplest to the most complex ones. Next, you will learn the ins and outs of data presentation in Excel. Then learn various techniques for structuring the table. In the next section, you will learn about various things related to graphics. Such as creating SmartArt, Charts, and Sparklines. In the next chapter, we will discuss advanced data processing techniques. We will discuss things like find and replace techniques, data sorting, filters, and so on. Then after that, we will discuss in detail everything related to tables, pivot tables, and how to combine the two features. We'll also cover a variety of conditional formatting features from the basic examples to more complex ones. And in the final chapter, we will cover different techniques related to printing and exporting, such as defining print areas, exporting to PDF, and so on.In the second course, first, you will learn important tips related to working with formulas in Excel. Then you will learn advanced techniques related to tables and dynamic arrays. In the next chapter, you will learn various conditional functions. Such as IFS, SUMIFS, AVERAGEIFS, etc. You will also learn logical functions such as AND, OR, and NOT. Next, you will learn various lookup functions, such as VLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, etc. You will learn in detail the "Match Mode" and "Search Mode" arguments, complete with various use cases. We will discuss rounding and division techniques, such as ROUNDOWN, ROUNDUP, and so on. In the next chapter, you will learn various techniques related to date and time. Such as extracting time data, converting time to different formats, and so on. Next, you will learn in-depth various techniques for working with text data. In the final chapter, you will learn various functions related to statistics, such as how to forecast future conditions based on trends or past data.So don't wait any longer. Join this course now! And maximize your Excel skills to their fullest potential.
