Microsoft FRx Report Design Essentials - II

Microsoft FRx Report Design Essentials II (formerly known as Advanced Report Design)  is a two-day class designed to help you gain complete control of your financial reporting process.  You 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.

Course objectives:

·          Learn how to import non-GL information from external worksheets

·          Learn how to import data from spreadsheets

·          Create a variety of cash flow statements

·          Discover more efficient ways to perform consolidations and allocations

·          Create advanced income statement reports using multiple segments in the row format

·          Learn to rotate (expenses in column)

·          Relational Reporting (percentage of sales)

·          Learn advanced formatting concepts

·          Use Row Linking to speed up processing time and reduce maintenance requirements

·          Create complex calculations such as specific column placement and conditional statements

·          Create and analyze OLAP cubes using FRx instant!OLAP

·          Perform currency translations using Microsoft FRx Desktop

·          Review currency translation using the FRx Currency Translation module (Online Tutorial provided for detailed instruction)

·          Learn the basics of XBRL report design and output