Microsoft
Excel for Accounting
by
Katherine T. Smith, D.B.A.
L. Murphy Smith, D.B.A., CPA
Lawrence C. Smith, Jr, Ph.D.
Example
Files:
-
Gledger
- Includes general ledger accounts which are linked to the trial balance
and income statement.
-
Incstmt
- Basic income statement.
-
Piechart
- Basic pie graph.
-
Graph
- Four graph types.
-
Bep
- Cost-volume-profit analysis (break-even point) with graph.
-
Ratio
- Financial ratios.
-
Attrib
- Attribute sampling, for the auditor's evaulation of an internal control
procedure.
-
Variable
- Variables sampling, for the auditor's evaluation of an account balance.
-
Demsup
- Economic demand and supply analysis.
-
Profit
- Microeconomic analysis of profit-maximizing equilibrium.
-
Quota
- Economic effect of an import quota.
-
Tariff
- Economic effect of a tariff on imports.
-
Macro
- Example of a macro used to sort a range of data.
Links:
Back to Excel
for Accounting: The First Course
Back to Excel
for Accounting: Managerial and Cost
Back to Excel
for Accounting: Auditing and AIS
Prentice-Hall
Microsoft
Corporation
Web
Search Engines
Dr.
Katherine T. Smith's Homepage
Dr. Murphy
Smith's Homepage
The
Bottom Line is Betrayal
Contact
the Webmaster with comments or suggestions for improving this page.
This
page is always under construction.