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.

• 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.

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.

Accounting Information Systems  (Accounting & Taxation)
Auditing  (Accounting & Taxation)
Computerized Accounting  (Accounting & Taxation)

Excel Download site (FTP)
Smith
©2003  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0131003798  |  ISBN-13: 9780131003798
More Info

Back to top

For the Accounting & Taxation Discipline

A-1 Photography Practice Set - Manual Version, 3/E
Sineath & Insinga
©1999   |   Prentice Hall   |   Paper; 125 pp   |   Instock
ISBN-10: 0130803103   |   ISBN-13: 9780130803108
Suggested retail price: $60.00  Buy from myPearsonStoreNet price: $45.00  (What's this?)

Getting Started with Peachtree 8.0
Osteraa
©2002   |   Prentice Hall   |   Paper; 70 pp   |   Instock
ISBN-10: 0130622648   |   ISBN-13: 9780130622648
Suggested retail price: $28.00  Buy from myPearsonStoreNet price: $21.00  (What's this?)

International Financial Reporting Standards (IFRS) Tips
Pearson
©2010   |   Prentice Hall   |   Access Code Card   |   Instock
ISBN-10: 0136100899   |   ISBN-13: 9780136100898
Suggested retail price: $7.00  Buy from myPearsonStoreNet price: $5.25  (What's this?)

Math Tips for Accounting
Pearson
©2010   |   Prentice Hall   |   Paper   |   Instock
ISBN-10: 0136112285   |   ISBN-13: 9780136112280
Suggested retail price: $6.67  Buy from myPearsonStoreNet price: $5.00  (What's this?)

PH Accounting Excel Tips, 6/E
Harrison
©2006   |   Prentice Hall   |   Paper; 1 pp   |   Instock
ISBN-10: 0131499653   |   ISBN-13: 9780131499652
Suggested retail price: $0.00Net price: $0.00  (What's this?)

Understanding Sarbane-Oxley Act of 2002: Impacting the Accounting Profession
Beasley & Elder
©2005   |   Prentice Hall   |   Paper; 56 pp   |   Instock
ISBN-10: 0131855263   |   ISBN-13: 9780131855267
Suggested retail price: $46.67  Buy from myPearsonStoreNet price: $35.00  (What's this?)

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.