|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-for-beginners-navigation-pivot-tables-and-vlookup/
课程评论：没有评论
Coursera 课程总结：Excel 入门 - 导航、数据透视表和 VLOOKUP 本课程专为 Microsoft Excel 新手设计，旨在将完全的 Excel 初学者（从未打开过 Excel 的学员）转化为能够熟练操作软件、制作专业报表的“报告达人”。 **您将学到：** * **Excel 基础导航：** 熟练掌握工具栏和菜单栏的使用。 * **文件保存：** 正确将工作簿保存为 Excel 文件格式，而非 CSV 文件。 * **表格构建：** 学习如何导航行、列和单元格，插入列、行，并理解工作表的概念。 * **基础电子表格制作：** 创建简单的电子表格，包括设置易于查看的标题菜单和为所有单元格添加边框。 * **快捷键应用：** 掌握 Shift + End + Down 等常用快捷键，快速选中整行/整列，并能快速高亮显示整个工作表。 * **数据管理：** 学习数据的排序和筛选功能。 * **基础公式：** 理解并应用 SUM（求和）、AutoSum（自动求和）、乘法和平均值公式。 * **高级功能：** 学习使用数据透视表（Pivot Tables）和 VLOOKUP 公式。 * **快速报告制作：** 将所学知识融会贯通，快速制作专业报告。 授课讲师拥有长达十年的专业 Microsoft Excel 使用经验，深刻理解初学者可能遇到的困惑，并能帮助学员按自己的节奏学习，轻松掌握 Excel 的使用技巧。
Are you new to Microsoft Excel?This course is designed to take the complete Excel beginner, literally someone that has never logged into Excel before, and show them how to navigate around the software, how to become comfortable with the software and finally, how to become a reporting pro!What you will learn in this Excel for Beginners course:navigate toolbar and menu barHow to Save as Workbook Not as CSV FileNavigate Rows Columns CellsInsert Column Insert Row Sheets ExplainedBuild a Basic Spreadsheetheader menu - make it easy to look atadd outline box to all cellsShortcut Keysshift end down and others - half triangle highlight entire sheet fastsorting and filteringsum, autosum, multiply-averagepivot tablesvlookup formulabuild report fast - put it all togetherAs someone that professionally uses Microsoft Excel in 50% of my job for the last 10 years, I am qualified to teach you how to use Excel. I understand what it is like to open Excel up and not really know what to do with the data. Let me show you how to get around Excel and learn at your own pace. I look forward to seeing you in the course!
