|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-beginner-to-intermediate-level-training/
课程评论：没有评论
**Coursera 课程总结：Microsoft Excel 初级到中级培训** 本课程旨在帮助您通过学习 Microsoft Excel 来简化工作。Excel 是 Microsoft Office 中最常用的产品之一，广泛应用于数据录入、数据分析、数据展示和计算。 **课程目标人群：** 本课程特别为工程师、审计员、记录员、数据分析师、数据录入员、学生、教师、研究人员，以及任何希望学习 Excel 的人士设计，涵盖从初级到中级水平。 **课程内容与结构：** * **总时长：** 约 4.5 小时，包含 42 个视频讲座（不含预览视频）。 * **基础友好：** 课程假定学习者拥有非常基础的 Excel 知识或为初学者，并包含一些入门级内容，但学习者可根据自身情况跳过。 * **版本兼容：** 课程以 Microsoft Excel 2016 版本为基础，但内容也适用于其他旧版本或最新版本。 * **实践资源：** 提供 Excel 练习文件和常用快捷键文件供下载练习。 * **核心章节：** 1. 介绍 2. Excel 数学函数 3. 绝对与相对引用及单元格命名 4. Excel 格式与数据类型 5. 工作表和工作簿导航 6. Excel 运算符与公式 7. 自动填充、选择性粘贴选项与 Excel 错误 8. Excel 逻辑函数 9. VLOOKUP（查找与引用）函数 10. Excel 审核功能 11. 插入图表、表格、批注与超链接 12. 信息、文本、日期、时间和引用函数 13. Excel 数据工具 14. 条件格式、排序与筛选选项 15. 打印与视图 **总结：** 本课程被认为是学习 Excel 的宝贵资源，相信能帮助您出色地掌握 Excel 的各项实用功能，提高工作效率。
Make Your Work Easier By Learning this Microsoft Excel course.Microsoft Excel is one of the most used products of Microsoft office & used for data entry, data analysis, data presentation, or calculation. This MS Excel course is Beginner to Intermediate Level training especially for engineers, auditors, record keepers, data analysts, data entry operators, students, teachers, or researchers, or for anyone who just wants to learn MS Excel. If your interest lies in any of the above-mentioned areas or any other field where Excel is used then this MS Excel training course really going to help in your work.Excluding the preview video, this Microsoft Excel course has a total of 42 video lectures with a total length of almost 4.5 hours. This course is designed by assuming that you have very basic knowledge of excel or you are totally beginner & started using MS Excel the very first time. Just to facilitate the beginners, some basic or entry-level topics are also included but you can skip those if you already have the basic knowledge.This course is designed in Microsoft Excel 2016 version but you can easily learn in almost any older or latest version of MS Excel.Excel sample files or excel practice worksheets are attached that you can download & practice on. Also, the MS excel shortcut keys file is attached. This course is divided into the following different sections:1. Introduction2. Mathematical Functions in Excel3. Absolute & Relative References and Excel Cell Name4. Formatting & Data Types in Excel5. Roaming in Excel Worksheet or Workbook6. Operators & Equations in Excel7. AutoFill, Paste Special Options & Excel Errors8. Logical Functions in Excel9. VLOOKUP Function in Excel10. Auditing in Excel11. Inserting Charts, Tables, Comments & Hyperlink12. Info, Text, Date, Time & Reference Functions13. Data Tools in Excel14. Conditional Formatting, Sort & Filter Options15. Printing & ViewingI strongly believe that this MS excel course will really be worth watching for you & I am sure that you will be very happy to choose this. Just hit the enroll button & start learning today.
