Excel for the CEO

Excel for the CEO provides the quick information you need to master Excel for running your business. Includes a special focus on pivot tables and advanced data funtions, designed to put you a step ahead of your competition.
Nội dung trích xuất từ tài liệu:
Excel for the CEO Excel for the CEOP.K. Hari Hara Subramanian Holy Macro! BooksExcel for the CEO© 2006 Holy Macro! BooksAll rights reserved. No part of this book may be reproduced or transmitted in any formor by any means, electronic or mechanical, including photocopying, recording, or by anyinformation or storage retrieval system without permission from the publisher.Every effort has been made to make this book as complete and accurate as possible, butno warranty or fitness is implied. The information is provided on an “as is” basis. Theauthors and the publisher shall have neither liability nor responsibility to any personor entity with respect to any loss or damages arising from the information contained inthis book.Written by:P.K. Hari Hara SubramanianEdited by:Linda DeLonaisOn the Cover:Design by Shannon Mattiza, 6’4 Productions.Published by:Holy Macro! BooksPO Box 82Uniontown, Ohio, USA 44685Distributed by:Independent Publishers GroupFirst printing:September 2006.Printed in the United States of AmericaLibrary of Congress DataExcel for the CEO / P.K. Hari Hara SubramanianLibrary of Congress Control Number: 2006931382ISBN: 1-932802-17-7Trademarks: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 isnot associated with any product or vendor mentioned in this book. Table of ContentsTable of ContentsA c k n o w l e d g e m e n t s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .aAbout the Author ........................................................................eStarting off on the Right Foot .................................................... 1 Basic Terminology........................................................................................................................ 2 Title Bar............................................................................................................................3 Menu Bar .........................................................................................................................3 Active Cell.........................................................................................................................3 Toolbar Collections..........................................................................................................4 Help Bar ...........................................................................................................................4 Minimize / Maximize and Close Buttons .......................................................................4 Task Pane / Task Selector..............................................................................................4 Task Pane / Task Selector..............................................................................................5 Rows and Columns..........................................................................................................5 Formula Bar .....................................................................................................................5 Name Box.........................................................................................................................6 Scroll Bars........................................................................................................................7 Tab Scrollers ....................................................................................................................7 Status Bar ........................................................................................................................8 Creating, Saving, Opening, and Closing Workbooks and Worksheets................................. 9 Creating Workbooks ........................................................................................................9 Saving Workbooks.........................................................................................................10 Opening Workbooks ......................................................................................................11 Closing Workbooks........................................................................................................12 Navigating in Excel – Within a Worksheet and Between Workbooks ...............................12 Selecting Cells, Rows and Columns, Non-adjacent Cells .....................................................13 Editing, Updating, and Dele ...