The table below shows typical accounting principles topics matched to recommended Microsoft Excel exercises.
Accounting Topic
Recommended Excel Exercises
2. Recording Business Transactions
3 Double-Entry Accounting
4 Double-Entry Accounting.
49 T-Accounts and Trial Balance
50 Trial Balance and Income Statement
3. Measuring Business Income:
51 Preparation of Adjusted Trial Balance
The Adjusting Process
52 Financial Statements and Related Questions
4. Completing the Accounting Cycle
53 Post Closing Trial Balance
54 Trial Balance and Worksheet
5. Merchandising Operations and
25 Sales by Product Type
the Accounting Cycle
55 Balance Sheet
56 Financial Ratios
6. Accounting Information Systems 57 Cash Disbursements
7. Internal Control and
15 Cash Budget
Managing Cash
16 Cash Budget
58 Bank Reconciliation
59 Cash Budget
8. Accounts and Notes Receivable
13 Bad Debt Expense
14 Bad Debt Expense
22 Aging Sales Invoices
23 Aging Sales Invoices
24 Aging Sales Invoices
60 Statement of Cash Flows
9. Accounting for Merchandise
5 Cost of Merchandise
Inventory
6 Cost of Merchandise
7 Tracking Inventory Quantity
8 Product Cost Schedule
61 Income Statement
62 Perpetual Inventory Record
63 Income Statement, Balance Sheet, & SCF
10. Plant Assets, Intangibles Assets,
9 Straight Line Depreciation
and Related Expenses
10 Straight Line Depreciation
11 Sum-of-the-Years-Digits Depreciation
12 Units-of-Production Depreciation
20 Joint Cost Allocation
21 Joint Cost Allocation
64 Allocation of Costs in Lump-Sum Purchase
11. Current Liabilities and Payroll
65 Partial Balance Sheet
Accounting
12. Accounting for Partnerships 66 Summary of Liquidation Transactions
13. Corporate Organization, Paid-In 19
Weighted Average Number of Shares of Stock
Capital, and the Balance Sheet
67 Financial Ratios
68 Balance Sheet, Ratios, and Questions
14. Retained Earnings, Treasury
69 Multiple-Step Income Statement
Stock, and Income Statement
15. Long-Term Liabilities
45 Lease Payment
70 Bond Amortization Schedule
16. Accounting for Investments
17 Interest Earned
and International Operations
18 Future Value of a Single Deposit
34 Foreign Currency (FC) Translation
Using Current Rate Method
35 FC Translation Using Current Rate Method
36 FC Translation Using Current Rate Method
37 FC Translation Using Current Rate Method
38 FC Translation Using Temporal Rate Method
39 FC Translation Using Temporal Rate Method
40 Economic Impact of Import Quota
41 Economic Impact of Import Quota
42 Economic Impact of a Tariff
43 Economic Impact of a Tariff
44 Economic Impact of a Tariff
17. Statement of Cash Flows
71 Statement of Cash Flows
72 Statement of Cash Flows
18. Financial Statement Analysis
30 Financial Ratios
31 Financial Ratios
32 Common Size Balance Sheets
33 Common Size Balance Sheets
73 Horizontal Analysis of Income Statement
19. Management Accounting
74 Cost of Goods Manufactured and Cost of
Goods Sold
75 Income Statement
20. Job Costing 76 Work in Progress and Questions
21. Process Costing
77 Compute Equivalent Units: FIFO
78 Compute Equivalent Units: Weighted Avg.
22. Cost-Volume-Profit Analysis
26 Cost-Volume-Profit Analysis
and the Contribution Margin
27 Cost-Volume-Profit Analysis
Approach to Decision Making
28 Cost-Volume-Profit Analysis: Graph
29 Cost-Volume-Profit Analysis: Graph
79 Graph Cost Behavior Patterns
80 Contribution Margin Income Statement
23. Master Budget and
81 Departmental Income Statement
Responsibility Accounting
24. Flexible Budgets and
82 Flexible Budget
Standard Costs
83 Graph Total Cost Line
25. Activity Based Costing
84 Cost Allocation Rates
& Tools for Cost Management
85 Budgeted Costs, ABC Cost Per Unit
86 Manufacturing Cost Based on ABC Unit
Cost
26. Special Business Decisions & 87
Product Mix Analysis
Capital Budgeting
88 Make or Buy Analysis
89 Best Use of Facilities Analysis