Excel Workbook For Dummies - Softcover

Harvey, Greg

Softcover

ISBN 10: 0471798452 ISBN 13: 9780471798453

Publisher: For Dummies, 2006

Synopsis

Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant’s green sheet, and mastering even the most basic functions can be a challenge.

Excel Workbook For Dummies is specially designed to give you the hands-on experience you need to start using this great program with confidence and efficiency. This guide is packed with hundreds of exercises that walk you through the ins and outs of Excel at your own pace. You’ll have all the tools you need to:

• Enter spreadsheet data
• Format, modify, and print your spreadsheet
• Copy and correct formulas
• Create date and time formulas
• Use math, statistical, lookup, and logical functions
• Chart spreadsheet data
• Add graphics to the spreadsheet
• Manage and secure your data
• Perform what-if analyses
• Generate pivot tables
• Publish spreadsheets as Web pages
• Add hyperlinks to spreadsheets
• Take advantage of Macros and Visual Basic Editor

Included is a bonus CD-ROM full of useful features, including sample files for all exercises in the book, a variety of important Excel tools, worksheets, and templates for financial planning, and a trial version of Crystal Xcelsius to get you started making progress and becoming an Excel expert!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

About this title

About the Author

Greg Harvey, PhD is president of Mind Over Media, Inc. and is an experienced educator. He has written numerous books on Excel.

From the Back Cover

• Develop spreadsheets to calculate, analyze, explain, and present data
• Create diverse spreadsheets to set up lists and tables
• Master formulas and functions
• Practice using dozens of Excel functions from basic to complex

Start using Excel spreadsheets, formulas, and charts — practice exercises make it easy

You 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

From the Inside Flap

• Develop spreadsheets to calculate, analyze, explain, and present data
• Create diverse spreadsheets to set up lists and tables
• Master formulas and functions
• Practice using dozens of Excel functions from basic to complex

Start using Excel spreadsheets, formulas, and charts — practice exercises make it easy

You 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

Edition details

• Publisher: For Dummies
• Publication date: 2006
• Language: English
• ISBN 10: 0471798452
• ISBN 13: 9780471798453
• Binding: Paperback
• Edition number: 1
• Number of pages: 368