EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals.
EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals.
EVERYDAY FREE SHIPPING on $25 & up - Excludes marketplace items & rentals
Search
Microsoft Excel for Accounting : The First Course

Microsoft Excel for Accounting : The First Course - 03 edition

ISBN13: 978-0130085511

Cover of Microsoft Excel for Accounting : The First Course 03 (ISBN 978-0130085511)
ISBN13: 978-0130085511
ISBN10: 0130085510
Cover type: Paperback
Edition/Copyright: 03
Publisher: Prentice Hall, Inc.
Published: 2003
International: No

List price: $57.75

More Shipping Options

Microsoft Excel for Accounting : The First Course - 03 edition

ISBN13: 978-0130085511

Katherine T. Smith, L. Murphy T. Smith and Lawrence C. Smith

ISBN13: 978-0130085511
ISBN10: 0130085510
Cover type: Paperback
Edition/Copyright: 03
Publisher: Prentice Hall, Inc.

Published: 2003
International: No

Author Bio

Smith, Katherine T. : Business Consultant


Smith, L. Murphy T. : Texas A&M University


Smith, Lawrence C. : Louisiana Tech University

Table of 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 That Correspond to Course Topics.
Solutions to Selected Assignments.
Index.

List price: $57.75
  • Marketplace
  • From
More Shipping Options