Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Microsoft Project is brimming with features to help you manage any project, large or small. But learning the software is only half the battle. What you really need is real-world guidance: how to prep your project before touching your PC, which Project tools work best, and which ones to use with care. This book explains it all, helping you go from project manager to project master. Get a project management primer. Discover what it takes to handle a project successfully Learn the program inside out. Get step-by-step instructions for Project Standard and Project Professional Build and refine your plan. Put together your team, schedule, and budget Achieve the results you want. Build realistic schedules, and learn how to keep costs under control Track your progress. Measure your performance, make course corrections, and manage changes Use Project's power tools. Customize Project's features and views, and transfer info directly between Project and other programs
Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home. The important stuff you need to know: Build a database with ease. Store information to track numbers, products, documents, and more. Customize the interface. Build your own forms to make data entry a snap. Find what you need fast. Search, sort, and summarize huge amounts of information. Put your data to use. Turn raw info into printed reports with attractive formatting. Share your data. Collaborate online with SharePoint and the Access web database. Dive into Access programming. Get tricks and techniques to automate common tasks. Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.
Microsoft Office is the most widely used software suite in the world. The half-dozen programs in Office 2010 are packed with amazing features, but most people just know the basics. This entertaining guide not only gets you started with Office, it reveals all kinds of useful things you didn't know the software could do -- with plenty of power-user tips and tricks when you're ready for more. Create professional-looking documents. Learn everything you need to know to craft beautiful Word documents. Stay organized. Keep track of your email, calendar, and contacts with Outlook. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and more. Build Access databases quickly. Make your data easy to find, sort, and manage. Manage your files more efficiently. Use the new Backstage view to quickly work with your Office files. Get to know the whole suite. Learn to use other handy Office tools: Publisher, OneNote, and Office Web Apps.
With the iOS 6 software and the new iPhone 5, Apple has two world-class hits 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 this expanded edition of his witty, full-color guide: the world’s most popular iPhone book. The important stuff you need to know: The iPhone 5. This book unearths all the secrets of the newest iPhone. Taller screen, faster chip, 4G LTE Internet, thinner than ever. The iOS 6 software. Older iPhones gain Do Not Disturb, the new Maps app, shared Photo Streams, camera panoramas, smarter Siri, and about 197 more new features. It’s all here. The apps. That catalog of 750,000 add-on programs makes the iPhone’s phone features almost secondary. Now you’ll know how to find, manage, and exploit those apps. The iPhone may be the world’s coolest computer, but it’s still a computer, with all of a computer’s complexities. iPhone: The Missing Manual is a funny, gorgeously illustrated guide to the tips, shortcuts, and workarounds that will turn you, too, into an iPhone addict.
Elements 9 offers much of Photoshop's power without the huge price tag. It's an ideal tool for most image-editing buffs -- including scrapbookers, photographers, and aspiring graphic artists. But Elements still doesn't come with a decent manual. This bestselling book will help you get the most out of the program, from the basics to advanced tips for both Windows and Mac. Quickly learn your way around. Customize Elements to suit your working style. Get to work right away. Import, organize, and make quick image fixes with ease. Retouch any image. Learn how to repair and restore your old and damaged photos. Add some pizzazz. Give images more zip with dozens of filters, frames, and special effects. Find your creative flair. Create scrapbooks, greeting cards, photo books, and more. Use advanced techniques. Work with layers, blend modes, and other tools. Try out your new skills. Download practice images and try new tricks as you learn.
What do you get when you cross a Mac with an iPad? OS X 10.8 Mountain Lion. Its 200 new features include iPaddish goodies like dictation, Notification Center, and Reminders—but not a single page of instructions. Fortunately, David Pogue is back, with the expertise and humor that have made this the #1 bestselling Mac book for over 10 years straight. Big-ticket changes. Twitter and Facebook intgration. Air-Play TV mirroring. Power Nap. Game Center. Documents in the Cloud. iMessages. Gatekeeper. If Apple wrote it, this book covers it. Mountain Lion Watch. This book demystifies the hundreds of smaller enhancements, too, in all 50 programs that come with the Mac: Safari, Mail, Messages, Preview… Shortcuts. This must be the tippiest, trickiest Mac book ever written. Undocumented surprises await on every page. Power users. Security, accounts, networking, build-your own Services, file sharing with Windows—this one witty, expert guide makes it all crystal clear. There's something new on practically every page of this new edition, and David Pogue brings his celebrated wit and expertise to every one of them. Apple's brought a new cat to town, and Mac OS X Mountain Lion: The Missing Manual is the best way to tame it.
Office 2011 for Mac is easy to use, but to unleash its full power, you need to go beyond the basics. This entertaining guide not only gets you started with Word, Excel, PowerPoint, and the new Outlook for Mac, it also reveals useful lots of things you didn't know the software could do. Get crystal-clear explanations on the features you use most -- and plenty of power-user tips when you're ready for more. Take advantage of new tools. Navigate with the Ribbon, use SmartArt graphics, and work online with Office Web Apps. Create professional-looking documents. Use Word to craft beautiful reports, newsletters, brochures, and posters. Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and other features. Use the programs together. Discover how to be more productive and creative by drawing directly in Word documents, adding spreadsheets to your slides, and more.
Your bookkeeping workflow will be smoother and faster with QuickBooks 2011 -- but only if you spend more time using the program than figuring out how it works. This Missing Manual puts you in control: You'll not only find out how and when to use specific features, you'll also get basic accounting advice to help you through the learning process. Set up QuickBooks. Arrange files and preferences to suit your company. Manage your business. Track inventory, control spending, run payroll, and handle income. Follow the money. Examine everything from customer invoices to year-end tasks. Find key info quickly. Take advantage of QuickBooks’ reports, Company Snapshot, and search tools. Streamline your workflow. Set up the Home page and Online Banking Center to meet your needs. Build and monitor budgets. Learn how to keep your company financially fit. Share your financial data. Work with your accountant more efficiently.
Nothing spices up websites like cool sound effects (think ker-thunk as visitors press a button) or embedded videos. Think you need a programmer to add sizzle to your site? Think again. This hands-on guide gives you the techniques you need to add video, music, animated GIFs, and sound effects to your site. This Mini Missing Manual is excerpted from Creating a Web Site: The Missing Manual.