Menu

K2's Next Generation Excel Reporting - VIRTUAL / LIVE

Prerequisites

Fundamental knowledge of Excel 2019 or newer

Objectives

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

Highlights

  • 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

Register Now

Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

Event Code:

NGE0717

8 CPE Credits
Accounting: 8 Credits

Registration

Member Price:
$309 $359
Non-member Price:
$399 $449
Register by July 3rd for Early Bird Pricing.

Registration is open through 07/16.

Monday, July 17th

10:00am to 5:30pm
(Check-In 9:30am)

Add to Calendar

Instructor

Steve Yoss

Related Courses

K2's QuickBooks for Accountants - VIRTUAL / LIVE

August 16, 2023

8 Credits
Details
Basic Audit Staff Training - Level 1 - VIRTUAL / LIVE

October 19, 2023

16 Credits
Details
Accounting for Revenues and Expenses in a Not-for-Profit - VIRTUAL / LIVE

October 24, 2023

4 Credits
Details
© 2023 Kentucky Society of Certified Public Accountants. All Rights Reserved. Contact Us