|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-365-intermediate/
课程评论：没有评论
Microsoft 365 Excel 中级课程 本课程旨在帮助您掌握 Microsoft 365 Excel 的中级技能。课程内容涵盖： * **基础表格功能：** 学习表格的创建、排序和筛选数据。 * **图表与图形：** 掌握图表的创建、增强、修改和美化，包括插入形状、图片和迷你图。 * **常用函数：** 深入学习统计函数、文本函数、日期时间函数、逻辑函数以及多工作簿操作。 * **核心函数应用：** 重点讲解 IF、IFS、VLOOKUP 和 COUNTIF 函数，并介绍一些“Power Functions”。 * **工作簿优化与分享：** 学习排版、打印设置、工作簿的保存（不同格式）、添加超链接、邮件发送以及工作簿的保护与共享，包括追踪更改。 课程还提供可下载的随堂测试及答案解析，助您巩固学习成果。
Learn Microsoft 365 Excel intermediate level going over basic table features, adding charts and graphs, working with functions, IF, VLOOKUP COUNTIF power functions, finalize printing saving workbooks, security and sharing workbooks. A downloadable Test Quiz is included with enclosed answer key. What you will learn: Introduction Excel 365 Intermediate Overview of entire course Excel 365 Intermediate Chapter 1 Basic Table features Chapter 1 Overview What tables are Sort and filter data part 1 Sort and filter data part 2 Creating and using tables Chapter 2 Adding charts and graphics Chapter 2 Overview Charts and Graphs What are Charts and Graphs and the difference Creating a chart Enhancing a chart Modifying chart data Changing chart types Inserting shapes and other features Working with chart elements Formatting charts Inserting pictures Creating in-cell charts with sparklines Chapter 3 Working with functions Chapter 3: Overview Statistical functions Using statistical functions Calculating present value Calculating loan payments and payoff Calculating principle & interest paid Calculating interest rate, auto calculations Working with text functions Working with ranges Using date and time functions Working with logical functions Copying formula values Chapter 4 IF, VLOOKUP, COUNTIF, Power Functions Chapter 4 Overview Using the IF Function Using IF with relational operators Using the IFS function Using VLOOKUP Using VLOOKUP approximate table data Using VLOOKUP exact table data Using COUNTIF Functions part 1 Using COUNTIF Functions part 2 Chapter 5 Finalize, Print and Save Chapter 5 Overview Use proofing help and research tools exploring the page layout and view tabs working with layout and page setup changing view options Previewing and modifying page breaks Adding headers and footers previewing and printing the worksheet Arranging multiple workbooks Adding hyperlinks Saving workbooks in different formats Emailing a workbook Chapter 6 Security and Sharing in Excel 365 Chapter 6 Overview Unlocking cells and protecting worksheets Protecting workbooks Assigning passwords to workbooks Sharing workbooks part 1 Sharing workbooks part 2 Tracking Changes Conclusion Downloadable Test Quiz is included with enclosed answer key
