K2's Next Generation Excel Reporting
-
Virtual
8.00 Credits
Member Price $309.00
Non-Member Price $359.00
Overview
You could pay $0 for this course!
This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1130296. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.
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
Prerequisites
Fundamental knowledge of Microsoft Office Excel 2019 or newer
Designed For
Excel users who want to improve Excel-based reporting processes to create accurate reports quickly and easily
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
Preparation
None
Non-Member Price $359.00
Member Price $309.00