Microsoft Excel for Accounting: Auditing and AIS
0130085529

Katherine T. Smith, Business Consultant
L. Murphy T Smith, Texas A&M University
Lawrence C. Smith, Louisiana Tech University

Publisher: Prentice Hall
Copyright: 2003
Format: Paper; 122 pp

ISBN-10: 0130085529
ISBN-13:9780130085528

Our Price: £18.99
Status: Not Yet Published
Estimated Availability: 09 Sep 2002



Description

For Computerized Accounting, Auditing, and Accounting Information Systems courses.

The text features Excel assignments that are designed to enable students to work more efficiently while enhancing their understanding of specific AIS and auditing course concepts. As students learn through experience by following directions and creating the example worksheets, they also increase their computer competency.


Table Of Contents


1. Computer Basics.


2. Making a Worksheet.


3. Formulas, Functions, and Formatting.


4. Charts.


5. Worksheet Manipulation.


6. Database Tools.


7. Macro Commands.


8. Guidelines for Worksheet Design.


9. Step-by-Step Excel Example.


Spreadsheet Assignments.


Audit Case Problem.


Solutions to Selected Assignments.


Index.

Features
  • Computer basics covered.
    • Provides students with an accessible review of basic computer operating systems, spreadsheet programs, basic commands and working with files.

  • Step-by-step Excel example—Including creating an Excel worksheet, editing a cell, centering, inserting formulas, manipulating data, numeric formatting, column expansion, printing and creating an Excel pie chart.
    • Walks students through an Excel example so that they can create their own worksheets.

  • Preparing Excel charts—e.g. column, stacked-column, line and pie charts.
    • Provides students with complete guidelines that give them hands-on experience preparing the full spectrum of Excel charts.

  • Guidelines for worksheet design—e.g. requirements outline, file ID, data input and output, input alignment, manual recalculation, backup files, testing.
    • Provides students with easy-to-follow guidelines for designing worksheets.

  • Spreadsheet problems and suggested assignment schedule.
    • Provides students with exercises to practice the skills they have learned.

  • Value to students—Each manual may be shrink-wrapped with any Prentice Hall Accounting text for only $5.00 net.

All Valuepacks
ACCOUNTG INFO SYS&MS XCL&QKBKS&QK SIMPL PKG
ROMNEY & STEINBART
© 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Estimated Availability: 28 Nov 2003
ISBN-10: 0131472631 | ISBN-13: 9780131472631
Our Price: £168.99

Package consists of:
Microsoft Excel for Accounting: Auditing and AIS
Quick, Simple Microsoft Access 2000
Accounting Information Systems, 9/E
QuickbooksPro 2002 with update for Pro 2003 and Data Files Package

MICROSF EXCEL FOR ACCTG&GET START W/QKBKS03
SMITH & SMITH
© 2004 | Prentice Hall | Kit/Package/ShrinkWrap | Estimated Availability: 28 Jan 2007
ISBN-10: 013163917X | ISBN-13: 9780131639171
Our Price: £17.99

Package consists of:
Microsoft Excel for Accounting: Auditing and AIS
Getting Started with Quickbooks Pro 2003, 6/E

Acctg Info Sys&Pchtree Cmp&CD&Xcl Acctg&, 9/E
ROMNEY & STEINBART
© 2003 | Prentice Hall | Kit/Package/ShrinkWrap | Estimated Availability: 28 Jan 2007
ISBN-10: 0131057782 | ISBN-13: 9780131057784
Our Price: £104.99

Package consists of:
Microsoft Excel for Accounting: Auditing and AIS
Getting Started with Excel
Accounting Information Systems, 9/E
Getting Started with Peachtree Complete 2002
Peachtree Complete Accounting 2002 CD with Getting Started Data Files