Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences. Entering Formulas&Functions, Entering a SUM Function Quickly, Absolute vs. Relative Cell References. Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag&Drop. Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Worksheets Simultaneously, Copying Data and Formatting to Multiple Worksheets. Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page. Working with Previous Versions (Compatibility Mode). Also includes: Lists of Selection and Movement Shortcuts.This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting&Filtering; Advanced&Macros; Charts&Sparklines; Functions&Formulas.

With the iOS5 software and the new iPhone 4S device, Apple has another world-class hit on its hands. This sleek, highly refined pocket computer comes with everything—cellphone, iPod, Internet, camcorder—except a printed manual. Fortunately, David Pogue is back with the latest edition of his witty, crystal-clear, colorful guide: the world's most popular iPhone book.Use it as a phone. Learn the basics as well as time-saving tricks and tips for contact searching by voice, texting, and more. Manage your stuff in the cloud. Sync and back up your contacts and media across all of your devices with iCloud. Get things done. Ask Siri to send reminders, place calls, and more. Master notifications. Use the Notification Center to find missed messages, calendar invitations, friend requests, and more. Connect with other iPhone owners. Send unlimited iMessages to friends, family, and colleagues who are also running iOS5. Treat it as an iPod. Master the ins and outs of iTunes, and listen to music, upload and view photos, and fill the iPhone with TV shows and movies. Take the iPhone online. Make the most of your online experience to browse the Web, read and compose email, use social networks, or send photos and audio files. Go beyond the iPhone. Learn how to use the App Store, and how to multitask between your apps, organize them in folders, and read ebooks in iBooks. Whether you have a brand-new iPhone or want to update an earlier model with the iOS5 software, this beautiful full-color book is the best, most objective resource available.

Tired of reading HTML books that only make sense after you're an expert? Then it's about time you picked up Head First HTML with CSS&XHTML and really learned HTML. You want to learn HTML so you can finally create those web pages you've always wanted, so you can communicate more effectively with friends, family, fans, and fanatic customers. You also want to do it right so you can actually maintain and expand your Web pages over time, and so your web pages work in all the browsers and mobile devices out there. Oh, and if you've never heard of CSS, that's okay--we won't tell anyone you're still partying like it's 1999--but if you're going to create Web pages in the 21st century then you'll want to know and understand CSS. Learn the real secrets of creating Web pages, and why everything your boss told you about HTML tables is probably wrong (and what to do instead). Most importantly, hold your own with your co-worker (and impress cocktail party guests) when he casually mentions how his HTML is now strict, and his CSS is in an external style sheet. With Head First HTML with CSS&XHTML, you'll avoid the embarrassment of thinking web-safe colors still matter, and the foolishness of slipping a font tag into your pages. Best of all, you'll learn HTML and CSS in a way that won't put you to sleep. If you've read a Head First book, you know what to expect: a visually-rich format designed for the way your brain works. Using the latest research in neurobiology, cognitive science, and learning theory, this book will load HTML, CSS, and XHTML into your brain in a way that sticks. So what are you waiting for? Leave those other dusty books behind and come join us in Webville. Your tour is about to begin. Praise"Elegant design is at the core of every chapter here, each concept conveyed with equal doses of pragmatism and wit." --Ken Goldstein, Executive Vice President, Disney Online "This book is a thoroughly modern introduction to forward-looking practices in web page markup and presentation." --Danny Goodman, author of Dynamic HTML: The Definitive Guide "What used to be a long trial and error learning process has now been reduced neatly into an engaging paperback." --Mike Davidson, CEO, Newsvine, Inc. "I love Head First HTML with CSS&XHTML--it teaches you everything you need to learn in a 'fun coated' format!" --Sally Applin, UI Designer and Artist "I haven't had as much fun reading a book (other than Harry Potter) in years. And your book finally helped me break out of my hapless so-last-century way of creating web pages." --Professor David M. Arnow, Department of Computer and Information Science, Brooklyn College "If you've ever had a family member who wanted you to design a website for them, buy them Head First HTML with CSS and XHTML. If you've ever asked a family member to design you a web site, buy this book. If you've ever bought an HTML book and ended up using it to level your desk, or for kindling on a cold winter day, buy this book. This is the book you've been waiting for. This is the learning system you've been waiting for." --Warren Kelly, Blogcritics.org

