|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-in-30-minutes-sorting-and-filtering-lists/
课程评论：没有评论
**Coursera 课程总结：Excel 30分钟精通 - 排序与筛选列表** 本课程是“Excel 30分钟精通”系列课程之一，专为已经掌握Excel 2019或Excel 365基础知识，但希望深入学习更复杂功能以分析数据的用户设计。课程旨在帮助学员在30分钟内高效掌握Excel中的数据排序和筛选技巧，从而提升业务生产力和个人竞争力。 **核心内容涵盖：** * **快速排序：** 学习使用Excel内置的快速排序选项。 * **多维度排序：** 掌握通过“排序选项”对话框进行多列排序、自定义列表排序以及按颜色排序。 * **自动筛选：** 学习应用自动筛选功能以查看特定数据，包括按日期和数字范围筛选。 * **高级筛选：** 学习利用自动筛选的分析选项，以及设置高级筛选以满足复杂的数据筛选标准。 **课程收益：** 通过完成本课程，学员将能够熟练地在Excel中对数据列进行排序和筛选。本课程是“Bigger Brains精通Excel 2019 - 中级”系列课程的一部分，完成整个系列将全面提升Excel中级应用能力。课程采用“Uniquely Engaging”™ Bigger Brains师生互动教学风格，提供高质量高清内容。
Learn to sort and filter columns of data in Excel 2019 or Excel 365-in under 30 minutes!When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Most businesses rely on Microsoft Excel, so increasing your knowledge is a boon to both business productivity and personal development. Our "Excel in 30 Minutes" series can help you get started.This course is one in a series of eleven 30-minute courses.Topics covered include:Sorting data using Quick Sort optionsSorting by multiple columns, custom lists, or colors using the Sort Options dialog boxApplying Autofilter to view specific dataFinding date and number ranges using AutofilterAnalyzing data using Autofilter optionsFiltering data based on complex criteria by setting up advanced filteringTake the full series and you will have completed our "Bigger Brains Mastering Excel 2019 - Intermediate" course.High-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!Target Audience: People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data.Course Goal: By the end of this course, you will be able to sort and filter columns of data in Excel.
