Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.

    Just four years later, Compaq was on the Fortune 500 list, and, two years after that, they had exceeded $1 billion in annual revenue. No company had ever achieved these milestones so rapidly.But few know the story behind the story. In 1982, when Compaq was founded, there was no software standardization, so every brand of personal computer required its own unique application software. Just eight years later, compatibility with the open PC standard had become ubiquitous, and it has continued to be for over two decades.This didn’t happen by accident. Cofounder and then CEO Rod Canion and his team made a series of risky and daring decisions—often facing criticism and incredulity—that allowed the open PC standard marketplace to thrive and the incredible benefits of open computing to be realized.A never-before-published insider account of Compaq’s extraordinary strategies and decisions, Open provides valuable lessons in leadership in times of crisis, management decision-making under the pressure of extraordinary growth, and the power of a unique, pervasive culture.Open tells the incredible story of Compaq’s meteoric rise from humble beginnings to become the PC industry leader in just over a decade. Along the way, Compaq helped change the face of computing while establishing the foundation for today’s world of tablets and smart phones.

    And they did it without fanfare or recognition from their employer. Hiltzik's Dealers of Lightning provides a fascinating look at technohistory that sets the record straight. In Dealers of Lightning, Hiltzik describes the forces and faces behind the revolution that the Xerox PARC team single-handedly spawned. The Xerox PARC group was composed solely of top technical minds. The decision was made at Xerox headquarters to give the team complete freedom from deadlines and directives, in hopes of fostering a true creative environment. It worked — perhaps too well. The team responded with a steady output of amazing technology, including the first version of the Internet, the first personal computer, user-friendly word-processing programs, and pop-up menus. Xerox, far from ready for the explosion of innovation, failed to utilize the technology dreamed up by the group. Out of all the dazzling inventions born at Xerox PARC, only a handful were developed and marketed by Xerox. However, one of these inventions, the laser printer, proved successful enough to earn billions for the company, therefore justifying its investment in the research center. Most oftheteam's creations would go on to be developed and perfected by other companies, such as IBM, Apple, and Microsoft. Drawing from interviews with the engineers, executives, and scientists involved in the Xerox PARC, Dealers of Lightning chronicles an amazing era of egos, ideas, and inventions at the dawn of the computer age.

    - Business is Fun, the book that goes behind the company that was synonymous with the popularization of 'video games.'Nearly 8 years in the making, Atari Inc. - Business is Fun is comprised of thousands of researched documents, hundreds of interviews, and access to materials never before available.An amazing 800 pages (including nearly 300 pages of rare, never before seen photos, memos and court documents), this book details Atari's genesis from an idea between an engineer and a visionary in 1969 to a nearly $2 billion dollar juggernaut, and ending with a $538 million death spiral during 1984. A testament to the people that worked at this beloved company, the book is full of their personal stories and insights. Learn about topics like:* All the behind the scenes stories surrounding the creation of the company's now iconic games and products.* The amazing story of Atari's very own "Xerox PARC" research facility up in the foothills of the Sierra Mountains* The full recounting of Steve Jobs's time at Atari, with comments from the people he worked with on projects and the detailed story of the creation of Atari Breakout, including input by Steve Wozniak on his development of the prototype, and how it couldn't be used and another Atari engineer would have to make the final production Breakout arcade game instead.* The creation of "Rick Rats Big Cheese Restaurants" which later became "Chuck E. Cheese's"* How Atari Inc. faltered and took down an entire industry with it before being put on the chopping block.If you've ever wanted to learn about the truth behind the creation of this iconic company told directly by the people who made FUN for a living, then this is the book for you!

    Revolution in the Valley traces this vision back to its earliest roots: the hallways and backrooms of Apple, where the groundbreaking Macintosh computer was born. The book traces the development of the Macintosh, from its inception as an underground skunkworks project in 1979 to its triumphant introduction in 1984 and beyond.The stories in "Revolution in the Valley" come on extremely good authority. That's because author Andy Hertzfeld was a core member of the team that built the Macintosh system software, and a key creator of the Mac's radically new user interface software. One of the chosen few who worked with the mercurial Steve Jobs, you might call him the ultimate insider.When "Revolution in the Valley" begins, Hertzfeld is working on Apple's first attempt at a low-cost, consumer-oriented computer: the Apple II. He sees that Steve Jobs is luring some of the company's most brilliant innovators to work on a tiny research effort the Macintosh. Hertzfeld manages to make his way onto the Macintosh research team, and the rest is history.Through lavish illustrations, period photos, and Hertzfeld's vivid first-hand accounts, Revolution in the Valley reveals what it was like to be there at the birth of the personal computer revolution. The story comes to life through the book's portrait of the talented and often eccentric characters who made up the Macintosh team. Now, over 20 years later, millions of people are benefiting from the technical achievements of this determined and brilliant group of people.

    C. R. Licklider, whose visionary dream of a human-computer symbiosis transformed the course of modern science and led to the development of the personal computer. Reprint.

    Getting Started with Arduino gives you lots of ideas for Arduino projects and helps you get going on them right away. From getting organized to putting the final touches on your prototype, all the information you need is right in the book. Inside, you'll learn about:Interaction design and physical computing The Arduino hardware and software development environment Basics of electricity and electronics Prototyping on a solderless breadboard Drawing a schematic diagram And more. With inexpensive hardware and open-source software components that you can download free, getting started with Arduino is a snap. To use the introductory examples in this book, all you need is a USB Arduino, USB A-B cable, and an LED. Join the tens of thousands of hobbyists who have discovered this incredible (and educational) platform. Written by the co-founder of the Arduino project, with illustrations by Elisa Canducci, Getting Started with Arduino gets you in on the fun! This 128-page book is a greatly expanded follow-up to the author's original short PDF that's available on the Arduino website.

    That’s where this full-color Missing Manual comes in. Learn how to stream HD video, make video calls, manage your email, surf the Web, listen to music, play games, and maybe even do a little iWork. This is the book that should have been in the box.Build your media library. Fill your iPad with music, movies, TV shows, eBooks, photos, and more.Share with others. Stream music, HD movies, TV shows, and more, to and from your iPad.Create your own media. Use the iPad’s new Photo Booth, iMovie, and GarageBand apps to express yourself.Get online. Connect through WiFi or Wi-Fi+3G, and surf with the iPad’s faster browser.Place video calls. See who’s talking with the iPad’s FaceTime app and its two cameras.Consolidate your email. Read and send messages from any of your accounts.Learn undocumented tips and tricks. Get the lowdown on cool iPad secrets and workarounds.

    The second wave came in 2006 when home-grown VCs raised large amounts of capital and funded products and services companies for Indian consumers.This is a gripping behind-the-scenes story of a VC's journey, right from the beginning of the second start-up revolution in India in 2006 until the end of the funding frenzy in 2016. A story about how global conditions, local consumers, founder ambition and good old greed shaped the start-up story in India.Rahul Chandra is the co-founder of Helion Ventures, and in this candid memoir he tells us about his journey building one of India's oldest VC firms. In a remarkably gripping account, he recounts his adventures in India's hyper-funded start-up ecosystem.The Moonshot Game gives readers an insight into the secret world of a VC, with unguarded stories involving large bets and big mistakes, and tales of how one juggles several investments at the same time.Rahul shows why being a VC is a constant journey of ups and downs, why building value is a long-term business, and why no amount of failure can be an excuse to lose optimism in the power of entrepreneurship.

    Windows 10 (a free update to users of Windows 8 or Windows 7) fixes a number of the problems introduced by the revolution in Windows 8 and offers plenty of new features, such as the new Spartan web browser, Cortana voice-activated "personal assistant," new universal apps (that run on tablet, phone, and computer), and more. But to really get the most out of the new operating system, you're going to need a guide.Thankfully, Windows 10: The Missing Manual will be there to help. Like its predecessors, this book from the founder of Yahoo Tech, previous New York Times columnist, bestselling author, and Missing Manuals creator David Pogue illuminates its subject with technical insight, plenty of wit, and hardnosed objectivity for beginners, veteran standalone PC users, new tablet owners, and those who know their way around a network.

    Creative Selection recounts the life of one of the few who worked behind the scenes, a highly-respected software engineer who worked in the final years the Steve Jobs era--the Golden Age of Apple.Ken Kocienda offers an inside look at Apple's creative process. For fifteen years, he was on the ground floor of the company as a specialist, directly responsible for experimenting with novel user interface concepts and writing powerful, easy-to-use software for products including the iPhone, the iPad, and the Safari web browser. His stories explain the symbiotic relationship between software and product development for those who have never dreamed of programming a computer, and reveal what it was like to work on the cutting edge of technology at one of the world's most admired companies.Kocienda shares moments of struggle and success, crisis and collaboration, illuminating each with lessons learned over his Apple career. He introduces the essential elements of innovation--inspiration, collaboration, craft, diligence, decisiveness, taste, and empathy--and uses these as a lens through which to understand productive work culture.An insider's tale of creativity and innovation at Apple, Creative Selection shows readers how a small group of people developed an evolutionary design model, and how they used this methodology to make groundbreaking and intuitive software which countless millions use every day.

    No one wants to add to the scrap heap. But if you restrict yourself to only reading articles from people who have actually created a business, hit some revenue target, or broken out of the MVP-in-an-incubator stage, there’s very few books and blogs left. This is why we hope this book is relevant to you.It’s not packed with startup clichés, nor is it steeped in myths about how huge companies got their break. Yes, Airbnb sold cereal before they were a 31 billion dollar company, and Slack was one hell of a pivot, but those wells have been over-drilled for their useful lessons at this point. This book is our honest, opinionated take on what we’ve learned building Intercom over the past 6 years. You won’t like it all, you won’t agree with it all, but you’re not supposed to. Your mileage will vary.

    This Self-Paced Training Kit is designed to help maximize your performance on 70-680, the required exam for the Microsoft Certified Technology Specialist (MCTS): Windows 7, Configuration certification.This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs to give you the skills and expertise you can use on the job.Work at your own pace through the lessons and lab exercises. This official study guide covers installing, upgrading, and migrating to Windows 7; configuring network connectivity, applications, and devices; implementing backup and recovery; configuring User Account Control (UAC), mobility options, and new features such as DirectAccess and BranchCache; and managing system updates.Then assess yourself using the 200 practice questions on CD, featuring multiple customizable testing options to meet your specific needs. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives. You get detailed explanations for right and wrong answers—including pointers back to the book for further study. You also get an exam discount voucher—making this kit an exceptional value and a great career investment.

    You must first approach the subject with the proper sense of perception, with the ability to visualize the finished print before you commit a scene to pixels, but still be flexible and spontaneous. Master Fine Art photographer Vincent Versace has spent his career learning and teaching the art of perception and how to translate it into stunning images. In Welcome to Oz,  he delves into what it means to approach digital photography cinematically, to use your perception, your camera, and Photoshop to capture the movement of life in a still image. Features: Adapt your workflow to the image so you always know how best to use your tools Turn a seemingly impossible photographic scenario into a successful image Practice “image harvesting” to combine the best parts of  many captures to create an optimum final result Create black and white prints that have the look, feel and “richness” of traditional silver prints without ever leaving the RGB color space 224 pages.