Accounting with Microsoft Excel

Catalog description

Course provides accounting refresher and uses Microsoft Excel features to perform accounting functions. Accounting topics include transactions, financial statements, cash flow, inventory costing, bank reconciliations, payroll, depreciation, bond amortization, financial ratios, and budgeting. Excel topics include formulas, formatting, multiple worksheets, charting, ranges, pivot tables, basic macros, goal seek, and special functions for calculations of inventory, payroll, depreciation, and time value of money.