Marketing to the Social Web or Excel 2003 Formulas

Marketing to the Social Web: How Digital Customer Communities Build Your Business

Author: Larry Weber

Praise for Marketing to the Social Web

"Weber understands that the world is going digital and that competitive advantage will accrue to those who understand the transformation. CEOs should heed this transformation and learn from Weber's insights how to navigate this new landscape to fully maximize their business opportunities."
-Mark Fuller, Chairman, Monitor Group

"Consumers are using technology to grab power from companies, the media, and the government. Marketing to the Social Web succinctly outlines how institutions can survive and win in this chaotic new world, and lays out the revised rules of engagement-ignore them at your peril."
-George F. Colony, CEO, Forrester Research, Inc.

"Larry has brought pragmatic and useful recommendations to help brand builders manage the complexity of social interaction in a digital age. I was pleased to read a book that actually suggests how to do something with social networks, instead of just ponder them."
-David Kenny, Chairman and Chief Executive Officer, Digitas Inc.

"Where's the allure of social 2.0? Brands can talk . . . customers talk louder! Digital influence has arrived."
-Jeff Taylor, CEO, Eons and Founder of Monster.com

"Larry Weber provides a simple and effective roadmap of the new customer information highway. Marketing to the Social Web is a valuable tool that will give everyone the confidence and know-how to compete in this fast-growing marketplace of ideas."
-Steve Harris, Vice President, Global Communications, General Motors Corporation

"As all lines and boundaries are washed away by the Web, Weber describes how to become part of the sea versus the sand."
-NicholasNegroponte, Chairman, One Laptop per Child

Interesting book: Andrew Jackson or Blue Rage Black Redemption

Excel 2003 Formulas

Author: John Walkenbach

Everything you need to know about

• Mastering operators, error values, naming techniques, and absolute versus relative references

• Debugging formulas and using the auditing tools

• Importing and exporting XML files and mapping the data to specific cells

• Using Excel 2003’s rights management feature

• Working magic with array formulas

• Developing custom formulas to produce the results you need

Here’s the formula for Excel excellence

Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel’s capacity.

CD-ROM Includes

• Trial version of the author’s award-winning Power Utility Pak 5

• More than 90 sample workbooks illustrating key formula concepts

Table of Contents:

	Preface
	Acknowledgments
Pt. I	Basic Information
Ch. 1	Excel in a Nutshell	3
Ch. 2	Basic Facts about Formulas	29
Ch. 3	Working with Names	55
Pt. II	Using Functions in Your Formulas
Ch. 4	Introducing Worksheet Functions	95
Ch. 5	Manipulating Text	111
Ch. 6	Working with Dates and Times	135
Ch. 7	Counting and Summing Techniques	175
Ch. 8	Using Lookup Functions	207
Ch. 9	Databases and Lists	233
Ch. 10	Miscellaneous Calculations	267
Pt. III	Financial Formulas
Ch. 11	Introducing Financial Formulas	293
Ch. 12	Discounting and Depreciation Financial Functions	333
Ch. 13	Advanced Uses of Financial Functions and Formulas	357
Pt. IV	Array Formulas
Ch. 14	Introducing Arrays	383
Ch. 15	Performing Magic with Array Formulas	405
Pt. V	Miscellaneous Formula Techniques
Ch. 16	Intentional Circular References	433
Ch. 17	Charting Techniques	449
Ch. 18	Pivot Tables	497
Ch. 19	Conditional Formatting and Data Validation	521
Ch. 20	Creating Megaformulas	547
Ch. 21	Tools and Methods for Debugging Formulas	569
Pt. VI	Developing Custom Worksheet Functions
Ch. 22	Introducing VBA	597
Ch. 23	Function Procedure Basics	609
Ch. 24	VBA Programming Concepts	629
Ch. 25	VBA Custom Function Examples	663
	App. A: Working with Imported 1-2-3 Files	709
	App. B: Excel Function Reference	717
	App. C: Using Custom Number Formats	735
	App. D: Additional Excel Resources	761
	App. E: What's on the CD-ROM	769
	Index	783
	End-User License Agreement	829