|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/analysis-for-office/
课程评论：没有评论
**SAP Analysis for Office 课程总结** 本课程为学习 SAP Analysis for Office (AO) 的入门到进阶指南，无论您是否有经验，都能从中受益。课程从零开始，详细讲解 AO 的各项功能，确保初学者也能轻松掌握。 **核心内容包括：** * **数据筛选：** 学习多种数据筛选技巧，包括如何在层级结构中筛选、按成员筛选以及使用后台筛选。 * **用户界面定制与设置：** 掌握如何自定义用户界面，并利用 AO 的选项和技术设置来配置其行为。课程会重点指出影响 AO 行为的各项设置。 * **上下文菜单运用：** 了解 AO 各功能提供的上下文菜单及其使用方法。 * **变量处理：** 学习变量提示（Variable Prompt）以及 AO 中的变量。 * **数据分析与呈现：** 学习如何对数据进行排名、在报告中展示数据信息。 * **动态创建与计算：** 学习现场创建层级结构（hierarchies on the fly），以及创建自定义计算指标（calculated key figures）和受限关键指标（restricted key figures）。 * **与 Microsoft Office 集成：** * 将 AO 数据集成到 Microsoft PowerPoint 演示文稿中。 * 在 AO 报告中使用 Excel 公式。 * 利用条件格式（conditional formatting）、Microsoft Excel 样式和图表（charts）来格式化和展示数据，并确保图表与数据联动。 * **API 概览：** 提供关于 Analysis for Office API 和 Microsoft VBA 的概览。 本课程旨在帮助您全面掌握 SAP Analysis for Office 的各项功能，从而高效地进行数据分析和报告制作。
In this course, you will learn SAP Analysis for Office from scratch. I explain every single function of Analysis for Office to you. So you can start with no knowledge about Analysis for Office. And if you have already some knowledge about Analysis for Office, you can look into the advanced section and see what you can do with Analysis for Office.You will learn how to filter data in different ways like in hierarchies, by members or via the background filter. How to customize the user interface and use the Analysis for Office options and technical settings to configure the behavior of Analysis for Office. If three is a setting to change the behavior, I will point it out to you. I show you the different context menus you get on each function and how you can use it. You learn about the variable prompt and also about variables in Analysis for Office. If you want to rank your data or display information about your data in your reports, you find information how to do so.You will create hierarchies on the fly and create own calculated and restricted key figures. Furthermore, you will learn how to create a Microsoft PowerPoint presentation with your data and how to use Excel formulas in your report. I teach you how to format and display your data in your report with conditional formatting, Microsoft Excel styles and charts which are linked to your data. You also get an overview about the Analysis for Office API and Microsoft VBA.
