|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-mastering-formulas-in-excel/
课程评论：没有评论
**课程名称：** Microsoft Excel - 掌握 Excel 中的公式 **课程概述：** 欢迎来到《掌握 Excel 中的公式》课程！本课程旨在帮助您掌握 Excel 公式的基础知识，从而释放 Excel 的隐藏潜力。讲师使用 2020 年最新的 Windows 版 Excel 录制，但其他版本在操作上差异不大。课程中将提供可下载的电子表格，鼓励学员跟随讲师一起操作并进行比对，这是最有效的学习方式。讲师对 Excel 充满热情，希望将这份热情和专业知识传授给学员，让您快速成为 Excel 使用高手，节省宝贵时间，并展现您的才华。 **课程内容：** * Excel 中查找和使用公式的基础介绍 * 深入了解一些简单的公式 * 如何统计有数据的单元格 * 如何对数字进行四舍五入 * 如何比较两个列表 * 使用 VLOOKUP 和 HLOOKUP 函数从表格中提取数据 * 复制公式以确保其正常工作（绝对引用和相对引用） **学习目标：** 学员将能够自信地使用 Excel 公式，提高工作效率，并像专家一样操作 Excel。 **讲师寄语：** 希望您喜爱本课程，并从中受益匪浅。祝您 Excel 学习愉快！
Welcome to my Mastering Formulas in Excel course.You will learn the fundamentals of working with formulas, which really unleashes the hidden power of Excel.I used the Windows version of Excel current in 2020 to make this course, but other versions should not be that different.I will be creating a spreadsheet during the course that you can download. The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much time, as well as look like a genius!In this course I cover:Basic introduction to finding and using Formulas in ExcelA closer look at some simple formulasHow to count cells with data How to round numbers How to compare two listsExtracting data from a table using vlookup and hlookup functionsCopying formulas so that they work - absolute and relative referencesI hope that you love this course and get a lot out of it.Happy Excelling!Keith
