Buy Excel 2013 Bible by John Walkenbach - Bookswagon
close menu
Bookswagon
search
My Account
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology Books > Business applications > Spreadsheet software > Excel 2013 Bible: (Bible)
Excel 2013 Bible: (Bible)

Excel 2013 Bible: (Bible)


     0     
5
4
3
2
1



International Edition


X
About the Book

Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!

Table of Contents:
Acknowledgments ix Introduction xxxvii Is This Book for You? xxxvii Software Versions xxxvii Conventions Used in This Book xxxviii Excel commands xxxviii Filenames, named ranges, and your input xxxviii Key names xxxviii Functions xxxviii Mouse conventions xxxix How This Book Is Organized xl How to Use This Book  xl What’s on the Website xli Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data 29 Chapter 3: Essential Worksheet Operations 49 Chapter 4: Working with Cells and Ranges 69 Chapter 5: Introducing Tables 101 Chapter 6: Worksheet Formatting 119 Chapter 7: Understanding Excel Files 145 Chapter 8: Using and Creating Templates 161 Chapter 9: Printing Your Work 171 Part II: Working with Formulas and Functions 193 Chapter 10: Introducing Formulas and Functions 195 Chapter 11: Creating Formulas That Manipulate Text 231 Chapter 12: Working with Dates and Times 251 Chapter 13: Creating Formulas That Count and Sum 285 Chapter 14: Creating Formulas That Look Up Values 313 Chapter 15: Creating Formulas for Financial Applications 333 Chapter 16: Miscellaneous Calculations 359 Chapter 17: Introducing Array Formulas 373 Chapter 18: Performing Magic with Array Formulas 397 Part III: Creating Charts and Graphics 419 Chapter 19: Getting Started Making Charts 421 Chapter 20: Learning Advanced Charting 457 Chapter 21: Visualizing Data Using Conditional Formatting 503 Chapter 22: Creating Sparkline Graphics 525 Chapter 23: Enhancing Your Work with Pictures and Drawings 539 Part IV: Using Advanced Excel Features 561 Chapter 24: Customizing the Excel User Interface 563 Chapter 25: Using Custom Number Formats 573 Chapter 26: Using Data Validation 591 Chapter 27: Creating and Using Worksheet Outlines 603 Chapter 28: Linking and Consolidating Worksheets 613 Chapter 29: Excel and the Internet 631 Chapter 30: Protecting Your Work 643 Chapter 31: Making Your Worksheets Error Free 655 Part V: Analyzing Data with Excel 683 Chapter 32: Importing and Cleaning Data 685 Chapter 33: Introducing Pivot Tables 715 Chapter 34: Analyzing Data with Pivot Tables 739 Chapter 35: Performing Spreadsheet What-If Analysis 777 Chapter 36: Analyzing Data Using Goal Seeking and Solver 793 Chapter 37: Analyzing Data with the Analysis ToolPak 813 Part VI: Programming Excel with VBA 825 Chapter 38: Introducing Visual Basic for Applications 827 Chapter 39: Creating Custom Worksheet Functions 855 Chapter 40: Creating UserForms 869 Chapter 41: Using UserForm Controls in a Worksheet 889 Chapter 42: Working with Excel Events 903 Chapter 44: Creating Custom Excel Add-Ins 931 Part VII: Appendixes 941 Appendix A: Worksheet Function Reference 943 Appendix B: Excel Shortcut Keys 961 Index 967

About the Author :
John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.


Best Sellers


Product Details
  • ISBN-13: 9781118490365
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: John Wiley & Sons Inc
  • Height: 239 mm
  • No of Pages: 1056
  • Returnable: N
  • Spine Width: 53 mm
  • Width: 191 mm
  • ISBN-10: 1118490363
  • Publisher Date: 05 Mar 2013
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Series Title: Bible
  • Weight: 1600 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Excel 2013 Bible: (Bible)
John Wiley & Sons Inc -
Excel 2013 Bible: (Bible)
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 2013 Bible: (Bible)

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


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!