The world's most popular spreadsheet program is now more powerful than ever, but it's also more complex. That's where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You'll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel's new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations.
Review financial data, use math and scientific formulas, and perform statistical analyses.

Think you have to be a technical wizard to build a great web site? Think again. For anyone who wants to create an engaging web site-for either personal or business purposes - "Creating Web Sites: The Missing Manual" demystifies the process and provides tools, techniques, and expert guidance for developing a professional and reliable Web presence. Like every Missing Manual, you can count on "Creating Web Sites: The Missing Manual" to be entertaining and insightful and complete with all the vital information, clear-headed advice, and detailed instructions you need to master the task at hand. Author Matthew MacDonald teaches you the fundamentals of creating, maintaining, and updating an effective, attractive, and visitor-friendly web site-from scratch or from an existing site that's a little too simple and flat for your liking. "Creating Web Sites: The Missing Manual" doesn't only cover how to create a well-designed, appealing, smart web site that is thoroughly up to date and brimming with the latest features.
It also covers why it's worth the effort by explaining the rationale for creating a site in the first place and discussing what makes a given web site particularly aesthetic, dynamic, and powerful. It further helps you determine your needs and goals and make well informed design and content decisions. "Creating Web Sites: The Missing Manual" includes a basic primer on HTML, working with JavaScript, and incorporating services like Paypal's shopping cart, Amazon's associate program, and Google AdSense and AdWords. It delivers advanced tricks for formatting, graphics, audio and video, as well as Flash animation and dynamic content. And you'll learn how to identify and connect with your site's audience through forms, forums, meta tags, and search engines. This isn't just another dry, uninspired book on how to create a web site. "Creating Web Sites: The Missing Manual" is a witty and intelligent guide for all of you who are ready to make your ideas and vision a Web reality.

With HTML5, you can make your websites run smoothly on almost all browsers and incorporate video tools, dynamic drawings, geolocation, offline web apps, drag-and-drop, and more. HTML5: The Missing Manual gets you started with your first HTML5-powered site in the very first chapter and shows you how to use HTML5 with JavaScript, CSS, and other familiar tools. Find out how to make HTML5 work properly from the start and avoid common pitfalls. Bestselling author Matthew MacDonald shows you not only how HTML5 works but also how to best use its new features to create an effective web experience for your visitors.




What, exactly, do you know about your body? Do you know how your immune system works? Or what your pancreas does? Or the myriad - and often simple - ways you can improve the way your body functions? This full-color, visually rich guide answers these questions and more. Matthew MacDonald, noted author of "Your Brain: The Missing Manual", takes you on a fascinating tour of your body from the outside in, beginning with your skin and progressing to your vital organs. You'll look at the quirks, curiosities, and shortcomings we've all learned to live with, and pick up just enough biology to understand how your body works.
You'll learn: that you shed skin more frequently than snakes do; why the number of fat cells you have rarely changes, no matter how much you diet or exercise - they simply get bigger or smaller; how you can measure and control fat; that your hair is made from the same stuff as horses' hooves; that you use only a small amount of the oxygen you inhale; why blood pressure is a more important health measure than heart rate - with four ways to lower dangerously high blood pressure; why our bodies crave foods that make us fat; how to use heart rate to shape an optimal workout session - one that's neither too easy nor too strenuous; why a tongue with just half a dozen taste buds can identify thousands of flavors; why bacteria in your gut outnumbers cells in your body - and what function they serve; why we age, and why we can't turn back the clock; and, what happens to your body in the minutes after you die. Rather than dumbed-down self-help or dense medical text, "Your Body: The Missing Manual" is entertaining and packed with information you can use. It's a book that may well change your life.

Think you need an army of skilled programmers to build a web site? Think again. With nothing more than an ordinary PC, some raw ambition, and this book, you'll learn how to create and maintain a professional-looking and visitor-friendly site that features components such as audio, video, and e-commerce capability. This Missing Manual gives you all the tools, techniques, and expert advice you need -- including when and how to adopt HTML5. * Learn to create a site from start to finish with hands-on, guided instructions * Control page design and layout with powerful style sheets * Bring in cash with Google ads, affiliate programs, and a PayPal shopping cart * Track site visitors and identify the pages they're checking out most often * Build a community by adding online discussions and forums * Create your own blog using a free blog-hosting service * Find the right Web host and get a personalized Web address

Excel 2003 for Starters

by Matthew MacDonald

Published 1 January 2005
The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful - and can be downright intimidating. If you're new to Excel or among the many existing Excel users who are dazed and confused by all that the program can do (and by how little it has actually done for you), "Excel for Starter: The Missing Manual" is your ideal resource. For everyone who wants to quickly get up to speed on Excel to create, organize, and present household and/or office data and information, this smart new guide delivers just the essentials: it concentrates on the must-have information and the best, most practical Excel features that people like you can use to maximize your productivity and minimize your spreadsheet confusion and frustration. "Excel for Starters: The Missing Manual" demystifies spreadsheets, and explains how to use them most effectively and efficiently.
Clear explanations (with lots of examples), step-by-step instructions, helpful illustrations, and timesaving advice guide you through all the most common and useful features of Excel 2002 and 2003 - including how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Sure, there are plenty more thorough, more massive Excel books on the bookstore shelves. But why wade your way through a swamp of details you'll never need - or want - to use? Let author Matthew MacDonald, an educator and software developer who also wrote the highly popular "Excel: The Missing Manual", be your trusted guide as you learn which Excel features will serve you best and which are best ignored. Utterly practical and refreshingly funny, this down-to-earth guide gives you nothing more (and nothing less) than what you need to make Excel do exactly what you want it to do. It's a quick read you'll want to keep on hand for reference again and again.

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, "Excel 2003: The Missing Manual" is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, "Excel 2003: The Missing Manual" is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs. Never a candidate for 'the most user-friendly of Microsoft programs', Excel demands study, practice and dedication to gain even a working knowledge of the basics. "Excel 2003" is probably even tougher to use than any previous version of Excel. However, despite its fairly steep learning curve, this marvelously rich program enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Excel can help you to collaborate effectively, and protect and control access to your work. Power users can take advantage of industry-standard Extensible Markup Language (XML) data to connect to business processes.
To unleash the power of the program and mine the full potential of their database talents, users need an authoritative and friendly resource. None is more authoritative or friendlier than "Excel 2003: The Missing Manual". Not only does the book provide exhaustive coverage of the basics, it provides numerous tips and tricks, as well as advanced data analysis, programming and Web interface knowledge that pros can adopt for their latest project. Neophytes will find everything they need to create professional spreadsheets and become confident users. "Excel 2003: The Missing Manual" covers: worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and programming. If you buy just one book about using Excel, this has GOT to be it. This book has all you need to help you excel at Excel.

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help. Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.
You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

Office 2013

by Nancy Conner and Matthew MacDonald

Published 1 January 2013
Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you're ready for more. You'll learn about Office's new templates and themes, touchscreen features, and other advances, including Excel's Quick Analysis tool. The important stuff you need to know: Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool. Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations. Share your Access database. Design a custom database and let other people view it in their web browsers. Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps. Create and share documents in the cloud. Upload and work with your Office files in Microsoft's SkyDrive.