In early reviews, geeks raved about Windows 7. But if you're an ordinary mortal, learning what this new system is all about will be challenging. Fear not: David Pogue's Windows 7: The Missing Manual comes to the rescue. Like its predecessors, this book illuminates its subject with reader-friendly insight, plenty of wit, and hardnosed objectivity for beginners as well as veteran PC users. Windows 7 fixes many of Vista's most painful shortcomings. It's speedier, has fewer intrusive and nagging screens, and is more compatible with peripherals. Plus, Windows 7 introduces a slew of new features, including better organization tools, easier WiFi connections and home networking setup, and even touchscreen computing for those lucky enough to own the latest hardware. With this book, you'll learn how to:Navigate the desktop, including the fast and powerful search function Take advantage of Window's apps and gadgets, and tap into 40 free programs Breeze the Web with Internet Explorer 8, and learn the email, chat, and videoconferencing programs Record TV and radio, display photos, play music, and record any of these to DVD using the Media Center Use your printer, fax, laptop, tablet PC, or smartphone with Windows 7 Beef up your system and back up your files Collaborate and share documents and other files by setting up a workgroup network

The authors present the complete guide to ANSI standard C language programming. Written by the developers of C, this new version helps readers keep up with the finalized ANSI standard for C while showing how to take advantage of C's rich set of operators, economy of expression, improved control flow, and data structures. The 2/E has been completely rewritten with additional examples and problem sets to clarify the implementation of difficult language constructs. For years, C programmers have let K&R guide them to building well-structured and efficient programs. Now this same help is available to those working with ANSI compilers. Includes detailed coverage of the C language plus the official C language reference manual for at-a-glance help with syntax notation, declarations, ANSI changes, scope rules, and the list goes on and on.

Learn the simplest ways to get things done with Microsoft® SharePoint® 2010!Here's WHAT You'll LearnManage and share team information in one location Use project task lists to organize people and processes Create libraries for documents, media, slides, and more Work seamlessly with Microsoft Office Find content quickly with the Search Center Add SharePoint blogs, wikis, and personal sites Here's HOW You’ll Learn ItJump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away

All the methods and tools you need to successfully program with ExcelJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. 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 new features of Excel 2010, 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 Visual Basic for Applications (VBA)Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applicationsProvides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere elseIncludes a CD with templates and worksheets from the bookThis power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Cascading Style Sheets can turn humdrum websites into highly-functional, professional-looking destinations, but many designers merely treat CSS as window-dressing to spruce up their site's appearance. You can tap into the real power of this tool with CSS: The Missing Manual. This second edition combines crystal-clear explanations, real-world examples, and dozens of step-by-step tutorials to show you how to design sites with CSS that work consistently across browsers. Witty and entertaining, this second edition gives you up-to-the-minute pro techniques. You'll learn how to:Create HTML that's simpler, uses less code, is search-engine friendly, and works well with CSS Style text by changing fonts, colors, font sizes, and adding borders Turn simple HTML links into complex and attractive navigation bars -- complete with rollover effects Create effective photo galleries and special effects, including drop shadows Get up to speed on CSS 3 properties that work in the latest browser versions Build complex layouts using CSS, including multi-column designs Style web pages for printing With CSS: The Missing Manual, Second Edition, you'll find all-new online tutorial pages, expanded CSS 3 coverage, and broad support for Firebox, Safari, and other major web browsers, including Internet Explorer 8. Learn how to use CSS effectively to build new websites, or refurbish old sites that are due for an upgrade.

