Excel for Accounting

Catalog description

This course introduces and emphasizes the use of Microsoft Excel on a personal computer (PC) to complete a variety of accounting tasks including journal entries, financial statements, inventory costing and analysis, bank reconciliations, depreciation schedules, payroll registers, bond amortization, financial statement analysis, and budgeting and cost analysis with emphasis placed on decision-making and how it can be enhanced by the spreadsheets produced. Students will practice recording financial information in Excel using various quantitative and formatting tolls to enhance both the functionality and visual appearance of spreadsheets.