Microsoft
Excel for Accounting Principles
by
Katherine T. Smith, D.B.A.
L. Murphy Smith, D.B.A., CPA
Lawrence C. Smith, Jr, Ph.D.
Table
of Contents
-
Chapter 1: Computer Basics
-- Components of the Computer. Operating Systems Software. Windows Operating
System. Windows 98. Windows 3.1. Starting Your Excel
Spreadsheet Program.
-
Chapter 2: Getting Started
-- Spreadsheet Organization. Rows and Columns. Cell Pointer.
Menu Bar. Toolbar. An Example. Saving. Printing.
Closing Files. Retrieving Files. Exiting.
-
Chapter 3: Editing
-- Editing a Cell. Moving a Cell. Editing a Worksheet.
Inserting Rows and Columns. Cut and Paste. Deleting Rows and
Columns. Copy and Paste. Selecting Cells. Centering.
Changing Column Width.
-
Chapter 4: Excel Commands
-- Toolbar Buttons. Automatic Sums. Currency Style. Sorting
Words and Numbers. Keyboard. Cancel an Action. Escape.
Page Up/Page Down. Function Keys.
-
Chapter 5: Formatting, Formulas,
and Functions -- Formatting. Numeric Formatting.
Text Formatting. Formulas. Functions. Copying.
-
Chapter 6: Charts/Graphs
-- Creating a Chart. Line Chart. Column Chart. Stacked-Column
Chart. Pie Chart.
-
Chapter 7: Worksheet Manipulation
-- Range Names. Freeze Panes. Split Screen. Importing
Data.
-
Chapter 8: Database Commands
-- Data Form. AutoFill. Data Sort. AutoFilter.
-
Chapter 9: Macro Commands
-- Creating a Macro. Running a Macro.
-
Chapter 10: Guidelines for Spreadsheet
Design -- Requirements Outline. File ID. Data
Input and Output. Input Alignment. Manual Recalculation.
Backup Files. Testing.
-
Chapter 11: Step-by-Step Excel Example
-- Assignment 1: Creating an Excel Worksheet. Assignment 2:
Creating an Excel Graph.
-
Spreadsheet Exercises
(89 total exercises).
-
Solutions to Odd-Numbered Exercises
1 to 45.
-
Index.
Links:
Back to Starting Page
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.