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)

NASBA CPE Credits:

8 CPE credits can be awarded for both Classroom Training and Live Web (Group Internet) format. This is an estimate based on the NASBA standard of 1 credit per 50 minutes of instruction. Learn more about our CPE certification.
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

Acumatica Summit 2019: Everything You Need to Know

Acumatica Summit 2019 was full of valuable information for customers and partners alike with educational sessions, product demos and keynotes from the best in the industry. If you couldn’t attend the invitation-only event, we have everything you need to know about this year’s conference. Read More

Submitted by Patrick Wills on Fri, 02/15/19 - 13:54

How to do a Bank Transfer in Sage 100cloud

When making a bank transfer there are different ways one can do it and below we will discuss two different ways using the Sage 100Cloud General Ledger Module. Read More

Submitted by Patrick Wills on Thu, 08/02/18 - 9:28

How to Plan an ERP Implementation Project from Start to Finish (and Beyond!)

ERP implementation projects have a notoriously high failure rate.  One of the things conveniently left out of reports containing these troubling statistics is why so many implementation projects fail to deliver expected results on time or on budget.  Of course, there is an infinite number of reasons that ERP projects fail, but the truth is that poor project planning is one of the most common. Without clarity on project structure, activities, roles, and responsibilities, ERP implementation projects can often suffer from confusion and resistance, making execution extremely difficult.  Read More

Submitted by Sean Atkins on Wed, 07/18/18 - 11:42

Whatever Your ERP Needs, We Have the Solution!

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