Excel 2003 All-in-One Desk Reference For Dummies View Larger Image | Greg Harvey
Wiley, Paperback, Published September 2003, 813 pages, ISBN 076453758X | List Price: $29.99
Our Price: $19.50
You Save: $10.49 (35% Off)
| | | Availability: In-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Your one-stop guide to designing worksheets, managing data, and making Excel work for you...
- Covers everything a reader needs to know to perform the task at hand, then goes a step beyond by outlining the most practical and useful applications for Excel in the workplace
- Organized in convenient minibooks to help the reader find necessary information about particular topics quickly and easily
- Includes basic coverage of importing data, building and editing worksheets, creating formulas, generating PivotTables, and performing financial functions, what-if scenarios, database functions, and Web que-ries
- Advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with VBA and the Web
About the Author
Greg Harvey is a veteran computer trainer and consultant who has written more than 50 books. He’s the owner of a multimedia publishing venture called Mind Over Media.
Table of Contents
Book I: Excel Basics.
Chapter 1: Getting Acquainted with Excel.
Chapter 2: Getting Help.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing Worksheets.
Chapter 4: Managing Worksheets.
Chapter 5: Printing Worksheets.
Book III: Formulas and Functions.
Chapter 1: Building Basic Formulas
Chapter 2: Logical Functions and Error Trapping
Chapter 3: Date and Time Formulas
Chapter 4: Financial Formulas
Chapter 5: Math and Statistical Formulas
Chapter 6: Lookup, Information, and Text Formulas.
Book IV: Worksheet Collaboration.
Chapter 1: Sharing and Reviewing Workbooks.
Chapter 2: Protecting Worksheets.
Chapter 3: Sharing Data with Other Programs.
Chapter 4: Sharing Data via a SharePoint Team Services Web Site.
Book V: Charts and Graphics.
Chapter 1: Charting Worksheet Data.
Chapter 2: Adding Graphic Objects.
Book VI: Data Management.
Chapter 1: Building and Maintaining Data Lists.
Chapter 2: Filtering and Querying a Data List.
Book VII: Data Analysis.
Chapter 1: Performing What-If Scenarios.
Chapter 2: Generating Pivot Tables.
Book VIII: Excel and the Web.
Chapter 1: Worksheets As Web Pages.
Chapter 2: Adding Hyperlinks to Worksheets.
Book IX: Excel and Visual Basic for Applications.
Chapter 1: Building and Running Macros.
Chapter 2: VBA Programming.
Index.
|
