|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-basic-excel-formulas-and-functions/
课程评论：没有评论
Coursera 上的 Excel 公式与函数速成课 本课程是一门为期 3 小时的 MS Excel 公式与函数教程，旨在帮助您快速掌握 Excel 的强大功能，提升工作效率。无论您是 Excel 新手，还是希望更深入地了解常用函数，本课程都将为您提供全面的指导。 **课程亮点：** * **内容精炼，高效学习：** 课程聚焦于核心的 Excel 公式和函数，避免冗余信息，让您在短时间内获得最大化的学习效果。 * **专业讲师，经验丰富：** 由拥有十余年 Excel 使用经验的讲师教授，他们也是其他广受欢迎在线课程的创作者，广受好评。 * **全面覆盖，实战导向：** 课程涵盖数学函数（SUM, AVERAGE, MIN/MAX 等）、文本函数（TRIM, CONCATENATE, LENGTH 等）、逻辑函数（IF, COUNTIF, SUMIF 等）、日期时间函数（TODAY, NOW, DAY/MONTH/YEAR 等）、查找函数（VLOOKUP, HLOOKUP, INDEX/MATCH 等）、数据工具（排序、筛选、数据验证、去重、文本分列）以及数据透视表。 * **互动学习，巩固提升：** 每节课都配有练习文件，供您边学边练。同时设有测验环节，帮助检验学习效果。每章节更有实践练习和答案，助您巩固所学。 * **可验证证书：** 完成课程并通过相关要求后，您将获得可验证的结业证书。 **何谓 Excel 必备技能？** 本课程将帮助您掌握在专业工作场所处理 Excel 所需的全部技能。 **讲师承诺：** 我们致力于教学，并随时准备为您解答课程内容、练习文件或任何其他相关问题。您可以通过课程论坛或直接消息与讲师互动。
Start using Excel to its full potential to become proficient at your Excel tasks today! Either you're new to Excel, or you've played around with it but want to get more comfortable with all the popular functions in Microsoft Excel, either way, this course will be great for you.A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.Why should you choose this course?This is a complete and concise tutorial on MS Excel formulas which can be completed within 3 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant Excel operations. What makes us qualified to teach you?The course is taught by Abhishek and Pukhraj. Instructors of the course have been using Excel for over a decade. We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - SikiruVery insightful, learning very nifty tricks and enough detail to make it stick in your mind. - ArmandOur PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message. Download Practice files, take Quizzes, and complete AssignmentsWith each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance. What is covered in this course? This course covers everything you need to crack Excel in the professional work place.Below are the Excel course contents of this complete and concise course on Microsoft Excel:Introduction - In this video, the structure and contents of the course are discussed.Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MIDLogical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIFDate-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYSLookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCHData Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)Pivot Tables - This Excel lecture covers Pivot tables end-to-end.
