Excel 2003 All-in-one Desk Reference for Dummies
Home > Computing and Information Technology > Business applications > Spreadsheet software > Excel 2003 All-in-one Desk Reference for Dummies
Excel 2003 All-in-one Desk Reference for Dummies

Excel 2003 All-in-one Desk Reference for Dummies

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

When you think of number crunching and spreadsheets, you think of Excel, right? After Word, it's the most popular program in the Microsoft Office suite. But if technical jargon isn't your first language, you may have found Excel just a teeny bit frustrating. It can be really hard to pick your way through the many features and make Excel do what you need for it to do. Once you know how, you can use Excel to: create fill in the blank forms; prepare expense reports and invoices; manage all sorts of data; keep sales and inventory records; analyze financial data and create forecasts; and, present information in charts and graphs. "Excel 2003 All in One Desk Reference For Dummies" tames the Excel monster. Nine minibooks break things down into manageable, logical sections covering the basics, worksheet design, formulas and functions, worksheet collaboration, charts and graphics, data management, data analysis, working on the Web, and tweaking Excel with a programming language called Visual Basic for Applications, or VBA. In the friendly, plain English "For Dummies" style, this book makes it easy to find what you're looking for and get instructions for doing what you need to do. You'll be able to: find your way around Excel's menus, toolbars, and dialog boxes, and access online help; format a professional looking spreadsheet that presents data the way you choose; edit an existing spreadsheet without disturbing its design or contents; build Excel formulas and use built in functions to produce the calculations you want; share spreadsheet data with other people and programs, and collect comments; create great looking charts and find out how to choose the right format to display your data effectively; use Excel to maintain large amounts of data, then filter the data to extract the information you need; publish spreadsheets and charts on the Web in HTML format; and, explore ways to customize Excel with VBA. Best of all, it's easy to find what you need in "Excel 2003 All in One Desk Reference For Dummies". Before you know it, you'll discover you've developed a friendship with Excel that will make your life easier, boost your business, and impress your friends!

Table of Contents:
Introduction.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 FormulasChapter 2: Logical Functions and Error TrappingChapter 3: Date and Time FormulasChapter 4: Financial FormulasChapter 5: Math and Statistical FormulasChapter 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.


Best Sellers


Product Details
  • ISBN-13: 9780764537585
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Hungry Minds Inc,U.S.
  • Height: 228 mm
  • Returnable: N
  • Weight: 1187 gr
  • ISBN-10: 076453758X
  • Publisher Date: 10 Oct 2003
  • Binding: Paperback
  • Language: English
  • Spine Width: 45 mm
  • Width: 185 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Excel 2003 All-in-one Desk Reference for Dummies
John Wiley & Sons Inc -
Excel 2003 All-in-one Desk Reference for Dummies
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Excel 2003 All-in-one Desk Reference for Dummies

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!