Excel for Microeconomics

Microsoft Excel for Accounting: Managerial and Cost Accounting
by
Dr. Katherine T. Smith
Dr. L. Murphy Smith
Dr. Lawrence C. Smith, Jr.

Contents

1 Computer Basics Components of the computer. Operating systems software. Windows Operating system. Loading your Excel spreadsheet program. Basic commands. Saving a file. Closing files. Retrieving files. Exiting.

2 Making a Worksheet Worksheet layout. An illustration. Editing. Moving cell contents. Inserting rows and columns. Deleting and shifting cells. Centering. Changing column or row width. Copy and paste. Printing.

3 Formulas, Functions, and Formatting Automatic sums. Formulas. Writing formulas. Copying formulas. Functions. Date and other functions. Numeric formatting. Percentage symbol. Currency style. Commas. Customized formatting.

4 Charts Column chart. Stacked-column chart. Line Chart. Pie chart.

5 Worksheet Manipulation Range names. Freeze panes. Split screen. Importing data.

6 Database Tools Data form. Data sort. Sorting a single column or row. Sorting multiple columns or rows. Autofill. Autofilter.

7 Macro Commands Creating a macro. Running a macro.

8 Guidelines for Worksheet Design Requirements outline. File ID. Data input and output. Input alignment. Manual recalculation. Backup files. Testing.

9 Step-by-Step Excel Example Creating an Excel worksheet. Editing a cell. Centering. Inserting formulas. Manipulating data. Numeric formatting. Column expansion. Printing. Creating an Excel pie chart.

Spreadsheet Assignments Assignment Schedule

Solutions to Selected Assignments Solutions

Index Alphabetical List

Links:
Back to Starting Page
Prentice-Hall
Microsoft Corporation
Web Search Engines
Quotations on Ethics (cool quotes & movie clips)
The Bottom Line is Betrayal

1 Computer Basics	Components of the computer. Operating systems software. Windows Operating system. Loading your Excel spreadsheet program. Basic commands. Saving a file. Closing files. Retrieving files. Exiting.
2 Making a Worksheet	Worksheet layout. An illustration. Editing. Moving cell contents. Inserting rows and columns. Deleting and shifting cells. Centering. Changing column or row width. Copy and paste. Printing.
3 Formulas, Functions, and Formatting	Automatic sums. Formulas. Writing formulas. Copying formulas. Functions. Date and other functions. Numeric formatting. Percentage symbol. Currency style. Commas. Customized formatting.
4 Charts	Column chart. Stacked-column chart. Line Chart. Pie chart.
5 Worksheet Manipulation	Range names. Freeze panes. Split screen. Importing data.
6 Database Tools	Data form. Data sort. Sorting a single column or row. Sorting multiple columns or rows. Autofill. Autofilter.
7 Macro Commands	Creating a macro. Running a macro.
8 Guidelines for Worksheet Design	Requirements outline. File ID. Data input and output. Input alignment. Manual recalculation. Backup files. Testing.
9 Step-by-Step Excel Example	Creating an Excel worksheet. Editing a cell. Centering. Inserting formulas. Manipulating data. Numeric formatting. Column expansion. Printing. Creating an Excel pie chart.
Spreadsheet Assignments	Assignment Schedule
Solutions to Selected Assignments	Solutions
Index	Alphabetical List