Getting to Know ArcGIS Desktop introduces principles of GIS as it teaches the mechanics of using ESRI’s leading technology. Key concepts are combined with detailed illustrations and step-by-step exercises to acquaint readers with the building blocks of ArcGIS® Desktop including ArcMap™, for displaying and querying maps, ArcCatalog™, for organizing geographic data, and ModelBuilder™, for diagramming and processing solutions to complex spatial analysis problems. Its broad scope, simple style, and practical orientation make this book an ideal classroom text and an excellent resource for those learning GIS on their own. A data CD for working through the exercises and a fully functioning 180-day trial ArcGIS® Desktop 10 software is included.

A new edition, packed with even more clever tricks and methods that make everyday life easierLifehackers redefine personal productivity with creative and clever methods for making life easier and more enjoyable. This new edition of a perennial bestseller boasts new and exciting tips, tricks, and methods that strike a perfect balance between current technology and common sense solutions for getting things done. Exploring the many ways technology has changed since the previous edition, this new edition has been updated to reflect the latest and greatest in technological and personal productivity.The new "hacks" run the gamut of working with the latest Windows and Mac operating systems for both Windows and Apple, getting more done with smartphones and their operating systems, and dealing with the evolution of the web. Even the most tried-and-true hacks have been updated to reflect the contemporary tech world and the tools it provides us.Hacks include:Hack 1: Empty Your Inbox (and Keep It Empty). Hack 2: Decrease Your Response Time. Hack 3: Craft Effective Messages. Hack 4: Highlight Messages Sent Directly to You. Hack 5: Use Disposable Email Addresses. Hack 6: Master Message Search. Hack 7: Future-Proof Your Email Address. Hack 8: Consolidate Multiple Email Addresses with Gmail. Hack 9: Script and Automate Repetitive Replies. Hack 10: Filter Low-Priority Messages. Hack 11: Organize Your Documents Folder. Hack 12: Instantly Retrieve Files Stored on Your Computer. Hack 13: Overhaul Your Filing Cabinet. Hack 14: Instantly Recall Any Number of Different Passwords. Hack 15: Securely Track Your Passwords. Hack 16: Tag Your Bookmarks. Hack 17: Organize Your Digital Photos. Hack 18: Corral Media Across Folders and Drives. Hack 19: Create Saved Search Folders. Hack 20: Create a Password-Protected Disk on Your PC. Hack 21: Create a Password-Protected Disk on Your Mac. Hack 22: Encrypt Your Entire Windows Operating System. Hack 23: Set Up 2-Step Verification for Your Google Account. Hack 24: Design Your Own Planner. Hack 25: Make Your To-Do List Doable. Hack 26: Set Up a Morning Dash. Hack 27: Map Your Time. Hack 28: Quick-Log Your Workday. Hack 29: Dash Through Tasks with a Timer. Hack 30: Form New Habits with Jerry Seinfeld's Chain. Hack 31: Control Your Workday. Hack 32: Turn Tasks into Game Play. Hack 33: Send Reminders to Your Future Self. Hack 34: Take Great Notes. Hack 35: Organize Your Life with Remember the Milk. Hack 36: Organize Your Life in Text Files. Hack 37: Set Up a Ubiquitous Note-Taking Inbox Across Devices. Hack 38: Off-Load Your Online Reading to a Distraction-Free Environment. Hack 39: Limit Visits to Time-Wasting Websites. Hack 40: Permanently Block Time-Wasting Websites. Hack 41: Reduce Email Interruptions. Hack 42: Split Your Work Among Multiple Desktops. Hack 43: Build a No-Fly Zone. Hack 44: Set Up Communication Quiet Hours. Hack 45: Clear Your Desktop. Hack 46: Make Your House a Usable Home. Hack 47: Sentence Stuff to Death Row. Hack 48: Drown Out Distracting Sounds with Pink Noise. Hack 49: Search the Web in Three Keystrokes. Hack 50: Command Your Windows PC from the Keyboard. Hack 51: Command Your Mac from the Keyboard. Hack 52: Reduce Repetitive Typing with Texter for Windows. Hack 53: Reduce Repetitive Typing with TextExpander for Mac. Hack 54: Automatically Fill in Repetitive Web Forms. Hack 55: Batch-Resize Photos. Hack 56: Bypass Free Site Registration with BugMeNot. Hack 57: Speed Up Web Pages on a Slow Internet Connection. Hack 58: Securely Save Website Passwords. Hack 59: Become a Scheduling Black Belt with Google Calendar. Hack 60: Set Up an Automated, Bulletproof File Back Up Solution. Hack 61: Automatically Back Up Your Files to an External Hard Drive (Mac). Hack 62: Automatically Clean Up Your PC. Hack 63: Automatically Clean Up Your Mac. Hack 64: Automatically Reboot and Launch Applications. Hack 65: Make Google Search Results Automatically Come to You. Hack 66: Automatically Download Music, Movies, and More. Hack 67: Access Your Most Important Files Anywhere with Dropbox. Hack 68: Manage Your Documents in a Web-Based Office Suite. Hack 69: Carry Your Life on a Flash Drive. Hack 70: Create a Virtual Private Network (VPN) with Hamachi. Hack 71: Run a Home Web Server. Hack 72: Run Full-Fledged Webapps from Your Home Computer. Hack 73: Build Your Personal Wikipedia. Hack 74: Remotely Control Your Home Computer. Hack 75: Give Your Home Computer a Web Address. Hack 76: Optimize Your Laptop. Hack 77: Speed Up Your Touchscreen Typing. Hack 78: Break Down the Barrier Between Your Computer and Mobile Phone. Hack 79: Remote Control Your Computer with Your Phone. Hack 80: Automate Android Functions with Tasker. Hack 81: Set Up One Phone Number to Rule Them All. Hack 82: Augment Reality with Your Phone. Hack 83: Remember Where You’ve Been Using Location Awareness. Hack 84: Command Your Phone with Your Voice. Hack 85: Use Your Camera Phone as a Scanner. Hack 86: Make Your "Dumbphone" Smarter via Text Message. Hack 87: Connect Your Computer to the Internet via Mobile Phone by "Tethering". Hack 88: Develop Your (Digital) Photographic Memory. Hack 89: Send and Receive Money on Your Mobile Phone with PayPal. Hack 90: Google Like a Pro. Hack 91: Subscribe to Websites with RSS. Hack 92: Quickly Search Within Specific Websites from the Address Bar. Hack 93: Extend Your Web Browser. Hack 94: Supercharge Your Firefox Downloads with DownThemAll! Hack 95: Get 10 Useful Bookmarklets. Hack 96: Find Reusable Media Online. Hack 97: Get Your Data on a Map. Hack 98: Set Multiple Sites as Your Home Page. Hack 99: Access Unavailable Websites via Google. Hack 100: Have a Say in What Google Says About You. Hack 101: Clear Your Web Browsing Tracks. Hack 102: Rescue Your PC from Malware. Hack 103: Protect Your PC from Malware. Hack 104: Clean Up Your Startup. Hack 105: Undo System Configuration Changes. Hack 106: Truly Delete Data from Your Hard Drive. Hack 107: Compare and Merge Files and Folders with WinMerge. Hack 108: Firewall Your Windows PC. Hack 109: Firewall Your Mac. Hack 110: Speed Up Windows with a Thumb Drive. Hack 111: Free Up Hard-Drive Space. Hack 112: Resurrect Deleted Files. Hack 113: Hot Image Your PC for Instant Restoration. Hack 114: Hot Image Your Mac for Instant Restoration. Hack 115: Recover Files from an Unbootable PC. Hack 116: Share Windows Files. Hack 117: Share Mac Files. Hack 118: Keep Your Web Browser in Sync Across Computers. Hack 119: Share a Single Printer Between Computers. Hack 120: Optimize Your Dual Monitors. Hack 121: Control Multiple Computers with a Single Keyboard and Mouse.Technology is supposed to make our lives easier by helping us work more efficiently. Lifehacker: The Guide to Working Smarter, Faster, and Better, Third Edition is your guide to making that happen!