Excel 2007 Bible
Author: John Walkenbach
• 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:
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 CustomNumber 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.
Here Comes Everybody: The Power of Organizing Without Organizations
Author: Clay Shirky
A revelatory examination of how the wildfire-like spread of new forms of social interaction enabled by technology is changing the way humans form groups and exist within them, with profound long-term economic and social effects-for good and for ill
A handful of kite hobbyists scattered around the world find each other online and collaborate on the most radical improvement in kite design in decades. A midwestern professor of Middle Eastern history starts a blog after 9/11 that becomes essential reading for journalists covering the Iraq war. Activists use the Internet and e-mail to bring offensive comments made by Trent Lott and Don Imus to a wide public and hound them from their positions. A few people find that a world-class online encyclopedia created entirely by volunteers and open for editing by anyone, a wiki, is not an impractical idea. Jihadi groups trade inspiration and instruction and showcase terrorist atrocities to the world, entirely online. A wide group of unrelated people swarms to a Web site about the theft of a cell phone and ultimately goads the New York City police to take action, leading to the culprit's arrest.
With accelerating velocity, our age's new technologies of social networking are evolving, and evolving us, into new groups doing new things in new ways, and old and new groups alike doing the old things better and more easily. You don't have to have a MySpace page to know that the times they are a changin'. Hierarchical structures that exist to manage the work of groups are seeing their raisons d'кtre swiftly eroded by the rising technological tide. Business models are being destroyed, transformed, born at dizzying speeds, and the larger socialimpact is profound.
One of the culture's wisest observers of the transformational power of the new forms of tech-enabled social interaction is Clay Shirky, and Here Comes Everybody is his marvelous reckoning with the ramifications of all this on what we do and who we are. Like Lawrence Lessig on the effect of new technology on regimes of cultural creation, Shirky's assessment of the impact of new technology on the nature and use of groups is marvelously broad minded, lucid, and penetrating; it integrates the views of a number of other thinkers across a broad range of disciplines with his own pioneering work to provide a holistic framework for understanding the opportunities and the threats to the existing order that these new, spontaneous networks of social interaction represent. Wikinomics, yes, but also wikigovernment, wikiculture, wikievery imaginable interest group, including the far from savory. A revolution in social organization has commenced, and Clay Shirky is its brilliant chronicler.
Publishers Weekly
Blogs, wikis and other Web 2.0 accoutrements are revolutionizing the social order, a development that's cause for more excitement than alarm, argues interactive telecommunications professor Shirky. He contextualizes the digital networking age with philosophical, sociological, economic and statistical theories and points to its major successes and failures. Grassroots activism stands among the winners-Belarus's "flash mobs," for example, blog their way to unprecedented antiauthoritarian demonstrations. Likewise, user/contributor-managed Wikipedia raises the bar for production efficiency by throwing traditional corporate hierarchy out the window. Print journalism falters as publishing methods are transformed through the Web. Shirky is at his best deconstructing Web failures like "Wikitorial," the Los Angeles Times's attempt to facilitate group op-ed writing. Readers will appreciate the Gladwellesque lucidity of his assessments on what makes or breaks group efforts online: "Every story in this book relies on the successful fusion of a plausible promise, an effective tool, and an acceptable bargain with the users." The sum of Shirky's incisive exploration, like the Web itself, is greater than its parts. (Mar.)
Copyright 2007 Reed Business Information
Kirkus Reviews
With newfangled technology like cell-phone photography and Internet bloggery, the course of human events is entering a new epoch, a networking guru informs us. Today, active groups can form where such formations were once impossible, declares Shirky (Interactive Telecommunications Group/NYU). Such modern configurations of power based on the free exchange of information can change society. So toss out all those old organization charts: The Internet, according to the author's facts, figures and theories, offers organization without management, networking without hierarchy. There is no institutional overhead, no cost in failure. Now we can publish before editing, Wikipedia being the prime example. In this new modality, victims of an abusive priest find redress together, stay-at-home moms consult communally, networking terrorists plot evil and anorexic teens confer on ways to starve. Collective action is almost effortless, and evanescent flash-mob events are easy to organize, often to the consternation of authorities. Viral networking can spread like the flu, distant conversation is as simple as pecking on a keyboard and everyone can be a journalist, a publisher, an encyclopedia editor. Shirky, with his illustrative anecdotes, provides back stories for latter-day groupies who log onto Flickr, Meetup, Groklaw and those sometimes fleeting wikis. He clearly applies the theories of power-law distribution and collective action, though as the discussion turns to Coasean Theory or the thoughts of Vilfredo Pareto it leans a bit toward the didactic. All that's needed, says the author, is the promise of a useful outcome, appropriate tools and agreement of participants to afford a platform fornetworking groups, like Archimedes, to move the world. Some wise observations amidst a predominantly old-news text.
What People Are Saying
Clear thinking and good writing about big changes. --Stewart Brand
Clay Shirky may be the finest thinker we have on the Internet revolution, but Here Comes Everybody is more than just a technology book; it's an absorbing guide to the future of society itself. Anyone interested in the vitality and influence of groups of human beings -- from knitting circles, to political movements, to multinational corporations -- needs to read this book. --Steven Johnson, author of Everything Bad Is Good for You and Emergence
How do trends emerge and opinions form? The answer used to be something vague about word of mouth, but now it's a highly measurable science, and nobody understands it better than Clay Shirky. In this delightfully readable book, practically every page has an insight that will change the way you think about the new era of social media. Highly recommended. --Chris Anderson, editor-in-chief of Wired magazine and author of The Long Tail
Clay has long been one of my favorite thinkers on all things Internet -- not only is he smart and articulate, but he's one of those people who is able to crystallize the half-formed ideas that I've been trying to piece together into glittering, brilliant insights that make me think, yes, of course, that's how it all works. --Cory Doctorow, co-editor of Boing Boing and author of Overclocked: Stories of the Future Present
In story after story, Clay masterfully makes the connections as to why business, society and our lives continue to be transformed by a world of net-enabled social tools. His pattern-matching skills are second to none. --Ray Ozzie, Microsoft Chief Software Architect
