Home > BrittBrief > Microsoft FRx - How to Link Excel Spreadsheets to Your FRx Reports
Microsoft FRx - How to Link Excel Spreadsheets to Your FRx Reports 
 
9/16/2009 
ALP Recording 

Click on the image above to watch the webcast replay now.

 Class Description

Are you reporting using both Excel and FRx - separately?

Many times, it's better to pull your Excel data - from one or multiple spreadsheets - into your FRx reports.

In this class you will learn to use linking to Excel to:

  • Expand the range of your FRx reports
  • Include additional (non-GL) info in your FRx reports, such as:
  • Statistical info (e.g. headcount, units)
  • Calculated numbers
  • Special budget amounts
  • Automate by dynamically pulling spreadsheet info based on the FRx report date
  • Perform currency translation
  • Leverage real-time links to most accurate and current data in Excel spreadsheets
  • Save time and eliminate errors

 Class Handout

 Other Materials of Interest
Microsoft FRx-How to Organize Report Catalogs, Rows, Columns and Trees in FRx
Does your FRx environment need some spring cleaning? Over time, your FRx environment can become degraded. In this class, you'll learn: the key report that shows how your reports are tied to building blocks, how to clean up your FRx building blocks, how to leverage FRx trees to minimize the number of catalogs.
Microsoft FRx - How Enhance Your Statement of Revenues and Expenses in FRx - Part I
Ready to move to the next level with your FRx-based Statement of Revenues and Expenses?
Microsoft FRx - How to Share the Right FRx Module with Each User
Is each of your report consumers using the right FRx module? There's FRx Report Designer, FRx DrillDown Viewer, FRx Report Launcher, and FRx Report Manager.
Microsoft FRx -How to Analyze Frx Report Data using Excel Pivot Tables
Imagine the power of analyzing your FRx report data using the "slice-and-dice" power of Excel pivot tables.The "secret" is in properly configuring your FRx reports with pivot tables in mind. Simply exporting a typical FRx report can yield meaningless results. But a proper design in FRx will deliver insightful, information-rich pivot tables and charts.
Microsoft FRx - How to Make Transaction-Level Reports more Meaningful in FRx
Transaction-level reports in FRx are often difficult to decipher. Why? Because the standard transaction-level reports lack meaningful information
Microsoft FRx - How to Recycle your Reports using Row Linking in FRx
Do your FRx reports talk with one another? They can begin by linking row formats, so you can "recycle" your FRx reports. In this class, you'll learn how.
Microsoft FRx - How to Link Excel Spreadsheets to Your FRx Reports
Are you reporting using both Excel and FRx - separately? Many times, it's better to pull your Excel data - from one or multiple spreadsheets - into your FRx reports.
Microsoft FRx - How to Work Smarter using 25 Tips for FRx - Part II
Back by popular demand, we will cover 25 new tips for FRx.
Microsoft FRx - How to Schedule the Generation and Distribution of Reports using FRx Report Server
How can you accelerate your monthly close cycle and deliver crucial weekly FRx reports on time ...without taxing your staff? Selecting and queuing reports, preparing emails and posting reports to network folders can be time-consuming. Workstation and server performance can be slowed.
Microsoft FRx - How to Produce Better Monthly Report Books in Half the time
Clients of Brittenford Systems often tell us that building month-end report books is the most challenging time of each month. It can take hours or days to organize, compile, print, collate and distribute report books.
Microsoft FRx - How to Consolidate Multiple Companies in FRx
Struggling to consolidate companies with different charts-of-accounts or different fiscal year-ends? You'll learn how to automate the process and reduce errors.
12359 Sunrise Valley Dr, Suite 130, Reston, VA 20191
©2011 Brittenford Systems, Inc.
remote system administration
remote system administration