Excel 2007 Bible
- 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.
Table of Contents
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.
Wiley Publishing, Inc. End-User License Agreement.
Sign up now »
Organizations that are looking for security features including identity management, encryption and access control — and at the same time want to take advantage of the cost and flexibility benefits ...
The transformation of computing through mobility, consumerisation, bring-your-own device (BYOD) and flex-work offers powerful benefits for today’s organisations ...
"as a teacher - you can't win - in a constantly changing ..."
High school students still see ICT as ‘sitting at a computer all day’: survey
"yep - big brother is watching you - now go out and ..."
Does encryption really shield you from government's prying eyes?
"New manager arrives, fires most of the apparently-underskilled staff rather than training ..."
Solving the skills conundrum – part 1
"How many of the Fortune 500 companies have access to PRISM? https://en.wikipedia.org/wiki/Industrial_espionage ..."
Australia suspected to have PRISM data: Ludlam
"I don't fall into their whinging crap . In the last eight ..."
Australia Post’s mail business to lose $200 million this year
- AT&T to offer NEC Terrain push-to-talk Android smartphone starting Friday
- Intel chooses sides in wireless power market
- Good riddance Google Reader: Feedly throws switch on alternate RSS service
- Countries question Google on Glass privacy
- Papers please! Microsoft creates second-class citizens with Office iPhone app
- Social media adds spice to financial services, say banks
- Google Analytics advocate touts plans to own the Universal customer view
- Google asks to make surveillance orders public, citing First Amendment
- ADMA criticises government plans for compulsory data breach notification
- Google Glass privacy concerns raised by international data protection authorities