E-Book Overview
Start using Excel spreadsheets, formulas, and charts - practice exercises make it easyYou don't have to be overwhelmed by Excel - this workbook helps you get the hang of the most popular spreadsheet program by doing! From working with pivot tables to adding graphics to building dynamic charts, managing and securing data, performing data analysis, adding hyperlinks, and creating macros, you will do it all with the help of practice files on the CD-ROM.See how to * Set up, format, and edit basic spreadsheets * Create a variety of formulas for finance, date and time, math, and more * Calculate return on investments or loan amortization * Master data analysis with pivot tables * Turn spreadsheets into Web pages and master hyperlinks All this on the bonus CD-ROM * Sample files for all exercises in the book * A variety of useful Excel tools * Worksheets and templates for financial planning and more * Trial version of Crystal Xcelsius
E-Book Content
Excel Workbook ®
FOR
DUMmIES
‰
by Greg Harvey, PhD
Excel Workbook ®
FOR
DUMmIES
‰
by Greg Harvey, PhD
Excel® Workbook For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2006 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923,