Curbside pickup and returns now available at 26 locations. View updated hours of operations here.

Excel 2007 Bible
(Adobe EPUB eBook, Kindle Book, OverDrive Read)

Book Cover
Average Rating
Series:
Published:
Wiley 2007
Status:
Available from OverDrive
Description
  • This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
  • Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
  • John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel
  • Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
  • Includes a valuable CD-ROM with templates and worksheets from the book
  • Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    Also in This Series
    Formats
    Adobe EPUB eBook
    Works on all eReaders (except Kindles), desktop computers and mobile devices with reading apps installed.
    Kindle Book
    Works on Kindles and devices with a Kindle app installed.
    Need Help?
    If you are having problem transferring a title to your device, please fill out this support form or visit the library so we can help you to use our eBooks and eAudio Books.
    More Like This
    More Copies In LINK+
    Loading LINK+ Copies...
    More Details
    Format:
    Adobe EPUB eBook, Kindle Book, OverDrive Read
    Street Date:
    03/06/2007
    Language:
    English
    ISBN:
    9781118050675
    ASIN:
    B00BOZDSEA
    Reviews from GoodReads
    Loading GoodReads Reviews.
    Citations
    APA Citation (style guide)

    John Walkenbach. (2007). Excel 2007 Bible. Wiley.

    Chicago / Turabian - Author Date Citation (style guide)

    John Walkenbach. 2007. Excel 2007 Bible. Wiley.

    Chicago / Turabian - Humanities Citation (style guide)

    John Walkenbach, Excel 2007 Bible. Wiley, 2007.

    MLA Citation (style guide)

    John Walkenbach. Excel 2007 Bible. Wiley, 2007. Web.

    Note! Citation formats are based on standards as of July 2010. Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy.
    Copy Details
    LibraryOwnedAvailable
    Shared Digital Collection11
    Staff View
    Grouped Work ID:
    4f23a830-5a66-98cf-e691-d372442ee6b5
    Go To Grouped Work
    Needs Update?:
    No
    Date Added:
    Jun 12, 2018 15:57:34
    Date Updated:
    Jun 12, 2018 15:57:34
    Last Metadata Check:
    May 16, 2021 07:12:21
    Last Metadata Change:
    Jul 24, 2020 17:30:54
    Last Availability Check:
    May 16, 2021 07:12:24
    Last Availability Change:
    Mar 17, 2021 18:32:54
    Last Grouped Work Modification Time:
    May 18, 2021 02:27:27

    OverDrive Product Record

    images
      • cover:
          • href: https://img1.od-cdn.com/ImageType-100/0128-1/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img100.jpg
          • type: image/jpeg
      • thumbnail:
          • href: https://img1.od-cdn.com/ImageType-200/0128-1/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img200.jpg
          • type: image/jpeg
      • cover150Wide:
          • href: https://img1.od-cdn.com/ImageType-150/0128-1/300/212/87/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img150.jpg
          • type: image/jpeg
      • cover300Wide:
          • href: https://img1.od-cdn.com/ImageType-400/0128-1/300/212/87/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img400.jpg
          • type: image/jpeg
    formats
        • identifiers:
              • type: ISBN
              • value: 9781118050675
        • name: Adobe EPUB eBook
        • id: ebook-epub-adobe
        • identifiers:
              • type: ASIN
              • value: B00BOZDSEA
        • name: Kindle Book
        • id: ebook-kindle
        • identifiers:
              • type: ISBN
              • value: 9781118050675
        • name: OverDrive Read
        • id: ebook-overdrive
    otherFormatIdentifiers
        • type: ISBN
        • value: 9780470044032
    mediaType
    eBook
    primaryCreator
      • role: Author
      • name: John Walkenbach
    title
    Excel 2007 Bible
    dateAdded
    2007-02-28T20:11:06.027-05:00
    contentDetails
        • href: https://link.overdrive.com/?websiteID=141&titleID=122788
        • type: text/html
        • account:
            • name: Sacramento Public Library (CA)
            • id: 1151
    sortTitle
    Excel 2007 Bible
    crossRefId
    122788
    series
    Bible
    id
    30021287-5228-4a81-8841-1e9b49ccbac1
    starRating
    4.3

    OverDrive MetaData

    isPublicDomain
    False
    formats
        • fileName: Excel2007Bible9781118050675
        • partCount: 0
        • fileSize: 91572070
        • identifiers:
              • type: ISBN
              • value: 9781118050675
        • rights:
              • type: CopyingTimesPerDays
              • value: 7
              • type: Printing
              • value: -1
              • type: Lending
              • value: 0
              • type: ReadAloud
              • value: 0
              • type: ExpirationRights
              • value: 0
        • name: Adobe EPUB eBook
        • id: ebook-epub-adobe
        • onSaleDate: 06/17/2011
        • samples:
              • source: From the book
              • formatType: ebook-overdrive
              • url: https://samples.overdrive.com/excel-2007-bible?.epub-sample.overdrive.com
        • fileName: Excel2007Bible9780470117088
        • partCount: 0
        • fileSize: 0
        • identifiers:
              • type: ASIN
              • value: B00BOZDSEA
        • name: Kindle Book
        • id: ebook-kindle
        • onSaleDate: 06/17/2011
        • samples:
              • source: From the book
              • formatType: ebook-overdrive
              • url: https://samples.overdrive.com/excel-2007-bible?.epub-sample.overdrive.com
        • fileName: Excel2007Bible9781118050675
        • partCount: 0
        • fileSize: 0
        • identifiers:
              • type: ISBN
              • value: 9781118050675
        • name: OverDrive Read
        • id: ebook-overdrive
        • onSaleDate: 06/17/2011
        • samples:
              • source: From the book
              • formatType: ebook-overdrive
              • url: https://samples.overdrive.com/excel-2007-bible?.epub-sample.overdrive.com
    keywords
        • value: Microsoft Excel
    creators
        • role: Author
        • fileAs: Walkenbach, John
        • bioText:

          John Walkenbach, a.k.a "Mr. Spreadsheet," is a principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books, including Excel 2003 Formulas and Excel 2003 Power Programming with VBA, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss.

        • name: John Walkenbach
    imprint
    John Wiley & Sons, Inc.
    publishDate
    2007-03-06T00:00:00-05:00
    isOwnedByCollections
    True
    title
    Excel 2007 Bible
    fullDescription
  • This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
  • Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
  • John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel
  • Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
  • Includes a valuable CD-ROM with templates and worksheets from the book
  • Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    popularity
    31
    links
      • self:
          • href: https://api.overdrive.com/v1/collections/v1L1BWwAAAA2I/products/30021287-5228-4a81-8841-1e9b49ccbac1/metadata
          • type: application/vnd.overdrive.api+json
    id
    30021287-5228-4a81-8841-1e9b49ccbac1
    starRating
    4.3
    images
      • cover:
          • href: https://img1.od-cdn.com/ImageType-100/0128-1/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img100.jpg
          • type: image/jpeg
      • thumbnail:
          • href: https://img1.od-cdn.com/ImageType-200/0128-1/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img200.jpg
          • type: image/jpeg
      • cover150Wide:
          • href: https://img1.od-cdn.com/ImageType-150/0128-1/300/212/87/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img150.jpg
          • type: image/jpeg
      • cover300Wide:
          • href: https://img1.od-cdn.com/ImageType-400/0128-1/300/212/87/{30021287-5228-4A81-8841-1E9B49CCBAC1}Img400.jpg
          • type: image/jpeg
    isPublicPerformanceAllowed
    False
    languages
        • code: en
        • name: English
    subjects
        • value: Technology
        • value: Nonfiction
        • value: Self Help
    publishDateText
    03/06/2007
    otherFormatIdentifiers
        • type: ISBN
        • value: 9780470044032
    mediaType
    eBook
    shortDescription
  • This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
  • Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
  • John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel
  • Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
  • Includes a valuable CD-ROM with templates and worksheets from the book
  • Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    sortTitle
    Excel 2007 Bible
    crossRefId
    122788
    series
    Bible
    publisher
    Wiley
    tableOfContents

    Part I: Getting Started with Excel 1

    Chapter 1: Introducing Excel 3

    Chapter 2: What’s New in Excel 2007? 25

    Chapter 3: Entering and Editing Worksheet Data 35

    Chapter 4: Essential Worksheet Operations 53

    Chapter 5: Working with Cells and Ranges 71

    Chapter 6: Introducing Tables 95

    Chapter 7: Worksheet Formatting 109

    Chapter 8: Understanding Excel’s Files 131

    Chapter 9: Using and Creating Templates 145

    Chapter 10: Printing Your Work 155

    Part II: Working with Formulas and Functions 173

    Chapter 11: Introducing Formulas and Functions 175

    Chapter 12: Creating Formulas That Manipulate Text 205

    Chapter 13: Working with Dates and Times 223

    Chapter 14: Creating Formulas That Count and Sum 249

    Chapter 15: Creating Formulas That Look Up Values 273

    Chapter 16: Creating Formulas for Financial Applications 291

    Chapter 17: Introducing Array Formulas 313

    Chapter 18: Performing Magic with Array Formulas 333

    Part III: Creating Charts and Graphics 349

    Chapter 19: Getting Started Making Charts 351

    Chapter 20: Learning Advanced Charting 381

    Chapter 21: Visualizing Data Using Conditional Formatting 421

    Chapter 22: Enhancing Your Work with Pictures and Drawings 441

    Part IV: Using Advanced Excel Features 459

    Chapter 23: Customizing the Quick Access Toolbar 461

    Chapter 24: Using Custom Number Formats 465

    Chapter 25: Using Data Validation 481

    Chapter 26: Creating and Using Worksheet Outlines 491

    Chapter 27: Linking and Consolidating Worksheets 499

    Chapter 28: Excel and the Internet 513

    Chapter 29: Sharing Data with Other Applications 521

    Chapter 30: Using Excel in a Workgroup 531

    Chapter 31: Protecting Your Work 539

    Chapter 32: Making Your Worksheets Error-Free 551

    Part V: Analyzing Data with Excel 573

    Chapter 33: Using Microsoft Query with External Database Files 575

    Chapter 34: Introducing Pivot Tables 591

    Chapter 35: Analyzing Data with Pivot Tables 609

    Chapter 36: Performing Spreadsheet What-If Analysis 635

    Chapter 37: Analyzing Data Using Goal Seek and Solver 649

    Chapter 38: Analyzing Data with the Analysis ToolPak 667

    Part VI: Programming Excel with VBA 679

    Chapter 39: Introducing Visual Basic for Applications 681

    Chapter 40: Creating Custom Worksheet Functions 703

    Chapter 41: Creating UserForms 715

    Chapter 42: Using UserForm Controls in a Worksheet 733

    Chapter 43: Working with Excel Events 745

    Chapter 44: VBA Examples 757

    Chapter 45: Creating Custom Excel Add-Ins 771

    Part VII: Appendixes 783

    Appendix A: Worksheet Function Reference 785

    Appendix B: What’s on the CD-ROM 799

    Appendix C: Additional Excel Resources 809

    Appendix D: Excel Shortcut Keys 815

    Index 823

    Wiley Publishing, Inc. End-User License Agreement 869