CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS

All New and Current customers who purchase the Premium, Plus, or Core (Total Value Package) 2021 Federal Tax Update or the 2021 Federal and California Update will get the Tax Advisory Complement Bundle for free.

NOTE:

  • New Federal Tax Update customers will get an immediate email with a coupon code for the free course once their Tax Update purchase is complete.
  • Current Customers that purchased the Premium, Plus, or Core (Total Value Package) 2021 Federal Tax Update will get an email with a coupon code to get the Tax Advisory Complement Bundle for free.

Better Financial and Operational Reporting with Excel

Icon_Webcast
Webcast
Icon_Level
Advanced
Credits
CPE Credits
5 Credits: Accounting

Course Description

Financial and operational reporting continues to consume too much time because most accounting and financial professionals are not taking advantage of the modern tools available in Excel. These tools can help you produce better quality reports in far less time than many of the traditional reporting processes you may be using today and, in this session, you will learn how to put these tools to work the right way for better results.

In this course you will learn the best practices for creating financial and operational reports. You will also learn how you can use tools such as Data Models, Power Query, Power Pivot, and PivotTables to create and publish effective financial and operational reports from Excel. Finally, you will also learn how you can leverage your knowledge of Excel features to create effective reports using Microsoft’s free Power BI application. In sum, if you create financial and operational reports, you can’t afford to miss this session.

 

Highlights include:

  • Best practices for Excel-based financial and operational reporting
  • Creating and managing Data Models using multiple techniques and tools
  • Using Power Query to link data into Excel and transform the data to make it more useful
  • Create PivotTables to summarize transactional data into financial and operational reports
  • Build fundamental financial and operational reports using Power BI Desktop

*This course is “laptop-friendly” and participants will have access to demonstration files. This course focuses on features found in Excel 2016 and newer for Windows.

Learning Objectives

Upon successful completion of this course, participants will be able to:

  • List best practices for Excel-based financial and operational reporting
  • Define and create Data Models in Excel
  • Manage Data Models effectively with Power Pivot by adding features such as KPIs
  • Utilize tools such as Power Query to link accounting transactions into Excel and apply critical transformations to your data to make it more useful
  • Summarize the data in your Data Models using both PivotTables and formula-based techniques
  • Work with Power BI Desktop to create and publish financial and operational reports

Course Specifics

Course ID
WC1121236501
Original Release Date
May 4, 2020
Revision Date
May 4, 2020
Prerequisites

Fundamental knowledge of Excel

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Stephen M. Yoss Headshot
K2 Enterprises (Stephen M. Yoss, Jr., CPA)

Stephen M. Yoss, Jr., CPA, MSIST, is a certified public accountant, the senior technology strategist and principal of Yossio, a continuing education instructor for financial professionals, and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions. At age 10, Stephen began working with technology; he started his first IT company at just 13, which focused on designing web applications for local businesses. At 15, he began writing original computer code and has been designing and implementing technological solutions continuously since then. Stephen is a graduate …

K2 Enterprises (Stephen M. Yoss, Jr., CPA) Read More »

Better Financial and Operational Reporting with Excel

CPE CREDITS
5 Credits: Accounting

$294.00


Webcasts are available for viewing Monday – Saturday, 8am – 10pm ET.
This webcast is 5 hours in length so you must start it before 05:00 pm ET.
Start within 3 hour(s) and 25 minutes to watch today.

Icon_Webcast
Webcast
Icon_Level
Advanced
Credits
CPE Credits
5 Credits: Accounting

Course Description

Financial and operational reporting continues to consume too much time because most accounting and financial professionals are not taking advantage of the modern tools available in Excel. These tools can help you produce better quality reports in far less time than many of the traditional reporting processes you may be using today and, in this session, you will learn how to put these tools to work the right way for better results.

In this course you will learn the best practices for creating financial and operational reports. You will also learn how you can use tools such as Data Models, Power Query, Power Pivot, and PivotTables to create and publish effective financial and operational reports from Excel. Finally, you will also learn how you can leverage your knowledge of Excel features to create effective reports using Microsoft’s free Power BI application. In sum, if you create financial and operational reports, you can’t afford to miss this session.

 

Highlights include:

  • Best practices for Excel-based financial and operational reporting
  • Creating and managing Data Models using multiple techniques and tools
  • Using Power Query to link data into Excel and transform the data to make it more useful
  • Create PivotTables to summarize transactional data into financial and operational reports
  • Build fundamental financial and operational reports using Power BI Desktop

*This course is “laptop-friendly” and participants will have access to demonstration files. This course focuses on features found in Excel 2016 and newer for Windows.

Learning Objectives

Upon successful completion of this course, participants will be able to:

  • List best practices for Excel-based financial and operational reporting
  • Define and create Data Models in Excel
  • Manage Data Models effectively with Power Pivot by adding features such as KPIs
  • Utilize tools such as Power Query to link accounting transactions into Excel and apply critical transformations to your data to make it more useful
  • Summarize the data in your Data Models using both PivotTables and formula-based techniques
  • Work with Power BI Desktop to create and publish financial and operational reports

Course Specifics

Course ID
WC1121236501
Original Release Date
May 4, 2020
Revision Date
May 4, 2020
Prerequisites

Fundamental knowledge of Excel

Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

Stephen M. Yoss Headshot
K2 Enterprises (Stephen M. Yoss, Jr., CPA)

Stephen M. Yoss, Jr., CPA, MSIST, is a certified public accountant, the senior technology strategist and principal of Yossio, a continuing education instructor for financial professionals, and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions. At age 10, Stephen began working with technology; he started his first IT company at just 13, which focused on designing web applications for local businesses. At 15, he began writing original computer code and has been designing and implementing technological solutions continuously since then. Stephen is a graduate …

K2 Enterprises (Stephen M. Yoss, Jr., CPA) Read More »

Better Financial and Operational Reporting with Excel

CPE CREDITS
5 Credits: Accounting

Webcasts are available for viewing Monday – Saturday, 8am – 10pm ET.
This webcast is 5 hours in length so you must start it before 05:00 pm ET.
Start within 3 hour(s) and 25 minutes to watch today.

$294.00