Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, Mr. Spreadsheet shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.Offers an analysis of Excel application development and a complete introduction to VBA Features invaluable advice from Mr. Spreadsheet himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.

    His amazing, unprecedented collection of animals, plants and insects from all around the world gained international fame during his lifetime. In 1731, after decades of collecting, Seba commissioned illustrations of each and every specimen and arranged the publication of a four-volume catalog detailing his entire collection?from strange and exotic plants to snakes, frogs, crocodiles, shellfish, corals, insects, butterflies and more, as well as fantastic beasts, such as a hydra and a dragon. Seba's scenic illustrations, often mixing plants and animals in a single plate, were unusual even for the time. Many of the stranger and more peculiar creatures from Seba's collection, some of which are now extinct, were as curious to those in Seba's day as they are to us now. This reproduction is taken from a rare, hand-colored original. The introduction offers background information about the fascinating tradition of the cabinet of curiosities to which Seba's curiosities belonged.

    Lacking the ability to measure their longitude, sailors throughout the great ages of exploration had been literally lost at sea as soon as they lost sight of land. Thousands of lives, and the increasing fortunes of nations, hung on a resolution.The scientific establishment of Europe—from Galileo to Sir Issac Newton—had mapped the heavens in both hemispheres in its certain pursuit of a celestial answer. In stark contrast, one man, John Harrison, dared to imagine a mechanical solution—a clock that would keep precise time at sea, something no clock had ever been able to do on land. Longitude is a dramatic human story of an epic scientific quest and Harrison's forty-year obsession with building his perfect timekeeper, known today as the chronometer. Full of heroism and chicanery, it is also a fascinating brief history of astronomy, navigation, and clock-making, and opens a new window on our world.On its 10th anniversary, a gift edition of this classic book, with a forward by one of history's greatest explorers, and eight pages of color illustrations.

    Many of the contributors bring their own special touch, presenting a refreshingly eclectic variety of personal icons, from pub signs to seaside piers, from cattle grids to canal boats, and from village cricket to nimbies.First published as a lavish colour coffee-table book, this new expanded paperback edition has double the original number of contributions from many celebrities including Bill Bryson, Michael Palin, Eric Clapton, Bryan Ferry, Sebastian Faulks, Kate Adie, Kevin Spacey, Gavin Pretor-Pinney, Richard Mabey, Simon Jenkins, John Sergeant, Benjamin Zephaniah, Joan Bakewell, Antony Beevor, Libby Purves, Jonathan Dimbleby, and many more: and a new preface by HRH Prince Charles.

    Reveals how to run an online business profitably in spite of the Internet's inherently free culture, disseminating the principles of a ''priceless economy'' in six categories that pertain to advertising, labor exchange, and advanced-version fees.

    But while many people support transit in the abstract, it's often hard to channel that support into good transit investments.  Part of the problem is that transit debates attract many kinds of experts, who often talk past each other.  Ordinary people listen to a little of this and decide that transit is impossible to figure out. Jarrett Walker believes that transit can be simple, if we focus first on the underlying geometry that all transit technologies share. In Human Transit, Walker supplies the basic tools, the critical questions, and the means to make smarter decisions about designing and implementing transit services. Human Transit explains the fundamental geometry of transit that shapes successful systems; the process for fitting technology to a particular community; and the local choices that lead to transit-friendly development. Whether you are in the field or simply a concerned citizen, here is an accessible guide to achieving successful public transit that will enrich any community.

    These numbers don't seem terribly grim, but in ten years, the skewed sex ratio will pose a colossal challenge. By the time those children reach adulthood, their generation will have twenty-four million more men than women.The prognosis for China's neighbors is no less bleak: Asia now has 163 million females "missing" from its population. Gender imbalance reaches far beyond Asia, affecting Georgia, Eastern Europe, and cities in the U.S. where there are significant immigrant populations. The world, therefore, is becoming increasingly male, and this mismatch is likely to create profound social upheaval.Historically, eras in which there have been an excess of men have produced periods of violent conflict and instability. Mara Hvistendahl has written a stunning, impeccably-researched book that does not flinch from examining not only the consequences of the misbegotten policies of sex selection but Western complicity with them.

    interstate system changed the face of our country. The Big Roads charts the creation of these essential American highways. From the turn-of-the-century car racing entrepreneur who spurred the citizen-led “Good Roads” movement, to the handful of driven engineers who conceived of the interstates and how they would work—years before President Eisenhower knew the plans existed—to the protests that erupted across the nation when highways reached the cities and found people unwilling to be uprooted in the name of progress, Swift follows a winding, fascinating route through twentieth-century American life.  How did we get from dirt tracks to expressways, from main streets to off-ramps, from mud to concrete and steel, in less than a century? Through decades of politics, activism, and marvels of engineering, we recognize in our highways the wanderlust, grand scale, and conflicting notions of citizenship and progress that define America.

    Increasingly, the decisions that affect our lives--where we go to school, whether we can get a job or a loan, how much we pay for health insurance--are being made not by humans, but by machines. In theory, this should lead to greater fairness: Everyone is judged according to the same rules.But as mathematician and data scientist Cathy O'Neil reveals, the mathematical models being used today are unregulated and uncontestable, even when they're wrong. Most troubling, they reinforce discrimination--propping up the lucky, punishing the downtrodden, and undermining our democracy in the process.

    A brief, but insightful look at history shows the evolution of combat, the development of the physical and psychological leverage that enables humans to kill other humans, followed by an objective examination of domestic violence in America. The authors reveal the nature of the warrior, brave men and women who train their minds and bodies to go to that place from which others flee. After examining the incredible impact of a few true warriors in battle, On Combat presents new and exciting research as to how to train the mind to become inoculated to stress, fear and even pain.

    Sometimes it's murder, sometimes it's by accident, and sometimes it's because they were so ludicrous they didnt deserve to exist in the first place. Occasionally they explode violently. A few slip away almost unnoticed. Often the cause of death is either 'got too greedy' or 'Napoleon turned up'. Now and then they just hold a referendum and vote themselves out of existence.This is an atlas of 48 nations that fell off the map. The polite way of writing an obituary is: dwell on the good bits, gloss over the embarrassing stuff. This book refuses to do so, because these dead nations are so full of schemers, racists, and con men that it's impossible to skip the embarrassing stuff.Because of this - and because treating nation-states with too much reverence is the entire problem with pretty much everything - these accounts are not concerned with adding to the earnest flag saluting in the world, however nice some of the flags might be.

    Cross answers this question with his ground-breaking approach to revitalizing businesses: focusing on the revenue side of the ledger instead of the cost side. The antithesis of slash-and-burn methods that left companies with empty profits and dissatisfied stockholders, Revenue Management overturns conventional thinking on marketing strategies and offers the key to initiating and sustaining growth.Using case studies from a variety of industries, small businesses, and nonprofit organizations, Cross describes no-tech, low-tech, and high-tech methods that managers can use to increase revenue without increasing products or promotions; predict consumer behavior; tap into new markets; and deliver products and services to customers effectively and efficiently. His proven tactics will help any business dramatically improve its bottom line by meeting the challenge of matching supply with demand.

    And considering that the "one man" is Neal Stephenson, "the hacker Hemingway" (Newsweek) -- acclaimed novelist, pragmatist, seer, nerd-friendly philosopher, and nationally bestselling author of groundbreaking literary works (Snow Crash, Cryptonomicon, etc., etc.) -- the word is well worth hearing. Mostly well-reasoned examination and partial rant, Stephenson's In the Beginning... was the Command Line is a thoughtful, irreverent, hilarious treatise on the cyber-culture past and present; on operating system tyrannies and downloaded popular revolutions; on the Internet, Disney World, Big Bangs, not to mention the meaning of life itself.

    Digital technologies—with hardware, software, and networks at their core—will in the near future diagnose diseases more accurately than doctors can, apply enormous data sets to transform retailing, and accomplish many tasks once considered uniquely human.In The Second Machine Age MIT’s Erik Brynjolfsson and Andrew McAfee—two thinkers at the forefront of their field—reveal the forces driving the reinvention of our lives and our economy. As the full impact of digital technologies is felt, we will realize immense bounty in the form of dazzling personal technology, advanced infrastructure, and near-boundless access to the cultural items that enrich our lives.Amid this bounty will also be wrenching change. Professions of all kinds—from lawyers to truck drivers—will be forever upended. Companies will be forced to transform or die. Recent economic indicators reflect this shift: fewer people are working, and wages are falling even as productivity and profits soar.Drawing on years of research and up-to-the-minute trends, Brynjolfsson and McAfee identify the best strategies for survival and offer a new path to prosperity. These include revamping education so that it prepares people for the next economy instead of the last one, designing new collaborations that pair brute processing power with human ingenuity, and embracing policies that make sense in a radically transformed landscape.A fundamentally optimistic book, The Second Machine Age alters how we think about issues of technological, societal, and economic progress.

    In Four Lost Cities, acclaimed science journalist Annalee Newitz takes readers on an entertaining and mind-bending adventure into the deep history of urban life. Investigating across the centuries and around the world, Newitz explores the rise and fall of four ancient cities, each the center of a sophisticated civilization: the Neolithic site of Çatalhöyük in Central Turkey, the Roman vacation town of Pompeii on Italy’s southern coast, the medieval megacity of Angkor in Cambodia, and the indigenous metropolis Cahokia, which stood beside the Mississippi River where East St. Louis is today.Newitz travels to all four sites and investigates the cutting-edge research in archaeology, revealing the mix of environmental changes and political turmoil that doomed these ancient settlements. Tracing the early development of urban planning, Newitz also introduces us to the often anonymous workers—slaves, women, immigrants, and manual laborers—who built these cities and created monuments that lasted millennia.Four Lost Cities is a journey into the forgotten past, but, foreseeing a future in which the majority of people on Earth will be living in cities, it may also reveal something of our own fate.