MICROSOFT FRx
ESSENTIALS 2

Microsoft FRx Essentials 2: This class designed to help you gain complete control of your financial reporting process. You will learn how to create a comprehensive financial and management reporting package that includes non-financial information from Excel, and how to create more complex reports such as statements of cash flow and those reports that require complex calculations.

This class is ideal for

Intermediate and advanced FRx users wishing to gain expert-level product efficiency

Topics Included

  • Learn how to import non-GL information from external worksheets
  • Learn how to import data from spreadsheets
  • Discover more efficient ways to perform consolidations and allocations
  • Create a variety of cash flow statements
  • Learn advanced formatting concepts
  • Use Row Linking to speed up processing time and reduce maintenance requirements
  • Create advanced income statement reports using multiple segments in the row format
  • Create complex calculations such as specific column placement and conditional statements
  • Learn to rotate (expenses in columns)
  • Relational Reporting (percentage of sales)

After completing this course you will be able to:

  • Link To data in Excel spreadsheets and use that data in FRx reports
  • Create Consolidation Reports
  • Create soft and hard Allocation Reports
  • Link to different row formats

Pre-requisites:

Students should have completed Microsoft FRx Essentials I or have equivalent experience. (E1 course completion is strongly encouraged.) Refunds cannot be given to students who attend training classes that exceed their FRx skill sets.

No advance preparation required for this course.

Tuition:

$995. Buy the book: $175 (included in the registration fee)

There are currently no scheduled classes. Please contact us to inquire about availability. View Calendar

Solutions by Industry

Manufacturing
Read More
Distribution
Read More
Medical
Read More
Financial
Read More
Services
Read More

What's New

Sage 100 2022.2 Release

Sage is pleased to announce the availability of Sage 100 Release 2022.2, 2021.5, 2020.6 and Sage 100 Payroll 2.22.3 as of Thursday, September 15, 2022. Read More

Submitted by Stephanie Dean on Thu, 09/29/22 - 8:00

Acumatica 2022 R2 Release

The release offers innovations in usability, includes the increased ability for businesses to target new geographic markets and segments, and sharpens the targeting of micro-markets and verticals Read More

Submitted by Stephanie Dean on Tue, 09/27/22 - 8:00

Updated Guidance from Microsoft regarding OAuth for Sage 100

Sage received updated guidance from Microsoft specific to the use of SMTP Auth for email integration between Sage 100 and Exchange Online. Here's what you need to know... Read More

Submitted by Stephanie Dean on Thu, 09/22/22 - 8:00

Whatever Your ERP Needs, We Have the Solution!

Or call us for a free consultation 866-379-3799