Excel 2007 bible

書誌事項

Excel 2007 bible

John Walkenbach

Wiley, c2007

  • pbk
  • pbk

タイトル別名

Microsoft Office Excel 2007

大学図書館所蔵 件 / 1

この図書・雑誌をさがす

注記

CD-ROM in back pocket

Formerly CIP

Cover and spine title: Microsoft Office Excel 2007

Includes index

内容説明・目次

内容説明

* 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.

目次

Acknowledgments. Introduction. Part I: Getting Started with Excel. Chapter 1: Introducing Excel. Chapter 2: What's New in Excel 2007? Chapter 3: Entering and Editing Worksheet Data. Chapter 4: Essential Worksheet Operations. Chapter 5: Working with Cells and Ranges. Chapter 6: Introducing Tables. Chapter 7: Worksheet Formatting. Chapter 8: Understanding Excel's Files. Chapter 9: Using and Creating Templates. Chapter 10: Printing Your Work. Part II: Working with Formulas and Functions. Chapter 11: Introducing Formulas and Functions. Chapter 12: Creating Formulas That Manipulate Text. Chapter 13: Working with Dates and Times. Chapter 14: Creating Formulas That Count and Sum. Chapter 15: Creating Formulas That Look Up Values. Chapter 16: Creating Formulas for Financial Applications. Chapter 17: Introducing Array Formulas. Chapter 18: Performing Magic with Array Formulas. Part III: Creating Charts and Graphics. Chapter 19: Getting Started Making Charts. Chapter 20: Learning Advanced Charting. Chapter 21: Visualizing Data Using Conditional Formatting. Chapter 22: Enhancing Your Work with Pictures and Drawings. Part IV: Using Advanced Excel Features. Chapter 23: Customizing the Quick Access Toolbar. Chapter 24: Using Custom Number Formats. Chapter 25: Using Data Validation. Chapter 26: Creating and Using Worksheet Outlines. Chapter 27: Linking and Consolidating Worksheets. Chapter 28: Excel and the Internet. Chapter 29: Sharing Data with Other Applications. Chapter 30: Using Excel in a Workgroup. Chapter 31: Protecting Your Work. Chapter 32: Making Your Worksheets Error-Free. Part V: Analyzing Data with Excel. Chapter 33: Using Microsoft Query with External Database Files. Chapter 34: Introducing Pivot Tables. Chapter 35: Analyzing Data with Pivot Tables. Chapter 36: Performing Spreadsheet What-If Analysis. Chapter 37: Analyzing Data Using Goal Seek and Solver. Chapter 38: Analyzing Data with the Analysis ToolPak. Part VI: Programming Excel with VBA. Chapter 39: Introducing Visual Basic for Applications. Chapter 40: Creating Custom Worksheet Functions. Chapter 41: Creating UserForms. Chapter 42: Using UserForm Controls in a Worksheet. Chapter 43: Working with Excel Events. Chapter 44: VBA Examples. Chapter 45: Creating Custom Excel Add-Ins. Part VII: Appendixes. Appendix A: Worksheet Function Reference. Appendix B: What's on the CD-ROM. Appendix C: Additional Excel Resources. Appendix D: Excel Shortcut Keys. Index. Wiley Publishing, Inc. End-User License Agreement.

「Nielsen BookData」 より

詳細情報

  • NII書誌ID(NCID)
    BA90477707
  • ISBN
    • 9780470044032
    • 0470044039
  • 出版国コード
    us
  • タイトル言語コード
    eng
  • 本文言語コード
    eng
  • 出版地
    Indianapolis, Ind
  • ページ数/冊数
    xlii, 866 p
  • 大きさ
    24cm
  • 付属資料
    1CD-ROM
  • 分類
  • 件名
ページトップへ