Use these solutions to organize, verify, and analyze financial data.

Financial data can be complex. Organizing, analyzing, and verifying the data in a timely and effective manner has far-reaching effects not only inside an organization, but outside to clients and investors as well. But working with the data doesn't have to be complicated. The following demo, articles, and templates will help you make the most of your financial reports and analysis.

Office demos

• Instant payroll totals for quarterly tax reporting
  Get tax totals fast with the list feature in Excel 2003.
• Import financial data from the Web
  Capture data from the Web instead of retyping.

Featured articles

• Instant payroll totals for quarterly tax reporting
  Make your 941 tax reporting fast and easy.
• Use Excel to compare two lists of data
  Find data that appears on one list but not on another.
• PivotTable reports: View data your way
  Extract, organize, and summarize financial data.
• Highlight financial performance with conditional formatting
  Draw attention to variances and other data you specify.
• Use conditional formulas in Excel to analyze data
  Calculate discounts, cross-check for accuracy, and display conditional messages.

Templates

• Fixed asset record with depreciation
  Use straight-line or double-declining balance methods to calculate depreciation for business assets.
• Income statement 1 year
  Prepare a profit and loss statement.
• Two-year comparative income statement
  Create a two-year income statement and see how income and expenses have changed year over year.
• Activity-based asset depreciation
  Calculate depreciation based on use, rather than time.
• Intangible asset depreciation
  Use this template to calculate the amortization of intangible assets (Section 197 intangibles).

Training

• PivotTable I: What's so great about PivotTable reports?
• PivotTable II: Swing into action with PivotTable reports
• PivotTable III: Show off your PivotTable skills

Try Microsoft Office System products and improve the way you work.