1 / 7

Excel in the Accounting Curriculum – Where and How

Excel in the Accounting Curriculum – Where and How. Debby Bloom-Hill, CMA, CFM Accounting Instructor Mitchell Community College, Statesville, NC. Where in the Accounting Curriculum?. Principles of Accounting Investments

dyani
Download Presentation

Excel in the Accounting Curriculum – Where and How

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel in the Accounting Curriculum – Where and How Debby Bloom-Hill, CMA, CFM Accounting Instructor Mitchell Community College, Statesville, NC

  2. Where in the Accounting Curriculum? • Principles of Accounting • Investments • Date functions, counting days using Excel, interest earned, future value • Fixed assets and depreciation • Depreciation tables and charts • Long term liabilities and bonds • Amortize lease, installment loans and bonds using interest method, present value calculations

  3. Where in the Accounting Curriculum? • Intermediate Accounting • All of the above, plus • Inventory • Inventory database (Excel 2013) • Cost/Managerial Accounting • Cost Behavior • Introduction to data, sorting and high/low, regression analysis, scatter charts

  4. Where in the Accounting Curriculum? • Cost/Managerial Accounting (continued) • CVP Analysis • What if analysis, goal seek • Flexible Budgeting • Relative and absolute cell references, scenario manager • Capital Budgeting • Time value of money, NPV and IRR functions in Excel

  5. Where in the Accounting Curriculum • Other courses • Auditing – use Excel’s statistical package • Advanced Accounting – use Excel for consolidations and partnership liquidations • Dedicated course in Excel for Accounting • Sample syllabus included

  6. Sample Syllabus for Excel and Accounting

  7. Sample Syllabus for Excel and Accounting

More Related