|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-the-complete-training-for-beginners/
课程评论：没有评论
课程名称：完整的微软Excel初学者培训 课程概述：本在线Excel教程由RCCS信息技术研究所设计与开发，旨在将他们的教学经验和服务传播到世界各地。该课程特别适合以下学习者：1. 对计算机基础知识有了解但尚不熟悉Excel及其操作的初学者；2. 刚刚学习Excel基础知识但缺乏经验和实践，希望提高知识与操作技能的学习者。 课程结构： 1. 简介 - Excel的解释 2. Excel基础 a. 工作表 - 操作与管理（单元格、公式、数据处理、简单计算等） b. 单元格引用 - 绝对引用、混合引用和相对引用（应用及示例） c. 公式栏 - 公式栏在Excel中的作用，各种计算及公式的制作与操作 3. Excel选项卡及功能区详解 a. 首页 - 常用命令和工具的操作与应用示例 b. 插入 - 常用命令和工具的操作与应用示例 c. 页面布局 - 常用命令和工具的操作与应用示例 d. 公式栏 - 高级工具 - 名称管理、公式审核 e. 数据 - 高级工具 - 情景、数据验证、合并、小计及分组、快速填充、文本到列、排序与筛选等命令和工具的操作与应用示例 f. 复习 - 保护工作表及常用命令和工具的操作与应用示例 g. 视图 - 高级工具 - 宏及常用命令和工具的操作与应用示例 4. Excel函数 - 解释及使用的示例 a. 数学函数 b. 统计函数 c. 逻辑函数 d. 文本函数 e. 日期和时间函数 f. 财务函数 g. 查找、索引与匹配函数 5. Excel图表 - 图表的设置与创建（柱形图、折线图、饼图、组合图、迷你图等） 6. 数据透视表与图表 - 设置与创建 7. Excel快捷键 - 常用快捷键及其使用示例 我们的承诺：由于该课程设计合理，学习方法循序渐进，学习者可以简单地掌握每个主题。在每个部分结束时，提供实验作业、指导视频和可下载文件供学习者进行实践。完成本课程后，我们确保您具备制作各种报表、报告及其打印、复杂计算等的Excel知识。 学习者建议：观看每个视频后，请自行练习，然后再开始下一个视频。实验作业也是按顺序添加的，以便您进行实践。通过这种方式，您的学习过程将是逐步的，您将有信心制作任何报表、报告、复杂计算及其打印。祝您好运，今天就开始学习吧 - 立即注册！
Designed and Developed ByThis Excel online Tutorial is designed and developed by RCCS, Institute of Information Technology to spread their teaching experience and services across the world.This Course well Suited For1. The learners who are the beginner, knowing computer basics, but not knowing excel and their operation 2. The learners who are just learned excel basics, but have no experience and practice, want to enhance knowledge and practiceCourse Structure 1. Introduction - Excel an Explanation 2. Excel Basics a. Worksheet - operation and management (cell, formula, data manipulation, simple calculation etc....) b. Cell Reference - Absolute, Missed and Relative Reference ( Application and uses with example) c. Formula Bar - role of formula bar in excel , various calculations and making formula and their operation 3. Excel Ribbon and Tabs - a detailed explanation a. Home - general commands and tools - operation and their uses with example b. Insert - general commands and tools - operation and their uses with example c. Page Layout - general commands and tools - operation and their uses with example d. Formula Bar - Advanced tools - Name Manager, Formula auditing d. Data - Advanced tools - Scenario, Data Validation, Consolidate, subtotal and group, Flash Fill ,text to column, sorting and filtering other commands and tools - operation and their uses with example e. Review - Protect sheet and general commands and tools - operation and their uses with example f. View - advanced tools - Macro general commands and tools - operation and their uses with example4. Excel Functions - explanation and uses with example a. Mathematical Functions b. Statistical functions c. Logical Functions d. Text Functions e. Date and Time Functions f. Financial Functions g. Lookup, Index and Match functions 5. Excel Charts - Setup and creation of Chart ( Column Chart, Line Chart, Pie chart, Combo Chart, Spark Line...)6. Pivot Table and Chart - Setup and Creation7. Excel Keyboard Shortcuts - frequently used shortcuts and their uses with example Our AssuranceSince this course is well designed and learning method is step by step from start to end, the learners can grasp simply each topics, and at the end of each section, there is a lab assignment - instruction video and downloadable file, for making practice. After the completion of this course, we are ensuring your excel knowledge, for making various statements, reports and their printing, complex calculations etc....Suggestion for Learners After watching each video, please practice it yourself, then start the next video. Lab assignment is added in order, so this also you can practice it. By doing this way, your learnings are step by step and you will be confident to make any statement , reports , complex calculations and their printing. All the best - start your learning today itself - enroll now
