The table below shows typical introductory financial accounting topics which are matched to recommended Microsoft Excel exercises.
Introductory Financial
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 & 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