|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-quick-start/
课程评论:没有评论
Coursera 上的Microsoft Excel:快速入门课程是一门旨在帮助您快速掌握Excel核心技能的实用课程。无论您是完全的初学者,还是需要更新知识的Excel用户,本课程都适合您。 **为什么选择这门课程?** * **提升职业竞争力:** 学习雇主普遍看重的Excel技能,增加您的就业选择和潜在薪资。 * **高效学习:** 课程采用短小精悍的讲座形式,让您可以快速学习并立即应用。 * **实践检验:** 通过动手练习和测验,巩固所学知识,确保理解到位。 **课程内容涵盖:** * Excel界面导航 * 数据录入与格式设置 * Excel公式和常用内置函数的使用 * 数据转换为Excel表格 * 数据排序与筛选 * 多工作表的管理 * 数据准备与打印 * 创建数据透视表 * 创建Excel图表 * VLOOKUP和HLOOKUP函数 * 以及许多实用的Excel快捷键。 **课程组成:** * 精炼的讲座视频 * 学习测验 * 练习题 * 习题解答视频 * 所有课程演示文稿的PDF版本 * 包含所有课程资源的压缩文件 **特别说明:** 本课程基于Windows 10 PC和Microsoft 365版本的Excel创建。如果您使用的是Mac或旧版本Excel,可能需要进行一些调整。 **讲师优势:** 讲师拥有数十年的电子表格使用经验,自Excel发布以来已持续使用,并曾担任专业Excel培训师。 **未来更新:** 课程将不断更新,未来计划加入挑战性练习(可在没有Excel的情况下进行测试)和条件格式等内容。 期待在课堂上与您相见!
Who Is This Course For?Anyone who wants to learn Microsoft Excel.Those who have used Excel in the past, but need a refresher.Why Take This Course?Increase your earning potential by having skills employers want.Have the skills to apply for more jobs.Learn what you need to learn quickly with short, focused lectures.Try out what you're learning with practice exercises.Test your understanding with quizzes.What's Covered in the Course?Navigating Microsoft Excel.Entering and formatting Excel data.Writing Excel formulas and using some of its built-in functions.Converting data to Excel tables.Sorting and filtering data in your Excel worksheets.Using multiple Excel worksheets.Preparing and printing your data.Building Excel pivot tables.Creating Excel charts.And using Excel's VLOOKUP and HLOOKUP functions.You'll also learn some Excel shortcuts along the way.What the Course ContainsShort, focused lectures.Quizzes.Practice exercises.Practice exercise solution videos.PDF versions of all the presentations in the course.A zip file with all the course resource files.The course was created on a Windows 10 PC using Excel for Microsoft 365. If you're using a Mac or an older version of Excel, you may need to make some adjustments to the steps I show you.Why Take My Course?I've been using spreadsheets since before Excel existed.I've been using Microsoft Excel since it was released in 1985.I have taught Excel to adult learners in several different settings, including as a trainer for CompUSA.I love using Excel and use it almost every day for business and personal use.Coming Soon!Additional enhancements and updates are always being made to the course. I'm currently working on adding:Challenge Exercises - Interactive videos that let you test your knowledge, even if you don't have Excel!Conditional Formatting - This section will be added to the course.I can't wait to see you in class!