Auditoria

This ebook licensed to H D Unauthorized reproduction or distribution of this ebook is illegal. D.

Excel for Auditors

by Bill Jelen and Dwayne K. Dowell

Holy Macro! Books

85E2C118-8687-4B2A-BBD1-206FE25BDA3D

Excel for Auditors © 2007 Tickling Keys
All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic ormechanical, including photocopying, recording, or by any information or storage retrieval system without permission from the publisher. Every effort has been made to make this book as complete and accurate as possible, but no warranty or fitness is implied. The information is provided on an “as is” basis. The authors and the publisher shall have neither liability nor responsibility to any person orentity with respect to any loss or damages arising from the information contained in this book.

Written by: Bill Jelen and Dwayne K. Dowell Edited by:
Linda DeLonais

On the Cover:
Design by Shannon Mattiza, 6’4 Productions.

Published by:
Holy Macro! Books PO Box 82 Uniontown, Ohio, USA 44685

Distributed by:
Independent Publishers Group

First printing:
September 2006.Printed in the United States of America

Library of Congress Data Excel for Auditors /Bill Jelen and Dwayne K. Dowell
Library of Congress Control Number: 2006931383

ISBN: 1-932802-16-9 Trademarks:
All brand names and product names used in this book are trade names, service marks, trademarks, or registered trade marks of their respective owners. Holy Macro! Books is not associated withany product or vendor mentioned in this book.

85E2C118-8687-4B2A-BBD1-206FE25BDA3D

Table of Contents

Table of Contents
About the Authors ....................................................................... a
Bill Jelen..........................................................................................................................................a Dwayne K.Dowell..........................................................................................................................a

Copying a Worksheet ..................................................................1
Here’s the Situation ..................................................................................................................... 1 Here’s What to Do........................................................................................................................ 1 Excel Details.................................................................................................................................. 3

Showing Numbers in Thousands ..................................................5
Here’s the Situation..................................................................................................................... 5 Here’s What to Do ........................................................................................................................ 5 Gotcha ........................................................................................................................................... 7 ExcelDetails.................................................................................................................................. 8

Quickly Seeing Sum or Average ...................................................9
Here’s the Situation ..................................................................................................................... 9 Here’s What to Do........................................................................................................................ 9 Gotcha .........................................................................................................................................12 Better in Excel 2007 ..................................................................................................................12 Excel...