ACCT 2241 - QuickBooks and Excel for Business
3 Credits
Introduces QuickBooks accounting software and extensive application of Microsoft Excel electronic spreadsheet applications. After completion of this course the student will be able to record small business transactions in QuickBooks and perform higher level Excel applications and analysis including macros, lookups, and pivot tables.
Pre-Requisites ACCT 2101 or ACCT 2101
Major Content Areas
10% Create custom financial customer, vendor, and inventory reports. 5% Create, save, and backup a company files. 15% Maintain customer, vendor, general ledger, and inventory databases. 30% Create Excel spreadsheets to plan, budget and control business activities. 5% Download and upload data between QuickBooks and Excel. 20% Enter business transactions. 15% Analyze data in Excel using macros, lookup functions and pivot tables.
Learning Outcomes
Communicate financial and management information effectively in both verbal and written form. Demonstrate knowledge of computerized accounting systems. Analyze data and develop solutions to produce required information to make good business decisions. Demonstrate knowledge of ethical considerations. Analyze financial data and prepare management presentations utilizing Microsoft Office tools.
|