Advanced Excel 2003 For Accounting

Course Overview

Advanced Excel functions and spreadsheet tools for accounting are explored in detail. Setting up Financial Reports is done in Excel.

Duration: 1 week

Financial Analysis

• Generating and understanding financial ratios
• Analyzing dollar and percent changes in financial statements

Budgeting and Planning

• Working with working capital
• Calculating cash flow projections
• Producing budgets and predicting their impacts
• Making accurate and timely forecasts
• Using break-even point analysis

Importing External Business Data in Excel

• Using Simply Accounting information in Excel
• Generating queries and setting query parameters

Valuating Depreciation

• Calculating depreciation with accounting functions
• Analyzing differences between different methods of depreciation