|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-365-advanced/
课程评论：没有评论
**课程名称：** Mastering Excel 365 - Advanced (2023) **课程概述：** 本课程专为需要深入掌握Excel进行数据分析和报告的商业专业人士设计。您将学习Excel的高级工具，以有效汇总信息、识别错误、应用条件格式以及查找和评估数据。课程将由Excel专家Kathy Jones教授，重点讲解如何充分利用筛选和排序技巧，包括新的动态数组函数。掌握这些技术将帮助您在处理大小不同的数据集时，都能快速找到所需信息。 课程还将涵盖如何为图表添加趋势线，以增强预测的可视化效果，并通过创建自定义模板来节省重复工作时间。此外，您将学习如何创建和修改关键对象，如数据透视表、宏和图形。 如果您需要轻松识别排名或为检查生成随机数，本课程也将教授相应的Excel应用方法。 **主题涵盖：** * 创建、保存和使用自定义工作表模板 * 探索动态数组函数 * 使用LOOKUP、文本、日期和数据库函数 * 使用高级筛选和排序技术 * 应用和修改数字、文本和日期单元格的数据验证 * 使用“分类汇总”函数和“分类汇总”功能 * 使用“数据合并”功能汇总来自多个区域的数据 * 创建、修改和筛选数据透视表 * 创建宏和添加窗体控件 * 创建自定义图表和图表模板 * 插入、格式化和修改图形（截图、符号和3D模型） * 运行“检查可访问性”并进行必要的更改 * 保护工作表、工作簿和区域 课程内容超过四个小时的高质量高清内容，采用“独具匠心”的Bigger Brains师生互动教学风格。
Learn many of Excel's advanced tools for analyzing and reporting on your dataBeing able to use Microsoft Excel skillfully is crucial for all business professionals who use, analyze, and apply data. Excel is the most popular data analysis tool in the workplace, so increasing your understanding of its advanced features is both necessary and smart.Excel expert Kathy Jones will show you how to make use of advanced features to summarize information, identify errors, apply conditional formatting, and find and assess information. She will also demonstrate how to best utilize available filtering and sorting techniques, including the new dynamic array functions. Learning to use these techniques will enable you to find the information you need when analyzing either large or small data sets.Since graphs greatly enhance your reports, you'll learn how to add trendlines to charts to add a visual element to your forecasting and how to save time by creating custom templates that can be used repeatedly. You'll also be able to create and modify important objects such as PivotTables, macros, and graphics.Finally, if you're looking to easily identify rankings or need to generate random numbers for inspections, this course will teach you how to use Excel to help you do it!Topics covered include:Creating, saving, and using a custom worksheet templateExploring dynamic array functionsUsing the LOOKUP, text, date, and database functionsUsing advanced filtering and sorting techniquesApplying and modifying data validation for numbers, text, and date cellsUsing the Subtotal function and the Subtotals featureUsing Data Consolidation to summarize data from multiple rangesCreating, modifying, and filtering a PivotTableCreating macros and add form controlsCreating custom charts and chart templatesInserting, formatting, and modifying graphics screenshots, symbols, and 3D modelsRunning the Accessibility Checker and addressing needed changesProtecting sheets, workbooks, and rangesOver four hours of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
