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.

Solutions by Industry

What's New

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

5 Ways to Maximize the Value of your Current ERP System

Many organizations aren't satisfied with the value their current ERP system delivers to the business. Before starting over with a new evaluation and selection process, it may help to take a step back and examine the ways in which your current system could be better. Here are five recommendations for maximizing the value of the ERP resources you already have and how to know when it's time to start fresh with a new ERP system. Read More

Submitted by Sean Atkins on Thu, 06/28/18 - 9:03

Whatever Your ERP Needs, We Have the Solution!

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