Visual Blueprint

Master two of the most powerful features of Excel Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide. Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work. • Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets • Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more • Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Advanced techniques for Excel power users Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more. • Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite • Expands your Excel knowledge and helps you use Excel data more efficiently • Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas • Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks • Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions Learn Excel at the highest levels with this practical guide.

The visual guide to developing for one of the world's hottest new mobile platforms, the Android OS. The Android operating system works on phones that combine a camera, Web browser, e-mail, GPS, and mapping tool into a single accessible pocket-sized unit, and can function on computers, as well. Aimed at visual learners and packed with hundreds of screen shots, this guide brings Flash developers up to speed on the necessary factors to take into account when developing for this touch-based, mobile platform. Experienced Flash developer Julian Dolce escorts you through the process of creating applications for the Android OS using the Flash CS5 development platform and informs you of best practices to try as well as common pitfalls to avoid. • Guides you step by step through the process of creating applications for the Android OS using Flash CS5 • Explores the capabilities and limitations of developing apps for the Android OS • Points out common pitfalls and teaches you best practices • Features hundreds of screen shots to assist with visual learning Android Development with Flash: Your visual blueprint for developing mobile apps gets you on your way to developing apps for Android... in a flash!

Visually explore the range of built-in and third-party libraries of Perl and Apache Perl and Apache have been providing Common Gateway Interface (CGI) access to Web sites for 20 years and are constantly evolving to support the ever-changing demands of Internet users. With this book, you will heighten your knowledge and see how to usePerl and Apache to develop dynamic Web sites. Beginning with a clear, step-by-step explanation of how to install Perl and Apache on both Windows and Linux servers, you then move on to configuring each to securely provide CGI Services. CGI developer and author Adam McDaniel shows techniques for effectively developing and maintaining dynamic sites and he shares real-world examples describing MySQL database access, PayPal credit-card transactions, and sample Facebook and Twitter interfaces. • Apache and Perl have been providing Common Gateway Interface (CGI) access to Internet Web sites for more than two decades, and both products are constantly evolving to support today's user requirements • Shows how to install Perl and Apache on Windows and Linux servers and configure each to securely provide CGI services • Details techniques for effectively developing and maintaining dynamic Web sites • Addresses MySQL database access and PayPal credit-card transactions, and examines sample Facebook and Twitter interfaces With this book, you'll benefit from a wealth of techniques and resources that you won't find anywhere else.