Excel 2007 Bible

Front Cover
John Wiley & Sons, Jun 17, 2011 - Computers - 912 pages
  • 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.

 

What people are saying - Write a review

User ratings

5 stars
5
4 stars
1
3 stars
0
2 stars
1
1 star
0

Excel 2007 Bible

User Review  - leann205 - Overstock.com

Great resource for learning Excel. The attached cdrom of the book is very helpful for looking up items on your computer. This product is very useful. Read full review

User Review - Flag as inappropriate

I have read the hard copy of this book and found this book very helpful whenever i lost my way in the world of excel 2007.

Contents

Introducing Excel
3
Whats New in Excel 2007?
25
Entering and Editing Worksheet Data
35
Essential Worksheet Operations
53
Working with Cells and Ranges
71
Introducing Tables
95
Worksheet Formatting
109
Understanding Excels Files
131
Linking and Consolidating Worksheets
499
Excel and the Internet
513
Sharing Data with Other Applications
521
Using Excel in a Workgroup
531
Protecting Your Work
539
Making Your Worksheets ErrorFree
551
Analyzing Data with Excel
573
Using Microsoft Query with External Database Files
575

Using and Creating Templates
145
Printing Your Work
155
Working with Formulas and Functions
173
Introducing Formulas and Functions
175
Creating Formulas That Manipulate Text
205
Working with Dates and Times
223
Creating Formulas That Count and Sum
249
Creating Formulas That Look Up Values
273
Creating Formulas for Financial Applications
291
Introducing Array Formulas
313
Performing Magic with Array Formulas
333
Creating Charts and Graphics
349
Getting Started Making Charts
351
Learning Advanced Charting
381
Visualizing Data Using Conditional Formatting
421
Enhancing Your Work with Pictures and Drawings
441
Using Advanced Excel Features
459
Customizing the Quick Access Toolbar
461
Using Custom Number Formats
465
Using Data Validation
481
Creating and Using Worksheet Outlines
491
Introducing Pivot Tables
591
Analyzing Data with Pivot Tables
609
Performing Spreadsheet WhatIf Analysis
635
Analyzing Data Using Goal Seek and Solver
649
Analyzing Data with the Analysis ToolPak
667
Programming Excel with VBA
679
Introducing Visual Basic for Applications
681
Creating Custom Worksheet Functions
703
Creating UserForms
715
Using UserForm Controls in a Worksheet
733
Working with Excel Events
745
VBA Examples
757
Creating Custom Excel AddIns
771
Appendixes
783
Worksheet Function Reference
785
Whats on the CDROM
799
Additional Excel Resources
809
Excel Shortcut Keys
815
Index
823
Wiley Publishing Inc EndUser License Agreement
867
Copyright

Other editions - View all

Common terms and phrases

About the author (2011)

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.

Bibliographic information