Course ID: NGEXR

Next Generation Excel Reporting

About & Customize

Popular Options

  • In-Person
  • Live Webcast

• Name at least three deficiencies associated with traditional Excel-based reporting practices

• Distinguish between the roles of tools such as Power Query, Power Pivot, and Data Analysis Expressions in next-generation Excel-based reports

• Cite the steps for creating data queries and transformations using Power Query

• Identify the opportunities for managing Data Models in Power Pivot

• List the steps necessary for summarizing data from a Data Model using a PivotTable

• Specify examples of formatting options and tools that you can use to enhance the appearance of an Excel-based report

• Identifying weaknesses in traditional reporting processes

• Using leading-edge features in Excel to improve reporting practices

• How to work with Power Query to solve common reporting challenges

• Adding Slicers and Timelines to your Excel-based reports

Designed For

Excel users who want to improve Excel-based reporting processes to create accurate reports quickly and easily

Field of Study
Computer Software & Applications
Prerequisites

Fundamental knowledge of Excel

CPE Credits
8
Level
Intermediate
Available Formats
In-Person, Live Webcast

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org