|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2013-basics-in-under-5-minutes-per-concept/
课程评论：没有评论
**课程名称：** 快速掌握 Excel 基础 **课程概述：** 本课程专为 Excel 新手设计，旨在帮助您快速成为一名自信的电子表格用户。所有视频时长均不超过 5 分钟，直观易懂，有助于您集中注意力。通过 20 多年的 IT 教学经验，讲师精选了 Excel 的关键知识点，并以简单易懂的语言进行讲解，避免技术术语。课程内容高度实用，您可以在学习概念的几分钟内就开始应用新技能。 **课程主要内容：** * **Excel 2013 基础：** 涵盖基本算术、格式设置、快捷键和实用技巧。 * **Excel 高级功能：** 介绍绝对引用和单元格的多重用途，以更好地利用 Excel 的强大功能。 * **常用公式：** 学习 SUM (求和)、AVERAGE (平均值)、IF (条件判断)、LOOKUP (查找)、RANK (排名)、COUNTIF (条件计数) 等公式，以及更多辅助您创建专业、高效电子表格的高级函数。 * **挑战活动：** 提供一系列自我评估的练习，帮助您巩固所学技能，并配有视频讲解解决方案。 * **图表制作：** 学习如何添加图表以增强信息的视觉效果。 * **进阶技巧：** 探索条件格式、生成随机数和概率等概念，以进一步提升您的电子表格技能。 **课程特色：** * 60 多个短小精悍的视频，每个视频不超过 5 分钟。 * 内容直击要点，讲解简单易懂，注重实际应用。 * 提供实践活动和视频解决方案，方便学习和巩固。 本课程将帮助您掌握 Excel 2013 的核心功能，成为一名更具竞争力的职场人士。
*** All videos are under 5 minutes in duration and are straight to the point to help maintain your concentration *** This course in Excel 2013 will allow a novice user to quickly become a confident spreadsheet user. Highly practical, you can be applying your new skills within minutes of learning a concept. Having taught IT for over 20 years I've identified the key aspects and you will benefit from my experience. You will find my videos straight to the point and that I explain all concepts in simple terms rather than getting too technical or using IT jargon. Wherever possible I provide practical examples to demonstrate where the concept being explored can be applied. I have taught these concepts to 1000s of students during my career and now would like to give you the opportunity to also learn some new, valuable and employable workplace skills The course consists of a brief overview of each concept and short, sharp videos covering the key points for all topics. Additionally, there is a practical, self-marked activity for you to complete and three videos showing me completing the task should you encounter difficulties. Major topics include: Basics of Excel 2013 - simple arithmetics, formatting, shortcuts and tricks of the trade. Additional features to better utilise the power of Excel - absolute referencing and using cells in multiple ways. Using Common Formulas - sum, average, if, lookup, rank, countif, plus some more advanced functions available to assist you to create professional, efficient spreadsheets. A Challenge Activity - self-marked series of examples to try your new skills. Videos of solutions to all activities are also provided. Adding Charts / Graphs to improve the visual effectiveness of highlighting your information. Some additional concepts to further develop your spreadsheeting skills including using conditional formatting, generating random numbers and probability. I look forward to assisting you in becoming a confident user of Excel 2013.
