This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.
大多数会计师使用Excel来帮助他们对数据做出决策. 然而, 随着数据量的增长, 基于一排排、一排排、一排排的数据做出战略决策变得很困难. 在这个网络广播中,您将学习如何构建强大的仪表板来分析Excel中的关键指标.
We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. 然后,我们将为仪表板创建关键性能指标(kpi). You will learn how you can add charts and eye-catching visuals, in order to make your dashboards easily understood.
This webcast focuses on using standard Excel features to create visuals. Although we will introduce new tools like Power BI Desktop, the focus of this webcast is not about using Power BI to create visuals.
This series is presented using Excel 2019/Office 365. 无论您使用的是哪个版本, 本网络广播系列中涵盖的大多数概念适用于所有版本的Excel.
Explore the other webcasts in the 2020 Power BI Series:
Power BI - Introduction to MS Power BI Tools
Power BI - Prepare Your Data Efficiently for Excel Analysis
Power BI - Analyze Your Data With Excel Pivot Tables
Power BI - Use Power Query to Transform Your Data
Power BI - Go Beyond PivotTables with Power Pivot
Power BI - Use Advanced Calculations with DAX Formulas
Power BI - Use PBI Desktop to Create Reports and Dashboards
Power BI - Share Your Data Analysis using PowerBI.com
学习目标:
· Use dashboards to make strategic decisions
· Create KPI dashboards that graphically represent your data
· Use Excel tools to easily create meaningful KPI dashboards
谁将受益:
Anyone who wants to use Excel to make strategic decisions
这是美国注册会计师协会主办的网络直播. YOU WILL 发射 THE COURSE FROM YOUR OSCPA LEARNING PORTAL. AICPA WILL ISSUE AND MAINTAIN YOUR CREDITS. 请务必在网络直播结束时从aicpa网站下载您的cpe证书.